Install & Config2019
The ODBC driver for SAP HANA is not a MicroStrategy-branded driver. The following steps show how to configure ODBC driver for SAP HANA.
Under Latest 5.0 Downloads find Download ODBC Driver, and then find the ODBC driver for your Windows environment (x86.msi or x8664.msi). Click the link to download and install the driver. Step 1: Download the client package. Install the Download Manager to your client machine and download the client package. Save the Download Manager installation files to your client machine and open it. For instructions on downloading and running the Download Manager, see either the Installing SAP HANA 2.0, express edition (Binary Installer. Add the SAP HANA database ODBC driver to the ExpressConnect for HANA DB installation. Download these libraries from the SAP Service Marketplace and install them after you have installed Replication Server.
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 Required database permissions to create metadata, History List, and statistics repositories 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: Zebra lp 2844 z driver for mac.
- Insert permission for the
_SYS_BIC
schema. - Select permission for the
_SYS_REPO
schema. - Select permission for the
_SYS_BI
schema.
To be able to execute reports that create temporary tables, you need theCREATE ANY
permission.
To Configure an ODBC Driver for SAP HANA on Windows
How To Install Odbc Drivers
- 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.
- 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 Managing ODBC and data sources with Microsoft ODBC Data Source Administrator.
- 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 Using the DB Query Tool.
- 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 Creating a database instance.
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 Additional Requirements to Support SAP HANA.
To Configure an ODBC Driver for SAP HANA on Linux
Begin by installing 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.
The following set of instructions are divided into two sections: how to configure your environment and how to configure a DSN.
To Configure the Environment
- In a Linux console window, browse to
HOME_PATH
whereHOME_PATH
is the specified home directory during installation.Browse to the folderenv
. - Add Write privileges to the
ODBC.sh
file by entering the following command: - Edit the
odbc.sh
file and provide the location where you installed the SAP HANA ODBC driver files. Within theODBC.sh
file, the following definition is included:SAPHANA_PATH=''
Replace this
placeholder with the location of the SAP HANA ODBC driver files. Do not modify any other occurrences of
within
odbc.sh
. - Save the
ODBC.sh
file and remove Write privileges from the file by entering the following command:
To Configure a DSN
- In a Linux console window, browse to
HOME_PATH
whereHOME_PATH
is the specified home directory during installation. - Open the
odbc.ini.example
file and find the section that starts with[SAP HANA]
. Copy the section into theodbc.ini
file. Edit the following information from the syntax that you copied to
odbc.ini
:Driver=
/libodbcHDB.so
Replace
Direct wav mp3 splitter 3.0 serial. with the location where you installed the SAP HANA ODBC driver files.
Servernode=
ip_address
:
port
Replace
ip_address
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.
- Save the
odbc.ini
file. - 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 Using the DB Query Tool.
- 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 Creating a database instance.
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 Linux drivers.
This completes the steps for the initial connection to SAP HANA in MicroStrategy for Windows environments. For additional configuration requirements, see Additional Requirements to Support SAP HANA below.
To Configure a DSN‑less Connection
To configure the ODBC driver for DSN‑less connection, an additional step is required along with the steps in the To Configure a DSN section above.
Open the odbcinst.ini file and find this section:
- Replace the placeholder with the location where you installed the SAP HANA ODBC driver files. The path is the same as specified in the odbc.ini file.
- Restart the Intelligence Server.
Additional Requirements to Support SAP HANA
Sap Hana Driver Download
Review the following additional requirements to ensure a successful integration of SAP HANA in MicroStrategy:
Oracle Odbc Driver Download
- 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 Project Design Guide.
- 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.