--- title: "Adding & Editing Datasources" slug: "adding-editing-datasources" status: "update" updated: 2025-08-11T13:09:15Z published: 2025-08-11T13:09:15Z canonical: "skthelp.syniti.com/adding-editing-datasources" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Adding & Editing Datasources This topic relates to the following sections: - [Initial Setup - First Week](/v1/docs/initial-setup-first-week) - [Datasources](/v1/docs/datasources) - [Adding & Editing Applications](/v1/docs/adding-editing-applications) - [Adding & Editing Instances](/v1/docs/adding-editing-instances) - [Adding & Editing Tables or Columns](/v1/docs/adding-editing-tables-or-columns) - [Import Metadata](/v1/docs/import-metadata) - [Verify Migrate Database Upgrade](/v1/docs/verify-migrate-database-upgrade) - [Data Type Conversion in the SKP](/v1/docs/data-type-conversion-in-the-skp) - [Security Profiles](/v1/docs/security-profiles) - [Security Profiles in Migrate](/v1/docs/security-profiles-in-migrate) - [Working Databases in Migrate](/v1/docs/introduction-to-syniti-migrate#working-databases-in-migrate) ## About Datasources This section provides details for the maintenance of System Datasources. This section does not discuss the process for maintaining Working Datasources or Snapshot Datasources. A Datasource is defined as a connection to a system at a specific level to provide the means of transferring data between that datasource and the client database. View the following page by navigating to **Catalog > Datasources** from the Syniti Migrate Homepage. On the Datasources multi-panel page, the data is filtered by Applications, Instances, and Datasources. The wizard provides guidance for building the datasource correctly and to prevent adding unnecessary field values or leaving valuable fields blank. This section refers specifically to the System Datasources. The remaining datasources are built in the following sections of the system: - Refer to section [Administer > Setup > Development Areas > Maintain Working Datasources](/v1/docs/maintain-working-datasources) to Add or Edit a Working Datasource. - Refer to section [Administer > Setup > Environments > Adding & Editing Reporting Datasources](/v1/docs/adding-editing-report-datasources) to Add or Edit a Reporting Datasource. - Refer to section [Administer > Setup > Environments > Adding & Editing Migrate Datasources](/v1/docs/adding-editing-report-datasources) to Add or Edit the Migrate Datasources. - Refer to section [Migrate > Snapshot Management > Add a Snapshot Datasource](/v1/docs/snapshot-management#add-a-snapshot-datasource) to Add or Edit a Snapshot Datasource. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(695).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=gdPTBBTn3VmOuM7Z1o%2FJS78od%2FAHxm0sN%2FxObMK%2Byjs%3D) Datasources: Main page ## Prerequisites to Adding a New Datasource - System Datasources must first be set up within the Syniti Knowledge Platform in the Data Catalog. Refer to section [Initial Setup - First Week](/v1/docs/initial-setup-first-week) for details of creating the Connector and Connections. - The remaining Datasources must also connect to a Datasource Server maintained within the Syniti Migrate system. This would include the Migrate, Reporting, and Construct datasources. Refer to section [Initial Setup - First Week](/v1/docs/initial-setup-first-week) for details of the database preparation steps. ## Datasource Purpose Although there are five Datasource Purpose options, this section provides the steps for building System Datasources or Reporting Datasources. All other Datasource Purpose options have referred sections as provided above. As the user completes field values, supportive fields become available for entry. The fields vary by response of a prior field. **Datasource Purpose**. The response alters the following tabs and required fields to meet the needs of the datasource purpose. There are seven options for selection and each option is discussed below: - **System** - These are originating systems Ex: JDE, BPCS, Cloudera, ECC, SRM - Stored within Applications / Instances of the same naming structure. These Datasources pull from Syniti Data Catalog systems. Refer to section [Add a System Datasource](/v1/docs/adding-editing-datasources) below for details - **Snapshot** - These are the point in time captures of an originating system used as a Source or Target - Stored in **Syniti Migration** Application (Ex: SRCJDE, TGTS4H) Refer to section [Migrate > Snapshot Management](/v1/docs/snapshot-management) to add or edit a Snapshot Datasource. - **Construct Snapshot** - This Datasource (SRCCONSTRUCT) stores the Snapshot data from the CONSTRUCT database within SQL Server for Migration - Stored in **Syniti Migration** Application. The connection is to the [Working Database](/v1/docs/introduction-to-syniti-migrate#working-databases-in-migrate) for migration. Refer to section [Migrate > Snapshot Management](/v1/docs/snapshot-management) to add or edit a Snapshot Datasource. - **Construct** - The CONSTRUCT datasource is a system datasource - Stored in **Syniti Construct** Application (SQL Server connection). Refer to section [Add a Construct Datasource](/v1/docs/adding-editing-datasources#add-a-construct-datasource) below for details. - **Migrate** - This Datasource (MIGRATE) is added by the system automatically - Stored in **Syniti Migration** Application. It stores the Value Mapping data for migration. Once it is modified to add the **Migration Database Server**, the system automatically pulls in the Tables and Functions of this Datasource. Refer to section [Adding & Editing Migrate Datasources](/v1/docs/adding-editing-migrate-datasources) for details of this process. > [!NOTE] > Note > > The **Datasource Purpose** field locks once the Datasource is saved. The value for this field may be viewed within the grid of Datasources on the Datasources main page. ## Add a System Datasource All legacy system datasources must use the Knowledge Platform Data Catalog system to associate the System Datasource to an Agent and Connection. Ensure that you are viewing Datasources and click the **Add** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/88e71159-1b59-4ad9-8f64-b0c08e863fcf.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=0IgzJiqNRGP4r7ZJ6HPzkIpG8ZKlg8PwlAqvFe4pLC4%3D) icon in the Datasources panel to view the list of possible connections for data connectivity in the Create a Datasource dialog box. | Term | Description | | --- | --- | | Application | The system being used as a source or target. | | Instance | Within the Application, the instance is the instance of the application. There may be multiple instances of the same application. | | Datasource | Within the Instance of the Application, the Datasource contains the connection information for that datasource. The term datasource implies that one may be a source or target system. | While creating the Datasources, the user should specify the Application and Instance in which this new Datasource resides. Once the required datasource is added, access **Monitor > Debug Log** to view the log messages to monitor the datasource update process. Refer to [Verify Migrate Database Upgrade](/v1/docs/verify-migrate-database-upgrade) for more information. ### Usage Tab This is a step by step setup that includes adding data to the Usage, Details, Connection, and Attributes tabs of the Wizard process. In this example, the Datasource Purpose selected is **System**. System datasources import from Knowledge Platform Data Catalog System. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(411).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=s5RYz8%2FHWhRkxo3pPH656b0JHaedNw63KIqPtri2pwg%3D) Datasources: Add New System Datasource: Usage Fill in the Usage fields for this Datasource. | Section | Field | Description | | --- | --- | --- | | Datasource Usage | Datasource Purpose* | Select **System** from the list. (Required) | | Import All | Active Only for System Datasources - Toggle to import every table from this datasource (this flag tells the system to ignore [Administer > Advanced > Applications](/v1/docs/applications) values for this Datasource. > [!NOTE] > Note > > Defaults as Inactive and is relevant to non SAP Datasources. | | Security Profile | Security Profile | Security Profiles in Migrate allow users to extend role-based security settings on an individual asset or component, such as Datasets, Datasources, and Releases. When a security profile is applied to an asset, only users associated with user groups and roles designated on the security profile have visibility or access to that asset. For example, if a security profile is applied to a release, then the subject areas, datasources, reports, mappings, ETL Jobs, Metrics, and all the granular details of a release are restricted from other users. Refer to [Security Profiles](/v1/docs/security-profiles) and [Security Profiles in Migrate](/v1/docs/security-profiles-in-migrate) for more information on implementing and managing security profiles. | > [!NOTE] > Note > > This datasource example for an ECC source system does not require adding a Snapshot Datasource. The SAP Datasources do not use the **Import All** field. Click the **Next** button to proceed to the Data Catalog tab. ### Data Catalog Tab Within the Data Catalog tab connects the Datasource to an active Datastore within Syniti Data Catalog, the user selects the **Database Type** and clicks the **Source Datastore** list within the Selected Catalog Asset panel. This produces a list of Datastores to select from. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(671).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=FBOd8fGrnLEPyI18TFaz51zKmFAzMnetVdCGChBjThk%3D) Datasources: Add New System Datasource: Data Catalog tab Select the required datastore to add it as the Datasource connection from Syniti Data Catalog. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(672).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=RrhkQwcMPi4MFhoEA7DtHTNJ%2Fm9FP9kOy8qL5at1hVA%3D) Datasources: Add New System Datasource: Data Catalog tab: Datastores list The Database Name and Schema fields are automatically filled in based on the selected Source Datastore’s configuration in Syniti Data Catalog. Refer to [Datastores](/v1/docs/datastores) for more information. The following table describes the fields in the Data Catalog tab for this Datasource. | Section | Field | Description | | --- | --- | --- | | Select Database Type | Database Type* | Select the database type. | | Selected Catalog Asset | Source Datastore | Select the Datastore that represents this Datasource. | | Selected Catalog Asset | Database Name | The Database Name of the selected datastore is displayed. | | Selected Catalog Asset | Schemas | Schemas (if available) of the selected datastore is displayed. Optionally, you can specify schemas while [editing the Datasource](/docs/adding-editing-datasources#edit-a-datasource) connection. | Click the **Next** button to proceed to the **Details** page tab. ### Details Tab The Details tab is standard for all Datasource Purpose types. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(696).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=0ORdBjKHipeCYedIPVNzuabPeUQUWpFc2xNECtXS8jk%3D) Datasources: Add New Datasource: Details Fill in the Details fields for this Datasource. > [!NOTE] > Note > > Once every required field has been entered, the **NEXT** button becomes active. | Field | Description | | --- | --- | | Application* | Select the Application. (Required) | | Instance* | Select the Instance. (Required) | | Datasource Name* | Enter the Datasource Name. (Required) | | Description | Enter the description of the Datasource. | | Active | Toggle to make the Datasource Active/Inactive. **NOTE**: Defaults as Active. | | Comments | Enter descriptive comments to support this datasource. | Click the **Next** button to proceed to the **Attributes** page tab. ### Attributes Tab Fill in the Attributes fields for this Datasource. There may be Attributes and Stakeholders stored on this tab. Select the value for **Owner** which is required, and click **Finish** button to Save and close the wizard dialog box. The system clocks and if successful the new Datasource displays in the list as expected. Refer to the section below [Verify the Connection](/v1/docs/adding-editing-datasources#verify-the-connection) for subsequent steps in this process. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(697).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=rs7%2B5Yir%2BaC8gwllZklZVVSQbZTc3RDiUTx6YzsN9ts%3D) > [!NOTE] > Note > > If the **Import All** toggle was not selected, then the user must update the Applications for the tables and possibly columns that need to be imported for this Datasource. Refer to section [Administer > Advanced > Applications](/v1/docs/applications) for more details of filtering the Import of Metadata to the Datasource. The Reporting Datasource Types do not Import Metadata so this option is not present. The new Datasource displays in the list for the Instance highlighted. > [!NOTE] > Note > > During the Save, if the user selects YES to import the Metadata for the new Datasource, there is no Job Queue or Debug Log postings for this effort. If the import is not successful, a message briefly displays stating 'Unable to import metadata due to invalid connection.' At this point, check the server information and fix the connection. > [!NOTE] > Note > > Once the system datasource is saved, the user may access in Edit mode to update for field Client. This field filters the data replicated into the snapshot table from the system datasource for the client value. See section [SAP Datasources filtered by Client](/v1/docs/adding-editing-datasources#sap-datasources-filtered-by-client) below for details of this filter. ## Add a Construct Datasource The CONSTRUCT Datasource is stored within the **Syniti Migration** Application / Instance as it is set up on the client's database. This datasource stores all of the construction tables and views used in the Syniti Construct system. To add a construct datasource: 1. Select the **Syniti Migration** Instance and click **Add** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/53d95634-49b8-44e6-a2b5-ed27145b9af6.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=yJgukdGmJRZVRh2Xs6zLRRB3%2F%2Bb3MGdYCj2p1%2Fjhbwk%3D) icon. 2. Select **Add New Datasource** from the list. The Create a New Datasource wizard is displayed. It is a step-by-step setup that includes adding data to the Usage, Details, Connection, and Attributes tabs in the wizard, as described below. ### Usage Tab > [!NOTE] > Note > > Once a Construct datasource is created as a Construct Datasource Purpose, the options for the Datasource Purpose list hides the Construct value. Only one Construct Datasource Purpose (Enrich) can exist for a Syniti Migration instance. In the Usage tab, select **Construct** as the purpose from the Datasource Purpose list of the Datasource Usage section. The CONSTRUCT datasource stores tables that are actively maintained throughout the project, while the SRCCONTRUCT datasource stores snapshot copies of same tables for use during the testing periods. Click the **Next** button to proceed to the **Details** page tab. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ca69de41-c156-44f2-82c4-0d5abefc5c68.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=Yn2DIfRsL1ak%2B4UmzdJx58Qezl5oQbRnewoLdItA2s4%3D) Datasources: Add Construct Datasource: Usage ### Details Tab The Details tab is standard for all Datasource Purpose types. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/57b34922-97d9-4b69-9c10-2cc74f3c6527.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=nlfU5ognd0m6t%2BZUodqs%2BrUUiFCCTd3MWY%2BmHufjfB4%3D) Datasources: Add New Report Datasource: Details Fill in the Details fields for this Datasource. | Field | Description | | --- | --- | | Application* | Select Syniti Migration as the Application. (Required) | | Instance* | Select Syniti Migration as the Instance. (Required) | | Datasource Name* | Enter the Datasource Name. (Required) | | Description | Enter the description of the Datasource. | | Active | Toggle to make the Datasource Active/Inactive. **NOTE**: Defaults as Active. | | Comments | Enter descriptive comments to support this datasource. | > [!NOTE] > Note > > Once every Required field has been entered, the **NEXT** button becomes active. Click the **Next** button to proceed to the **Connection** page tab. ### Connection Tab The connection information of the Datasource is entered on this tab of the Report Datasource. > [!NOTE] > Note > > Fields on the Connection tab are contingent upon the **Server** selected and the ETL Tool set in [Parameters](/v1/docs/parameters), so if there were no connection for this Datasource, click **Next** immediately to advance to save this datasource. If the database selected is SQL Server or HANA DB, both **Database Name** and **Default Schema** are required. If the server selected Oracle or Oracle_ODBC Servers, **Database Name** is hidden, and **Default Schema** is a required field. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/b44f43b6-95fc-402f-bf9c-e9482f745076.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=iWiDENVWPmMIjfV03YZTDkhh80jOL2FNfIt%2Bw4FcOew%3D) Datasources: Add New Report Datasource: Connection tab Fill in the Details for this Datasource Connection. | Section | Field | Description | | --- | --- | --- | | Connection | Server | Select the available Working Database Server. Refer to section [Administer > Setup > Servers](/v1/docs/servers) for details. | | Connection | Database Name* | Enter the Database Name. (Required) Contingent upon Server | | Connection | Default Schema* | Enter the Default Schema. (Required) Contingent upon Server. > [!NOTE] > Note > > While the Default Schema value identifies the primary Schema for the connection setup, the metadata scan collect data from all Schema sources, and is not restricted to the one specified. | | Connection | Timeout (seconds) | The number of seconds this Datasource refreshes before it is stopped. Prevents excessive clocking. The default with no value is set by the Job Queue and Job Type, but generally defaults to 30 seconds. | | Connection | User Name | This field is contingent upon the setup of the Datasource Server and value may become required. | | Connection | Password | This field is contingent upon the setup of the Datasource Server and value may become required. Click on the **Show/Hide** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/6c9d2799-303d-4e48-b9d8-b6e9348f92ea.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=6tV4feiKaxRvbY8etDUO915XYryHFRsx52BCySzAEi0%3D) icon to view the Password entered. | | SAP Data Services | Datastore | Name of the Data Services Datastore from which Jobs pull Source data. This Datastore is used in the Syniti Migrate automation XML. | Click the **Next** button to proceed to the **Attributes** page tab. ### Attributes Tab Fill in the Attributes fields for this Datasource. There may be Attributes and Stakeholders stored on this tab. Select the value for **Owner** which is required, and click **Finish** button to Save and close the wizard. The system clocks and if successful the new Datasource displays in the list as expected. Refer to the section below [Verify the Connection](/v1/docs/adding-editing-datasources#verify-the-connection) for subsequent steps in this process. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/8a6f5ae7-2a29-4892-a0d1-0b1092ff54f8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=WxYdFP62VTkW3aH%2F%2Bf%2BlkSusGXw3rpyvTfWGt2TbQhw%3D) Datasources: Add New Datasource: Attributes ## Verify the Connection Upon saving the new Datasource, the User should verify that the connection is active. Select the Datasource and click the **Connection** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/02bbd4a4-5445-4a43-bf3c-150b06434bd5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=880CSgYJNXJkkxtcuqZXIC279RTj7qBcrXjOXKflb9A%3D) Icon to initiate a check against the system. If the connection is successful a message displays " **Primary - Connection success**." ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/706f0fa1-4b1b-45ac-b905-544d625c09be.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=c%2FXmdljh4%2FChmKEUbEXvjaS%2BYFYlfwxeBnAaswY44go%3D) Datasources: Datasource: Verify Connection 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. This verification is extremely important as well as the setup of the Datasource and Snapshot. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/e798e2f4-7a76-4bec-9bde-5e2b3ab5ede8.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=6oZFidY2QhpnGj%2FT2sp6IijDWxMf3Ow28I6DuPbjLzI%3D) Datasources: Verify Connection: Error Messages ## Edit a Datasource To edit a datasource, click on the **Edit** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/6e6efde4-ce05-4274-a700-62d4f42b117b.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=om0c7Cuv7bCVJchEq1HslM%2BGbWKB4tnWS5qkKkMijOo%3D) icon to display the Datasource Details page. The details of the datasource depend upon the type of datasource as a System, Report, Snapshot, or Working type. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/48e3d123-2ad4-4209-9c66-9b1752930291.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=ZqSFhF6kkELTdqB78uVyNd3FrYSKphZNwaxCOgPUmKA%3D) Datasources: Datasource: Edit Details > [!NOTE] > Note > > Once a Datasource is linked to a Snapshot Datasource, this link is permanent and cannot be removed. The value in the field is display only. This way the table data does not become fragmented and incorrect. > [!NOTE] > Note > > Once the User Name and Password have been saved into a Datasource, only the Admin role has access to view the Password going forward. The **Show/Hide** *![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/15cd3805-329e-4280-af0a-639932cc435f.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=jzsEjBrCSRv%2BOHUyc36heEYfg0oGv%2BMU2ZvU%2B8pqiUA%3D)* icon for viewing the password is not available to anyone who is not provided the Role of Admin. The Details page for Datasource is very similar to Instance and Application in that there is a left side panel with Details, and the tabbed section on the right side panel that contains associated object data. The list of fields below are for the System Datasources. > [!NOTE] > Note > > With the rollout of the Datastore Integration feature, the existing Catalog system’s information in Migrate’s Datasources is transformed into Source Datastore using the SKP Asset ID, which links a connection between the Datasource in Migrate and the System asset in Catalog. The pre-existing information regarding System, Database, and Schemas is mapped with the relevant Datastore, which is subsequently shown in the Syniti Catalog System section of the Edit Datasource page. > > If no mapping is found, the Source Datastore list will remain empty and can be selected manually. | Section | Field | Description | | --- | --- | --- | | Details | Application* | Select the Application. (Display Only) | | Details | Instance* | Select the Instance. (Required) | | Details | Datasource Name* | Enter the datasource name. (Required) | | Details | Description | The description of the datasource. | | Details | Active | Toggle to make the datasource Active/Inactive. > [!NOTE] > Note > > Defaults as Active. | | Details | Comments | Enter descriptive comments to support this datasource. | | Syniti Catalog System | Database Type | Select from the drop-down list the available Database type. See [Note](/docs/adding-editing-datasources#DBSchema) below for details. | | Syniti Catalog System | Client | Displays the client used for SAP Datasources. See [SAP Datasources filtered by Client](/v1/docs/adding-editing-datasources#sap-datasources-filtered-by-client) section below. | | Syniti Catalog System | Source Datastore | Displays the Datastore name for this datasource provided by Data Catalog. This list allows for the selection of the link to a Datastore within Data Catalog. Refer to [Datastores](/v1/docs/datastores) for more information. > [!NOTE] > Note > > Selecting the **Clear Selected Datastore** (**X**) button will reset the connection details for this Datasource, and you will need to fill in the Syniti Catalog System section again by turning on the **Import from Catalog Systems** toggle button. | | Syniti Catalog System | Database Name | Displays the Database Name for this Datasource based on the selected Source Datastore configuration. | | Syniti Catalog System | Default Schema | - Displays the default schema that will be used for this datasource. If required, you can specify a schema or a comma-separated list of schemas available in the database. - While the Default Schema value identifies the primary Schema for the connection setup, the metadata scan collect data from all Schema sources, and is not restricted to the one specified. See the [Note](/docs/adding-editing-datasources#DBSchema) below for more information. | | Stakeholders | Owner* | Select the Owner responsible for this Datasource. (Required) | | Metadata | Import All | Toggle to flag import metadata for all tables of the Datasource | | Metadata | Last Refresh Date | Date of the last refresh of metadata. | | Audit | Various | These are the system generated values for auditing the work. | | | ID | Datasource GUID. | | | SKP Asset ID | Displays the Asset ID for the datasource provided by Data Catalog. | > [!NOTE] > Note > > If within the Syniti Catalog System section, the **Database Type** value is SAPNETWEAVER, then **Default Schema** must be left blank for the system to properly scan and refresh the table data for the datasource. For all other Database Types, the Default Schema value is necessary. At the header of this panel are quick use icons as shown below: | Icon | Name | Use | | --- | --- | --- | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/5795837d-7184-48a8-a4ef-3af3cd207b6e.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=rrq%2BVq3HI3P7OaXjQPin6Ujt%2B9mfjIuqaNeu7qCdtDQ%3D) | Save | The Save icon saves the current entries. | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/cb82e7b4-0144-4f50-84ab-814d6bb3f1b2.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=vbjl4DdBzgpjf6GnncyCNw050bBUyFnKcT2DjInMARc%3D) | Cancel | The Cancel icon leaves the current page without saving changed data. | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/29d626f3-ff03-46d1-a241-e66af2b6ed1d.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=5QWqMYIU2Gdsvi2fiqUAcBDIm7kl2q5TMAunEukG8Ew%3D) | Help | The Help icon links to the page in Syniti help text to provide a detailed explanation of this section and use. | | ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/04f4155a-6b6f-43b1-b504-aca51fe9cf53.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=GH%2Fd9v5UqLBy2%2Foxh0mceKWLBU1h39HFVE27DRIkNko%3D) | Additional Options | This icon produces a list of options for the Datasource including - - **Import Metadata** - **View Debug Logs** - **View History** Refer to sections below that discuss these options and use. | ### SAP Datasources filtered by Client The SAP System Datasources use the field **Client** to determine which client filter of data within a server is used. To provide a filter for all tables of a datasource, the field **Client** is provided within the Datasource Details page in section **Syniti Catalog System** as shown below. This field is then passed onto the Replicate system for the snapshot datasource linked to this system datasource. Individual tables within a datasource may also be assigned a Client, however, in the system datasource, the client applies to all tables of that datasource. > [!NOTE] > Note > > When the Database Type is SAPNETWEAVER, leave the Default Schema field blank, otherwise the scanning process will fail. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(673).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=jbk%2FsOfyjDvcftWMnPI0Us%2F8ftB02GpOydSEHnDHWhs%3D) When finished with edits, click the **Save** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/5795837d-7184-48a8-a4ef-3af3cd207b6e.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=rrq%2BVq3HI3P7OaXjQPin6Ujt%2B9mfjIuqaNeu7qCdtDQ%3D) icon to complete. ## Edit the Tables or Columns At this point, the user may add new Tables and Columns to the existing Datasource. They may also edit the details section to update field values. Refer to section [Adding & Editing Tables or Columns](/v1/docs/adding-editing-tables-or-columns) for details. ## Additional Options Icon for a Datasource Within this icon of the Datasource there are four options: **Import Metadata, Import Metadata Delta**, **View Debug Logs,** and **View History**. This is a quick step process that allows the user to perform tasks without having to modify using the Edit process. **Import Metadata** - Refer to section [Catalog > Datasources > Adding & Editing Datasources > Import Metadata](/v1/docs/import-metadata) for details of this process. **View Debug Logs** - A click on this option opens the Debug Log and filter to job logs for this Datasource. > [!NOTE] > Note > > The **Download Debug Zip File** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/819ec747-4bd5-4675-b1a4-3f4139bb47b5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=vrKjR85KX3SAitPqHzTEfYgEa7Hn66ftldm4%2FoM70L8%3D) icon will produce a file on the local drive with details of this table data. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/8b953a13-3781-431f-9e7f-831cfca77faa.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=t4sveMrXQ02Rzm%2FuVo%2BtXJ9zBGuh2q2RvP3p%2B%2FtBuhM%3D) View Debug Logs **View History** - Click on this option to view the history of changes for this system datasource. A window displays rows of changes that may be downloaded to a local drive. > [!NOTE] > Note > > The **Download** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/819ec747-4bd5-4675-b1a4-3f4139bb47b5.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=vrKjR85KX3SAitPqHzTEfYgEa7Hn66ftldm4%2FoM70L8%3D) icon will produce a file on the local drive with details of this table data. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ebe489e2-89e3-4623-aeff-e6d12da14c1a.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=4SVzkSMdtUDBjOcAif3f03UDiSs%2FNkfGZBWfsmS4M4Q%3D) View History ## Delete a Datasource Should the System Datasource not be relevant to the project it may be removed from Syniti Migrate. Generally, once tables are imported to the Datasource it is considered a required datasource, however, if the tables are not set as references to Datasets, Mappings, Value Mappings, etc. it may be deleted from the system. In the image below, the system datasource JDE contains many tables of which table F0004 contains References. In this case, the system datasource cannot be removed. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/5cdfd30d-eef8-47bd-8c8e-ba02deebaddf.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=%2BgyCeV3Y9c1sCvXUFxRiw9QRD%2FWcMEhIisiwYLc%2B8GI%3D) Datasources: System Datasource A warning message displays after a click on Delete icon. Click **OK** to proceed. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/a6efe991-82bf-4500-9810-3fc80cd5d697.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=Y9YUbGq5j%2Fx3%2F1%2FesTyGKs6Hd03KVRPzGTD9UwDpXnA%3D) The Validation Error message indicates that the system datasource contains datasource tables with references and therefore cannot delete. The additional warning messages are ignored due to the Error message. Click **OK** to exit this action. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/2edd37f5-01d6-43e0-ab76-72596cc1f201.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=sCmR%2BxJnMrOyCsWdy9jtPfq258UWWcSRuf7R1kP8YFI%3D) Datasources: System Datasource: Delete Validation Error Message In the case where the System Datasource does not contain tables with references, it may be removed. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/e4afa339-02a3-4a65-95c2-15a3011115fa.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=GQf2GgXm0y54XTCOGbsFm9MMfOLRgRqjw82eszE1Mww%3D) Datasources: System Datasource: without References There are no references attached to the Datasource tables, and only warning messages display. Click on **CONTINUE DELETE** button to proceed to remove this system datasource table from the list. The warning messages indicate that the tables are removed and the snapshot relationships are removed with this action. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/ebf9cf42-96c8-48b9-808b-eff7c170a26c.png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A21%3A08Z&se=2026-11-17T20%3A21%3A08Z&sr=b&sp=r&sig=aOYUtsTR4avCFu0cKKoKlZ2nafLjTuyUOM1y2QcE4hY%3D) Datasources: System Datasource: Delete Validation Warning Message ## Datasource Objects On the right side of this page is the Tab for Tables & Columns. The Administrator or IT Lead is responsible for this tab of data. This page provides two panels - one for Datasource Tables, and then one for Datasource Columns. Refer to section [Catalog > Dataset Design > Maintain Tables & Fields](/v1/docs/maintain-tables-and-fields-tab) for more details on this topic. ## Subsequent Tasks - Upon saving the Datasource, the User should attempt to Import metadata (import the tables and fields as they exist in the tables in the system identified). Refer to section [Catalog > Datasources> Adding & Editing Datasources > Import metadata](/v1/docs/import-metadata) for details of this subsequent process in Syniti Migrate. - In the case of a Snapshot Datasource, the User would IMPORT TABLES from the source Datasource to the Snapshot Datasource (all Active tables), and then Import metadata. Refer to section [Migrate > Snapshot Management](/v1/docs/snapshot-management) for details of this subsequent process in Syniti Migrate.