How-to connect LiveCycle Data Services 2.6 to Microsoft SQL Server

Flex is front-end only. So, when you want to get information from one of your databases, you need 'something else' to transport your data between the database and the Flex front-end. This 'something', you often have to make from scratch, and names and structure are often partly redundant, as it copies existing code, written in ActionScript/Flex.

Adobe LiveCycle Data Services is capable of providing this missing link, without writing a single line of code, by using its SQL Adapter. You specify SQL statements directly in a configuring file, for Creating, Reading, Updating and Deleting information (CRUD).

Here in Scandinavia, "all" databases are Microsoftified, therefore I would very much like to connect to Microsoft SQL Server. Though, finding examples for connecting to MSSQL wasn't that easy. 

 

Being a newbie to Flex, LiveCycle Data Services and Java application servers in general didn't make it easier. But I've succeeded, and here's my story for others in the same situation:

1. Download and install Livecycle Data Services  2. Understand the folders of LCDS and Tomcat, the java app server 3. Explore the existsing sample HSQLDB database and its configuration 4. Create a Flex application reading the sample database 5. Install MSSQL Java drivers 6. Set up MSSQL and LCDS' connection As you see, I'm not yet finished writing all the sub sections. But they will come...