Can I join between two datasources?

[Eric Kok]

I have a series of tables that I want to use, but some of them I need to access via API as it requires some coding round the data.

How can I combine the data from the 2 different datasources?

Eric

[Satheesh Kumar Kalimuthu]

Hi Eric, 

 

Thank you for contacting Syncfusion support. 

 

We can achieve your requirement combining two data source using our Syncfusion Data Integration Platform and resultant processed data will be stored in target database server. By connecting this server with our Syncfusion Dashboard Designer enables you to design dashboard.  

 

We have created a sample which is available in the below link for connecting two different REST API and combining it as single table. 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/Joining_two_table-1157748423 

 

Please follow the below steps to achieve your requirement, 

1. Download and install Syncfusion Data Integration Platform(DIP) from here.
2. Create work flow in the DIP by referring document attached in the above link.
3. After that please refer the document from below link to connect the DIP with our Dashboard Designer.

http://www.syncfusion.com/downloads/support/directtrac/general/ze/DIP_Designer1570582420 

 

 

For more information about Syncfusion Data Integration Platform, please refer the below help document, 

https://help.syncfusion.com/data-integration/overview 

 

Kindly let us know if you need any further assistance on this. 

 

Regards, 

Satheesh