Skip to main content

Step 4: Add Target Database

Setting Up Your Target Database​

Before you can synchronize your data, you need to set up a target database. XPipes supports synchronization between any combination of supported databases, allowing you to choose the best target for your specific use case.

Supported Target Databases​

XPipes supports all major databases as targets, including:

  • MySQL - Popular open-source relational database
  • PostgreSQL - Advanced open-source relational database
  • Oracle - Enterprise-grade relational database
  • SQL Server - Microsoft's relational database system
  • MongoDB - Leading NoSQL document database
  • ClickHouse - High-performance columnar database for analytics
  • MariaDB - MySQL-compatible database
  • And many more - See our connectors documentation for the full list

Database Connection Options​

You have several options for setting up your target database:

1. Use Your Existing Database​

Connect to any existing database instance you already have running. This gives you full control over your data and infrastructure.

Benefits:

  • Use existing infrastructure
  • Full control over configuration
  • No additional costs for database hosting
  • Seamless integration with existing systems

2. Cloud Database Services​

Connect to managed database services from major cloud providers.

Supported cloud services:

  • AWS RDS (MySQL, PostgreSQL, Oracle, SQL Server)
  • Google Cloud SQL
  • Azure Database services
  • MongoDB Atlas
  • ClickHouse Cloud

Creating a Target Database Connection​

To create a target database connection:

  1. Navigate to the Connections section in the left sidebar

  2. Click Create and select your target database type

  3. Fill in the connection details (varies by database type):

    • Name: A descriptive name for your connection
    • Host: The hostname or IP address of your database server
    • Port: The port number (varies by database)
    • Database: The database name
    • Username: Your database username
    • Password: Your database password
    • Additional settings: Database-specific configuration options

  4. Click Test Connection to verify the connection works

  5. Click Save to create the connection

Database-Specific Configuration​

Each database type has specific configuration requirements. For detailed setup instructions for your target database, see our connectors documentation.

Next Steps​

Once you've set up your target database, you're ready to:

  1. Create a Synchronization Task to start synchronizing data between your databases