BI Adhoc Reporting on OLTP model

View previous topic View next topic Go down

BI Adhoc Reporting on OLTP model

Post  Padmalakshmiravi on Tue Jul 17, 2012 2:59 am

I would like to get all your valuable inputs on building BI Adhoc Reporting solution on top of a OLTP model. Pls share your thoughts and any articles published.

Regards,
Padmalakshmi

Padmalakshmiravi

Posts : 2
Join date : 2012-07-16

View user profile

Back to top Go down

Re: BI Adhoc Reporting on OLTP model

Post  ngalemmo on Tue Jul 17, 2012 3:27 am

Ad hoc reporting over OLTP schema has been done for the last 40 years. It stinks. That's why data warehouses were created.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: BI Adhoc Reporting on OLTP model

Post  Padmalakshmiravi on Tue Jul 17, 2012 4:06 am

If not on OLTP schema, what are the options for Real Time Reporting? Users are not ready to accept any Near Real Time solutions.
How good is Oracle Golden Gate in supporting Real Time DW? Pls suggest.

Padmalakshmiravi

Posts : 2
Join date : 2012-07-16

View user profile

Back to top Go down

Re: BI Adhoc Reporting on OLTP model

Post  ngalemmo on Tue Jul 17, 2012 5:19 pm

That depends on what 'real time reporting' entails: What is 'real time'? What do you want to report? Is the business capable of taking action on the report in a timely manner? Is this an operational issue (such as looking at a specific thing, such as a customer's order, a WIP work order, etc...)? There is no one answer or a golden bullet (or gate).
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: BI Adhoc Reporting on OLTP model

Post  amosgreg on Wed Jul 18, 2012 1:08 pm

Padmalakshmiravi wrote:How good is Oracle Golden Gate in supporting Real Time DW?
Depending on various systematic things that may or may not be readily quanitifiable(transaction volume, number of replicated tables, network thru-put ....) GoldenGate latency can be measured in subsecond responce times. Transformations into other data structures take time and while Goldengate does support some types of transformations straight table to table replication is extremely fast.

Now depending on the reporting front-end needs(due to the transformation needs), near realtime might not really be an option.
We are currently replicating both Tandem Enscribe files to Oracle tables and SQLMX tables to Oracle tables with both being OLTP systems and both with minimal transformation in near realtime.
We are using Crystal Reports and Oracle Stored Procedures as the reporting engine for stock reports however we are not going to be able to create and use a Business Objects Universe on the existing table structure. We will need to transform the DB into a star to use the Webi and InfoView for the self-service/adhoc reporting engine.

Greg

amosgreg

Posts : 4
Join date : 2012-07-18

View user profile

Back to top Go down

Re: BI Adhoc Reporting on OLTP model

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum