Redbrick ODBC

dirkm · Post by **dirkm** » Mon Jul 17, 2006 8:27 am

Hi, I am trying to configure a data source (odbc) connection from Datastage, on one Unix server, to Redbrick on another Unix server.

Datastage used to run on the Redbrick server, but we are now moving it to another server.

All my other datasources seem to be ok on the new Datastage server (SQL, Informix), but I cannot get the one pointing to Redbrick to work. I don't know if I have the correct libraries installed. I tried the ones that came with the installation of Datastage (packages), but they were different from the ones we use on the Redbrick server, so I copies these libraries to the new Datastage server - but still no success.

Can someone please point me in the right direction ?

ray.wurlod · Post by **ray.wurlod** » Mon Jul 17, 2006 4:50 pm

Welcome aboard. :D

Unlike most ODBC data sources, DataStage does not look for the Red Brick driver in the usual way. You will need to have the environment variables RB_CONFIG and RB_HOME set.

You were right to copy the Red Brick libraries to the new DataStage server, but you need to set all needed Red Brick environment variables (especially the two mentioned above) for DataStage users; that is, in the dsenv script.

Plus, of course, you will need DSNs created, and referred to in the uvodbc.config file in the project.

dirkm · Post by **dirkm** » Tue Jul 18, 2006 1:07 am

Wonderful - thank you so much. I was about to give up hope on this one. I added RB_CONFIG, and RB_HOME to my dsenv file, and it connected! So simple. I can't tell you how happy I am. I had to get this to work very urgently for my company.

Thanks, I really appreciate the help, and thank you for the welcome.

Regards
Dirk