Hello,
I have two metadata servers, A and B.
A has oracle tables (through sas/access to oracle)
B has teradata tables (through sas/access interface to teradata)
We want to do the following, having code change metadata servers automatically (not manually)
1. perform a data step returning tables from oracle, saving the data set to a lan location
2. have enterprise guide change metadata servers to the workspace that has access to teradata (so, swap from the logged in A, and establish a connection to B)
3. perform a data step (on the lan stored file) saving into teradata through metadata server B
Yep, thats it, in code, after a data step, swap metadata servers and in the other, perform a second data step.
Please tell me if this is on the right/wrong track.
tools > options > tasks (or programs) pre-code run "option metaserver=b" etc
Or if there is another way to implement during a macro controlled process, swapping metadata servers.
I don't have any influence on any smarter solution.
Very interested to see responses, that address "option metaserver=b" to swap metadata servers or something easier.
We use "SAS Enterprise Guide 4.1 (4.1.0.1019)"
Thanks in advance, for any help, guidance, solutions on this point.
Tim Tam