mv.RSDC:
Microsoft Reporting Services
Functionality
Microsoft has invested millions of dollars in the creation of the Reporting Services infrastructure in SQL Server 2005 to provide a scalable, easy to use reporting solution which integrates tightly with their development toolsets. Now, using the new Reporting Services Data Connector product available from jBASE International, MultiValue users on all platforms have a gateway into this world class technology.
Reporting Services Data Connector (mv.RSDC) exploits the full feature set of SSRS and allows it to be used against all of the major MultiValue database platforms with almost no extra work on behalf of the application developer.
With Reporting Services, MultiValue databases can now be used to provide sophisticated, real-time report data using a wide variety of delivery mediums and incorporating all of the reporting features expected by today's demanding report consumer.
Introduction
Microsoft SQL
Server 2008 Reporting Services (SSRS)
provides a full range of
ready-to-use tools and services to
help you create, deploy, and manage
reports for your organization, as
well as programming features that
enable you to extend and customize
your reporting functionality.
SQL Server 2008 Reporting Services (SSRS) is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.
With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. You can publish reports, schedule report processing, or access reports on-demand. Reporting Services also enables you to create ad hoc reports based on predefined models, and to interactively explore data within the model. You can select from a variety of viewing formats, export reports to other applications, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. Reporting Services provides the key to your business data.SSIS in Brief
SSRS in Brief
The SSRS architecture allows third party developers to integrate with its data acquisition components to facilitate report production based on a wide range of back-end datasources. By integrating with the low level data provider interface of the SSRS product, mv.RSDC allows MultiValue databases to supply data at SSRS's data acquisition phase. This approach has the advantage of allowing the full feature set of the SSRS Report Designer and Report Builder to be leveraged in the manipulation, format and display of the MultiValue data.
mv.RSDC also has the advantage of leveraging the full power of the standard MultiValue dictionary layer with minimal work being required prior to data being made available to the Reporting Services infrastructure.
mv.RSDC makes use of the high performance Adapter Objects (ADO.NET) functionality provided by mv.NET to provide the underlying connectivity to the MultiValue database - from there onwards SSRS takes over to provide the complete reporting package.
Key Features &
Benefits of mv.RSDC
Leverages Reporting Services Functionality
mv.RSDC’s separation of data acquisition, report processing and result publishing processes allows an organization to implement a reporting strategy which is fine-tuned to their particular requirements and IT esoterics. The flexibility of report publishing formats combined with the ease of report authoring and end-user customization provides for a genuine real-time data reporting experience for both IT literate and IT novice members of staff.
Full integration with the SSRS Report Designer
Leverage the full feature set of Report Designer & Report Builder in the manipulation, format and display of MultiValue data in a wide variety of end-user focused reporting layouts.
Multiple normalization Techniques
Drill-down enabled data normalization, allowing the full drill down functionality of Reporting Services to be used against MultiValue data.
High performance data retrieval
Fast data retrieval using the mv.NET ADO.NET managed data provider, along with wizard driven query creation within the SSRS report designer.
Seamless integration with SSRS
Allows MultiValue developers and end users to leverage the capabilities of their existing information systems and connect to custom data sources, produce additional output formats and deliver to a variety of computing devices.
SQL-style query syntax support
By providing SQL command syntax support to generate queries non-MultiValue aware developers can author reports that eventually draw their data content from MultiValue databases.
Available for all major MultiValue databases
Because mv.RSDC utilizes the mv.NET product available from jBASE to access MultiValue databases, all of the major MultiValue databases are made available to SSRS.For more information email sales@jbase.com.
Related Links
 |
Download 30 Day Evaluation |
 |
mv.RSDC Flyer (PDF) |
|
Related Products |
|
|
|
mv.NET |
|
|
mv.SSIS |
 |
David Cooper, Lead Developer at BlueFinity International: |
|
"mv.RSDC provides a real opportunity for all the major MultiValue database users, both VARs and end users, to fully exploit the benefits of Reporting Services. By enabling Reporting Services to access MultiValue databases as easily as SQL-based platforms, mv.RSDC effectively 'levels the playing field' in terms of end-user reach to valuable application data. mv.RSDC provides the whole MultiValue community with a fantastic opportunity to ride on the crest of the Reporting Services wave currently being generated by the Microsoft marketing machine."
|
|