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:
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.
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.