Connecting to SAP HANA in Data Virtualization
You must configure SAP HANA as a data source before you can create a connection to it in Data Virtualization.
Before you begin
Procedure
To connect to SAP HANA in Data Virtualization:
On the navigation menu, click Data sources page appears.
. TheClick
to view a list of data sources.-
Select the SAP HANA data source connection.
-
Specify the following information:
- Name of the database
- Hostname or IP address and port number of the database
-
Select a JDBC Driver JAR from the drop-down list.
To upload a JDBC Driver JAR file, follow these steps.
-
Enter SAP HANA in the Connection type field.
-
Upload the ngdbc.jar file.
-
For the driver class name, enter com.sap.db.jdbc.DriverSapDB.
-
For the JDBC URL prefix, enter jdbc:sap.
-
Click Upload.
-
-
Specify the username and password that allow access to the data source.
-
If you want to use SSL to connect to the database, copy the content of the SSL certificate and paste it in the corresponding box.
-
Click Create to add the connection to the data source environment.