DSN/ODBC connection

Shaaz

I've a workflow which is connected to PostgreSQL server using a normal OBDC connection as highlighted below in yellow.

How do I change the workflows from ODBC to Bulk ??

Will the existing ODBC connection work??

Kindly help me with steps to change my workflow from ODBC to Bulk.

Connectors

Database Connection

Accepted answers

Shaaz

I made below changes in the workflow and it worked.

Column order and column size in Alteryx should be in sync with DB table

All comments

TheOC

hi @Shaaz

Theres a little bit of documentation here:
https://help.alteryx.com/20214/designer/configure-posgresql-bulk-connection-writing-data

But by the sounds, you can just use the same connection for bulk as ODBC, just select bulk instead of ODBC.

cheers,
TheOC

apathetichell

Does that work with In-DB? I don't see an option for bulk write configuration on my Greenplum In-DB set up.

danilang

Hi @apathetichell

The bulk option is only available on Output Data tools, except for Teradata which a bulk import option for some reason. The bulk setting is implemented on the Alteryx side and has to do with the way that data is written. If the data is in non-bulk mode, the primary key is checked by designer for inserts and updates on a record by record basis. This slows the writing process down since the records cannot be batched. This is how Designer can determine whether to insert or update any specific record. In bulk mode, the records are sent in batches which is up to 1000's of times faster. The drawback is that you have to determine which records can be updated and which can be inserted. If you get this step wrong, the database will throw PK related errors, which will stop your workflow.

The bulk option doesn't apply the same way to In-DB processes. The Data Stream In tool either creates a temp table, a new table or overwrites(drops) an existing table, so these can always be batched. The only issue will be with the overwrite option if the data you're streaming in doesn't satisfy the primary key on the target table. The Data Stream Out is a read operation which is always batched. All other operations are In-DB and managed by the backend database.

Dan

Alteryx_AR

@Shaaz -- Hope this helps-- Configure PosgreSQL Bulk Connection for Writing Data | Alteryx Help

Shaaz

I made below changes in the workflow and it worked.

Column order and column size in Alteryx should be in sync with DB table

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177