Business Integration Solutions Documentation

How to: Setup External Document for SQL Integration

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

To setup external document for SQL integration:

  1. Go to the documents list page. For:
  • Connectivity Studio click Departments/Business Integration Solutions/Connectivity Studio/Design/Documents.
  • Notification Management click Departments/Business Integration Solutions/Notification Management/Design/Documents.
  • Replictaion Management click
    • Departments/Business Integration Solutions/Replication Management/Publications/Design/Documents for publictaions.
    • Departments/Business Integration Solutions/Replication Management/Subscriptions/Design/Documents for subscriptions.
  • EDI Studio click Departments/Business Integration Solutions/EDI Studio/Design/Documents.
  1. Click New.
  2. On the General fast tab:
  • Select type as External and provide document number and description.
  • Select subtype as SQL Server. This will enable the SQL Server Connection fast tab.
  1. On the SQL Server Connection fast tab, to connect to an SQL database:
  • Either specify SQL Server Name and SQL Database Name Or
  • Specify SQL Connection String.
  1. Click Design button to open the setup page.
  2. Add tables and fields to define the document structure manually. > When adding fields, the Wizard shows which fields are marked as mandatory by the SQL database. Select the key fields.

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