Configuring DataDirect SequeLink to Reference an ODBC System Data Source

Use the procedure described in this section to configure DataDirect SequeLink to reference an ODBC system data source.

To configure DataDirect SequeLink:
1. Start the DataDirect SequeLink 5.4 Manager. For example, Start > Programs > DataDirect SequeLink 5.4 Service for ODBC Socket > SequeLink 5.4 Manager Snapin.

The sladmin54 window appears.

Figure 366. DataDirect sladmin54 Window

2. Expand the SequeLink 5.4 Manager (localhost) branch. This exposes another branch, Not connected to SLAgent54.
3. Expand the Not connected to SLAgent54 branch.

The Logon to SequeLink Service dialog box appears.

Figure 367. DataDirect Logon to SequeLine Service Dialog Box

4. Enter a user ID and password and click OK to connect to the SequeLink Service you created when you installed the DataDirect SequeLink SocketServer. (This will be the user ID and password for the machine on which you installed the DataDirect SequeLink SocketServer.)

Figure 368. DataDirect sladmin Window - After Connecting

After connecting to the SequeLink Service, the information in the sladmin window changes.

5. Once you are connected, expand the SLSocket54 [active] branch as follows: Configuration > Data Source Settings > Default > Advanced. When you are done, your sladmin window should look like this:

Figure 369. DataDirect sladmin Window - Advanced Settings

6. Double-click DataSourceSOCODBCConnStr.

The DataSourceSOCODBCConnStr dialog box appears.

Figure 370. DataDirect Connection String Dialog Box

7. In the Value field, enter the following: DSN=data source name, where data source name is the name of the data source you created in step 6 of the procedure described in Creating an ODBC System Data Source.
8. Click OK, and close the sladmin window.

Now that you have created and configured the ODBC system data source, you can use it to create a DB-to-XML data source in Stylus Studio as described in Using DataDirect SequeLink as a DB-to-XML Data Source.

Map between EDIFACT and X12

Anything can be mapped to anything: EDIFACT to X12 or vice-versa, either to XML, and any of those to flat files or other formats. Both the XSLT and XQuery mappers can help bridge complex formats with ease.

XML Document Wizards

Stylus Studio XML Document Wizards help you easily convert EDI, flat files, and other document formats to industry-standard XML.

XML Publisher - XSLT Generator and XSL:FO Generator

The XML Publisher lets you easily design beautiful documents in HTML or PDF format from relational, XML and other data sources using XSL:FO or XSLT, using an intuitive visual interface.

XML Reports

Build beautiful XML reports from Relational, XML and Legacy Data. You XML report can be rendered in PDF or HTML using XSLT, XQuery or XSL:FO.

Stylus Most Wanted

 
Free Stylus Studio XML Training:
W3C Member