Community docs

KNOTS

With KNOTS, you can quickly and easily leverage ETL without complex manual configurations.

Download KNOTS & Docker.

Before you can start replicating your data, you'll need to download and install KNOTS and Docker:

Download for MacDownload for Windows

Installation instructions for Mac

Installation instructions for Windows

  1. Download the correct package from the newest releases in the KNOTS repository on GitHub (KNOTS is built on top on Singer.io taps & targets).

  2. Download the correct Docker package for your system (you will need to create a free Docker account if you don't already have one).

  3. Install KNOTS and Docker on your computer.

Create your knot.

Now that KNOTS & Docker are installed, you can begin creating your first knot:

Docker Tips:
  • On Mac: Check the Docker file sharing preferences to make sure Users is a shared directory.

  • On Windows: The first time you set up a tap, Docker will ask to share the C drive. Accept, and enter your password if prompted.

knots_choose-tap.png
knots_config-tap.png
knots_choose-data.png
knots_choose-target.png
  1. Open KNOTS & Docker (make sure Docker is open & running before starting your first knot.)

  2. Select your tap (the source you want to use to replicate data).

  3. Configure your tap. You'll need to enter the following information:

    If you are running your database locally, enter host.docker.internal instead of localhost Most apps have a default port (5432 for PostgreSQL, 3306 for MySQL).
    • Hostname.

    • Port.

    • Your database name.

    • Username & password for your database.

  4. Select any and all data that you would like to replicate.

  5. Select data.world as your target.

  6. Configure the data.world target. You'll need to enter the following information:

    Choose Browse to choose from a list of available datasets.
    • Dataset URL.

    • Your API token (from your data.world's KNOTS integration page).

    • Username & password for your database.

    knots_config-target.png
  7. Choose a name for your knot, then choose Save & Run.

Knots walkthrough video

Watch a short video that will walk you through the process of installing and using KNOTS.

Please note, this walkthrough is shown on MacOS.

What next?

Here are a few things you can do with KNOTS and data.world:

  • With any saved knot, you can sync new data, sync all data, and edit, export, or delete your knot.

  • Using the Export function, you can set up a job that will update your data automatically on a schedule. Learn more about using a job scheduler here