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


OLEDB Login Page


The OLEDB Login Page allows a user to enter a connection string, and choose additional options in regards to the insert.

Connection Tab

oConnection String:  The connection string to the OLEDB data source.  Double-clicking on the text box launches the Data Link Properties form which assists in the creation of the connection string.  Begin by choosing the OLEDB provider to use for the connection, followed by the database name, credentials, and any additional options required for the selected provider.  After completing any additional options, press OK to insert the generated connection string into the text box.

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 OLEDB 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 OLEDB 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 © 2023 pasUNITY, Inc.


Send comments on this topic.