# Configure Source Database You can configure the following databases as sources: Oracle, Microsoft SQL Server, MySQL, PostgreSQL, Snowflake, MongoDB (private preview), Salesforce (public preview), and SingleStore (non-production preview). For other JDBC-compatible databases, you can use the **Any Database** option, which is in non-production preview. To configure the source database, navigate to **Dashboard** > **Source**, and then select the gear icon. * *Oracle* ## Oracle Configuration1) In the **Source Database** dialog, select **Oracle** from the **Source Database** list. 2) Select the **Extract Type** from the following: 1. **Log Miner** 2. **Fast Log Miner** 3. **Remote Log Miner** 4. **Continuous Log Miner** 5. **Full Extracts** 6. **Timestamps** **Note**: Tabs are different for **Remote Log Miner** extract type. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the name of your database. 4. **User Id**: Enter a valid Oracle database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) Enter the configuration details for **Remote Log Miner** extract type: 1. Select the **Source Database** tab, and enter the following configuration details: **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the Oracle SID. **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 4. **User Id**: Enter a valid Oracle database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 2. Select the **Mining Database** tab, and enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the Oracle SID. **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 4. **User Id**: Enter a valid Oracle database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 5) Select the **Advanced Options** tab. The configuration details vary for each **Extract Type**. | **Extract Type** | **Configurations in Advanced Options** | | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Log Miner | | | Fast Log Miner | | | Remote Log Miner | | | Continuous Log Miner | | | Full Extracts | | | Timestamps | | Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 6) Select **Apply** to confirm and save the details. 7) Select **Test** to verify the connectivity.## Oracle Pluggable Configuration1) In the **Source Database** dialog, select **Oracle(Pluggable Database)** from the **Source Database** list. 2) Select the **Extract Type** from the following: 1. **Fast Log Miner** 2. **Continuous Log Miner** 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the Oracle SID. **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 4. **User Id**: Enter a valid Oracle pluggable database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) In the **Root** **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the root container database name. 4. **User Id**: Enter a valid root container user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 5) Select the **Advanced Options** tab. The configuration details vary for each **Extract Type**. | **Extract Type** | **Configurations in Advanced Options** | | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Fast Log Miner | | | Continuous Log Miner | | Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 6) Select **Apply** to confirm and save the details. 7) Select **Test** to verify the connectivity.## Oracle RAC Configuration1) In the **Source Database** dialog, select **Oracle(RAC)** from the **Source Database** list. 2) Select the **Extract Type** from the following: 1. **Log Miner** 2. **Continuous Log Miner** 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the Oracle SID. **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 4. **User Id**: Enter a valid Oracle pluggable database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) Select the **Advanced Options** tab. The configuration details vary for each **Extract Type**. | **Extract Type** | **Configurations in Advanced Options** | | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Log Miner | | | Continuous Log Miner | | Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 5) Select **Apply** to confirm and save the details. 6) Select **Test** to verify the connectivity.## Oracle RAC Pluggable Configuration1) In the **Source Database** dialog, select **Oracle(RAC) (Pluggable Database)** from the **Source Database** list. 2) In the **Extract Type** list, select **Log Miner**. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the Oracle SID. **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 4. **User Id**: Enter a valid Oracle pluggable database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) In the **Root** **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the root container database name. 4. **User Id**: Enter a valid root container user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 5) Select the **Advanced Options** tab. Enter the following configuration details: 1. Extract Threads 2. Log file catchup count 3. Log catchup time (mins) 4. Log catchup offset (mins) 5. Log file look-ahead 6. Convert RAW to Hex Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 6) Select **Apply** to confirm and save the details. 7) Select **Test** to verify the connectivity.## Oracle 19c Configuration1) In the **Source Database** dialog, select **Oracle 19c** from the **Source Database** list. 2) In the **Extract Type** list, select **Continuous** **Log Miner**. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the Oracle SID. **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 4. **User Id**: Enter a valid Oracle pluggable database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) Select the **Advanced Options** tab. Enable **Convert RAW to Hex**. Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 5) Select **Apply** to confirm and save the details. 6) Select **Test** to verify the connectivity.## Oracle 19c Pluggable Configuration1) In the **Source Database** dialog, select **Oracle 19c (Pluggable Database)** from the **Source Database** list. 2) In the **Extract Type** list, select **Continuous** **Log Miner**. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the Oracle SID. **Note**: When using SID to connect to a dedicated Oracle server instance, use **:SID**. 4. **User Id**: Enter a valid Oracle pluggable database user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) In the **Root** **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Oracle is 1521). 3. **Database Name**: Enter the root container database name. 4. **User Id**: Enter a valid root container user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 5) Select the **Advanced Options** tab. Enable **Convert RAW to Hex**. Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 6) Select **Apply** to confirm and save the details. 7) Select **Test** to verify the connectivity. * *Microsoft SQL Server* ## Microsoft SQL Server Configuration1) In the **Source Database** dialog, select **Microsoft SQL Server** from the **Source Database** list. 2) Select the **Extract Type** from the following: 1. **Change Tracking** 2. **CDC** 3. **Full Extracts** 4. **Timestamps** 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for SQL Server is 1433). 3. **Database Name**: Enter the name of your database. 4. **User Id**: Enter a valid SQL Server user ID to be used with Ingest. If a Windows user is required, contact [SingleStore Support](http://support.singlestore.com/) for guidance. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. **Note**: For development and testing environments, such as those with self-signed certificates, you can enter `trustServerCertificate=true` in this field to bypass the certificate validation. However, in production environments, it is strongly recommended to avoid this setting and instead enforce a full TLS certificate validation. 4) Select the **Advanced Options** tab. Enter the **Extract Threads**. Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 5) Select **Apply** to confirm and save the details. 6) Select **Test** to verify the connectivity. * *MySQL* ## MySQL Configuration1) In the **Source Database** dialog, select **MySQL 5.1 or higher** from the **Source Database** list. 2) In the **Extract Type** list, there are two options: * **Continuous**: Captures changes in real time as they are written to the binlog. This mode is recommended when minimal latency is required between a data change in the source and its appearance in the destination. Continuous mode is the preferred option and is suitable for most workloads. * **Log**: Captures changes when a new binlog file is automatically rotated or manually flushed. This mode is efficient and well-suited for high-volume systems. If Continuous mode experiences performance degradation, switching to Log mode can help maintain stability with a marginal increase in latency. * **Fast Extractor (Preview)**: Uses a dedicated fast extractor to read the MySQL binary log and stream changes to SingleStore with high throughput. This mode is intended for high-change-rate MySQL workloads. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for MySQL is 3306). 3. **Database Name**: Enter the name of your database. 4. **User Id**: Enter a valid MySQL user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) Select the **Advanced Options** tab. Enable **Handle zero length strings**. Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/appendix.md) for more information. 5) Select **Apply** to confirm and save the details. 6) Select **Test** to verify the connectivity.## Configure SSLTo configure SSL for the MySQL source connection, include the `sslMode` parameter in the **JDBC Options** field. Flow supports the following values for `sslMode`:- `DISABLED` - SSL is not used. This is the default if `sslMode` is not specified in the JDBC options. - `REQUIRED` - Forces the connection to use SSL. If an SSL connection cannot be established, the connection fails.**Note**: `VERIFY_CA` and `PREFERRED` options are not supported in Flow.## Example: Enable SSL for a MySQL sourceIn the **JDBC Options** field, enter :```shell sslMode=REQUIRED&serverSslCert=/path/to/ca-bundle.pem ```Where:- `sslMode`=`REQUIRED` enforces SSL for the connection. - `serverSslCert` is the path to the CA bundle that signed the MySQL server certificate. **Note**: The `serverSslCert` option must point to a CA bundle (public key) file that is available on the host where the Ingest service is running. Ensure that this file is copied to that host and that the Ingest process has read access to it, then reference its full path in the `serverSslCert` parameter. If the certificate is issued by a non-public Certificate Authority (non-public CA) or if certificate validation fails (for example, because the CA is not trusted, an intermediate certificate is missing, the hostname does not match, the certificate is expired, or the public key or JKS file is infected or malicious), create a Java KeyStore (JKS) file on the Flow server and use it to validate the certificate. A JKS file is a password-protected file that stores certificates and keys for Java applications. To create and populate a JKS, use your organization's standard Java keystore procedure (typically the keytool utility). For more information, refer to the official Java documentation for [Java KeyStore](https://docs.oracle.com/javase/8/docs/api/java/security/KeyStore.html) and [keytool](https://docs.oracle.com/javase/8/docs/technotes/tools/unix/keytool.html). * *PostgreSQL* ## PostgreSQL Configuration1) In the **Source Database** dialog, select **Postgres** from the **Source Database** list. 2) In the **Extract Type** list, select **Logs**. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening (default port for Postgres is 5432). 3. **Database Name**: Enter the name of your database. 4. **User Id**: Enter a valid Postgres user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) Select **Apply** to confirm and save the details. 5) Select **Test** to verify the connectivity. * *Snowflake* ## Snowflake Configuration1) In the **Source Database** dialog, select **Any Database** from the **Source Database** list. 2) In the **Extract Type** list, select **Full Extracts**. 3) In the **Database** tab, enter the following configuration details: 1. **JDBC Driver**: Specify the JDBC driver name for the source database. For Snowflake, enter `com.snowflake.client.jdbc.SnowflakeDriver` 2. **JDBC URL**: Enter the JDBC connection string for the source database in the format: `jdbc:://:` 3. **User Id**: Enter a valid user ID to be used with Ingest. 4. **Password:** Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 4) Select **Apply** to confirm and save the details. 5) Select **Test** to verify the connectivity.**Note**: Other JDBC-compliant databases are in a non-production preview, and can be tested using the **Any Database** option from the list. Feel free to reach out to[ SingleStore Support](https://support.singlestore.com/hc/en-us) with any observations. * *Any Database* ## Any Database Configuration1) In the **Source Database** dialog, select **Any Database** from the **Source Database** list. 2) In the **Extract Type** list, select **Full Extracts**. 3) In the **Database** tab, enter the following configuration details: 1. **JDBC Driver**: Specify the JDBC driver name for the source database. Example: `com.vertica.jdbc.Driver` **Note**: The JDBC driver differs depending on the database. 2. **JDBC URL**: Enter the JDBC connection string for the source database. The JDBC URL varies for each database. Example: `jdbc:vertica://my-vertica-server.com:5433/myDB` **Note**: JDBC URLs vary from one database to another. 3. **User Id**: Enter a valid user ID to be used with Ingest. 4. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 4) Select **Test** to verify the connectivity. 5) Select **Apply** to confirm and save the details. * *MongoDB (private preview)* > **📝 Note**: This is a Private Preview feature.## MongoDB Configuration1) In the **Source Database** dialog, select **MongoDB** from the **Source Database** list. 2) In the **Extract Type** list, there are two extract types: * **Self-managed**: Your MongoDB instance must be running in **replication mode**. * **Atlas**: Your IP address must be added to the **MongoDB Atlas IP Access List**. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database. 2. **Port**: Enter the port number on which the database server is listening (default port for MongoDB is 27017). **Note**: This field is not required for the **Atlas** extract type. 3. **Database Name**: Enter the name of your database. 4. **User ID**: Enter a valid user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) Select **Apply** to confirm and save the details. 5) Select **Test** to verify the connectivity. * *Salesforce (public preview)* > **📝 Note**: This is a Public Preview feature.## Salesforce Configuration1) In the **Source Database** dialog, select **Salesforce** from the Source Database list. 2) In the **Extract Type** list, select **API**. 3) In the **Salesforce** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the Salesforce server. 2. **User Id**: Enter a valid Salesforce user ID to be used with Ingest.  3. **Password**: Enter your Salesforce password concatenated with the security token generated by your Salesforce Connected App. Refer to [Source Database Setup](https://docs.google.com/document/d/1aD92TPSC9AZDQetRa6pBKaAPnzhSo8XDg2YR24mPnY4/edit?tab=t.0#heading=h.lnakxcq9x9b9) for instructions on retrieving the security token. **Note**: Passwords are encrypted within Ingest. 4. **Consumer Key**: Enter the Consumer Key generated by your Salesforce Connected App. 5. **Consumer Secret**: Enter the Consumer Key generated by your Salesforce Connected App. 6. Select **Test** to verify the connectivity. 7. Select **Apply** to confirm and save the details. * *SingleStore (non-production preview)* > **📝 Note**: This feature is in non-production preview for Ingest Full Extracts only.## SingleStore Configuration1) In the **Source Database** dialog, select **SingleStore (Preview)** from the **Source Database** list. 2) In the **Extract Type** list, select **Full Extracts**. 3) In the **Database** tab, enter the following configuration details: 1. **Host Name**: Enter the IP address or hostname of the database server. 2. **Port**: Enter the port number on which the database server is listening. 3. **Database Name**: Enter the name of your database. 4. **User Id**.: Enter a valid user ID to be used with Ingest. 5. **Password**: Enter the password for this user. **Note**: Passwords are encrypted within Ingest. 6. **JDBC Options** (Optional): JDBC options are optional and can be used to extend the JDBC URL for accessing the database. 4) Select **Apply** to confirm and save the details. 5) Select **Test** to verify the connectivity. *** Modified at: May 6, 2026 Source: [/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/configure-source-database/](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow/singlestore-ingest/configure-source-database/) (An index of the documentation is available at /llms.txt)