Syniti ADMM: Register and refresh view from SRC*** in Snapshot Management

Tatsiana Vorsa

• February 16, 2024 08:21

Hi Team,

I'm trying to find a way to perform a complex logic based on my source tables from Oracle before mapping them to SAP Target table.

Here the list of steps:

1. Create source snapshots for all my source tables from Oracle in SRC***.

2. Refresh data for all my source snapshots from Oracle.

3. Create a new view in SRC*** in SQL Management Studio which contains a complex logic bases on the source snapshots tables. The result of view contains all necessary columns and data. SQL Management Studio shows data successfully by reviewing rows in the view (Syniti Replicate - Management Center also shows the data).

4. Register the view in SKP on the Snapshot Management of the source SRC***.

5. Import Metada in the view. This job is finished with the error:

It seems that system can't read metada of the view and therefore can't update the data of the view.

It is confused also that  "TABLE_NAME": "TEST_VIEW", "TABLE_SCHEMA": null. It seems that system is expecting a table only (not view) and doesn't recognize the view and it's schema (schema is dbo, not null).

Could you please confirm that view can be used as source in Snapshot Management for further mapping? As per this instruction https://support.syniti.com/hc/en-us/community/posts/17282376954135-SYNITI-ADMM-where-clause-filter-on-Source-insert-rule it should work.

How this issue can be resolved?

1

• 

  Rakesh Ananthuni

  • February 16, 2024 10:12
  • Edited

  Hi Tatsiana,

  Can you try by passing schema name when you are importing table under Catalog->Datasources?

  Regards,

  Rakesh 

  0
• 

  Tatsiana Vorsa

  • February 16, 2024 10:31

  Hi Rakesh,

  Thank you for the adviсe! I passed the schema name and now "TABLE_SCHEMA": dbo in the log.

  It doesn't resolve the main issue. Here is the error message: dbo.TEST_VIEW appears to be a VIEW not a table.

  0
• 

  Rakesh Ananthuni

  • February 16, 2024 10:43

  Hi Tatsiana,

  Could you please raise a support ticket for this issue along with the steps performed and screenshots.

  Regards,

  Rakesh

  0
• 

  Michael Mowbray

  • February 16, 2024 11:09

  Tatsiana, we are doing similar at Mitre 10. Don't register the views in Snapshot Management (as you've seen that causes errors) but do make sure that the Tables used by those views are in Snapshot Management.  Then just use the view in Mapping as a Source and it all will work. DM me michael.mowbray@syniti.com if you'd like more information.

  0
• 

  Tatsiana Vorsa

  • February 19, 2024 10:43
  • Edited

  Thanks to Michael! 

  I’ve added the structure of the view manually using plus sign in the Snapshot Management instead of using the Import Metadata menu option in the Snapshot Management.

  Now it works fine!

  0

Please sign in to leave a comment.