Functions for DataSources
Use
You can execute the following DataSource functions in the object tree of the Data Warehousing Workbench. The functions available differ depending on the object type (DataSource – RSDS, DataSource 3.x – ISFS) and source system:
● In the context menu of an application component, you can execute the following functions:
○ For both object types: Replicate metadata for all DataSources that are assigned to this application component.
○ For object type RSDS: Create DataSource.
● In the context menu of a DataSource, you can execute the following functions:
○ For both object types: Display, delete, manage, create transformation, create data transfer process, create InfoPackage.
○ For object type RSDS: Change, copy (however, 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 execute the following functions. Here too, the functions available 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.
Features
The following table provides an overview of the functions available in the Data Warehousing Workbench and DataSource repository for DataSources and DataSources 3.x:
Function |
Description |
More 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, where appropriate, and the data type of the DataSource. DataSource maintenance appears and you can enter the required data on the tab pages there. |
|
Display |
The display mode of DataSource maintenance appears. You can display a DataSource 3.x or a DataSource (emulation). You cannot switch from the display mode to the change. |
|
Change |
The change mode of DataSource maintenance appears. For transfer of 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 for creating 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 BI-relevant metadata for DataSources in SAP source systems is transferred into BI from the source system by means of replication. |
|
Create transformations |
In the transformation, you determine how you want to assign the DataSource fields to InfoObjects in BI. |
|
Create data transfer processes |
In the data transfer process, you determine how you want to distribute the data from the PSA to additional targets in BI. |
|
Create InfoPackage |
In the InfoPackage, you determine selections for transferring data into BI. |
|
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, that is, you can convert 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 you perform migration, we recommend that you 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. |