The benefit of using the database name instead of the port is that it allows for changing the port of the database (e.g. When a tenant DB is moved to a server that already has a different tenant DB using the ports) without having to change the meaning of the connection in the application code. The instance number (which drives what ports to use) is an operational detail, that has zero meaning to the clients - except for the connection string. So, avoiding the use of the ports helps with independence from the DB operations. – Jul 26 '18 at 4:54. That makes sense. I found one instance where the DATABASE method resulted in not being able to make a connection though - when connecting to a HANA server running on an Azure VM.
When I try to just provide the hostname and database name in HANA Studio I can't connect, but when I just provide the hostname:port number (and omit the DATABASE property) I can connect using ODBC Test. Interestingly, if I attempt to connect from another Azure VM I can connect using the DATABASE connection property. Any idea what's going on?
To make a database connection from ArcGIS to SAP HANA, an Open Database Connectivity (ODBC) driver must be configured. Description and Server:Port fields. Additionally, click the Connect button to verify that a successful ODBC connection can be established with the server.
– Jul 26 '18 at 15:38.
![Odbc server port for hana odbc windows 7 Odbc server port for hana odbc windows 7](http://www.oms.cherware.de/wp-content/uploads/sites/2/2017/05/createdsn2.jpg)
» » 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:.
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.