Business Integration Solutions documentation

How to: Set up an external document for SQL integration

Use this task to create an external document based on the tables and fields of a SQL database.

To set up an external document for SQL integration:

1. Go to the documents list page. Depending on the solution:

   • For Connectivity Studio: go to Departments > Business Integration Solutions > Connectivity Studio > Design > Documents.
   • For Notification Management: go to Departments > Business Integration Solutions > Notification Management > Design > Documents.
   • For Replication Management: go to Departments > Business Integration Solutions > Replication Management > Publications > Design > Documents for publications, or Subscriptions > Design > Documents for subscriptions.
   • For EDI Studio: go to Departments > Business Integration Solutions > EDI Studio > Design > Documents.

2. Select New.

3. On the General FastTab:

   • Select type as External and provide a document number and description.
   • Select subtype as SQL Server. This enables the SQL Server Connection FastTab.

4. On the SQL Server Connection FastTab, to connect to a SQL database:

   • Either specify SQL Server Name and SQL Database Name, or
   • Specify SQL Connection String.

5. Select the Design button to open the setup page.

6. Add tables and fields to define the document structure manually.

   When adding fields, the wizard shows which fields the SQL database marks as mandatory. Select the key fields.

A new external document structure (with subtype SQL Server) is created and added to the document list page.