General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Write data into an existing table in Oracle using Output Tool

6 - Meteoroid

I have some data I get from Excel form that I clean.  I want to insert this into an Oracle table that is already created.  I would like to delete any records from the table that fall on a certain date and match a certain ID.  After this I want to insert all the data that I cleaned in my flow into the database.  Why is this so difficult to find any documentation on this?  Is Alteryx trying to hide this from customers?

Highlighted
Alteryx Certified Partner

Hi @RyanDonovanNG 

 

Oracle documentation is here: https://help.alteryx.com/current/OracleConnections.htm

Output Tool documentation is here: https://help.alteryx.com/current/DbFileOutput.htm

 

What have you attempted so far and where exactly are you running into issues?

 

I'm not an expert on Oracle but here are a couple of ideas:

 

1) To send the instruction to the database to delete records based on certain conditions, I think you could explore using the Dynamic Input tool

2) To insert the data into your database you can simply use the Output tool

 

There's a huge amount of extra information available on the Community and in the documentation.

Highlighted
6 - Meteoroid

I have used a batch macro to send the conditions I want to delete on.  I also put the original data set through the Batch Macro with no processing so I know the deletes happen first.  I then send this original data into output tool to be appended to Oracle Table.  I have gotten this to work with Strings only.  It seems to freeze now when I have mixed Oracle Datatypes (Date,Number, varchar, etc).  I think it is doing this because of datatypes because I only want to insert 60 records in my testing.

Highlighted
6 - Meteoroid

Data Types Solved by messing around and reading following post:

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Select-Oracle-Data-Types-when-creating-table...

 

You can currently map field names to alteryx variables.  Would there be plans in the future to have a table that shows the DataType Mapping where you can select so Alteryx Variables match Databases datatypes?