Skip to content

Database connectors

Deployments can also be used to connect to external data sources. We provide template deployment packages written in Python for connecting to databases, cloud services and other software systems. These templates can be used without modifications, but can also be customized for more advances use cases. All connector templates are published on our Github.

Deploying connector templates

You can get started with connectors immediately by downloading one of the template deployment packages, and uploading it to UbiOps as you would do with any normal deployment. Create a deployment and first version for the connector and upload the ZIP as the code of the deployment.

The settings of the connector can be configured through environment variables. The list of environment variables that need to be configured is included in the README of each connector template. For security reasons, we advise you to configure environment variables containing passwords and other secrets as secret variables, to make them unreadable.

You can verify that your connector is working by making a direct manual request to the connector deployment, before including it in a pipeline.

Make sure to whitelist UbiOps in your firewall

Outbound connections from UbiOps will be made through a proxy with the following IPv4 address: 34.90.157.84. Make sure your firewall whitelists this IP address if necessary.

Customized or new connectors

For advanced use cases you can customize the template connectors. This can for example be useful if you want to do data processing before pushing your data to an external system, or if you want to include logic to update existing data instead of only inserting.

In addition to the existing template connectors, we published a basic structure that is used as the base for all connectors. Using this blueprint you can implement your own connector for a storage system that is not yet available as a template. UbiOps is frequently implementing new connectors as well, so the library of available connectors will expand in the future.

Available connector templates

The following connector templates are currently available on the UbiOps Github. The connectors are divided into output connectors, that can be used to push data from UbiOps into a database or other storage system, and input connectors, that can be used to retrieve data.

Each of the connectors contains a README with usage instructions.

Output connectors

Connector Deployment package Link
Amazon Web Services Kinesis ZIP Github
Amazon Web Services S3 ZIP Github
Azure Blob Storage ZIP Github
Google Cloud Platform BigQuery ZIP Github
Google Cloud Platform Cloud Storage ZIP Github
InfluxDB ZIP Github
Microsoft SQL server ZIP Github
MySQL ZIP Github
PostgreSQL ZIP Github

Input connectors

Connector Deployment package Link
RabbitMQ ZIP Github
Snowflake ZIP Github