Dear Team,
I have created a data job and my final table is in Excel but wants to store in Oracle directly.
please go through the attached one screenshot for your references. and let me know if required any further details.
Thank You
Shakti
I'm not too familiar with this but my understanding is you will need to create an ODBC data connection in the Data Tab in Dataflux Data Management Studio. This will point to the Oracle schema where you want your new table to be stored. Unless you have "Create Table" permissions in this schema you will have to get a DBA to create the table for you.
Then in the Folder Tab, open your Dataflux job and replace your text file output node with a Data Target (Insert) node. This node is for inserting rows which is what I guess you want to do. In the properties of this node point to the required table listed in the Oracle data connection.
A quick addition: you can create the connection to your Oracle database directly from the Windows ODBC Administrator (32 bits to match Data Management Studio)
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.