Configuration examples

The following tables provide examples for all configurations available for AVEVA Adapter for RDBMS.

Note: The examples in this topic are using the default port number 5590. If you selected a different port number, replace it with that value.

System components configuration with two RDBMS adapter instances

[

{

"componentId": "RDBMS1",

"componentType": "RDBMS"

},

{

"componentId": "RDBMS2",

"componentType": "RDBMS"

},

{

"componentId": "OmfEgress",

"componentType": "OmfEgress"

}

]

Data source configuration

The following are examples of valid RDBMS data source configurations.

RDBMS minimum data source configuration for ODBC

[

{

"defaultStreamIdPattern": "{QueryId}.{ValueColumn}",

"connectString": "DSN=MyDSN",

"dataProvider": "ODBC"

}

]

RDBMS minimum data source configuration for SQL Server

[

{

"defaultStreamIdPattern": "{QueryId}.{ValueColumn}",

"connectString": "Server=ServerName\\SQLEXPRESS; UID=[username]; PWD=[password]",

"dataProvider": "sqlServer"

}

]

RDBMS data source configuration with Windows Authentication for SQL Server

[

{

"defaultStreamIdPattern": "{QueryId}.{ValueColumn}",

"connectString": "Server=ServerName\\SQLEXPRESS; Trusted_Connection=yes",

"windowsUser": "domain\\MyUser",

"windowsPassword": "MyPassword",

"dataProvider": "sqlServer"

}

]

Data selection configuration

There are two main ways to configure a selection item: by column or by row.

Column as an identifier

Temperature:

[

{

"streamId": "Tank1.Temperature",

"valueColumn": "Temperature",

"indexColumn": "SampleTime",

"scheduleId": "1min",

"queryId": "Tank1",

"selected": true

}

]

Pressure:

[

{

"StreamId": "Tank1.Pressure",

"ValueColumn": "Pressure",

"IndexColumn": "SampleTime",

"ScheduleId": "1min",

"QueryId": "Tank1",

"Selected": true

}

]

Volume:

[

{

"streamId": "Tank1.Volume",

"valueColumn": "Volume",

"indexColumn": "SampleTime",

"scheduleId": "1min",

"queryId": "Tank1",

"selected": true

}

]

Identifier in Row

Tank1.Temperature:

[

{

"streamId": "Tank1.Temperature",

"valueColumn": "Temperature",

"indexColumn": "SampleTime",

"selectColumn": "Asset",

"selectValue": "Tank1",

"scheduleId": "1min",

"queryId": "Tanks",

"selected": true

}

]

Tank2.Temperature:

[

{

"streamId": "Tank2.Temperature",

"valueColumn": "Temperature",

"indexColumn": "SampleTime",

"selectColumn": "Asset",

"selectValue": "Tank2",

"scheduleId": "1min",

"queryId": "Tanks",

"selected": true

}

]