Database connector setup: A step-by-step guide

Fivetran offers multiple connection options to choose from for setting up a secure and efficient database connector, including direct connection, SSH tunnel, AWS PrivateLink, Azure PrivateLink, Google Cloud Private Service Connect, VPN tunnel, and proxy agent. The company provides various replication methods, such as log-based change data capture and log-free change data capture, depending on the location and operations of the database. To set up a successful database connector, users must gather required information from key stakeholders, including the database architect, security team, and database analyst or analytics team. Once the necessary details are collected, users can breeze through the connector setup process by selecting the connector, choosing the connection and update method, and clicking save and test to validate everything is correct. Fivetran provides an easy-to-use dashboard for each connector, allowing users to monitor recent syncs, user actions, alerts, logs, schema, usage, and setup details. The company's automated features, such as automated schema drift handling and automated resyncs in the event of a failure, ensure that connectors are up and running with a guaranteed 99.9% SLA, giving users pipeline peace of mind.