Joining Data Sources

Valuable data is commonly stored in multiple databases across your organization. For example, your accounting data might be in an Oracle database while your customer data lives in a SQL Server database. Because these databases don't know about each other, it is difficult to join and analyze the accounting and sales data together.

To address this common problem, BLR Rosetta can join data across multiple databases and present the data as a consolidated data set. To end users, the joined data looks like one table of data, which can be queried and analyzed just like data from a single database.

BLR Rosetta can also join data between tables that share similar columns. This operation, called a union, is useful for merging customer lists or project data that resides in separate databases. Again, the consolidated data is presented to the end user as a merged data set, and the details of the underlying data sources never complicate the user workflow.