When you choose Relational Database as the data source, you can create a data source from SQL-based and other dynamic databases.
Provide all the necessary information to connect to a relational database and query a subset of data. Note that mandatory entries are indicated in red.
.png)
Provider
Select the data source provider from the dropdown list. For example, Microsoft OLE DB provider for SQL Server. If the one you are looking for is missing, contact your system administrator. The list of providers is based on the providers that are installed on the Necto server machine.
Server
Enter the database server name.
Database Login Details
Enter the User Name and Password for the database in the designated fields.
Database
From the dropdown list, select a database to access.
Connection String
Click on the Connection String tab to display the connection string to the database.
.png)
In most cases the generated connection string requires no editing. However, if you wish to make any changes or add an option, click Edit (1).png){kind=small}
to open the Connection String Editor.
.png)
Copy a connection string from a UDL file or from a different tool and add advanced options.
Click Test Connection to test the connection. The system indicates whether or not the connection is working. Click OK.