BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Data Federator: Unioning Multiple Tables into single view?


 
Search this topic... | Search Other Products... | Search Box
Register or Login to Post    Forum Index -> Other Products  Previous TopicPrint TopicNext Topic
Author Message
Kerby Johnson
Forum Member
Forum Member



Joined: 14 Mar 2011

Posts: 2



PostPosted: Mon Mar 14, 2011 6:53 pm 
Post subject: Data Federator: Unioning Multiple Tables into single view?

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
This post has been reported for Wrong Forum. The current status is Closed / Resolved.
Moderator MichaelWelter closed this report Click for Details
Back to top
MichaelWelter
Forum Advocate
Forum Advocate



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 15015
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way


flag
PostPosted: Tue Mar 15, 2011 3:33 pm 
Post subject: Re: Data Federator: Unioning Multiple Tables into single vie

Welcome to Bicon_mrgreen.gifB!

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

_________________
Michael Welter, BOCP-BOE, Webi Image link
Independent BI Consultant
(909)899-3002

______________________
Follow me on Twitter

Latest Blog Posts
• 2019-02-22 Tableau Security Made Easy
• 2018-09-20 Hello, Tableau
• 2018-08-16 New Beginnings
Back to top
Kerby Johnson
Forum Member
Forum Member



Joined: 14 Mar 2011

Posts: 2



PostPosted: Wed Mar 16, 2011 12:53 pm 
Post subject: Re: Data Federator: Unioning Multiple Tables into single vie

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
Back to top
ranjul.gupta
Principal Member
Principal Member



Joined: 16 Oct 2008
ASUG Icon
Posts: 112
Location: United States


flag
PostPosted: Fri Jul 15, 2011 3:15 am 
Post subject: Re: Data Federator: Unioning Multiple Tables into single vie

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
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0401 seconds using 17 queries. (SQL 0.0087 Parse 0.0009 Other 0.0305)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo