Connect SQL Assistant to VMWare

Database
Highlighted
Enthusiast

Connect SQL Assistant to VMWare

Hi Forum,

 

I've got an answer for connectring VMWare to Teradata Express but I can't seem to replicate this to connect SQL Assistant?

 

Can anyone give me the same sort of clear directions that DeaveWellman gave me for the last question?

 

Here's the link to the post;

https://community.teradata.com/t5/Database/Download-a-working-Teradata-app-with-sample-tables/m-p/82...

 

Thanks


Accepted Solutions
Senior Apprentice

Re: Connect SQL Assistant to VMWare

This might be the point to make sure that your TD system uses a static IP address (by default it comes using dhcp).

 

Just a thought...

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
1 ACCEPTED SOLUTION
4 REPLIES
Senior Apprentice

Re: Connect SQL Assistant to VMWare

Hi Pete,

 

The key information that you need is the IP address of your TD vm system (the one that you use in a ping command).

 

Once you have that you can connect from SQLA (presumably running on your Win7 host.).

 

Start SQLA and decide how you're going to connect, do you use ODBC or .NET. It doesn't make any difference to the sql syntax or functionality. I'm only aware of one very slight advantage to using .NET which is why I tend to do that. The choice is made in a drop-down list top left corner of the SQLA toolbar.

 

Using .NET

- click the connect icon (plug icon, left-hand end of toolbar)

- on the 'connection information' dialog enter a 'data source name'. This is your name and can be practically anything you like (e.g. 'myTD')

- for 'Server' enter the ip address of the TD vm system

- for 'user name' enter DBC

- for 'password' enter DBC

- leave all other fields blank

 

Click 'OK' and that should logon to the TD system. try the test query(s) that I gave in the earlier post.

 

Using ODBC

- click the connect icon (plug icon, left-hand end of toolbar)

 - on the 'select data source' dialog select the 'machine data source' tab and then click 'New'

    (you might get a warning about non-admin rights and 'system data sources', just click OK and continue)

- create a new data source using the plain 'Teradata' driver (do not use any of the 'Teradata xxxx' drivers)

- click through until you get to the screen where you enter details

- enter a 'name'. This is your name and can be practically anything you like (e.g. 'myTD'). Optionally enter a description.

- for 'Name or IP address' enter the ip address of the TD vm system

- for 'user name' enter DBC

- personally I leave 'password' blank and then enter it when I logon but you can enter a value of DBC if you'd like).

- click OK (as many times as needed) to save the data source

 

You now have an ODBC data source which can be used to logon.

 

HTH

Dave

 

 

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Senior Apprentice

Re: Connect SQL Assistant to VMWare

This might be the point to make sure that your TD system uses a static IP address (by default it comes using dhcp).

 

Just a thought...

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Enthusiast

Re: Connect SQL Assistant to VMWare

Thanks Dave,

 

I've tried both .Net (Timeout for connection) & ODBC (No response received when tyring to connect).

I'm using the smae IP address as I used before.

How do I check oif I'm using a status IP address?

 

Thanks Pete 

 

Enthusiast

Re: Connect SQL Assistant to VMWare

Thanks Dave,

 

I tried again & it's all good, working fine.

 

Cheers Pete