Getting data to the right people at the right time is the ultimate goal of Dream Report.  It is smart enough to recognize an event, collect the right data, analyze it – format it and then deliver it.  Dream Report supports over 60 drivers to a wide range of both industry and business data sources.  So, with access to those data sources, Dream Report can deliver pre-canned reports to users and users can easily create new reports.

But what if the data resides in systems that are too critical to enable external access to?

Often times, database systems are core to a company’s operation.  System loads need to me carefully controlled to keep performance optimal for users.  Perhaps the data is critical and access needs to be tightly controlled.  But there is data in those systems that others would benefit from.  How can you give the right people access to the right data, while absolutely guaranteeing the operational integrity of your primary data store?

Data Replication is the answer.

Data replication is the process of mirroring data from one database to another.  Replication can occur between different database types.  SAP to Oracle, Oracle to MS-SQL, One to Many, Many to One, etc.  Unlike complete database replication that is typically performed in bulk and periodically, an ideal solution will replicate continuously, monitoring transaction logs to know what needs to be updated.

Benefits of Database Replication

The benefits of database replication are many:

  1. The selection of specific data to share with others
  2. The removal of primary system loading by eliminating direct users
  3. The aggregation of multiple data sources into one
  4. The conversion of data from one system to another (example – SAP to MS-SQL)
  5. The ability to deliver specific data to specific users
  6. Creating the infrastructure for Dream Report redundancy

Why is this important to Dream Report?

While Dream Report is an ideal solution for delivering predefined reports to users, Dream Report also changes the paradigm in report generation, making report generation so easy that anyone can create reports as needed with next to no effort.  This will beg access to more information an ever before.  If that information is from legacy systems, delicate systems or systems where direct access is not encouraged, then database replication becomes a great solution.

Once data is accessible, then Dream Report is the right way to either deliver canned reports to meet your compliance needs, provide an interactive reporting environment through the Dream Report Web Portal, or give users the ability to quickly generate any report they want, through the Dream Report easy to use Development Studio.  Dream Report is as easy to use as PowerPoint – with a little data access thrown in…

Attunity is one such database replication solution that has recently spent some time explaining their solution to Ocean data Systems.  We’re impressed, and would like to make you aware of this added tool for your toolbox.  www.attunity.com