# Configure Source Database
You can configure the following databases as a source: Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and Snowflake.
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 and confirm it by re-entering it in the **Confirm Password** field.
**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 and confirm it by re-entering it in the **Confirm Password** field.
**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 and confirm it by re-entering it in the **Confirm Password** field.
**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 | - Log file catchup count
- Log catchup time (mins)
- Log catchup offset (mins)
- Log file look-ahead
- Convert RAW to Hex
|
| Fast Log Miner | - Extract Threads
- Log file catchup count
- Log catchup time (mins)
- Log catchup offset (mins)
- Log file look-ahead
- Convert RAW to Hex
|
| Remote Log Miner | - Extract Threads
- Log file catchup count
- Log catchup time (mins)
- Log catchup offset (mins)
- Log file look-ahead
- Convert RAW to Hex
|
| Continuous Log Miner | |
| Full Extracts | - Extract Threads
- Convert RAW to Hex
|
| Timestamps | - Extract Threads
- Convert RAW to Hex
|
Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow-on-helios/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 and confirm it by re-entering it in the **Confirm Password** field.
**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 and confirm it by re-entering it in the **Confirm Password** field.
**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 | - Extract Threads
- Log file catchup count
- Log catchup time (mins)
- Log catchup offset (mins)
- Log file look-ahead
- Convert RAW to Hex
|
| Continuous Log Miner | |
Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow-on-helios/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 and confirm it by re-entering it in the **Confirm Password** field.
**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 | - Extract Threads
- Log file catchup count
- Log catchup time (mins)
- Log catchup offset (mins)
- Log file look-ahead
- Convert RAW to Hex
|
| Continuous Log Miner | |
Refer to [Appendix](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow-on-helios/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 and confirm it by re-entering it in the **Confirm Password** field.
**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 and confirm it by re-entering it in the **Confirm Password** field.
**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-on-helios/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 and confirm it by re-entering it in the **Confirm Password** field.
**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-on-helios/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 and confirm it by re-entering it in the **Confirm Password** field.
**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 and confirm it by re-entering it in the **Confirm Password** field.
**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-on-helios/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 and confirm it by re-entering it in the **Confirm Password** field.
**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-on-helios/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:
* **Log**: Captures changes when a new binlog file is automatically rotated or manually flushed.
* **Continuous**: Captures changes in real-time as they are written to the binlog. Recommended for CDC use cases.
* **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 and confirm it by re-entering it in the **Confirm Password** field.
**Note**: Passwords are encrypted within Ingest.
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-on-helios/singlestore-ingest/appendix.md) for more information.
5) Select **Apply** to confirm and save the details.
6) Select **Test** to verify the connectivity.**Note**: To configure SSL certificates for MySQL source connections, contact [SingleStore Support](https://support.singlestore.com).
* *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 and confirm it by re-entering it in the **Confirm Password** field.
**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 and confirm it by re-entering it in the **Confirm Password** field.
**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.
***
Modified at: April 27, 2026
Source: [/db/v9.1/load-data/load-data-with-singlestore-flow-on-helios/singlestore-ingest/configure-source-database/](https://docs.singlestore.com/db/v9.1/load-data/load-data-with-singlestore-flow-on-helios/singlestore-ingest/configure-source-database/)
(An index of the documentation is available at /llms.txt)