» » ODBC Driver for SAP HANA for Windows and Linux ODBC Driver for SAP HANA for Windows and Linux The ODBC driver for SAP HANA is not a MicroStrategy-branded driver. The following steps show how to configure ODBC driver for SAP HANA 1.x. Prerequisites:.
Get real-time, high-performance connectivity to SAP HANA from your favorite BI and reporting tools with Progress DataDirect SAP HANA ODBC drivers. The Tableau web site only points me to the SAP Marketplace. Download SAP HANA client and run hdbsetup which will install ODBC driver to.
MicroStrategy recommends that the SAP HANA user account used to create the database is granted full permissions for the database. If the database user account cannot be granted full permissions to the database, you can use the recommendations listed in to determine the required permissions for the SAP HANA database user account. In addition, ensure the following permissions are defined for your SAP HANA user account: ▫ Insert permission for the SYSBIC schema.
▫ Select permission for the SYSREPO schema. To configure an ODBC Driver for SAP HANA on Windows 1 Install the SAP HANA ODBC driver files on the Windows system that will host the MicroStrategy Intelligence Server. For specific installation steps, refer to your third-party SAP documentation. For exact version numbers of SAP HANA drivers certified with MicroStrategy, refer to the MicroStrategy General Information Readme. 2 Using the Microsoft ODBC Data Source Administrator, create a data source name to connect to your SAP HANA data source.
For best practices on using the Microsoft ODBC Data Source Administrator to create data source names that are to be used in MicroStrategy, see. 3 You can use the MicroStrategy DB Query Tool to test whether data can be retrieved data from your SAP HANA data source. For information on how to use the MicroStrategy DB Query Tool, see. 4 To use an SAP HANA as a data source, you must create a database instance in MicroStrategy.
For information on creating a database instance, see. When creating a database connection, which is part of a database instance, ensure that you select Non UTF-8 as the character set encoding for Windows drivers.
This completes the steps for the initial connection to SAP HANA in MicroStrategy for Windows environments. For additional configuration requirements, see. To configure an ODBC Driver for SAP HANA on Linux 1 Install the SAP HANA ODBC driver files on the Linux system that will host the MicroStrategy Intelligence Server. For specific installation steps, refer to your third-party SAP documentation. For exact version numbers of SAP HANA drivers certified with MicroStrategy, refer to the MicroStrategy General Information Readme.
To configure the environment 2 In a Linux console window, browse to HOMEPATH, where HOMEPATH is the directory you specified as the Home Directory during installation. Browse to the folder env. 3 Add Write privileges to the ODBC.sh file by entering the following command: chmod u+w ODBC.sh 4 Edit the odbc.sh file and provide the location where you installed the SAP HANA ODBC driver files. Within the ODBC.sh file, the following definition is included: SAPHANAPATH=' Replace this placeholder with the location of the SAP HANA ODBC driver files. Do not modify any other occurrences of within odbc.sh.
5 Save the ODBC.sh file and remove Write privileges from the file by entering the following command: chmod a-w ODBC.sh To configure a DSN 6 In a Linux console window, browse to HOMEPATH where HOMEPATH is the directory you specified as the Home Directory during your MicroStrategy installation. 7 Open the odbc.ini.example file and find the section that starts with SAP HANA. Copy the section into the odbc.ini file. 8 Edit the following information from the syntax that you copied to odbc.ini:. Driver= /libodbcHDB.so Replace with the location where you installed the SAP HANA ODBC driver files. Servernode= ipaddress: port ▫ Replace ipaddress with the IP address for the machine that hosts the SAP HANA database. ▫ Replace port with the port number for the connection to the SAP HANA database.
Contact your SAP HANA database administrator for the required port number. USER= uid Replace uid with a valid SAP HANA user account. PASSWORD= pwd Replace pwd with the password for the SAP HANA user account described above. For information on the available parameters, refer to your third-party SAP HANA driver documentation. This can often be found along with the driver installation. 9 Save the odbc.ini file.
10 You can use the MicroStrategy DB Query Tool to test whether data can be retrieved data from your SAP HANA data source. For information on how to use the MicroStrategy DB Query Tool, see. 11 To use an SAP HANA as a data source, you must create a database instance in MicroStrategy.
For information on creating a database instance, see. When creating a database connection, which is part of a database instance, for SAP HANA, ensure that you select Non UTF-8 as the character set encoding for UNIX drivers. This completes the steps for the initial connection to SAP HANA in MicroStrategy for Windows environments. For additional configuration requirements, see below.
Additional requirements to support SAP HANA Review the following additional requirements to ensure a successful integration of SAP HANA in MicroStrategy:. Be aware that once you import tables from SAP HANA into MicroStrategy, you must manually import any prefix information as well.
Using the Warehouse Catalog, you can select all tables imported from SAP HANA and select Import Prefix to import the prefix information. For additional steps to access and use the Warehouse Catalog, see the. If the tables in SAP HANA include input parameters, these are supported in MicroStrategy using prompts. Using the Table Editor available in MicroStrategy Developer, you can create and modify prompts to support input parameters. For steps to access and use the Table Editor, refer to the Project Design Help.
How To: Configure an ODBC driver to connect to a SAP HANA database Summary To make a database connection from ArcGIS to SAP HANA, an Open Database Connectivity (ODBC) driver must be configured. The following article describes making the connection to a SAP HANA database, but configuring the ODBC is very similar for any other database that supports this method of connection. This article assumes the database client files have already been installed. Procedure.
Open the 32-bit ODBC administrator by navigating to the following path: C: Windows SysWOW64 odbcad32.exe. Under the System DSN tab, click the Add button. Select the driver to be configured.
In this example, HDBODBC32 is selected from the list of drivers. Click Finish. A dialog box appears. Fill out the Data Source Name, Description and Server:Port fields.
Click the Settings. Button, and click Add. Enter the following: Property: SPATIALTYPES Value: 1 Click OK. Click OK to complete the driver configuration. Additionally, click the Connect button to verify that a successful ODBC connection can be established with the server.
From the system's Environment Variables, update the Path variable to include the SAP Client location, which contains the.exe and.dll files (The default location is C: Program Files (x86) sap hdbclient;). Place it at the beginning of the Path variable's value, as seen below.
Use the Data Source name created in Step 4 to connect from ArcCatalog. Related Information.