Connecting via OLE DB Drivers

Object Linking and Embedding Database

The OLE DB provides access to a data source via an installed driver on the operating system regardless of the architecture of the data source.

In Sisense, it serves as a connector to data providers that are not included in the common providers list, such as SQL Server, MySQL, Oracle and so forth.

Adding a table to Sisense

  1. Click Add Data on the top menu of Sisense.
  2. Under the Database servers category select Generic OleDB Driver.
  3. In the Data Link Properties dialog, select a connection by choosing the relevant OLE DB driver and the connection properties.
  4. Note: When the data source server requires a login credentials, you must select the Allow saving password checkbox.
  5. Follow all wizard steps and click OK to move to the final dialog. From the tables selection dialog, select tables that you want to add and click Add to complete the wizard. Note: You may need to update the executed table query described below.

Setting the table query (Troubleshoot)

ODBC and OLE DB are generic drivers; therefore the SQL syntax being executed against the actual data source may vary from one provider to the other.

Sisense sets by default the standard SQL for the ODBC/OLE DB tables which covers most of the known data providers. For cases where non-standard SQL must be supplied, the table addition dialog provides a quick preview of the current SQL query and an edit button which opens the Query Properties dialog.

In the Query Properties dialog, two options are available:

Note: The automatic options can be applied on the current table or on all tables, while the manual option defines a single table and can only be applied on the current table. The Apply All and Apply Table buttons will be enabled according to the selection made.

Misc Troubleshooting: