Here is the story. Currently we support per NSF Application JDBC configured connections, whose definition lies inside special file with .jdbc extension. Global JDBC connections per server and additional DDE tooling support will be introduced later.
1. To be able to connect to your MS SQL database you would need to place Sample MS SQL plugin, provided here:
into your \domino\workspace\applications\eclipse\plugins directory.
If you'd like to try locally - then better approach is to use an update site, see here:
2. Have similar as described in that link mssql_test.jdbc file placed into your NSF Application under WebContent\WEB-INF\jdbc folder. For that you may need to use DDE Navigator view (via Window/Show Eclipse Views/Navigator), because standard DDE Applications view doesn't show that .
3. Open our sample XPagesJDBC.nsf in DDE, find JDBC_StaticViewPanelTable.xsp in it, find this section in it:
var="jdbcData1" defaultOrderBy="id" sqlTable="users"
and change connectionName to the name of your .jdbc file and sqlTable to your, for example:
var="jdbcData1" defaultOrderBy="id" sqlTable="mssqlusers"
4. On that same XPage change viewcolumn to retrieve values from your database, by altering these places:
<xp:viewColumn id="viewColumn3" columnName="firstName">
ang changing columnName to the name of a column/field inside your mssqlusers table.
5. Save your work and try preview via a web browser.
Hope that will help