Noteable provides native integrations with common SQL databases, data warehouses, cloud storage vendors, and other data sources. This section describes how to create connections to external data.
Set up a data connection in either the Data Connection left sidebar of a notebook, or the resource section at the bottom of the Space and Project page left sidebar:
Many data sources will be behind a firewall. To connect to a firewalled data source, you will need to ensure your firewall accepts incoming connections from the following Noteable IP addresses:
Click the link below to learn more about how to configure each specific data connection type:
Connecting to a localhost database can be an advanced exercise. Due to the high variation in each user's home or office configuration, we may not be able to help with the specifics, but below outlines some general steps for success.
To connect to a database that is running on your localhost, you'd need to:
- Local network updates:
- Know your home / office routers external IP address.
- Configure your home/office router to allow incoming connections on a specific TCP port number from the Notable external IP addresses listed above, and tell the router to connect that external port to your computer's internal-network IP address corresponding to your data connection type, for example MySQL's listening port is 3306. This is called 'incoming NAT traversal'.
- Database administration:
- Determine if you're running a firewall on your database server host operating system. Please refer to online documentation and resources specific to your host type if unsure.
- If you are running a database host firewall, you'll need to enable external connections through your local OS firewall and your database configuration. Most databases have database-specific administration steps you will need to take to allow incoming connections from external IP addresses for a given database-level user. Consult your database documentation on how to grant connection privileges for a user, database, and multiple external IP addresses.
- Noteable Data Connection
- Add the data connection within Noteable using your router's external IP address as the connection host name, and the port number you chose to allow the NAT traversal incoming connections.
It is highly recommended that when allowing incoming connections into your home network, you narrow the surface area as much as possible, namely to:
- Only open the external router port to the required IP addresses listed above
- Create a new database-level user account just for the use case of queries from Noteable notebooks, and configure that account to have only the capabilities you'll need it to do in your queries. You can always grant it more capabilities later if needed. Do not use a database-level superuser account.