IBM SPSS Modeler 配置使用 SDAP 驱动

weiliwei

Installation
1. Download the latest support version of SDAP installer from the Dashboard
2. Log on to system as root user.
3. Run the bin file, for example:
     # ./SDAP_7.1_Linux64.bin
4. Uncompress the tar file generated from the bin package, for example,
     # tar zxvf SDAP_7.1_linux64.tar.gz

Configuration
1. Run setodbcpath.sh:
     # ./ setodbcpath.sh
2. Edit the odbc.ini file to configure the required databases. The following are some tips for each database configuration in SDAP:
- <>must be removed
- SQL Server
     i) EnableQuotedIdentifiers=1
     If this is set to 0, the following error will be reported:
     Error: HY000[102] [IBM SPSS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 'cardid'.
      ii) Fetch TWFS as Time=1
      If this is set to 0, the Time storage data will be shown as $Null.
- DB2
     UseCurrentSchema=0
     0 indicates you can see others' tables
     1 indicates you only can see your own tables
- Oracle
     Configure either ServiceName or SID
- DB2 z/OS
     Configure Location, Collection and Port
- DB2 iSeries
     Configure Location and Port
3. Edit odbc.sh file to executable.
4. Edit modelersrv.sh in Modeler Server installation to add the location of odbc.sh, for example:
. /qatest/SDAP711/odbc.sh (Note that there is a space between "." and "/")
5. Configure in bin folder of Modeler Server installation:
# rm -rf libspssodbc.so
# ln -s libspssodbc_datadirect.so libspssodbc.so
Or
# ln -s libspssodbc_datadirect_utf16.so libspssodbc.so
Note that for SAP HANA and DB2 CLI, only the s libspssodbc_datadirect_utf16.so can be used.
6. Restart Modeler Server