SingleStore + Smart Ingest

Smart Ingest lets you pull data stored in your SingleStore database and push it to Iterable.

# In this article

# Connection requirements

Before you can connect Smart Ingest to SingleStore, you need to do the following:

• Allow Smart Ingest IPs in SingleStore.
• Choose a connection type.
• Get SingleStore connection details.
• (Optional) Create a CA certificate.

# Allowing Smart Ingest IPs in SingleStore

Before you connect Smart Ingest to SingleStore, make sure to allow Smart Ingest IPs to connect to your database.

# Connection types

Smart Ingest supports two connection types for SingleStore:

• A direct connection over the public internet.

• A SSH tunnel.

  To learn more about SSH tunneling and how to set up standard and reverse tunnels for Smart Ingest, read SSH Tunneling for Smart Ingest.

The connection type you choose depends on your SingleStore configuration and your security requirements. Because data is encrypted in transit via TLS, a direct connection is suitable for most use cases. You may need to set up a tunnel if your SingleStore instance is on a private network or virtual private cloud (VPC).

# SingleStore connection details

To connect to SingleStore, you need the following details:

• Host - The hostname or IP address of your SingleStore server.

• Port - The port number of your SingleStore server. The default port number is 3306, but yours may be different.

• Database - The name of the database to use when Smart Ingest executes queries in SingleStore.

• User - This can be your personal SingleStore login or a dedicated user for Smart Ingest. The user should, at minimum, have permission to read the tables you want to sync.

• Password - The password for the user specified above.

• CA Certificate - You can optionally provide your own CA certificate. (This is uncommon.)

# Using CA verification

If you have a custom CA certificate for your SingleStore server, you can provide the certificate to Smart Ingest. This is optional, and most users can connect without providing a custom certificate.

To use your own CA certificate with Smart Ingest, you need to provide a CA certificate file (max size 10MB). Smart Ingest supports the following formats for CA certificates:

• PEM - A common format for certificates and keys. You can provide the certificate and key in separate files, or in a single file with the certificate first and the key second.

• CRT - A common format for certificates. You can provide the certificate in a single file.

# Connecting SingleStore to Smart Ingest

To connect Smart Ingest with your SingleStore database:

1. Log in to Iterable as a user with the Manage Integrations project permission and open the project you’re working on.

2. Go to Integrations > Smart Ingest.

3. Click Connect a New Source.

4. Select SingleStore and click Continue.

5. In Step 1, select the connection type your sync should use to connect:

   • Connect Directly to SingleStore. This creates a direct connection with no additional setup needed.

   • Connect via SSH Tunnel. This connects using SSH. Add a standard or reverse tunnel, or select an existing tunnel if you’ve already set one up.

     To learn more about SSH tunneling and how to set up standard and reverse tunnels for Smart Ingest, read SSH Tunneling for Smart Ingest.

6. In Step 2, enter your SingleStore database details: Host, Port, and Database.

   If you have a custom CA certificate, turn on the setting Enable Verification and provide the CA certificate.

7. In Step 3, enter your user credentials for SingleStore: User and Password.

8. Click Continue. Smart Ingest automatically tests the connection.

9. When the connection test is successful, click Continue. (If there are problems connecting, click Back and review the connection details for accuracy.)

10. Add a name for your data source to display in Iterable.

11. Click Finish.

# Next steps

You've now connected your data warehouse to Smart Ingest. The next thing you can do is create a sync.