02-07-2012 01:08 PM
It took me ages to get it so EG could see my Netezza data warehouse appliance instead of my PC as local.
I don't keep data on my PC. At any rate, my PC had to be re-imaged and everything re-installed and now I'm back at square 1.
I think my previous problem occurred because our system admins don't know what to do with EG.
There were schemas involved and I don't know what those were.
Now I have both my Netezza and my SQL server setup as ODBC thinking that would be easier, but I still can't get to them
Any ideas on how to get everything working again?
02-07-2012 03:45 PM
The ODBC connections work with base SAS, but we don't have a separate EG server. We also don't have any SAS Admins that know anything about EG. I can connect to the SQL server because it asks me to select from the list of tables there. I just can't see or use the data...
02-07-2012 03:09 PM
You don't provide any details of what you have tried so far, but since you are checking out ODBC you need:
1) SAS/ACCESS to ODBC licensed on your EG Server. Run PROC SETINIT to confirm.
2) The ODBC drivers for SQL Server and Netezza need to be installed on the EG server. Can you see these as data sources in the ODBC Administrator in the Windows Control Panel?
3) ODBC data sources need to be defined via the ODBC Administrator, for the SQL Server and Netezza on the EG Server. You can also test the ODBC connections through this tool.
If all this is sorted then I would try a small test program to access ODBC using an SQL CONNECT statement - check your documentation for this.
I would also follow Art's suggestion.
02-07-2012 03:46 PM
Setting up EG properly is a task the SAS Admin at your site should do. Defining common libraries for EG is something which should be done in metadata using SAS Management Console (though a SAS Admin task).
If there is no one around at your site with the neccessary knowledge then it's time to get someone trained.
Else: Agree with Art to contact SAS TechSupport.
Whether you can use ODBC depends on what SAS/Access modules have been licensed at your site.
02-09-2012 06:22 PM
It would help if you posted the SAS code you are using to connect to ODBC, plus any SAS log messages you are getting.
Your response indicates you are running EG with SAS just on your desktop so all setup/configuration/connecting can be done on the same computer which should be straightforward....