About Microsoft Access
An Access file on a shared drive is more often the system of record than anyone likes to admit. We read it like any other database, relationships and all, instead of asking someone to retype it.
How the integration works
What you hand over The .mdb or .accdb file from the shared drive.
What gets read Tables and the relationships between them, so a customer and their orders stay connected.
What comes out One normalised dataset: consistent column names, UTF-8 throughout, empty values instead of the literal text NULL. The transformation works against that shape, not against the quirks of the source.
Other integrations in Data sources
Amazon RDS PostgreSQLManaged PostgreSQL on AWS. Read from a dump or a replica.
Amazon RedshiftCloud warehouse as a source for large customer datasets.
Amazon S3Object storage as a source. Files and exports pulled straight from the bucket.
CSV FilesA folder of exports. Delimiter and encoding detected automatically.
FirebirdUnder trades and SMB software. The database file from the office server.
Google BigQueryWarehouse as a source. Query results feed the migration.Our Micromerce integrations enable us to implement all your business processes and individual requirements thanks to customized configurations.However, before you start worrying about which integrations are the right combination for you, take a look at the solution packages that we have already put together for our customers over the years.