Do I need, can I have SID=Oracle SID in Oracle odbc defintio
Posted: Fri Oct 05, 2007 9:44 am
Hi,
Our SE/Oracle link is working quite well thanks to this site. We are using a huge Peoplesoft Schema (1000+ tables) and Oracle Plug In Import is taking a 1/2 hour to come up. It is not an EE site and the Orchestrate import is not working. We want to use the Oracle ODBC drivers so we can import Oracle metadata, one table at a time, and not have to wait the 1/2 hour for the list to come up. I've never done Oracle odbc before. The vanilla Oracle ODBC definition does not have a "SID=Oracle SID" entry in it. It does have a "HostName=Oracle server" in it. I am slightly nervous about trying to access ODBC Oracle without a SID. Does it work to just specify "HostName=Oracle server"?
Also does the datastage server need to be booted to make the new odbc connections known? My memory was that you didn't need to reboot the server.
Our SE/Oracle link is working quite well thanks to this site. We are using a huge Peoplesoft Schema (1000+ tables) and Oracle Plug In Import is taking a 1/2 hour to come up. It is not an EE site and the Orchestrate import is not working. We want to use the Oracle ODBC drivers so we can import Oracle metadata, one table at a time, and not have to wait the 1/2 hour for the list to come up. I've never done Oracle odbc before. The vanilla Oracle ODBC definition does not have a "SID=Oracle SID" entry in it. It does have a "HostName=Oracle server" in it. I am slightly nervous about trying to access ODBC Oracle without a SID. Does it work to just specify "HostName=Oracle server"?
Also does the datastage server need to be booted to make the new odbc connections known? My memory was that you didn't need to reboot the server.