Hana Odbc Driver Configuration
PurposeHere is a simple example of an ODBC driver connecting to Databases for Smart Data Analytics. OverviewTo connect to Databases such as Adaptive Server Enterprise(ASE) an ODBC driver is needed.
By default the HANA ODBC Driver is setup, but others are not. UnixODBCunixODBC is a 3rd party tool to house ODBC drivers from different companies. Note: You can add ODBC tracing by adding this to the top of your odbcinst.ini file:ODBCTrace = yesTraceFile = /sql.log ODBC in SDSTo add an ODBC driver to SDS:. Open HANA Studio. Data Services tab.
Hana Odbc Drivers
Establish a connection to your SDS server. Right click Default Add ODBC Services. Properties: User = Password = ODBC DSN = AdapterGenericDBinput or GenericDBoutput can be used to connect to the Databases.Database Service Name = DSN / Related Content Related Documents Related sap notes/kbas.
.If the ASA database resides in an NTFS folder, make sure theWindows 'Network Service' or 'Everyone' user has full controls over thatfolder, otherwise, testing of the data source may fail.Enable the connection pooling setting in ODBC driver, otherwise,the data source pools settings in AEM will not take effect, and theruntime performance of the deployed applications may dramatically slowdown. Detailed steps are as below:(1) Open ODBC Administrator.(2) Switch to the Connection Poolingtab, as shown in the following figure.(3) Select the Enable option in thePerfMon group box, as shown in thefollowing figure.(4) Select SQL Anywhere 10 from theODBC Drivers list box, or any other driveryou want, and double click it.