Enable Support of SAP HANA in CloudConnect

The GoodData platform can be integrated with the SAP HANA database.

If you are using SAP HANA for data transformations before the data is loaded to your project, enable support of SAP HANA in CloudConnect.

The steps vary depending on the operating system installed on your computer.

For a MacOS

Steps:

1. Copy the SAP HANA JDBC driver (that is, the file ngdbc.jar) to any directory on your computer, for example:

   /usr/share/drivers
   

2. Navigate to the folder where CloudConnect is installed. Right-click the CloudConnect application, and select Show Content Package. The Contents folder opens.

3. Go to Contents -> Eclipse, and locate the eclipse.ini file.

4. Open eclipse.ini in editable mode, and add the following line at the end of the file:

   -Dclover.designer.external-lib=file:/usr/share/drivers/ngdbc.jar
   

   The file location in this line must correspond to the actual path to ngdbc.jar on your computer.

5. Save the changes, and close eclipse.ini.

6. Start CloudConnect, and go to CloudConnect -> Preferences -> Java -> Installed JREs.

7. Select your installed JREs, and click Edit… . The edit dialog opens.

8. Click Add External JARs… , navigate to and select the SAP HANA JDBC driver stored on your computer, and click Open. The browse dialog closes. You are back to the edit dialog.

9. Click Finish, then click OK. The SAP HANA JDBC driver is added to CloudConnect.

10. Restart CloudConnect.

For a MS Windows OS

Steps:

1. Copy the SAP HANA JDBC driver (that is, the file ngdbc.jar) to any directory on your computer, for example:

   C:/Drivers/
   

2. Navigate to the folder where CloudConnect is installed, and locate the file CloudConnect.ini.

3. Open CloudConnect.ini in editable mode, and add the following line at the end of the file:

   -Dclover.designer.external-lib=file:C:/Drivers/ngdbc.jar
   

   The file location in this line must correspond with the actual path to ngdbc.jar on your computer.

4. Save the changes, and close CloudConnect.ini.

5. Start CloudConnect, and go to Window -> Preferences -> Java -> Installed JREs.

6. Select your installed JREs, and click Edit… . The edit dialog opens.

7. Click Add External JARs… , navigate to and select the SAP HANA JDBC driver stored on your computer, and click Open. The browse dialog closes. You are back to the edit dialog.

8. Click Finish, then click OK. The SAP HANA JDBC driver is added to CloudConnect.

9. Restart CloudConnect.

See also: Error ‘Cannot create JDBC driver SAP HANA’