ODBC

 

The ODBC destination allows you to insert rows of data into a table or view within a ODBC data source.

 

ODBC Login Page

 

The ODBC Login Page allows a user to create, edit and select a Data Source Name (DSN) for connection to an ODBC data source.

•Connection Tab

oChoose DSN:  Select an existing DSN for your connection string.

oODBC DSN Editor:  Launches the ODBC Data Source Administrator form to manage database drivers and data sources.  Click here for more information at MSDN.

oConnection String Help:  This links to the MSDN web page on the .NET Framework implementation of the ODBC connection string, along with examples.

oConnection String:  The connection string to the ODBC data source.

•Advanced Tab

oConnection Timeout:  The amount of time to spend attempting to make a connection to the database.  The default time is 30 seconds.

oCommand Timeout:  The amount of time to spend attempting to complete the commands or transaction before disconnecting.  It is advised to use a higher command timeout if you are inserting a lot of data or working with a slow connection.

oUse Transactions:  A transaction is a single unit of work.  Enabling transactions allows for an all-or-nothing insert.  If any lines encounter a problem, the transaction will roll back and all modifications will be erased.  If a transaction is successful, all modifications were successful and become a permanent part of the database.

Database Table Name Page

 

Using the credentials supplied on the login page, the database will be queried for all tables and views.  Select the name of the object you wish to insert into.

 

Database Mapping Page

 

The Database Mapping Page is used to map properties and attributes from the source document to columns in the desired object within the ODBC data source.  The detected macros list box on the left contains all of the available macros originating from the source document.  The detected columns list box contains a list of all of the detected column names within the ODBC object that was selected on the previous page.  These support drag and drop.  Drag a column or macro to the column macros data grid and drop.  Dropping a column name will create a new row in the data grid with the name of the column.  The name of the column cannot be changed.  Dragging a macro from the detected macros list box will add the macro to the Column Macro column on the line which it is dropped.

 

Copyright © 2024 pasUNITY, Inc.

 

Send comments on this topic.