Data Federator: Unioning Multiple Tables into single view?

other
1

Hi,

I have three different databases with tables containing a portion of the same kind of data and I want to union the three different tables together in Data Federator to present a single logical view that has the complete set of data. Is this possible in Data Federator? How would I go about doing that?

Note: I do not have keys to join the tables together on since it’s not simply extending the data in one table with additional data in another table and doing an inner join on a unique key. Instead, for example, there’s a customer table for Finance, a customer table for Operations and a customer table for Sales and they all contain the same columns (with maybe slightly different names) and same type of data. I want to effectively union Finance, Operations and Sales together in a federated/virtualized view so applications can just query from that view to get all the customers from the three different databases.

I have been unable to do this so far since Data Federator requires each table in a mapping to have a relationship with the other tables in the mapping.

Thanks for the help.

Kerby

Kerby Johnson (BOB member since 2011-03-14)

2

Welcome to B:bob:B!

[Moderator Note: Moving from Data Integrator to Other Products. - MichaelWelter]

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Thanks for moving the post. I had tried originally to post in this forum and it wasn’t allowed for some reason.

I figured out how to union the two tables together in the target table (using two mappings instead of a single mapping with the two tables) but now I have another question.

Is it possible for an application to use the combined view to write back into the database?

e.g. have an application use the target table in Data Federator and view the results, and based on that update the data in the underlying database that provides the data for the target table?

Thanks for the help.

Kerby

Kerby Johnson (BOB member since 2011-03-14)

4

It is not possible to write the data back to the individual databases, because it is just the Virtual DB which is reading the data from the individual data sources.

Cheers,
Ranjul

ranjul.gupta :india: (BOB member since 2008-10-16)