How to Integrate the HANA Database with SMP/Agentry?

[Former Member]

Dears, Good Day!

Kindly share the inputs/suggestions on the subjected query.

Needs to post the data from Agentry Mobile Application built on SMP 3.0 to HANA Database;

How to integrate the HANA Database from Agentry using SQL System Connection.

Steps Carried :

Created the ODBC Datasource/System DSN using HDBODBC driver (Using this DSN Name in Agentry.ini SQL connection section dbConnectionName).

What are the Mandatory parameters/values needs to set in Agentry.ini(@ SQL system Connection) apart from the dbConnectionName, dbConnectionUserid & password?

dbConnectionType=ODBC or ???

queryInitFile=???

queryConstantFiles=???

Kindly suggest.

Regards,

Tirupati

[bill_froelich · Accepted solution]

Tirupati,

While I have not personally connected to HANA yet I don't see why it wouldn't work.

The dbConnectionType should be ODBC

The queryInitFile should be set to sqlBE.ini and you should copy the template version from the C:\SAP\MobilePlatform3\Server\configuration\com.sap.mobile.platform.server.agentry directory to your application directory.

The queryConstantFiles points to the file that contains the mappings between the SQL SDML tags and the substituions you need for the backend database.  Take a look at the sqlserver_sd.ini and oracle_sd.ini files as examples and you can create a version for HANA and put the file in your application directory and point to it with this setting.

Good luck and let us know how it goes.

--Bill

[Former Member · Accepted solution]

Thank you Bill for your information!

We are able to integrate the SAP HANA DB with Agentry successfully.

Sharing the steps for feature reference.

- Install SAP HANA HDBODBC 64 bit driver(As per your client Machine).

- Create the ODBC Datasource/System DSN using HDBODBC driver (Note the DSN Name)

- Create the SQL System Connection in Agentry Application and publish

- Create the sqlBEHDB.ini file(copy of the existing sqlBE.ini) and add only the required sections(Sections :Misc, ValidateUser, RealidateUser & ValidatePreviousUser)

- Create the queryconstantfile(hanaHdb_sd.ini) as per the SAP HANA HDB database(refer Oracle_sd.ini & sqlServer_sd.ini)

- Place the sqlBEHDB.ini, hanaHdb_sd.ini files into agentry application folder

- Update the following details in SAP Management cockpit(Application Back-End Tab) - as per the attached snap shot.

[agentry_src]

Discussion successfully moved from SAP for Mobile to SMP Developer Center as the more appropriate venue for this question.

Regards, Mike (Moderator)

SAP Technology RIG