StreamLab External Connections Overview

External connections are databases or other data sources external to SQLstream s-Server. Once you set up an external connection, you can read and write to such data sources from StreamLab. (You don’t need to configure anything here if you’re working with s-Server data alone.) You can connect to the following types of external database:

  • MySQL
  • Oracle
  • Paracel
  • PostgreSQL
  • SQL Server
  • Teradata
  • Actian/Vectorwise

There is also a generic option which lets you set your own connection parameters. (You will need to specify a SQL dialect and so on.)

For all databases other than Oracle, SQL server, and Teradata, you will need to install these databases' JDBC drivers. Please consult documentation for these products for information on installing their JDBC drivers. Once you set up a connection, you can use it for multiple sources and sinks.

Adding an external source is similar to adding other sources.

To add an external source:

  1. On the External Connections page, drag an external connection from the left column into the center area.

  2. Click the new External Connection source. The External Connection Source page opens. Enter configuration information for the source. This varies depending on your selection, but generally includes a name for the source, a hostname, the name of the database, and logon credentials for the database.

  3. Give connection a name. You will use this name to reference the external connection later, as inadding an external table sink.

  4. Enter the hostname on which the database resides. This defaults to localhost.

  5. Enter the name of the database. This is configured when the database is created. Please consult the database’s administrator for more information.

  6. (Optional) Enter schema name. You can also indicate this when reading or writing from the external connection.

  7. Enter the user name and password required to log onto the database. These are also configured when the database is created. Please consult the database’s administrator for more information.

  8. In the upper right corner, click Execute. You should see Last Run with a blue checkmark.

There is an Additional Options field for advanced users. This option is in place for database options not otherwise available through the StreamLab interface.

Once you set up the external connection, you can use it as an external table for a sink.