Instruction how to read or write from access databases.
Access is partially supported in ETLBox. Most of the components may work, but there are some limitations when connecting with Access. Below are these limitation described in detail. The good news is: You can make it work to integrate access either as source or as destination.
An overview of existing database connectors in ETLBox and their concepts.
There a numerous database connector packages that come with ETLBox. Add the connector package for the database that you want to connect with. So if you want to connect with a SqlServer, add the ETLBox.SqlServer pacakge to your project. For MySql, use ETLBox.MySql.
Details about the Couchbase connector
Couchbase can be used a document storage and key/value storage. This article will give you an overview of the Couchbase connectors for ETLBox.
Details about the DbMerge connector
The following article describes how you can use the data from your data flow to insert new data in a destination table, update existing or delete removed records.
MongoSource and MongoDestination in detail
A detailed overview of the MongoSource and MongoDestination.
How to read or write data from Redis
Redis is a very popular key/value store. ETLBox can connect to Redis with the RedisSource and RedisDestination.
Accessing relation databases with the DbSource and DbDestination
A detailed overview of the DbSource and DbDestination connector.