- Print
- DarkLight
A Snapshot is a static database of tables and columns pulled on a specific date from a system being used for Mock or Live Conversions.
Snapshot Management is the process of managing the data that is captured:
from the Source Datasource into the Snapshot Source Datasource (created with a prefix of SRC) and
from the Target Datasource to the Snapshot Target Datasource (created with a prefix of TGT).
The Snapshot Datasource pulls rows of data from the System Datasource into the table using Syniti Replicate and builds a job in Syniti Migrate that manages the job set in Syniti Replicate.
Access the Snapshot Management page by selecting Migrate > Snapshot Management from the Migrate menu.
Types of Snapshot tables that display on the Snapshot Management page are:
Tables that are automatically refreshed and capture data from the Source Datasource to the Snapshot Source Datasource and from the Target Datasource to the Snapshot Target Datasource databases.These Snapshot Datasources are created with the prefix of either SRC or TGT to represent the direction of the data and are associated with a System Datasource. These types of tables are described in this topic.
Tables that must be manually replicated from a text file or a system that is not supported by the Syniti Knowledge Platform. These tables do not have a System Datasource, but do have an associated Syniti Replicate replication. When you manually refresh tables of this type, the replication executes. Refer to Repopulate Using a Manual Replication for more information.
Tables that exist in a Snapshot database that are not refreshed. Typically, these are views used for mapping. While these tables display on the Snapshot Management page, the Refresh icon is dimmed for them as they do not have a System table or an associated Syniti Replicate replication.
Prerequisites for Snapshot Management
Before you create a Snapshot Datasource:
The Datasource Server must exist and the connection must be active.
The System Datasource must exist on the Datasources page (Catalog > Datasources). Refer to Datasources for more information.
Users & Roles for Snapshot Management
The Design Team is responsible for maintenance of the Snapshot Datasources.
Role | Definition |
---|---|
Administrator | The IT Lead or Team Administrator responsible for all Snapshot Datasource initial setup. |
Dataset Designer | The user responsible for the design and functionality of the Dataset. |
Developer | The user who develops the ETL process in Syniti Migrate. |
Tasks specific to Database Systems
The Syniti Migrate Application is stored in SQL Server, however, the data may reside in a different database on a client site. Refer to The Data Migration Process for details about working in a database that is not the Migration SQL Server database. In some cases, the project uses SAP HANA, Oracle or a different client-held SQL Server for the working database. These sections of help describe how to use these different databases and provide more details about using Snapshot Datasources:
SNAPSHOT Datasource xAppLTMC Used in the SAP S/4HANA LTMC Conversion Process
Refer to LTMC - SAP S/4HANA Migration Cockpit for details about using the LTMC Staging option for SAP S/4HANA system projects.
Create and Populate the Snapshot Datasource
To create and populate the Snapshot Datasource with tables and rows of data, follow these steps.
Create the System Datasource and import the metadata for each table that must be included in the snapshot. Refer to Adding and Editing Datasources for more information.
Create the Snapshot Datasource, assigning it to a System Datasource from which the tables and row data is pulled on a scheduled basis. Refer to Add a Snapshot Datasource for details.
In the System Datasource, assign tables from the System Datasource to the Snapshot Datasource. Refer to the Add Tables to a Snapshot Datasource for more information.
In the Snapshot Datasource, run the BUILD XML to build out the XML scripting and create the tables in the database.
Note
This step creates the tables in the Snapshot Datasource if the ETL Tool is external (Data Services). Refer to Snapshot Datasource Build Import XML for more information.
Access the Snapshot Management page by selecting Migrate > Snapshot Management. from the Migrate menu.
Click the Repopulate
icon to import table data (content) from the System Datasource into the Snapshot Datasource using Syniti Replicate system jobs. Refer to Repopulate Snapshot Datasource from System Datasource for details.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/9fa70e52-7475-4d68-945e-770976d6b7d5.png)
The following details apply to the Snapshot Datasource. Details for the System Datasource that is attached to a Snapshot Datasource are provided in Adding & Editing Datasources.
The Snapshot Datasources panel displays the following fields:
Heading | Description |
---|---|
Repopulate | Click this icon to truncate the tables and re-import the data rows (content) from Syniti Replicate using the System Datasource to the Snapshot Datasource for the Datasource selected. This process builds a job queue with steps for Truncate and Import of the data.
|
Name | Name of the Datasource. |
Description | Description for this Datasource. |
Datasource Validation Status ID
| Displays a status icon that shows whether the Datasource is connected correctly. |
Acitve | Toggle on if the Datasource is active. |
Snapshot Tables Tab
When you select a row for a Snapshot Datasource, the Snapshot Tables tab displays the following fields:
Heading | Description |
---|---|
Repopulate | Click to truncate he table and re-import the data rows (content) from Syniti Replicate using the System Datasource to the Snapshot Datasource for the table selected. This process builds a job queue with steps for Truncate and Import of the data.
|
Name | Name of the Table. |
Description | Description for this table. |
System Datasource | The System Datasource assigned to the table. |
Record Count | Total number of rows for this table. |
Active | Toggle to show if the table is currently Active/Inactive. |
References | Count of the Objects actively using the table. |
Status | Status icon for the most recent repopulate action. |
Repopulated On | Last date and time this table repopulated rows. |
Add a Snapshot Table
If the required table does not exist in the Catalog System Datasource, and is not available to select in the System Datasources tab, then add the table manually to the System Datasources database and then import it on the Snapshot Tables list.
To add a Snapshot table:
Select Migrate > Snapshot Management in the Migrate menu.
In the Snapshot Datasources panel, select the Snapshot Datasoruce to add the table to.
In the Snapshot Tables tab, click the Add
icon. The Import Table dialog box is displayed.
From the System Datasource list, select a Datasource to import a table manually.
Enter the System Datasource schema in the Schema field.
Enter the table name in the Table or View Name field.
Note
This field is case-sensitive and it validates that the table exists in the System Datasource database.
Click the Save icon.
System Datasources Tab
The System Datasources tab has two panels: System Datasources and System Snapshot Tables.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ccf57bd2-3fed-4f07-83d8-a4e4727e406d.png)
The System Datasources panel contains the following fields:
Heading | Description |
---|---|
Repopulate | Click this icon to truncate the tables and re-import the data rows (content) from Syniti Replicate using the System Datasource to the Snapshot Datasource for the Datasource selected. This process builds a job queue with steps for Truncate and Import of the data.
|
Name | Name of the System Datasource. |
Description | The description for this System Datasource. |
Active | Toggle to mark the datasource as Active/Inactive for use. |
Select Tables | Click this icon to open the System Datasource Tables Import modal that provides a list of the tables stored in the selected System Datasource. Toggle the tables to Active for Snapshot use, which adds the table to the Snapshot Datasource list of tables. See Add or Remove Tables from a Snapshot Datasource for details. |
The System Snapshot Tables panel displays the following fields:
Heading | Description |
---|---|
Repopulate | Click this icon to truncate the table and re-import the data rows (content) from Syniti Replicate using the System Datasource to the Snapshot Datasource for the table selected. It builds a job queue with steps for Truncate and Import of the data.
|
Name | Name of the table. |
Record Count | Total number of rows for this table. |
References | Total number of rows for this table. |
Status | Displays the status of the last repopulate action. |
Repopulated On | Last date and time this table repopulated rows. |
To add a System Snapshot table:
In the System Snapshot Tables panel, click the Add
icon. The Import Table dialog box is displayed.
Enter the System Datasource schema in the Schema field.
Enter the table name in the Table or View Name field.
Note
This field is case-sensitive and it validates that the table exists in the System Datasource database.
Click the Save icon.
Add a Snapshot Datasource
To add a Snapshot Datasource:
Select Migrate > Snapshot Management from the Migrate menu.
Click the Add
icon in the Snapshot Datasource panel.
Select the prefix from the Prefix list box. Options are:
SRC: Select this prefix if you are creating a Source Datasource.
TGT: Select this prefix if you are creating a Target Datasource.
No Prefix: This option is not allowed, you must select a prefix.
Enter the source system name in the ZSource field. This name is allowed a maximum of 12 characters.
Note
The Datasource Name field is automatically populated with the values entered in the Prefix and ZSource field.
Enter a description of the Datasource in the Description field.
Enter comments to support this Datasource in the Source Comments field.
Under System Datasources, click the Add button to select the System Datasource to link to this Snapshot Datasource.
Select the System Datasource from the System Datasource list box and click the Add button.
Under Connection, select the Connection Server name from the Server Id list boix. The values that display below this list box depend on the selected Server.
Enter the name of the database for this datasource in the Database Name field.
Enter the schema for the database for this datasource in the Default Schema field.
Note
You must use the Snapshot Datasource schema. The System Datasource schema cannot be used.
Enter the number of seconds this Datasource refreshes before it is stopped to prevent excessive clocking in the Timeout(seconds) field. The default with no value is set by the Job Queue and Job Type, but defaults to 30 seconds.
Enter the user name to access this datasource in the User Name field or leave blank and the Server access is used by default.
Enter the password to access this datasource in the Password field or leave blank and the Server access is used by default.
Note
The Datastore name in the Datastore field is copied from the ZSource field and is the SAP Data Services Datastore from which the jobs pull source data. This Datastore is used in the creation of the automation XML.
Note
The section for XML is visible on the Datasource details page if the ETL Tool is not Syniti Migrate (for example, if the tool is SAP Data Services). If the ETL Tool field in the Administer > Setup > Parameters page is set to Syniti Migrate, the XML section is hidden
Note
You cannot update the ZSource or Datastore name after the Datasource is added.
Note
The Connection section of the Create a Snapshot Datasource modal cannot be left empty. If it is, the following happens:
If the user does not provide any connection info, Migrate displays an error message after the user clicks the Save icon.
If the user provides server information (by completing the Server Id and Database Name fields) but does not provide the username and password, the system attempts to test the connection using the credentials from the server, and updates the status accordingly.
Click the Save icon to save the Snapshot Datasource.
Note
Snapshot databases are added to the Syniti Migration Application.
Note
A warning message displays to indicate that you cannot change the ZSource and or Datasource Name fields after you have saved the Snapshot Datasource.
Click Ok.
Issues During the Save
Snapshot Datasource needs to have prefix of TGT or SRC
An error message displays if you have not set the Prefix for the Datasource to either TGT or SRC.
To fix the issue, click the Cancel Save button and update the Prefix correctly.
Datasource already exists
The new Datasource has the same name as an existing Datasource. The Save fails. Click OK and add a unique Datasource name.
Snapshot Datasource Requires a Server
Snapshot Datasource requires a server ID to save the datasource. Click OK and complete the Server ID field to proceed.
Verify the Connection
After saving the Snapshot Datasource, you must verify the connection is active.
To verify the connection:
Select Migrate > Snapshot Management from the Migrate menu.
Select the Datasource in the Snapshot Datasources panel.
Click the Connection
Icon to initiate a check against the system.
If the connection is successful a message displays: "Primary - Connection success."
If the connection is not successful, the tables and columns do not import and metadata does not process successfully. The Job Queue runs, but no outcome of data is present.
Repopulate a Snapshot Datasource from a System Datasource
Syniti Migrate allows you to repopulate a datasource to pull the rows of data from a source table to a target table using Syniti Replicate.
To repopulate the Snapshot Datasource from a System Datasource:
Select Migrate > Snapshot Management from the Migrate menu.
Click the Repopulate
icon for a Snapshot Datasource table or for an entire Snapshot Datasource to initiate the job queue refresh of data using a replication built within Syniti Replicate.
A confirmation message displays, click OK to proceed.
Note
This process connects Syniti Migrate to Syniti Replicate, builds a replication based on the data stored in the Snapshot Datasource and System Datasource, and updates the replication to contain a Where Clause filtering the data where a value exists in the field. This process is seamless: after you click the Repopulate icon, the replication runs. The data is populated into the snapshot table from the system table based on the Where clause added and the Client value (for SAP systems). Refer to SAP Datasources filtered by Client for more information.
Note
Tables may be imported using a Database connection (the preferred method) or using an RFC connection, and sometimes both may be used. If both Database and RFC connections exist, all imports of data default to the Database connection unless the field TABLE TYPE is set as Pooled or Clustered. These are special SAP Tables that must be read from the application layer.
While viewing the Snapshot Management page, select to highlight a snapshot datasource. This action updates the right side panel to display the tables linked between snapshot and system.
Refer to the Syniti Replicate help topic Managing Replications in the Management Center for details on maintenance for replications.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/c89fc84c-3103-495a-9b1a-c4363cd159d0.png)
Snapshot Management: Snapshot Datasource Details
Note
When Syniti Migrate calls Replicate to create or run a replication, the correct connection is based on the username of the datasource. For Oracle projects, each Oracle datasource must have a corresponding Syniti Knowledge Platform System Connection with the correct username and password for each of the schemas on the working database. Refer to Create a Connection for more information.
Note
The Snapshot System Where Clause filters data from the System Datasource to the Snapshot Datasource using Syniti Replicate.
Note
If the replication exists in Syniti Replicate prior to adding a value to this field, the next repopulate attempts to add the Where Clause to the replication and save the change.
Note
Once the Where Clause has been stored in the replication, this job may be run from either Syniti Replicate or from Syniti Migrate with the same outcome.
Select Monitor > Job Queues from the Migrate menu to view the progress of the Repopulate job running for the Datasource table. The replication process begins and completes showing the duration, record count, and date of run. Refer to Job Queues for more information.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/32eba6f7-a44b-442a-99a2-bb21292c0260.png)
Job Queue: Repopulate job display
The Debug log provides details of the run.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/e282918f-7eee-4ab1-9efa-ede58b21c09b.png)
Debug Log: Details for Repopulate run
Once refreshed, the Snapshot Datasource table shows the Repopulated On date and active count of records pulled. The Duration is displayed in seconds.
In Syniti Replicate, the same job queue is stored as they are linked together.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/a4278a1d-08d0-4533-a9b3-e193f5e344ab.png)
Syniti Replicate Management Center: Replication Monitor
Note
If the System Datasource stored in the Syniti Catalog is deleted, then the Repopulate process will fail. The Debug Log message that displays is: "Cannot perform this action as the System associated with this datasource is deleted."
Repopulate Using a Manual Replication
If a link from a source datasource to a target datasource requires a manual build through Syniti Replicate for the replication (for example, if the source is a text file, a system not registered in the Syniti Knowledge Platform or a system that cannot be scanned in the Syniti Knowledge Platform), you can perform a manual replication on a Syniti Migrate Snapshot Datasource table.
To perform a manual replication:
Select Migrate > Snapshot Management from the Migrate menu.
On the Snapshot Tables tab, click the Edit icon for the Snapshot table that must be manually replicated.
Enter the Where clause to pull data into the Snapshot table in the Snapshot System Where Clause field.
Click the Select SDR Replication icon
and select a replication from the active Replication jobs stored in Syniti Replicate.
Note
Refer to the Syniti Replicate help topic Managing Replications in the Management Center for details about creating manual replications.
Click the Save icon.
After the record is saved, the following occurs as part of the Repopulate process:
This link overrides the Repopulate attempt to build a replication job as part of the Repopulate process,
The Snapshot System Where Clause field is no longer visible or used for the replication.
The Repopulate action runs the job assigned from Syniti Replicate as it is set.
By creating this manual replication, you can build replication jobs outside of the automation provided by Syniti Migrate and use them through the same Snapshot Management process as the normal repopulate steps.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/438546dc-71db-4097-9972-c1acc795c924.png)
Add a CONSTRUCT Snapshot Datasource
You must set up a static database for the Construct module on a project as it allows the resources the ability to continually maintain the Construct database tables while the team takes a snapshot and uses the static data for the testing phase.
The SRCCONSTRUCT database is stored in the database used for migration (SAP HANA, Oracle, or SQL Server) at the client site, and therefore the data in that database is visible for use by the conversion team.
The CONSTRUCT database stores the active tables, views and rules for Syniti Construct (SQL Server database).
In the image below, the SRCCONSTRUCT database is set up in SQL Server in the Migration Working Server, but this setup also works in SAP HANA or Oracle. The SRCCONSTRUCT database stores all of the Construct page's tables as a copy from the CONSTRUCT database in the client site SQL Server.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/3f5095f2-8e21-474e-8ffd-d3a1a0c89400.png)
The same process for assigning available System Datasource tables to the Snapshot Datasource works for SRCCONSTRUCT. The SRCCONSTRUCT snapshot is linked to three System Datasources:
CONSTRUCT to store the active Construct page tables
MIGRATE to store the Value mappings tables
MIGRATE_APP to store the Central Relevancy tables, System Report views, and the Rulebook views
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/84448f1b-2f3c-4485-b37c-5052c540e3d5.png)
Central Relevancy Snapshot Data Stored in SRCCONSTRUCT
The System Datasource MIGRATE_APP is linked to the SRCCONSTRUCT Snapshot Datasource to provide a list of views prefixed with MIG_ used to store data for System Reports. These views allow you to build reports against table data stored in the core, hidden database. The SRCCONSTRUCT database stores these views as tables that repopulate the rows of data.
MIGRATE_APP is not an actual database and it cannot be edited or deleted. It is assigned to the SRCCONSTRUCT Snapshot Datasource to support construction and reporting. Syniti Migrate creates this link between MIGRATE_APP and SRCCONSTRUCT on saving the SRCCONSTRUCT snapshot Datasource and then runs a job to import the views stored in the core database for use in reporting or metrics. Repopulating these views pulls in the records. Each of the views may be used as a System Report for viewing or exporting data.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(246).png)
The following MIG_ views are imported:
View | Used In | Description |
---|---|---|
MIG_ALL_DATASET_TABLES | System Reporting | List of all Dataset Tables |
MIG_ALL_DATASETS | System Reporting | List of all Datasets |
MIG_ALL_GOVERNANCE_RULES | System Reporting | List of all Governance Rules |
MIG_ALL_SNAPSHOT_TABLES | System Reporting | List of all Snapshot Management Tables |
MIG_ALL_SUBJECT_AREAS | System Reporting | List of all Subject Areas |
MIG_DATASET_CHECKTABLES | System Reporting | List of all Dataset Check tables |
MIG_DATASOURCE_TABLE_NO_COLUMNS | System Reporting | List of all Datasource Tables with no columns |
MIG_DEPLOYMENT_USERS | System Reporting | List of all Deployments and users assigned. |
MIG_ENRICH_METRICS | Construction | List of Construction Metric Views. |
MIG_EXPENSIVE_MIGRATION_REPORTS | System Reporting | List of reports with excessive rows or large amounts of data. |
MIG_EXPORT_ETL | System Reporting | List of ETL Tasks to provide an export file. |
MIG_EXPORT_MAPPING | System Reporting | List of Mappings to provide an export file. |
MIG_EXPORT_REPORTS | System Reporting | List of Reports to provide an export file. |
MIG_INTERFACE_SOURCE_ENV | System Reporting | List of all active primary sources and information about the project for mapping. |
MIG_LIST_DATASOURCE_TABLES_IN_IMPORT_GROUP | System Reporting | List of all datasource tables included in an import. |
MIG_MAPPING_EXPORT | System Reporting | List of mappings by Dataset. |
MIG_MAPPING_FIELDS_IN_DESIGN_REQUIRED | System Reporting | List of all required mapping fields in a design. |
MIG_MY_DATASETS | System Reporting | List of datasets by User. |
MIG_OBJECT_INFO | System Reporting | List of fields for each Object for use in reports. |
MIG_RELEASE_RELEVANCY | Central Relevancy | List of Relevancy Attributes by Project / Release. |
MIG_REPORT | System Reporting | List of all active reports. |
MIG_REPORT_DEPLOY | System Reporting | List of all active reports based on deployments. |
MIG_USER_ACCESS_LIST | System Reporting | List of Users and last activity date. |
MIG_VU_RULEBOOK | Migration Reporting | Migration Reporting Rulebook build. |
MIG_VU_RULEBOOK_DEPLOY | Migration Reporting | Migration Reporting Rulebook build by Deployment. |
MIG_ZDEPLOY_LIST | Construction | List of deployments by project / release. |
MIG_ZSOURCE_LIST | Construction | List of Datasources. |
Value Mapping Snapshot Data Stored in SRCCONSTRUCT
The process for value mapping check table values from legacy to target is stored in the SRCCONSTRUCT database for use as a Snapshot Management process. The LIST_TARGET_VALUE and XTVALUEMAP tables are automatically added to:
the SRCCONSTRUCT Snapshot Datasource to store values for static use during mock conversion testing and
the MIGRATE System Datasource to store active values where changes are made in real time.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/cd8cd19c-109b-4ec0-a324-0c95ad0ff484.png)
The LIST_TARGET_VALUE table stores the fields TARGET_VALUE and LOAD_VALUE so that in a situation where the Target Value is a concatenation of more than one field, the Load Value contains the actual value that loads to the target table. In the image below, for the records for the REGION_LIST check table, the TARGET_VALUE and LOAD_VALUE columns contain different values. For the records for the COUNTRY_LIST check table, these fields contain the same value.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/8b96cb70-cbe6-4bd3-beae-9a0fa6c2131b.png)
The XTVALUEMAP table stores the data used in the value mappings for fields including the ZXREF_SOURCE, ZXREF_VALUE and TARGET_VALUE as examples. This table is used in the Source Xref rules for Update and Insert in ETL and when building the XML scripting for SAP Data Services for the Xref rules.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/f4f187f5-700d-4e03-99f4-a83a134fe6bd.png)
Note
The XRef Update rules use the value in the LOAD_VALUE field in the XTVALUEMAP table for the target value. If no LOAD_VALUE is stored for the record, the Xref Update rules use the TARGET_VALUE.
In Snapshot Management, the MIG_XTVALUEMAP view has been added to the MIGRATE database. This view provides access for the Xref Update rules to use the LOAD_VALUE field. Update the Snapshot Table Name of the XTVALUEMAP snapshot to MIG_XTVALUEMAP, such that you can use this view as a source for the XTVALUEMAP snapshot from the MIGRATE database to the SRCCONSTRUCT database. The XRef Update rules can then reference the LOAD_VALUE field from the new XTVALUEMAP table in the SRCCONSTRUCT database.
Edit a Snapshot Datasource
Snapshot Datasource names follow a naming convention:
The Source Snapshot Datasource name contains the system name with a Prefix of SRC (For example, SRCJDE, SRCECC)
The Target Snapshot Datasource name contains the system name with a Prefix of TGT (for example, TGTECC, TGTS4H)
The server for all of the Snapshot Datasources is the database used for the conversion (for example Migration, SAP HANA, or Oracle). The Application is always set to Migration DEPLOY for Snapshot Datasources.
Attach each Snapshot Datasource to a System Datasource of the same name. For example, attach a System Datasource of SRCJDE to a Snapshot Datasource named JDE.
The System Datasource (the source system connection) must be created in the Application and Instance of the type of system. These are the System Datasources (the actual source system connection). The Snapshot is the static capture of data from the system source in the Migration SQL Server.
To edit a Snapshot Datasource:
Select Migrate > Snapshot Management from the Migrate menu.
Click the Edit
icon to display the Datasource Detailspage.
Note
So that the table data does not become fragmented and incorrect, once a System Datasource is linked to a Snapshot Datasource and vice versa, this link is permanent and cannot be removed. The value in the field is display only.
Select an Instance from the Instancelist box, if needed.
Note
A Snapshot Datasource is always created with a ZSource which is derived from the Datasource Name minus the prefix as a default. If the Snapshot Datasource is TGTECC, the ZSource is ECC. The ZSource cannot be edited.
Enter a description of the Snapshot Datasource in the Description field.
Toggle the Active toggle to off if the Snapshot Datasource is not active. Otherwise, leave the default.
Enter comments to support the Snapshot Datasource in the Comments field.
Select the Snapshot Datasource server from the Server Id list box. Refer to Datasource Servers for more information.
Enter the Snapshot Datasource database name in the Database Name field.
Enter the schema used by default for the Snapshot Datasource in the Default Schema field.
Enter the number of seconds to allow before a timeout when running this Snapshot Datasource refresh in the Timeout(seconds) field.
Enter the user name for the Snapshot Datasource in the Username field.
Enter the password for the Snapshot Datasource in the Passwordfield.
Note
Once the user name and password have been saved into a Datasource, only the Administrator role has access to view the password going forward. The Show/Hide icon
for viewing the password is not available to anyone who is not provided the Role of Administrator.
The Owner field automatically populates with the user name of the user who created the record. The field value is configurable in Administer > Advanced > Stakeholders. Refer to Stakeholders for more information,.
Leave the Import Alloff, or toggle it to on, if needed.
Note
This activates an import process and is used on systems other than SAP. Refer to Import Metadata for more information.
If you are using a Data Services Datastore for the Snapshot Datasource, enter the name in the Datastore field. Refer to Building Datasources in Data Services for more information.
If the Snapshot Datasource is SAP Data Services, click the Create Snapshot Tables button to create all Snapshot Datasource tables listed in the working Database.
If the Snapshot Datasource is SAP Data Services, click the Build Import XML button to build the automation XML scripting for Datasource Import within the ETL. Refer to Snapshot Datasource Build Import XMLfor more information.
Note
The Build Import XML button displays on this page if the ETL Tool is not Syniti Migrate, for example if it is SAP Data Services. If the Snapshot ETL Tool list box on the Parameters page (Administer > Setup > Parameters) is set to Syniti Migrate, the XML section is hidden.
After the scripts are built, click the View Import XML button to view the automation XML scripting for Datasource Import in the ETL. Refer to Snapshot Datasources View Import XMLfor more information.
Note
The View Import XML button displays on this page if the ETL Tool is not Syniti Migrate, for example if it is SAP Data Services. If the Snapshot ETL Tool list box on the Parameters page (Administer > Setup > Parameters) is set to Syniti Migrate, the XML section is hidden.
If the Snapshot Datasource is not SAP Data Services, click the Start Data Refresh button to initiate the Job Queue to repopulate all active tables for this Snapshot Datasource.
As the purpose of this Datasource is Snapshot, leave the the Report Flag off to indicate that this datasource is does not have a Purpose of Report.
As the purpose of this Datasource is Snapshot, leave the Working DB Flagoff to indicate that this datasource is not set with a Datasource Purpose of Working.
Note
The Snapshot Flag is toggled to on by default for Snapshot Datasources.
Click the Save icon.
Edit a System Datasource
To edit a System Datasource:
Select Catalog > Datasources in the Migrate menu.
Click the Edit icon for a System Datasource in the Datasources panel.
Select the System Datasource’s Instance from the Instance list box.
Update the datasource name in the Datasource Name field, if needed.
Enter a description of the System Datasource in the Description field.
If needed, toggle Active to off to make the System Datasource Inactive. Otherwise, retain the Active default setting.
Enter descriptive comments to support this System Datasource in the Comment field.
Click the Select from Catalog button to open the Select Catalog Asset for Datasource modal, if this System Datasource must be connected with an existing system in the Syniti Knowledge Platform Catalog. .
On this modal:
Select the System from the Syniti Knowledge Platform Catalog to connect to this System Datasource.
Click the Save icon.
Close the modal..
Select the type of database used by the System Datasource from the Database Typelist box.
Note
The System Friendly Name field and the System Name field display data for this datasource provided by the Syniti Knowledge Platform’s Catalog.
Note
The Path field displays a path for the datasource provided by Syniti Catalog. This field only displays if this System Datasource has had a system from the Syniti Knowledge Platform connected to it.
Enter the SAP Client value in the Clientfield.
Note
This value is used for SAP replications, and the field only displays for SAP-based System Datasources.
Select the user responsible for this Datasource from the Owner list box.
Toggle Import Allto on to import metadata for all tables of the Datasource.
Note
The Last Refresh Date is the date of the last import of metadata.
Enter the name of the Data Services Datastore from which jobs pull source data in the Datastorefield. This Datastore is used in the Syniti Migrate automation XML.
Note
The SKP Asset ID field displays the Asset ID for the datasource provided by Syniti Catalog.
Click the Save icon.
Import Metadata on the Snapshot Datasources Page
To import metadata:
Select Migrate > Snapshot Management in the Migrate menu.
Click the Edit icon for a Snapshot Datasource.
Click the Additional Options
icon.
Select Import Metadata.
Syniti Migrate builds a job queue that imports columns and constraints for each table included in the import list for this datasource. Filtering is based on criteria set up in Administer > Advanced > Applications
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/01f63803-cb84-4ea0-8b3b-a63b1494914d.png)
Snapshot Datasource: Details: Options list
The single Job Queue contains one to many steps, one for each table that import metadata as shown below.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/Working in Snapshot Management_29.png)
Each step builds out the table's columns and constraints, and points to the specific debug log entries for that table.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/f80a7781-0d8d-4db9-a8b8-0870918124e6.png)
Debug Log: Details for Job Queue step 20
View Debug Logs on the Snapshot Datasources Page
To view Debug logs:
Select Migrate > Snapshot Management in the Migrate menu.
Click the Edit icon for a Snapshot Datasource.
Click the Additional Options
icon.
Select View Debug Logs.
A list of Debug log entries for this Datasource's latest refresh of data displays. Refer to Debug Log for more information.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/829ed191-2fd0-49c8-9bdb-f4bfd873bc4a.png)
Debug Log: View log of entries for Datasource
View History on the Snapshot Datasources Page
You can view a history of all changes to a Datasource.
To view history:
Select Migrate > Snapshot Management in the Migrate menu.
Click the Edit icon for a Snapshot Datasource.
Click the Additional Options
icon.
Select View History.
Delete a Snapshot Datasource
You can delete a Snapshot Datasource if it does not have any dependencies.
To delete a Snapshot Datasource:
Select Migrate > Snapshot Management in the Migrate menu.
Select that Snapshot Datasource, and click the Delete
icon.
Click OK to the confirmation message.
Add or Remove a Table from the Source Snapshot Datasource
Note
The table must have valid columns set up in the database to import from the source Datasource to the Snapshot Datasource.
On the System Datasources tab, on the Snapshot Management page, the System Datasources associated with the selected Snapshot Datasource display. The System Datasource tables included in the selected System Datasource display in the panel below.
To add or remove a table from a Source Snapshot Datasource:
Select Migrate > Snapshot Management in the Migrate menu.
On the System Datasource tab, click the Select Tables
icon for the System Datasource where the tables will be imported.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/688500ed-2f40-4ccb-bdb3-876e78c78f5f.png)
Snapshot Management: Source Datasource Details
Note
The System Datasource Tables Import modal displays every table stored in the System Datasource.
Toggle the Snapshot field to on or off for each table relevant to the project to and it add it to, or remove it from, the System Snapshot Tables panel on the Snapshot Management page.
Once all of the tables have been added, click the Cancel
icon to close the modal.
![](http://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/f163f9ab-4fa3-4c2a-ab9d-c1e0bcce9cc3.png)
Snapshot Management: Source Datasource Details: Import System Tables
Add All Active System Tables to the Snapshot Datasource
Note
This is not a good practice to use with SAP systems as they have many tables.
You can import all of the tables in the System Datasource to the Snapshot Datasource.
To import all tables:
Select Migrate > Snapshot Management in the Migrate menu.
On the System Datasources tab, click the Select Tables
icon for the System Datasource where the tables will be imported.
Click the Import All button.
Note
This process imports every active table from the System Datasource into the Snapshot Datasource.
Click OK to the confirmation message.
Note
A successful table import does not produce a Job Queue entry.
Snapshot Datasource Tables Tab
On the right side of the Snapshot Datasources details page is the Datasource Tables tab, which provides a panel for Datasource tables and a panel for Datasource columns. Refer to Edit Snapshot Tables or Columns for more details.