SAS Teradata ODBC Connection

Hi,

I am relatively new to SAS. I am using Enterprise Guide 4.1 and trying to connect to a Teradata DB using ODBC. My Teradata client uses ODBC to connect to the server and I have successfully used the same ODBC to connect using R.

If I click on File->Open->ODBC... then select the same ODBC data source as I use in R and Teradata client, input my password and click OK I get the error message

Enterprise Guide cannot open the data file: ODBC;DSN=my_odbc_name; UID=my_username;PWD=*******;
Error opening data "ODBC;DSN=my_odbc_name; UID=my_username;PWD=my_password; ".
Failed to open the data set in READ mode.
Do you want to remove all references to this file from the project?

What am I doing wrong?

Thanks

Mike
hungoveragainAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
hungoveragainAuthor Commented:
I have found this is possible with the following code

libname TODBC odbc
datasrc = 'MyODBC'
user = 'USERNAME'
password = 'SECRET'
schema = 'SCHEMANAME'
;

This will create a library within the local server containing every table and view as its own data source.

Clicking New->ODBC and connecting to the ODBC does not work. However

BEWARE! The ODBC connection is woefully slow. If you are accessing a table / dataset of more than about 10,000 rows you will find it quicker to export to a text file and import that (yes really).

Alternately there is a SAS / ACCESS set of modules but these require licenses and some kind of server side configuration.

Mike
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
hungoveragainAuthor Commented:
This is the answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.