Output tool configuration for Oracle database

[RAMN]

Hello community,

Can someone help me with the output tool configuration to load the data into table in oracle database. I am getting the data from excel and applying some transformations and now I have to load this into particular oracle table. 

Thank you!

Ram

[BrianR]

Hi @RAMN, not sure where you are in the Oracle configuration in your environment, so apologies if I state something already in place. However, if not already done, you will need to make sure your environment can currently connect to Oracle. This would include drivers, such as one example, Oracle OCI. Once that process is complete, and you can connect to Oracle, then your Output tool configuration would point to your Oracle database, and then a particular table within your Oracle database.

Take a look at this link from our Help site for information on what you need to connect to Oracle...

https://help.alteryx.com/current/designer/oracle

Brian

[RAMN]

Hi Brian,

Thanks for your response.

I have the OCI connection string that has been setup and I am able to connect to oracle database with the input data tool, however to load data into oracle table using output tool I am not getting the option to select tables from the database even after passing the connection string in the output data tool. If you can provide me a screenshot with sample database that would be great.

Thanks!!

Ramn