Reporting and more recently accessing data for Business Intelligence or exporting data for corporate Data warehouse 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.