Configure data source

To use AVEVA Adapter for RDBMS, you must configure the adapter to collect data from one or more relational databases using the data source configuration. The data source configuration defines properties to communicate with the source relational database through a specified data provider.

Data providers

The data source configuration allows you to choose between two data providers: SQLServer or Open Database Connectivity (ODBC). The SQLServer data provider allows you to connect to a Microsoft SQL Server without any additional software. The ODBC data provider allows you to connect to any ODBC-compliant relational database.

Note: When using the ODBC data provider, you need to install an appropriate ODBC driver for your data source. For more information on ODBC drivers, refer to the Microsoft's ODBC Programmers Reference and the manual for the ODBC driver you are using.

Postman

To configure the data source using Postman:

1. To initialize the configuration, use the PUT method in conjunction with the http://localhost:5590/api/v1/configuration/<componentId>/DataSource REST endpoint.

   Note: If you installed the adapter to listen on a non-default port, update 5590 to the port number in use.

2. Copy and paste an example configuration for the data source into the Body section.

   For sample JSONs, see the Examples section.

3. Update the example JSON parameters for your environment.

4. Select Send to push the configuration to the adapter.

EdgeCmd

To configure the data source using EdgeCmd:

5. Using a text editor, create an empty text file.

6. Copy and paste an example configuration for the data source into the file.

7. Update the example JSON parameters for your environment.

   For sample JSONs, see the Examples section.

8. Save the file. For example, ConfigureDataSource.json.

9. Open a command line session. Change directory to the location of your saved file.

10. Use the following edgecmd command with the name of your JSON file. For this example, we will use ConfigureDataSource.json for the saved file.

    edgecmd -port <port number> -cid <componentId> set DataSource -file /.ConfigureDataSource.json

For a list of other REST operations you can perform, like updating or deleting a data source configuration, see the REST URLs section.

After data source configuration is complete, you must configure data selection to define the streams to collect from the data source.