Data Bridge Specification Wizard Workflows

The path that you take through the screens of the Data Bridge Specification Wizard depends on the datasource from which you import data. The diagrams and sections that follow outline the workflows for the different types of data import.

Overview
For each type of datasource, you navigate through the Welcome screen of the wizard and either select or create a Specification (SPE) file in the Specification File screen. In the Select Datasource screen, you select a datasource and then perform tasks specific to that type of datasource. The types of datasource are as follows:
  • A flat file (a text file)
  • SAP Netweaver® Business Warehouse data
  • Structural data from an OLAP cube
  • Values data from an OLAP cube
  • A relational database table
Note To import data from SAP Netweaver® Business Warehouse, follow the workflows to import either structural or values data from an OLAP cube.
When you complete the datasource-specific tasks, you work through the Specification Wizard screens that are common to all datasources. In order, the common screens are as follows:
  • Field Mappings screen
  • Lookup Fields screen
  • Ignore Records screen
  • Select Records screen
  • Ignore Characters screen
  • Generated SPE File screen
  • Run Options screen

When you complete these screens, for all datasources you then create, validate, and run the Control (CTF) file and the data is imported into your model. The diagram that follows illustrates this overview of using the Data Bridge Specification File Wizard: