SAP Business Objects ​

Prerequisites ​

  • SAP Business Objects 4.2 SP5+
  • Hive OBDC Connector (32 bits)

1. Create a 32bits DSN ​

1. Launch the OBDC 32bits application and Open the System DSN tab, select 'SAP Hive ODBC Driver' and hit "Configure".

  • In 'Hive Server Type' choose "Hive Server 2".

2. Open 'Advanced Options' and tick both "Get Tables with Query" and "Unicode SQL Character Types" boxes:

2. Connecting to an Indexima cluster using 'Information Design Tool' ​

1. Create a relational connection and select "Simba ODBC Drivers".

2. Choose the DSN you previously created.

3. Change parameter in the business layer configuration ​

1. In the Business Layer panel, hit "Parameters".

2. Change the 'Distinct_values' parameter to "GROUPBY".