Databases as a Data Source
Your production database contains your most important data, and DataChannel’s database connectors are our most important and battle-tested connectors. Our database connectors are designed for correctness and safety. Correctness means that your destination should always be an accurate replica of your database source. Safety means that no matter what, DataChannel should never cause problems in your source database.
Connect: Connect us to your production database or read-replica via a specific DataChannel user that you create in your database. For instructions on creating a DataChannel user, see the setup guide for your database type.
Select Table(s): Select the table(s) / views you wish to move or provide a custom
SELECTSQL query you would want us to use to move data.
Transform and map schema: DataChannel parses through all your data, typecasting and mapping every column in the source object to a column in the corresponding table in the destination. We transform any data types that are not natively supported in the destination into data types that are accepted. DataChannel does not do any aggregations at this stage.
Load: DataChannel automatically creates schemas and tables for each mapped source object in the destination.
Update Mode: DataChannel provides you with the flexibility of choosing your data fetch mode between Incremental and Full. You can choose how often these batches run, from every 15 minutes to every 24 hours. DataChannel’s unique system automatically recognizes schema changes in your data source and persists these changes to the destination.
We’ll be happy to help you with any questions you might have! Send us an email at firstname.lastname@example.org.
Subscribe to our Newsletter for latest updates at DataChannel.