This topic contains the following sections:
This page contains the following sections:
While viewing a Snapshot Datasource Details within EDIT for a Datasource, click VIEW IMPORT XML button to view the XML code that has been built. This action allows users to view the XML code that has been generated and then download that code to import to SAP Data Services.
NOTE: If within Parameters the ETL Tool = SAP Data Services, the Build and View XML processes is active. If however, the ETL Tool = Syniti Migrate, then this section is not relevant. Syniti Migrate ETL Jobs Tool does not use XML Scripting.
Datasources Details: XML: View Import XML
The resulting page displays a list of the following scripting for the Datasource:
Target SystemSAP tables associated that are active
Target SystemSQL tables associated that are active
Import DataFlows for each table
Import Workflows for each grouping of tables
Import Jobs - AllTables, Config, and metadata
This data creates, within theSAP Data Services, the Datastore details for the snapshot datasource.
Datasource: View Import XML
Invalid Datatype XREF
Should the Field format not translate using the Data Type Translation within Syniti Migrate, the table fails to build, and within the script of the table build the words "INVALID_DATATYPE_XREF" displays rather than an actual field format or data type. Correct the translation and correct the scripting to build the table without issues.
HANA DB: Create Table with Errors: INVALID DATATYPE XREF
There are three buttons within this page for use in pulling down the data built for XML scripting.
The GET LOADFILE button pulls from this page all of the XML Load File scripting into a flat file with extension of .XML. The user may next access the ETL system to import this file to build out the Project, Dataflows, Import tables, and etc.
NOTE: The GET LOADFILE button works for single loadfile situations. If the source of this build is large enough (> 50 tables), the build produces 2 or more load files and set them in the order of import to DS. Given this circumstance, the user is not able to use the GET LOADFILE button, and then needs to click on the XML button for each of the multiple Loadfiles in the left panel of this page. See Working with Large Datasources and Large XML files below for more details.
The Refresh icon updates the page and attempt to pull in the latest data from the datasource system.
Depending upon the number of tables to import, the XML Build my have only 1 Load File or may have 2 load files as shown below. In this case, the SAP system is building over 50 tables, and due to the size of this file, there is need to split it into 2 LOAD FILES.
A file with all the TABLE Definitions (XML and SQL). Basically, this is the list of tables under the two datasources as if you had done an Import by Name on the Datastore.
A file with all the Jobs, Workflows, and Dataflows for the import jobs.
In the case of the TWO files, the user won't be able to use the DOWNLOAD XML button on the tool bar. They must use the download button next to each for the Load files.
NOTE: To download these files, they must each be downloaded with the XML build for the row of the LOAD files. The GET LOADFILE button does not perform for this type of XML Build.
Datasource: View XML with Multiple Load Files