DriverFX for Calyx Point
DriverFX is a fully functional ODBC driver for reading Calyx Point data files by using
standard SQL queries. It requires an ODBC compliant front-end application such as Crystal Reports,
Microsoft Word, Microsoft Excel, Microsoft Access, Visual Basic, PowerBuilder or Delphi. Once
installed, it will allow these applications to read Calyx Point data files in the same fashion as
other file formats installed on your computer. Using the official Calyx SDK interface, we are able
to offer our customers total compatibility with all Calyx file formats.
What is ODBC?
ODBC (Open Data Base Connectivity) is a specification designed by Microsoft to allow Windows applications
to access multiple database systems through a single method with no regard for various file formats. SQL
(Structured Query Language) is used as the method for accessing data through ODBC. Vendors of ODBC drivers
(like this one) follow the specifications for ODBC so that any ODBC compliant application can access the data
available through the driver. ODBC compliant applications include: Microsoft Access, Word, Excel, PowerBuilder,
Borland Delphi, Crystal Reports, Visual Basic and hundreds of others. Users of these applications do not need
to learn SQL language to access these database files, they are simply presented on the desktop for the user to
manipulate with wizards and icons.
What is DriverFX for Calyx Point?
DriverFX is an ODBC driver (DLL) for Calyx Point data files. Calyx Point stores it's data in it's own
proprietary DBMS file format. This driver allows users of any ODBC compliant front end application to read
the data contained in Calyx Point data files similarly to any other ODBC enabled database.
DriverFX for Calyx Point works by accepting SQL commands from applications through the ODBC interface, then converting
those calls to navigational XML commands to the Calyx Point DBMS and returning record sets that qualify for
the query results. This driver is not a Client/Server product, but rather communicates directly with the
Calyx Point application. Calyx Point is a flat file database, and this driver will not change it into a
relational database, so keep that in mind when developing with this driver.
DriverFX acts as a 'wrapper' around the Calyx Point SDK so customers can finally get at their data
using standard database tools; speeding development time.
What can I do with DriverFX for Calyx Point?
- A user in Microsoft Office can use Excel to pull loan information directly into a spreadsheet and create a chart
- Microsoft Word can do a borrower mail merge directly from Calyx Point data files
- Crystal Reports can create multi-file reports from Calyx Point data