We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

How to write data from in-DB tool into a database?

8 - Asteroid


I am planning to read data from one database and write into another database,

In the above figure, from the source database, i am planning to write a query that joins five tables and i want to write the data into another database.

But, I am not able to connect Source database into destination database.






6 - Meteoroid

Hi anil. The data stream in tool is for bringing data from your local machine into the server space, creating a temp table, new table or overwriting an existing table.


You may be looking for the "Write Data in-DB" tool. This gives you a couple more options such as delete / append (rather than re-create the whole table).


For updating records on a table, the only way I have done this is to bring the data to the local machine (using the Data Stream Out tool), then using the Output tool and pointing to the table on the server. I have had the best luck doing this as if the database is keyed correctly you can update, insert only new records, as well as use bulk insert if you have large amounts of data.

6 - Meteoroid

If the database you want to write to is within the same data source as the source data( i.e. SQL Server) then you can simply use the Write Data In-DB tool. If the Destination database you want to write to is in a different data source, such as an Oracle database and your Source database is SQL Server, then you need to use the Data Stream Out tool and then use a Data Stream In tool to to the Destination database.