Introduction
Before starting to configure Alert Database Export, you must have "Microsoft OLE DB Provider for SQL Server" installed on the Alert computer. If you don't have it, you can download it directly on Microsoft web site: Microsoft OLE DB Provider For SQL Server.
You also need to configure your SQL server by following SQL Server: Prerequisite.
When the SQL Server configuration will be done, we will create a UDL file to test the connection easily.
If the UDL file can connect to the database then we will import the UDL file in Alert and connection must be done.
Creating UDL file
To create a UDL file, create a new text file "AlertDB.txt" and rename it "AlertDB.udl".
Once the file is created, double-click on it.
In new windows, select the "Provider" tab and select "Microsoft OLE DB Provider for SQL Server"
Now you need to enter SQL Server connection info:
For our example, the server used is SQLEXPRESS installed on the machine called PORTGL10.
Note the syntax of the location of the data source: Computer_Name\SQLEXPRESS for our example.
We use the login information that we have created on the SQL Server before "AlertUsr".
To check whether the connection is valid, click "Test Connection". The result must be positive!
This UDL file will need to be referenced in Alert.
Enable Database Export in Alert
To enable Database export in Alert, you must go to "Configuration/Options" in Alert, on new window check "Database export activation" and click "Data links...":
Select the UDL file than you have created before and click on "OK" twice to close all windows.
If you don't have any error messages, connection is good and you will have a new "Call" screen which has been appeared:
