Sharing Data Between Applications

When information is stored in one system, but created in another, the result can be a lot of manual data entry and potential for errors. MDT can streamline your business process using data interfaces.

ODBC (Open Database Connectivity)
EDI (Electronic Data Interchange)
XML, CSV, TXT, HTML and other Data Formats

ODBC (Open Database Connectivity)

Open Data Connectivity is used by a multitude of vendors and a variety of technologies to enable "live" sharing of individual data records between database management systems. For instance you can share data between a Progressive or SQL database, and a Microsoft Access database. You can share from, or to, a FileMaker Pro database, a FoxPro database, and others.

ODBC is just one of the many ways that data can be shared between applications. You can reduce your data entry chores. Contact us today to learn more.

EDI (Electronic Data Interchange)

EDI is the term sometimes used to denote the electronic transfer of structured data from one computer to other using a set of mutually agreeable standards.

Unlike ODBC, EDI can be used, for example, to send all of the data to create a complete invoice. In most databases, an invoice is comprised of at least three types of records, a header record, multiple line item records, and a total record. An EDI process can be implemented to transfer all of them as a transaction.

If you need to transfer transactional data from one system to another, or from a web based application to a desktop system, MDT has the knowledge and experience to build your interface.

XML, CSV, TXT, HTML and other Data Formats

If your management application will allow you to import data, it most likely requires that data to be in one of these "data formats".

A "data format" specifies what order pieces of information must be in, a maximum length for each piece of data, and what character(s) separate once piece of data from another. Sometimes a "data format" will specify allowable values.

MDT professionals know how to handle data formats properly, with required verification procedures. We can help you, or train you.

Services

Business Backup
Web Sites
Microsoft Access
Sharing Data
Data Conversion
EDI