Ensure that the respective Oracle connection is available and “Connect As - Destination” is enabled. If not, create a new connection.
Create a new Loader using the Oracle connection and enter the table name to load the data.
Map source and target columns by selecting PostgreSQL Data Object as the source and Oracle Loader as the target, then create the column mappings.
The mapper has features such as "Matching Names", "Pattern Matching", and “AI” to map the column easily.
Execute the Dataflow. The summary of the Dataflow execution is shown below.
Click the success record count on the Loader to view the Loader Execution Summary form.
The loaded data can be viewed by clicking on the success record count.
As with loading, ensure that the respective Oracle connection is available and “Connect As - Source ” is enabled. If not, create a new connection.
Create a new Oracle Data Object, specify the table name, and select the columns to extract.
Execute the Data Object. With the summary of extracted data is shown below.
The extracted data can be viewed using the View Data. That's it, data loading and extraction from Oracle is done successfully with no coding, just by simple configurations.
Ensure that the respective SAP connection is available and “Connect As - Destination” is enabled. If not, create a new connection.
Create a new Loader using the SAP connection and enter the Bank BAPI name to load the data.
Create a Dataflow to map Oracle Data Object as the source and SAP Loader as the target, then map the source and target columns.
The mapper has features such as "Matching Names", "Pattern Matching", and “AI” to map the column easily.
Execute the Dataflow. The summary of the Dataflow execution is shown here.
Click the success record count on the Loader to view the Loader Execution Summary form.
The loaded data can be viewed by clicking on the success record count.
As with loading, ensure that the respective Oracle connection is available and “Connect As - Source ” is enabled. If not, create a new connection.
Create a new SAP Data Object, specify the Bank BAPI name, and select the columns to extract.
Execute the Dataflow. The summary of the Dataflow execution is shown below.
The extracted data can be viewed using the View Data. That's it, data loading and extraction from SAP is done successfully with no coding, just by simple configurations.
