To retrieve the metadata of the SAP BW Data Source, Data Store Object, InfoCube or InfoObject objects, do the following:
In the Repository tree view, right-click the newly created SAP connection and select Retrieve SAP BW metadata from the contextual menu. The [SAP BW Table Wizard] dialog box opens up.
In the Search in drop-down list, select the type of the SAP BW objects whose table metadata you want to retrieve.
In the Name field, enter the filter criteria for the object name to narrow your search if needed.
In the Description field, enter the filter criteria for the object description to narrow your search if needed.
Note that for the Data Store Object, InfoCube and InfoObject types, the filter criterias for the Name field and the Description field act together as an OR operator, that is to say, all objects that match either the filter criteria for the Name field or the filter criteria for the Description field will be returned.
For the Data Source, InfoCube and InfoObject objects, you can select the data type from the Type drop-down list to filter the search results.
For the Data Source objects, you can also enter the filter condition for the Data Source system name if needed.
Click Search and all the SAP BW objects that match the criteria will be listed in the table. Select one or more objects of interest by selecting the corresponding check boxes in the Name column and then wait until the Creation Status for all the selected objects is Success.
Note that the tables and their schemas of the selected objects will finally be saved in the Repository and the tables of the unselected objects will be removed from the Repository if they already exist in the Repository.
For the InfoObject type objects, only the Attribute, Hierarchy and Text information can be extracted, and the number of the columns for each type of information is displayed in the Column Number field with the format A[X] H[Y] T[Z], where X, Y and Z represent the number of the columns for the Attribute, Hierarchy and Text information respectively.
Click Next to proceed to the next step.
All tables of the selected objects are listed in the Table Name area. For the InfoObject table, the type information is appended to the name of each table. You can remove the table(s) by clicking Remove Table in this step.
Click Refresh Table and the latest table schema will be displayed in the Current Table area. You can modify the schema of the selected table in the Current Table area if needed.
You can also click Refresh Preview to preview the data in the selected table if needed. But note that the Refresh Preview button is not available when you search the Data Source type objects.
Click Finish and the tables and their schemas appear under the folder for the corresponding object type in the Repository tree view.
You can now drag and drop any SAP BW table node onto your design workspace as an SAP BW component, with all the metadata information automatically filled. For more information about the SAP BW components, see Talend Components Reference Guide.
If you need to further edit or read a table for an object, right-click the table and select the corresponding item from the contextual menu to open this wizard again and make your modifications.
Note that when reading data from the Data Source and InfoCube objects or writing data to the direct updatable Data Store objects, the custom function modules Z_TALEND_INFOPROV_READ_RFC and Z_TALEND_ODSO_UPSERT_RFC have to be installed. For how to install these modules, see the readme.txt file provided under the <Talend_Studio>\plugins\org.talend.libraries.sap_<version>\resources directory.