Add an SAP connection in Talend Studio and
design the Job with the tSAPInfoCubeInput component to retrieve data from the SAP
table.
Procedure
-
Access Talend Studio.
-
Navigate to and create a connection.
-
Right-click the newly created connection and select Retrieve SAP BW
metadata.
-
Import the 0FIGL_C10 SAP table. After importing, the table appears under the
SAP InfoCube folder.
-
Create a Standard Job with the following components:
-
tSAPConnection
-
tLogRow
-
tFileOutputDelimited
-
Drag the 0FIGL_C10 SAP table from the SAP
InfoCube folder into the Job:
-
Connect the components as shown in the previous step.
-
Configure the 0FIGL_C10 tSAPInfoCubeInput
component:
-
Add your SAP connection details in the tSAPConnection
component.
-
Select the tFileOutputDelimited component and add the File Name details of the file where you want to
store the output results after running the Job. You can find the File Name field
in the Basic settings view.
-
Click Run to execute the Job.
When you open the file that you added in step 10, you
retrieve the exact values exported from the SAP application table, 0FIGL_C10, as
shown in step 3 of
Checking BW Data Warehouse Workbench.
