System Administration

How the DSP Uses Data Source Types

Data Source Type

Use in DSP

Data Services Repository

Used by dspMigrate and Collect to execute batch jobs via SAP's Data Services application. Used also by Integrate to execute batch jobs for loading purposes.

SAP Application Server

Used by:

  • Collect to populate 'sdb' and 'dg' databases via RFC.

  • Integrate to post data to SAP's ERP application.

ODBC

Used by Collect or Assemble to populate 'sdb' and 'dg' databases.

OleDB

Used by Collect or Assemble to populate 'sdb' and 'dg' databases.

Oracle

Used by Collect or Assemble to populate 'sdb' and 'dg' databases.

Migration Source Database

Used heavily by dspMigrate. Populated by Collect or Assemble.

Migration Object Database

Used heavily by dspMigrate, especially Transform. Commonly used by Integrate and dspMonitor.

Target System Database

Used heavily by dspMigrate, dspCompose. Populated by Collect or Assemble.

Local Utility Database

Typically used to hold SQL objects for the development/operation of a custom DSP Webapp.

Local File

Used by:

  • Collect, Common, dspMonitor, Integrate, Map, and Transform to write files to the DSP application server.
  • Assemble to read from or write to a file.

Remote File (HTTP)

Used by Assemble to read from or write to a file.

Remote File (FTP)

Used by Assemble to read from or write to a file.

Remote File (UNC)

Used by Assemble to read from or write to a file.