Functions for DataSources
You can perform the following DataSource functions in the Data Warehousing Workbench object tree. The functions available differ depending on the object type (DataSource - RSDS, DataSource 3.x - ISFS) and source system:
- In the context menu for an application component, you can perform the following functions:
- For both object types: Replicate metadata for all DataSources assigned to this application component.
- For object type RSDS: Create DataSource.
- In the context menu for a DataSource, you can perform the following functions:
- For both object types: Display, delete, manage, create transformation, create data transfer process, create InfoPackage.
- For object type RSDS: Change, copy (though not with an SAP source system as the target).
- For object type ISFS: Create transfer rules, migrate.
- Only for DataSources from SAP source systems (both object types): Display DataSource in source system, replicate metadata.
In the DataSource repository (transaction RSDS), you can perform the following functions. The functions available here also depend on the object type:
- For both object types: Display, delete, replicate.
- For object type RSDS: Change, create, copy (however, not with an SAP source system as the target), restore DataSource 3.x (if the DataSource is the result of migration and the migration was performed using the With Export option).
- For object type ISFS: Migrate.
The following table provides an overview of the functions available in the Data Warehousing Workbench and DataSource repository for DataSources and 3.x DataSources:
| Function | Description | Additional Information |
|---|---|---|
|
Create |
If you want to create a new DataSource for transferring data using UD Connect, DB Connect or from flat files, you first specify the name of the DataSource, the source system - if applicable - and the data type of the DataSource. DataSource maintenance appears. You can enter the required data on the tab pages here. |
|
|
Display |
You are now in display mode for the DataSource. You can display a DataSource 3.x or a DataSource (emulation). You cannot switch to change mode from the emulated display. |
|
|
Change |
DataSource maintenance change mode appears. To transfer data from SAP source systems, you use this interface to select the fields from the DataSource to be transferred and to make specifications for format and conversion of field contents from the DataSource. |
|
|
Copy |
You can use a DataSource as a template to create a new DataSource. This function is not available if you want to use an SAP source system as the target. For SAP source systems, you can create DataSources in the source system in generic DataSource maintenance (RS02). |
- |
|
Delete |
When you delete a DataSource, the dependent objects (such as a transformation or InfoPackage) are also deleted. |
- |
|
Manage |
The overview screen for requests in the PSA appears. Here you can select the requests that contain the data you want to call in PSA maintenance. |
|
|
For SAP source systems: Display DataSource in source system |
The DataSource display in the SAP source system appears. |
- |
|
For SAP source systems: Replicate metadata |
The BW-relevant metadata for DataSources in SAP source systems is transferred to BW from the source system using replication. |
|
|
Create transformations |
In the transformation, you determine how to assign the DataSource fields to InfoObjects in BW. |
|
|
Create Data Transfer Process |
In the data transfer process, you determine how to distribute the data from the PSA to additional targets in BW. |
|
|
Create InfoPackage |
In the InfoPackage, you determine selections for transferring data to BW. |
|
|
For DataSources 3.x: Create transfer rules |
If the DataSource 3.x is assigned to an InfoSource, determine how the DataSource fields are assigned to the InfoObjects of the InfoSource and how the data is to be transferred to the InfoObjects. |
- |
|
For DataSources 3.x: Migrate |
You can migrate a DataSource 3.x to a DataSource, thereby converting the metadata on the database. The DataSource 3.x can be restored to its status before the migration if the associated objects of DataSource 3.x (DataSource ISFS, mapping ISMP, transfer structure ISTS) are exported during migration. Before migrating, you are advised to create the data flow with a transformation based on a DataSource 3.x. You also have the option of using an emulated DataSource 3.x.
As well as manually migrating individual DataSources, you can also migrate a complete data flow. More information:Migrating Data Flows. We recommend using this system-backed automatic migration when migrating data flows. |