ODBC

 

The ODBC source allows you to create your create a custom query against a SQL Server database and use the returned set of data as source data for pasTransfer.

 

ODBC Query Page

 

The ODBC Query Page allows a user to create, edit and select a Data Source Name (DSN) for connection to an ODBC data source, and write a custom query for exporting data from the database.

•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.

•Query Tab

oQuery: The select statement to be used to query data from the SQL Server.

•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.

Data Record Column Macros Page

 

The Data Record Column Macros Page is used to map columns from the returned set data to a Account Line.  The list box to the left contains a list of columns which will be returned from the query specified in the prior page.

 

General Tab

•Account Code:  The identifying account code for the account.  This is a macro-enabled field.

•Account Type:  The type of the account.  This is a macro-enabled field.

•Description:  The description for an account.  This is a macro-enabled field.

•Currency:  The currency for an account.  This is a macro-enabled field.

•Active:  The active status for the account.  This is a macro-enabled field.

•Site:  The site for the account.  This is a macro-enabled field.

Attributes Tab

 

Any columns from the source data can be made into attributes and mapped later on the destination transformation.  Click and drag a column to the attribute data grid to create a macro command.

 

Copyright © 2024 pasUNITY, Inc.

 

Send comments on this topic.