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 Login 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 Vendor 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

•Vendor Code:  The vendor code for the vendor.  This is a macro-enabled field.

•Vendor Name:  The name of the vendor.  This is a macro-enabled field.

•Description:  The description of the vendor.  This is a macro-enabled field.

•Active:  The active status of the vendor, typically a true/false or boolean (1/0) value.  This is a macro-enabled field.

•Status:  The actual status of the vendor.  This is a macro-enabled field.

Details Tab

•Site/Property:  The site or property of the vendor.  This is a macro-enabled field.

•Email Address:  The email address of the vendor.  This is a macro-enabled field.

•Web Site URL:  The website of the vendor.  This is a macro-enabled field.

•Currency:  The currency of the vendor.  This is a macro-enabled field.

•Payment Terms:  The payment terms of the vendor.  This is a macro-enabled field.

•Tax ID:  The tax ID of the vendor.  This is a macro-enabled field.

Address Tab

 

The Address tab will allow you to specify multiple addresses for the vendor.  Drag and drop a column name representing an address line 1 into the grid.  You will manually need to enter Line 2, Line 3, City, Region/State, Postal Code, and Country.

 

Phone Tab

 

The Phone tab will allow you to specify multiple phone numbers for the vendor.  Drag and column name representing a phone number into the grid.  You will manually need to enter the extension.

 

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.

Created with an evaluation copy of HelpSmith.
To remove this notice, you should purchase the full version of the product.