• Enabling the data source
• Creating an SAP HANA data source
  • Creating a named connection (optional)
  • Configuring the data source

Enabling the data source

The SAP HANA data source is deactivated by default in DigDash Enterprise. To activate the data source, the following file must be modified to uncomment the part concerning SAP HANA:
apache-tomcat/webapps/ddenterpriseapi/WEB-INF/classes/resources/config/tabledsrepository.xml

should become :

Next, you need to install the JDBC driver for SAP HANA in DigDash (see Add JDBC driver).
After making these changes, restart the DigDash server.

Creating an SAP HANA data source

Creating a named connection (optional)

You can create a named connection so that you can reuse this connection in several different data sources. By centralising the configuration of your connection, you will be able to reconfigure the connection more easily without having to change data sources in the future if required.

To create this named connection :

1. Open the database connection management interface.
2. Click on the add button.
3. Choose SAPHANA from the drop-down list.

4. Fill in the connection information:

   • Server: The address of the SAP HANA server.
   • Port: The database port.
   • Options: Additional connection options to configure authentication and/or connection settings.
   • User: The user to authenticate with.
   • Password: The user's password.

Configuring the data source

1. Click on Templates in the Studio.
2. Click on SAP HANA in the Databases category.
3. Choose a named connection or set up a manual connection.
4. Configure your query using the query creation wizard:
   • Select a view or table from the tree on the left.
   • Select the columns you want to retrieve from the table at the top right.
   • If necessary, add filters by dragging and dropping columns from the top right-hand table to the bottom right-hand table.
5. Once the query has been configured, you can preview the data in the Columns tab.
6. Click on Next.