WebFOCUS BI

This section provides you with information on how to connect WebFOCUS to Exasol using the OBDC driver.

Prerequisites

  • Exasol ODBC driver installed on your operating system. You can download the driver from the download section.
  • Both the Exasol database and WebFOCUS Server must be able to communicate with each other through a network and the Exasol database must be running.

Connect WebFOCUS to Exasol

To be able to connect to Exasol from WebFOCUS, you need to first configure the adapter. You can configure the adapter from either the Web Console or the Data Management Console. If an adapter is already configure, it is listed in the Configured Adapters section.

Using the Web Console

  1. Login to WebFOCUS home page from the Web Console. Click Connect to connect to a data source.
  2. A new tab opens in your browse where you can configure the data source. Right click New Datasource to configure a new data source.
  3. A splash screen with a list of adapters is displayed. Select Exasol from the list.
  4. Configure the connection by entering the relevant parameters in the Connect parameters section. In the Environment section, select edasprof from the drop-down menu to the add this connection for all users or select a user profile.
    • Connection Name: Name to identify this connection.
    • System: Address of the machine where Exasol database is running.
    • Security: Authentication method to be used when connecting the user to the database.
    • User: Primary authorization ID by which you are known to the data source.
    • Password: Password associated with the primary authorization ID.
    • Additional connection string keywords: Can be used to add options to the connection string.
  5. Click Test to test the connection. You should see a sample list of objects stored in the Exasol data source you are accessing. Click Configure to complete the configuration.
  6. Right click on the Exasol data source and then select Show DBMS objects.
  7. The Owner/Schema drop-down list displays the schemas in your Exasol database. Select the desired schema. As an example in the below screenshot, RETAIL is selected as the Owner/Schema. All the tables for the selected schema are displayed.
  8. Select the checkbox next to the tables you need. Next, select the purple Run icon on the top left of the screen.
  9. A class diagram of the selected tables and the relationship between them is displayed. You can further model the data if you wish and preview it. Once complete, select the purple Run icon.
  10. Save the Synonym in the designated application folder. Synonym is a unique name or alias for each Exasol table accessible from the server.
  11. The saved data model will now appear in your Domains folder within your Home page. Right clicking on the data model allows you to create content, alternately if you create a chart, you can browse to the application folder you saved the Synonym in.
  12. Next, you can drag Measures and Dimensions from the fields on the screen to create content.

Using the Data Management Console

The procedure to configure a data source using the Data Management Console is identical to using the Web Console. However, the Data Management Console provides additional administration functionalities to an administrator. Follow the steps below to configure a data source using the Data Management Console:

  1. Login to WebFOCUS Data Management Console, select Connect to Data from the menu on the left of the screen. Then select New Datasource in the Adapters/ Connections panel.
  2. A splash screen with a list of adapters is displayed. Select Exasol from the list.
  3. Configure the connection by entering the relevant parameters in the Connect parameters section. In the Environment section, select edasprof from the drop-down menu to the add this connection for all users or select a user profile.
    • Connection Name: Name to identify this connection.
    • System: Address of the machine where Exasol database is running.
    • Security: Authentication method to be used when connecting the user to the database.
    • User: Primary authorization ID by which you are known to the data source.
    • Password: Password associated with the primary authorization ID.
    • Additional connection strung keywords: Can be used to add options to the connection string.
  4. Click Test to test the connection. You should see a sample list of objects stored in the Exasol data source you are accessing. Click Configure to complete the configuration.
  5. Right click on the Exasol data source and then select Show DBMS objects.
  6. The Owner/Schema drop-down list displays the schemas in your Exasol database. Select the desired schema. As an example in the below screenshot, RETAIL is selected as the Owner/Schema. All the tables for the selected schema are displayed.
  7. Select the checkbox next to the tables you need. Next, select the purple Run icon on the top left of the screen.
  8. A Business View of the selected tables and the relationship between them is displayed. You can further model the data if you wish and preview it. Once complete, select the purple Run icon.
  9. Save the Synonym in the designated application folder. Synonym is a unique name or alias for each Exasol table accessible from the server.
  10. The saved data model can be accessed from the Data Management Console Home page.
  11. Next, you can drag Measures and Dimensions from the fields on the screen to create content.