INDCONN Macro Variable

The INDCONN macro variable is used to provide credentials to connect to SAP HANA. You must specify user ID and password to access the machine on which you have installed the SAP HANA system. You must assign the INDCONN macro variable before the %INDHN_CREATE_MODELTABLE, the%INDHN_PUBLISH_MODEL, and the %INDHN_PUBLISH_MODEL macros are invoked.

Note: If you do not specify the connection information in the INDCONN macro variable, use the %INDHN_CREATE_MODELTABLE, %INDHN_PUBLISH_MODEL, or %INDHN_RUN_MODEL macro DATABASE= argument to specify the DSN.

Here is the syntax for the value of the INDCONN macro variable:

USER=user PASSWORD=password
<SERVER=server>
<PORT=port-number | INSTANCE=instance-number >
<SCHEMA=schema-name>
<PRESERVE_TAB_NAMES=YES | NO>
<PRESERVE_COL_NAMES=YES | NO>

Arguments

USER=user

specifies the SAP HANA user name (also called the user ID) that is used to connect to the database.

PASSWORD=password

specifies the password that is associated with your SAP HANA user ID.

Tip	Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error.

SERVER=server

specifies the SAP HANA server name or the IP address of the server host.

Interaction

You can use the DATABASE= argument in the %INDHN_CREATE_MODELTABLE, %INDHN_PUBLISH_MODEL, or %INDHN_RUN_MODEL macro instead of specifying the SERVER= argument.

PORT=port-number

specifies the port number.

Interactions	Specify either the PORT= argument or the INSTANCE= argument.
	You can use the DATABASE= argument in the %INDHN_CREATE_MODELTABLE, %INDHN_PUBLISH_MODEL, or %INDHN_RUN_MODEL macro instead of specifying the PORT= argument.

INSTANCE=instance-number

specifies the instance number.

Interactions	Specify either the PORT= argument or the INSTANCE= argument.
	You can use the DATABASE= argument in the %INDHN_CREATE_MODELTABLE, %INDHN_PUBLISH_MODEL, or %INDHN_RUN_MODEL macro instead of specifying the INSTANCE= argument.

SCHEMA=schema-name

specifies the SAP HANA schema that contains the tables and views that you want to access.

Default

If you do not specify a value for the SCHEMA argument, the default schema is used.

PRESERVE_TAB_NAMES=YES | NO

preserves spaces, special characters, and case sensitivity in SAP HANA table names.

YES

specifies that table names are read from and passed to the SAP HANA with special characters, and the exact, case-sensitive spelling of the name is preserved.

NO

specifies that when you create SAP HANA tables or refer to an existing table, the table names are derived from SAS member names by using SAS member name normalization. However, SAP HANA applies its own normalization rules to the SAS member names. Therefore, the table names are created or referenced in the database following the SAP HANA normalization rules.

Default

PRESERVE_COL_NAMES=YES | NO

preserves spaces, special characters, and case sensitivity in SAP HANA column names when you create SAP HANA tables.

YES

specifies that column names that are used in table creation are passed to the DBMS with special characters and the exact, case-sensitive spelling of the name is preserved.

NO

specifies that column names that are used to create SAP HANA tables are derived from SAS variable names (VALIDVARNAME= system option) by using the SAS variable name normalization rules. However, SAP HANA applies its own normalization rules to the SAS variable names when creating the SAP HANA column names.

Default

Tip

The INDCONN macro variable is not passed as an argument to the %INDHN_PUBLISH_MODEL macro. This information can be concealed in your SAS job. For example, you can place it in an autoexec file and apply permissions to the file so that others cannot access the user credentials.