How to create a join among Target System tables in Synchronization Editor?

What version are you using?

In addition, you need to provide some more information about your use-case. What type of connectors are you using? Speaking generally, you need to join the data on the target system side or sync the information of both tables in 2 separate workflow steps.

Hi Markus

Version is 8.0.0

Connector used is Native Connector

I have one table at source side and two tables at target side. So I want to create mapping of both the tables at target side, on to the source side. 

For achieving this, I wanted to know that how can I create the join among both target side table within the synchronization editor so I can map the columns to my table present at source side.

The target side is OneIM on the left in the Synchronization Editor or the right?

Target is on the right side.

You cannot do a join in the synchronization editor. If you are just reading the information, it might be better to use the ADO.NET-based connector which allows you to use free SQL statements.

Another option would be to create a view in the target system (if possible) that is doing the join

Or, if you just read the target system into OneIM, the use of two workflow step syncing the information.

Hi Markus,

Thanks for replying.

For some reasons I cannot create a view in the target system. This is the main reason I asked this question,

I need to Insert/Update/Delete records into OneIM source system, based on the records synchronized from the  target system. Can I do that using ADO.NET-based connector? 

If you use the ADO.NET connector instead of the connector specific to one of the supported database systems, you have to specify the queries for the data you want to sync into OneIM. Therefore, you are able to join the two tabel you are needing the data from.

And yes, from Target System (ADO.NET generic) to OneIM all 3 CRUD oerations are supported directly. This is not a connector feature but a sync engine feature.

Thing is, to make the opposite work, from OneIM to Target System (ADO.NET generic), you need to provide a custom commit script that needs to be developed on your end.

If you use the ADO.NET connector instead of the connector specific to one of the supported database systems, you have to specify the queries for the data you want to sync into OneIM. Therefore, you are able to join the two tabel you are needing the data from.

And yes, from Target System (ADO.NET generic) to OneIM all 3 CRUD oerations are supported directly. This is not a connector feature but a sync engine feature.

Thing is, to make the opposite work, from OneIM to Target System (ADO.NET generic), you need to provide a custom commit script that needs to be developed on your end.

Hi Markus,

Thanks for your response. Actually I was working on my Use Case and I am struggling to find where i can write the SQL Query inside the ADO.Connector?

Does it need to be written inside the Schema Class?  Please guide.

Thanks,

You define the queries, including a join if you need one, in the connection definition of the connector. So to change the query you need to edit the connection at the target system side.