I'm interested in using SQL Assistant to connect to two different databsaes.
My steps are as follows:
1) Using the connect icon => Connect to Teradata
2) run Teradata SQL
2) Using the disconnect icon => Disconnect from Teradata
3) Using the connect icon => Connect to MS Access database
4) run Access sql.
I'd like to script the process. Is there a command line procedure that I can call to connect to the databases instead of using the icons (interface)?
Oracle has CONNECT DATABASE command, I figure teradata has to have the same thing or some kind of connection object that can be used. Any know off hand?