Excel JDBC Data Connector with SQL Connector
Access Microsoft Excel data in real time from your analytic applications, without cumbersome and time consuming exports
Using the powerful Simba SQL engine, your Excel data is exposed as a SQL data source allowing for easy querying of Excel data from your analytic applications.
Data can be accessed at both a worksheet level as well as distinct tables representing portions of a worksheet. Detection of horizontal and vertical tables within an Excel worksheet can be performed automatically or, for finer control, ranges of cells can be specified. Additionally, data types for cells are preserved ensuring an accurate representation of your Excel data to other applications.
- Real-time SQL access to Excel data from any application supporting JDBC connectivity
- Access Excel data either as an entire worksheet or discrete ranges of data within a worksheet
- Automatic detection of named tables within a worksheet
- Represent discrete blocks of data as tables through automatic detection or by manually specifying ranges of data
- Optionally specify the first row of data should be used for field names
- Read tables that are oriented horizontally or vertically
- Reference an Excel file directly or as a connection object from within a Java application
- Support for Excel XLS and XLSX file formats
- JDBC connector compliant with the latest JDBC 4.2 specification
- Simple per-host licensing (server or desktop). The license cost is the same for any number of installed processors or cores (virtual or physical).
- Departmental, enterprise and worldwide licensing available on request
- Supports both Excel XLS and XLSX file formats
- Complies with the latest JDBC 4.2 specification
- Supports ANSI SQL-92
- Supports Unicode
User Guides, Release Notes, and FAQs.