ODBC stands for Open DataBase Connectivity. ODBC provides a
standardized set of rules for getting information to and from
a database. An ODBC driver is a software interface that accepts
ODBC standard queries and then passes them through to the specific
application, modifying where necessary to account for application
specific database structure and format.
The functions of a driver are invisible to users and third
party applications. From a third party perspective, a standardised
ODBC query or update is presented to the database, and a standardised
ODBC response is returned. Source: MYOB Developer Pack.
|
Since the very first release of MYOB
ODBC we have been developing solutions to meet the needs of
our customers. We are continually finding new and interesting
ways that this tool can be utilised to improve day-to-day business
functions.
Included below is a small sample of the MYOB ODBC projects
we have been working on.
|
|
Name: |
Group Consolidation |
| Features: |
Merging 14 MYOB data files
into a single consolidated Profit and Loss and Balance
Sheet. |
| Benefit: |
Replaced manual
data entry and Microsoft Excel spreadsheets that were
complicated and prone to user error. |
| Time
Saving: |
An average
of 16 hours of manual data entry saved per month. |
|
|
Name: |
Gross Profit Report
|
| Features: |
Sale amount, cost of sales
and gross profit grouped by inventory items, salesperson
and date range. |
| Benefit: |
This functionality
and data was not accessible from MYOB. |
| Time
Saving: |
Invaluable
to this sale driven company. |
|
|
Name: |
Web Site Catalogue
Upload |
| Features: |
MYOB ODBC was used to
create an XML file that contained selected inventory items
that where uploaded to a secure ecommerce web site. |
| Benefit: |
Not possible
prior to implementation. |
| Time
Saving: |
Not feasible
to manually created an XML file that contains over 7,000
inventory items. |
|
|
Name: |
Time Billing Invoices
and Summaries |
| Features: |
Extracts time billing
information and presents the data in a Microsoft Word
document in a format specified by our clients. |
| Benefit: |
Removed the
need to manually format Time Billing invoices and summaries. |
| Time
Saving: |
An average
of 1.5 hours per invoice. |
|
|
 |
|
MYOB ODBC is basically a tool that is used to connect
and read directly from an MYOB data file. For example it can
be used to combine/share accounting data with other applications
or it can be used to present data in a format that best meets
the needs of a business.
The MYOB ODBC architecture has four major components:
- tools such as
Microsoft Access, Microsoft Office, Development Language (i.e.
Microsoft Visual Basic), and Crystal Report can be used to
create applications that interface to MYOB ODBC. SQL Statements
are passed to the ODBC Driver Manager to access records in
the MYOB data file.
- a Dynamic Link
Library loads the MYOB ODBC drivers on behalf of the application.
- a Dynamic Link Library that Processes
ODBC function calls received from the Driver Manager, submitting
the resultant SQL requests to a specific data source, and
returns results to the application. If necessary, the driver
modifies an application's request so that the request conforms
to syntax supported by the associated DBMS.
- The data source
for the MYOB ODBC driver must be an MYOB data file.
|
| |
|
