Snapshot Datasource View Import XML

This topic contains the following sections:

• Snapshot Management

• Edit Snapshot Tables and Columns

• Snapshot Datasource Build Import XML

About Snapshot Datasource View Import XML

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.

The resulting page displays a list of the following scripting for the Datasource:

•  Load File(s)

• 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

• Import Project 

This data creates, within theSAP Data Services, the Datastore details for the snapshot datasource. 

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. 

There are three buttons within this page for use in pulling down the data built for XML scripting. 

Get Loadfile Button

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.

Refresh Button

The Refresh  icon updates the page and attempt to pull in the latest data from the datasource system. 

Working with Large Datasources and Large XML files

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.