Send COM port data to ODBC database (Oracle, MS SQL, MY SQL …)

 

When inserting data into the database CPS Plus uses the following SQL template:

INSERT INTO TABLE_NAME(Column list) VALUES ('FIELD1', 'FIELD2', ... 'FIELDN').

 

The data read from the serial device can be further divided into several parts in order to be inserted into different columns.

Division into columns of the read data is determined by a separation character. CPS Plus uses values of placeholder variables FIELD1, FIELD2, FIELD3...FIELDx to construct SQL insertion statement. Values of these placeholder variables are populated by read data from COM port. If separator character is not found among read data, CPS will place complete read data string into placeholder variable ‘FIELD0’. If separator character is found, CPS Plus will split read data string into parts and these parts will be passed to variables  ‘FIELD1’, ‘FIELD2’ …’FIELDN’respectfully.

 

To define separator character, columns, table and database in which CPS will insert the data, use “‘ODBC Connection Wizard’.

 

ODBC data logging option can be set at the level of all COM ports or on the level of individual COM ports or devices connected to the COM port.

 

If you want to enable data logging using ODBC drivers,  at the level of all available COM ports, select "Send Serial Data to Database Using ODBC' in ‘Log Mode’ menu displayed on the CPS Plus Terminal window.

 

If you want to enable data logging using ODBC drivers, on the level of a single COM port, click the COM port settings through the CPS Plus terminal window, and then click on the button 'Data Logging Options’. When configuration dialog appears, with the available options for selected COM port, select the option “‘Send Serial Data to Database Using ODBC' and then activate ‘ODBC Connection Wizard’ by clicking on the 'Setup ODBC Connection ...' button.