Sign inTry Free

Dashboard

On this page

The Dashboard provides a central screen to monitor the overall status of the Ingest instance.

  • Dashboard provides quick access to configure Ingest, including the following:

    • Source Database

    • Destination Database

    • Tables

    • Schedule Tasks

  • The Checklist gives the summary of the steps that are needed to complete to start an Ingest job.

  • The graph summary displays the number of records transferred.

    • When Hourly is selected, you can view transfer statistics for the past 24 hours.

    • When Daily is selected, the monthly statistics are shown.

    • The bar graph illustrates the process status:

      • Initial Extract is represented by blue.

      • Inserts are represented by green.

      • Updates are represented by yellow.

      • Deletes are represented by red.

    • Hovering over the bar graph shows the exact number of records transferred.

  • You can view the log for Source and Destination database at the bottom.

Source Database

You can configure the following databases as a source: Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.

To configure the source database, navigate to Dashboard > Source, and then select the gear icon.

Destination Database

You can configure SingleStore databases as a destination. To configure the destination database, navigate to Dashboard > Destination, and then select the gear icon.

  1. In the Destination Database dialog, select SingleStore from the Destination Database list.

  2. In the SingleStore 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 SingleStore is 3306).

    3. Database Name: Enter the name of your database.

    4. User Id: Enter a valid SingleStore 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.

  3. Select the Advanced Options tab. Enter the following configuration details:

    1. Max Updates (Default maximum update is 4)

    2. Load Threads

    3. Add Database Prefix

    4. Truncate table instead of drop

    5. Schema for all tables

    6. Ignore database name in schema

    7. Schema for staging tables

    8. Retain staging tables

    Refer to Appendix for more information.

  4. Select Test to verify the connectivity.

  5. Select Apply to confirm and save the details.

Last modified: January 29, 2025

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK