IBM MobileFirst and SQL Adapter

48 Views Asked by At

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 ?

1

There are 1 best solutions below

1
Smitha TV On

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.