Our technical services group has many years of experience working with database systems of every sort and size. We have extensive knowledge and skill in the development of data Extraction, Transformation, and Loading (ETL) tools and techniques. This enables us to automate the transfer of large data volumes between systems.
In simplest terms, data conversion involves moving computer data from one format to another. Data can be structured, encoded, and stored in many different ways, and the transfer of data from one environment to another environment often requires specialized training and experience. Data conversions might be as simple as the conversion of a text file from one character encoding system to another — or it might be much more complex, such as the conversion of office file formats or the migration of business data from one platform and schema to an entirely different platform and schema.
Data conversion sometimes requires intermediate processing by computer program and utilities, and might even require a complex staging process, in which the data is subject to validation steps. Validation might include manual quality assurance checks and/or automated data integrity checks. Here is a list of some of the file formats and data environments with which we have experience:
- Microsoft SQL Server
- Microsoft Access
- Microsoft FoxPro
- TXT (fixed-width and delimited)
- XLS and XLSX