Managing database connections

When outputting files to a database connection, there are additional considerations regarding how we will manage the process. Commonly, the development workflow will connect to a sandbox or development database instance before connecting to the production instance when published. You also have to consider how the Open Database Connectivity (ODBC) connections will be synchronized across the local and server environments. You also have to consider the implications of the type of output connection, either standard or bulk loading, that you use.

Using standard connections

The standard output connections in Alteryx make use of the standard INSERT statements to load data into a table. You can leverage any of the ODBC connection properties and capabilities in the same way that you can leverage them when connecting to a data source from an input tool. You also have the same limitations when sharing the workflows with Data Source Names (DSNs).

If you...