Data Warehousing, Business Intelligence & Reporting
Reporting and more recently accessing data for Business Intelligence or exporting data for corporate Datawarehouse functions rely heavily on industry standard SQL based technologies. The importance of straightforward ODBC access to data has been recognized and jBASE 5 is delivered with a new ODBC interface, enabling all the industry standard tools to be used. To complement this for the Java community a new JDBC is also available.
On Line Analytical Processing (OLAP) is becoming more important every day. It allows company decision makers to slice and dice data enabling them make intelligent business decisions. One of the primary repositories of data for OLAP is Microsoft’s SQL Server. The ability to extract, transform and load (ETL) jBASE data into SQL Server is potentially very important for the jBASE user.
Microsoft SQL Server is delivered with a sophisticated tool set called SQL Server Integration Services (SSIS) to enable data from multiple sources to be consumed. SSIS is a platform for building enterprise-level data integration and data transformations solutions. jBASE's mv.SSIS product provides the complete solution to enable data extraction from jBASE and then full integration with the Microsoft SSIS package. The result is jBASE data transfer to SQL Server tables without any programming effort needed at all.
With the market consolidation of reporting tools and the major corporate push behind Microsoft’s response with SQL Server Reporting Services, jBASE have also responded to the market. mv.RSDC provides jBASE users with sophisticated, real-time reporting using a wide variety of delivery mediums and incorporating all of the reporting features expected by today's demanding report consumer. mv.RSDC is fully integrated with jBASE 5 to provide comprehensive reporting with the minimum of effort.
Whatever the Reporting or Business Intelligence requirement, there are a series of alternative strategies available to the jBASE user. Explore our data warehousing, BI and reporting tools via the links to the right, or email firstname.lastname@example.org for more information.
|jBASE MultiValue Database|
|Security & Encryption|
Extract data from the jBASE database (in both bulk and filtered export mode) to other data repositories using Microsoft's SQL Server Integration Services (SSIS) product.