Home
Accessing Stages Through Enterprise Designer
Access different stages through Enterprise Designer.
Read from SAP

Welcome
Explore Data Integration. Connect different data sources and various stages used in Data Integration process.
Introduction
Learn about data management architecture and the star schema data warehouse design.
Connecting to Data Sources and Data Warehouses
Connect to different types of data sources.
Populating the Data Warehouse
Prepare your data for warehouse. Populate Time Dimension table, Dimension table, Fact table. Add time stamp to records in a Data Warehouse.
Updating the Data Warehouse
Define a Data Warehouse update schedule. Update a fact table. Use Global and Local cache for queries.
Accessing Stages Through Enterprise Designer
Access different stages through Enterprise Designer.
- Call Stored Procedure
- DB Change Data Reader
  The DB Change Data Reader stage allows you to select the columns to be included in the current jobflow, where the columns have the Change Data Capture feature enabled on them.
- DB Loader
  The DB Loader stage allows you to access and load data from/to databases configured in Spectrum Data Integration. This stage provides an interface to a high-speed data loading utility. Currently, the Spectrum Data Integration platform supports Oracle Loader, DB2 Loader, PostgreSQL Loader, and Teradata Loader.
- Field Parser
- Field Combiner
- Field Selector
- Generate Time Dimension
- Query Cache
- Query DB
- Query NoSQL DB
- Read From DB
- Read From File
- Read from Hadoop Sequence File
- Read From Hive File
- Read from HL7 File
- Read from NoSQL DB
- Read from SAP
- Read from Spreadsheet
- Read from Variable Format File
- Read From XML
- SQL Command
- Transposer
- Unique ID Generator
- Write to Cache
- Write to DB
- Write to File
- Write to Hadoop Sequence File
- Write to Hive File
- Write to NoSQL DB
- Write to Spreadsheet
- Write to Variable Format File
- Write to XML
- Date and Number Patterns
Configurations
Configure Oracle LogMiner, and HDFS connection for HA Cluster.
Optimizing Performance
Improve performance by determining an optimum fetch size. Learn about best practices for connecting to HDFS 3.x and Hive 2.1.1.

Read from SAP

The Read from SAP stage reads data from a SAP database as input to a dataflow. It can read data from a single table or multiple tables. When reading data from multiple tables, the stage performs a join operation to determine which records to read into the dataflow.

Table 1. Minimum SAP application requirements
Component	Release	SP Level	Support Package
SAP_BASIS	740	0005	SAPKB74005
SAP_ABA	740	0005	SAPKA74005

Note: The minimum supported version of SAP Business Suite 7 application is ECC 6.0 EHP 7 and CRM 7.0 EHP 3 with its components, release, and support pack levels mentioned in this table.