Creating an ODBC or OLE DB DataReader protocol

This type of DataReader protocol imports data from an ODBC or OLE DB data source, including OLE DB for OLAP (ODBO).

To create an ODBC or OLE DB DataReader protocol, go to the SQL tab of the DataReader click the action icon and select New Protocol.

 

 

The following protocol configuration window opens

 

 

 

 

Note:

You may double click on the table title bar to view the fields data types and a sample record. Refer to ODBC DataReader options for details on how to configure the automatic data type conversion of the table fields to Board's internal data types.

 

 

Note:

If you need to define complex transformation formulas you may use the ETL module.

 

 

Note that by changing the Join option, you can alter the syntax used for writing the Join statement.

 

 

 

Defining a DataReader protocol generates a SQL statement. When the protocol is launched, Board sends the SQL statement to the ODBC or OLE DB provider and waits for the results. Note that the SQL statement is entirely executed by the ODBC or OLE DB provider therefore the commands and syntax which can be used in the SQL statement entirely depend on the ODBC or OLE DB provider used.

It is recommended to test the protocol SQL statement using the Browse function: click the Browse button as shown is the illustration. The query will be executed on the first 200 rows and the resulting data is displayed in spreadsheet.

 

Note that Board is not meant to be a sophisticated SQL query generator, if complex queries are needed it is recommended to use an ad-hoc query tool or that to create a view in the relational database which performs the desired query, then use this view in the Board protocol.

Defining an ODBC Data Reader protocol generates an SQL statement. When the protocol is launched, Board sends the SQL statement to the OLE DB provider and waits for the results.. Note that the SQL statement is run on the OLE DB provider therefore the commands and syntax which are supported depend on the OLE DB provider you  connect to.

It is recommended you test the SQL statement using the Browse function: from the protocol definition window, click the Edit button, then click the Browse button. The query is executed on the first 200 rows and the result data is displayed in spreadsheet format.

 

Note:

The maximum length of an SQL statement is 3000 characters.