- HDBODBC DRIVER WINDOWS HOW TO
- HDBODBC DRIVER WINDOWS INSTALL
- HDBODBC DRIVER WINDOWS DRIVERS
- HDBODBC DRIVER WINDOWS FULL
- HDBODBC DRIVER WINDOWS PASSWORD
This completes the steps for the initial connection to SAP HANA in MicroStrategy for Windows environments. 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 can often be found along with the driver installation.
HDBODBC DRIVER WINDOWS PASSWORD
Replace pwd with the password for the SAP HANA user account described above.įor information on the available parameters, refer to your third-party SAP HANA driver documentation. Replace uid with a valid SAP HANA user account. Contact your SAP HANA database administrator for the required port number.
Replace port with the port number for the connection to the SAP HANA database. Replace ip_address with the IP address for the machine that hosts the SAP HANA database. Replace with the location where you installed the SAP HANA ODBC driver files. Copy the section into the odbc.ini file.Įdit the following information from the syntax that you copied to odbc.ini: Open the file and find the section that starts with. In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation. Save the ODBC.sh file and remove Write privileges from the file by entering the following command: Do not modify any other occurrences of within odbc.sh. Replace this placeholder with the location of the SAP HANA ODBC driver files. Within the ODBC.sh file, the following definition is included: In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation.Browse to the folder env.Īdd Write privileges to the ODBC.sh file by entering the following command:Įdit the odbc.sh file and provide the location where you installed the SAP HANA ODBC driver files.
HDBODBC DRIVER WINDOWS DRIVERS
For specific installation steps, refer to your third-party SAP documentation.įor exact version numbers of SAP HANA drivers certified with MicroStrategy, refer to the MicroStrategy General Information Readme.
HDBODBC DRIVER WINDOWS INSTALL
Install the SAP HANA ODBC driver files on the Linux system that will host the MicroStrategy Intelligence Server. To configure an ODBC Driver for SAP HANA on Linux 1 For additional configuration requirements, see Additional requirements to support SAP HANA. 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. For information on creating a database instance, see Creating a database instance. To use an SAP HANA as a data source, you must create a database instance in MicroStrategy.
HDBODBC DRIVER WINDOWS HOW TO
For information on how to use the MicroStrategy DB Query Tool, see Using the DB Query Tool. You can use the MicroStrategy DB Query Tool to test whether data can be retrieved data from your SAP HANA data source. Using the Microsoft ODBC Data Source Administrator, create a data source name to connect to your SAP HANA data source.įor 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. Install the SAP HANA ODBC driver files on the Windows system that will host the MicroStrategy Intelligence Server. To configure an ODBC Driver for SAP HANA on Windows 1 Select permission for the _SYS_REPO schema. Insert permission for the _SYS_BIC schema. In addition, ensure the following permissions are defined for your SAP HANA user account:
HDBODBC DRIVER WINDOWS FULL
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. MicroStrategy recommends that the SAP HANA user account used to create the database is granted full permissions for the database. To configure an ODBC Driver for SAP HANA on Linux To configure an ODBC Driver for SAP HANA on Windows
The following steps show how to configure ODBC driver for SAP HANA 1.x. The ODBC driver for SAP HANA is not a MicroStrategy-branded driver. Connecting to Databases and Data Sources » Creating DSNs for specific data sources » ODBC Driver for SAP HANA for Windows and Linux ODBC Driver for SAP HANA for Windows and Linux
0 kommentar(er)
