|
|
|
|
The
Solution
 There is a solution and
it’s called ODBCFace.
ODBCFace is a generalized interface between
Microsoft Excel 97, 2000, 2002 and any
OLE DB (Object Linking and
Embedding for Databases) and
ODBC (Open Database Connectivity) data providers.
Although it could be
technically defined as an ETL tool (Extraction, Transformation and
Loading) it completely removes the need to learn the ins and outs
of an ETL tool. The transformation platform for ODBCFace is Microsoft®
Excel therefore, this tool should be regarded as an EXL tool (Extraction
Excel and Loading). |
|
Whether you are implementing JDE, SAP,
Oracle,
BAAN,
PeopleSoft or another ERP system, ODBCFace is the implementation tool that allows
you to export data from your legacy system, easily integrate the
information in a familiar tool and, finally, upload it to your new
system.
The interface reads a simple script that enables
you to add commands to the Excel Menu bar. For each of these commands, you can specify
multiple activities to perform against databases in multiple data
providers. You can retrieve, upload, update and delete information between more
than one DBMS at the touch of a magic wand or, better, at the click of
a mouse.
|
 |
|
The scripting language is so simple that a novice
user of ODBCFace can prepare one maintenance model for a master table
in a couple of hours. And, if that's not enough, ODBCFace comes with a
development wizard that will reduce the distance between you and a
fully functional maintenance model to three fast and easy steps.
Expert users can perform the same task in a
matter of minutes. They
can also use advanced features to push the usage of ODBCFace to limits
previously only reached with complex and expensive Visual Basic
development. These features include: OLE DB engine,
XML capabilities,
automated execution, integrated
debugger, conditional logic, nested SQL statements, multi-providers
and multi-steps command, complete two-way integration with Excel
macros and many more.
ODBCFace gives you the ability to map Excel cells
or columns to data elements in your ERP system.
It also lets you retrieve values from an Excel workbook and
embed them inside SQL statements.
You can perform virtually any type of database activity
including running stored procedures and submitting remote jobs
(according to the DBMS and OLE DB driver in use).
|
 |
|
The product has been developed using
Microsoft® Visual Basic Application Edition and uses the
Microsoft® Data Access Components MDAC 2.7 Library for data
access (included in the installation).
The minimal requirements to use ODBCFace
are Microsoft® Windows 98, NT, 2000 or XP and Microsoft®
Excel 97, 2000 or 2002. |
|
