topic SAS DI SQL transformation oracle connection in SAS Data Management

SAS DI SQL transformation oracle connection

JeroenPotgieter — Mon, 13 Jun 2022 09:53:39 GMT

Hi all, I'm trying to execute explicit SQL in Oracle with two tables with different schemas. SAS DI is using in the connection string to oracle the authdomain of the first connected source table. Is there a way to bypass this option and use the authdomain of the target table instead of the (first) connected source table?

Re: SAS DI SQL transformation oracle connection

LinusH — Mon, 13 Jun 2022 10:22:24 GMT

If you can show how you have defined the two tables in the transformation, and the generated code (with comments if needed), it would help me to understand what you are trying to do.

Re: SAS DI SQL transformation oracle connection

MarkDawson — Thu, 22 Sep 2022 08:42:37 GMT

Hi Jeroen,

Your post was a few months ago, and I only just came across it.

SAS did add some support for this, see 68840 - Database connection information for a source table is used when creating a new database table with the Create Table transformation (sas.com) for a Hot Fix that might help you. However, if that does not meet your use case, please contact your local SAS Technical Support office, maybe with a package file that shows the issue. SAS can then review and determine if we can also address your specific use case.

Thanks, Mark