Mount databases

Instabase supports integration with a variety of databases. Mounting databases within a subspace lets you access existing, external data for use in Instabase apps and projects.

Mounting databases

Instabase supports the following database types:

Within a subspace, you can mount external databases.

  1. Navigate to Explorer by using the left navigation dock, then navigate to your subspace and click the New Database button below the list of drives.

  2. Select the database type and enter the required authentication credentials.

Database configuration

Configuration details for mounting databases.

Amazon Redshift

  • Mount Name: A name for the mount.

  • Username: Amazon Redshift user account username

  • Password: Amazon Redshift user account password

  • Database name: Database name

  • Host: Server host URL

  • Port: Port for connecting to database

  • Permissions: Permissions for the mounted storage.

    • Read-only: Mount drive with only read permissions

    • Write: Mount drive with read and write permissions

Microsoft SQL Server

  • Mount Name: A name for the mount.

  • Username: SQL Server user account username

  • Password: SQL Server user account password

  • Database name: Database name

  • Host: Server host URL

  • Port: Port for connecting to database

  • Permissions: Permissions for the mounted storage.

    • Read-only: Mount drive with only read permissions

    • Write: Mount drive with read and write permissions

MySQL

  • Mount Name: A name for the mount.

  • Username: MySQL user account username.

  • Password: MYSQL user account password.

  • Database name: Database name.

  • Host: Server host URL.

  • Port: Port for connecting to database.

  • Permissions: Permissions for the mounted storage.

    • Read-only: Mount drive with only read permissions

    • Write: Mount drive with read and write permissions

Oracle

  • Mount Name: A name for the mount.

  • Username: Oracle user account username.

  • Password: Oracle user account password.

  • Database name: Database name.

  • Load from tnsnames.ora:

    • Not selected: Do not retrieve connection information from tnsnames.ora file

    • Selected: Use tnsnames.ora file to retrieve connection information for database

  • Host: Server host URL.

  • Port: Port for connecting to database.

  • Permissions: Permissions for the mounted storage.

    • Read-only: Mount drive with only read permissions

    • Write: Mount drive with read and write permissions

PostgreSQL

  • Mount Name: A name for the mount.

  • Username: Postgres user account username.

  • Password: Postgres user account password.

  • Database name: Database name.

  • Host: Server host URL.

  • Port: Port for connecting to database.

  • Permissions: Permissions for the mounted storage.

    • Read-only: Mount drive with only read permissions

    • Write: Mount drive with read and write permissions