CODEWITHSUNDEEP
ibm-mobilefirstworklight-adaptersmobilefirst-adaptersmobilefirst-serverworklight-server
MichealSmith
MichealSmith

Reputation: 183

IBM MobileFirst and SQL Adapter

I have a MS-SQL server and I want to connect IBM SQL Adapter to get data from one table. Does IBM MFPF support MS-SQL server connectivity ?

can anyone share their experience how to connect with MS-SQL Server ?

Upvotes: 0

Views: 51

Answers (1)

Smitha TV
Smitha TV

Reputation: 51

Yes, MobileFirst provides supports for MS-SQL server connectivity.

There are three approaches you can take:

1) Use Java SQL Adapters. 2) Use Javascript SQL Adapters. 3) Use Java adapters.

For 1) and 2) the DB connection details are specified in the adapter.xml directly. Alternatively you can define a datasource in the application server and refer that in the adapter.xml

Option 3) involves the use of Java adapters and the developer filling in Java code that connects to and performs CRUD operations on MS-SQL.

Upvotes: 0

Related Questions