Reporting system for organization. Architecture advise required

Posted by Andrew Florko on Stack Overflow See other posts from Stack Overflow or by Andrew Florko
Published on 2010-05-22T05:40:35Z Indexed on 2010/05/22 5:50 UTC
Read the original article Hit count: 206

Filed under:

reporting

|

integration

|

architecture

We have several legacy & 3'd-party systems in organization that use several RDBMS vendors (& more specific data storages). Cross-system data reporting (as well as extra-reports that are not implemented in 3'd-party systems) is required with charts and population of templates (winword, excel). Reporting system is visioned as intranet web-site with custom user access to reports. We expect ~50 reports per day.

Would you suggest to use BizTalk or any other integration software if commercial-department doesn't plan to buy anything expensive.

Would you suggest to create centralized data storage for reporting that is populated regularly or rely on on-demand services that providers always up-to-request data.

Thank you in advance!

© Stack Overflow or respective owner

Related posts about reporting

SQL Azure Reporting Limited CTP Arrived

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
It’s about 3 months later when I registered the SQL Azure Reporting CTP on the Microsoft Connect after TechED 2010 China. Today when I checked my mailbox I found that the SQL Azure team had just accepted my request and sent the activation code over to me. So let’s have a look on the new SQL Azure… >>> More
Telerik Reporting introduces WPF Report Viewer, the first reporting tool supporting all .NET desktop

as seen on Dot net Slackers - Search for 'Dot net Slackers'
With the release of Telerik Reporting Q1 2010 Service Pack 1 we are proud to announce a very important addition to Telerik Reporting. Finally, our suite of report viewers is now complete, making Telerik Reporting the first reporting tool to support all .NET desktop and web platforms: ASP.NET,… >>> More
JD Edwards World Reporting Made Easy with Real Time Reporting Tools from The GL Company

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Fred talks to Paul Yarwood, US Operations General Manager and Richard Crotty, North America Business Development Manager for The GL Company, an Oracle Certified Partner, and Denise Grills, Senior Director of Marketing and Product Strategy for Oracle's JD Edwards World products. They discuss how the… >>> More
Complex reporting on subversion (possibly Export Subversion log into database for reporting)

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the best way to do complex reporting on subversion logs like the following for each file? file, directory, last revision date, previous revision date(where revision date is at least 30 older than last), days diff(between revision dates) Since Subversion allows on revision to change multiple… >>> More
An Introduction to XBRL (eXtensible Business Reporting Language)

as seen on Internet.com - Search for 'Internet.com'
XBRL (short for eXtensible Business Reporting Language) is an XML-based standard for handling corporate financial information. This article explains what XBRL is, provides an introduction to some of it's uses, and provides links to a number of XBRL related resources for you to continue learning about… >>> More

Related posts about integration

Continuous Integration for SQL Server Part II – Integration Testing

as seen on Simple Talk - Search for 'Simple Talk'
My previous post, on setting up Continuous Integration for SQL Server databases using GitHub, Bamboo and Red Gate’s tools, covered the first two parts of a simple Database Continuous Delivery process: Putting your database in to a source control system, and, Running a continuous integration… >>> More
Cloud and On-Premises Applications Integration using Oracle Integration Adapters

as seen on Oracle Blogs - Search for 'Oracle Blogs'
See how Oracle Integration adapters will continue to provide connectivity and harness information from diverse enterprise applications and technologies—both on-premises and in the cloud on our Exclusive Openworld session - "CON8642 - Cloud and On-Premises Applications Integration, Using… >>> More
Integration tests in Continuous Integration environment: Database and filesystem state

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to implement automated integration tests for my application. It's a very complex monster. You could say that its database and part of the filesystem are part of its state, because it saves image files in the hard drive, and references to those in the DB. The software needs all those, in… >>> More
New Whitepaper: Primer on Integrating with EBS 12 with Other Applications

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle E-Business Suite offers several integration points and a variety of integration technologies. While a given integration point may be available through various technologies and products, it is important to select the best approach for your specific integration requirements. I am pleased to announce… >>> More
List of resources for database continuous integration

as seen on Simple Talk - Search for 'Simple Talk'
Because there is so little information on database continuous integration out in the wild, I've taken it upon myself to aggregate as much as possible and post the links to this blog. Because it's my area of expertise, this will focus on SQL Server and Red Gate tooling, although I am keen to include… >>> More