Hi, is it possible to use data from two data sources in one catalog item? Is there an instruction regarding such task? Let’s say we have data in ERP and separate data in MDM tool, which are not the part of the ERP itself, and we want to check if data in both are consistent for same records. We’ve heard, that it should be done by converting catalog items in IDE (at least for Gen1), but I’m not sure how should it be working.
Solved
Two data sources for one Catalog Item
+1- Data Voyager
- 2 replies
Best answer by Siva_Madhavan
For Profiling the tables, you should use DQC step.
- Data Pioneer L2
Reconciliation of data in both the source systems? If they are part of same database you can write a SQL Catalog item query and create in ONE web as one catalog item. Per my understanding this would be an IDE plan reading the data sources and having a joiner in between.
+1- Data Voyager
Hi, no - by two data sources I meant two separate databases, so SQL Catalog Item can’t be used for that case. I’ve tried using Transform Data / IDE Component in Catalog Item view, by simple joining data from both catalog items, but it didn’t work and profiling was not executed, hence I’m not sure if that was the right solution for this kind of task.
- Data Pioneer L2
For Profiling the tables, you should use DQC step.
+1- Data Voyager
Hi, thank you. We’ve tried it and we received some errors, so our consultant is now looking into the issue internally.
- Data Pioneer L2
Thanks
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most Liked this week
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.