SQL Server |
|
•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.
•Account Code: The account code for a journal line. This is a macro-enabled field.
•Matching Account Code: The matching account code for a journal line. This is a macro-enabled field.
•Description: The description for a journal line. This is a macro-enabled field.
•Reference: The reference for a journal line. This is a macro-enabled field.
•Transaction Date: The transaction date for a journal line. This is a macro-enabled field.
•Period: The period for a journal line. This is a macro-enabled field.
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.