Follow below steps to be able to create table along with its data from Oracle to Netezza.
Suppose we have employees table at Oracle database
Suppose we have employees table at Oracle database
Connect to Alteryx, use "Input Data" tool to read the employee table of Oracle
Fill the username, password, tns info to connect to your Oracle DB.
Test the connection, SQL.
Use "Output Data" tool in Alteryx and to connect to Netezza to create the table
Workflow looks as follows
output of workflow
@Netezza Side
No comments:
Post a Comment