1. Add Data Source
An ODBC System data source stores the information needed to connect to the specified data provider, in our case the SQL database. For this reason, you must already have a database that you want to use, for the Integration Server, before you create an ODBC connection.
Wizard Walkthrough:
In this dialog box, you name the ODBC data source and describe it (optional). You also select the server for which the connection is intended, either by entering it or from the drop-down list.
For SQL Express type .\SQLEXPRESS for SQL SERVER type (local) on the same machine.
In this dialog box, you choose how to verify the login ID authenticity. With the first option, the network login has to match the owner of the SQL server. With the second alternative, you use the Login ID and Password defined at the installation of the SQL server. (e.g. “sa” – Server Administrator, this is just an example but is often used as the default value).
Be sure to tick the first box in this dialog box: Change the default database to: and select the SQL database, to be used by the integration server, from the drop-down list.
The default values in this dialog box are fine. (See picture above, for more information).
All that remains is to click Finish, followed by Testing the source, in the dialog box that opens, and finally click the OK button.
You have now finished the ODBC data source setup. When you return to the System Configuration Program and the Database tab, you will see that the data source you have just created appears in the DSN name field, drop-down list.
2. Initiate Database
In this window, you select the data source to be used by the Integration Server to connect to the SQL database. If you have not set up an ODBC connection to the database you want to use, you can do that now by clicking Setup database... completing the wizard.
Select Data Source
Select the data source you wish the Integration Server to use for connecting to the SQL database. This is done in the DSN name field, while the appropriate authentication (for the SQL Server) is entered in the User name and Password fields.
Initiate Database
Once the data source is selected, you need to initiate the database and set up the necessary structure so the integration server can store transactions and integration configurations in the database. To initiate the database, click the Initiate database button, the warning dialog, shown below, opens:
Only initiate the database the first time you use the chosen SQL database. If you setup another data source later, to the same SQL database as before, and click the Initiate database button, you will clear all of the transactions and integration configurations and restore an empty structure. If it is the first time you use the SQL database, (not the same as dat asource) then click the OK button.
0 Comments