SQL Server

 

The SQL Server 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.

 

SQL Server Query Page

 

The SQL Server Query Page allows a user to enter credentials, select a database, and write a custom query for exporting data from the database.

•Connection Tab

oSQL Server Name:  The location/address of the SQL Server database.

oAuthentication:  The method for signing into the SQL Server database.  Windows will attempt to log in with the users Windows Credentials.  SQL Server will allow you to manually enter a user name and password for the SQL Server database.  Optionally, you can choose to save the password afterwards.

oDatabase Name:  The name of the target database which contains the table or view which is to be inserted into.

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