Domino is an open platform, and capable of connecting to many data sources. In addition to manually uploading data to Domino’s native file store through the application or CLI, many users choose to connect directly to data sources from their Python and R code.
Domino offers the following methods to connect to external data services:
- Domino data sources
-
A structured mechanism to create and manage connection properties. Available for select set of supported external data services
- Instrumented Domino Compute Environment
-
A combination of properly configured data service specific driver and Python or R package. Available for any data service where a compatible library is available.
When configuring a connection to a data service, regardless of the method used, consider the following:
-
Network connectivity
To access a data source from Domino, there must be network connectivity from Domino to the source. This can be a LAN connection, or connection over the Internet. This applies for both types of connectivity.
-
Package or driver
You must have the appropriate package or driver installed in yourenvironment. There is a large collection of publicly available resources specific to almost any data source, and Domino has authored some guides to common examples.
Domino data sources remove the complexity associated with managing drivers and packages.
When not using Domino data sources, you need to have the appropriate package or driver installed in yourenvironment. There is a large collection of publicly available resources specific to almost any data source, and Domino has authored some guides to common examples that you can see below.
-
Credentials
To authenticate to your data source, you will need to store your credentials for the Data source in Domino. Instead of adding them as plain text in your code, we recommend users use environment variables to securely store any usernames or passwords. When connecting to a data source using Kerberos, users can store their keytab securely by adding it to User Settings > Kerberos Integration.
Domino Data Sources allow user to store credentials in a structured and secure manner.
When not using Domino Data Sources, you will need to manage credentials for authenticating with the external data service yourself. Instead of adding them as plain text in your code, it is recommended that users use environment variables to securely store usernames, passwords, or keys. When connecting to a data source using Kerberos, users can store their keytab securely by adding it to User Settings > Kerberos Integration.
The following table summarizes the options available for connection to popular external systems.
Data Service | Domino Data Source | Driver + Package | Instructions |
---|---|---|---|
AWS S3 | |||
Azure Data Lake Storage | |||
DataRobot | |||
Generic S3 (MinIO) | |||
Google BigQuery | |||
Google Cloud Service | |||
IBM Db2 | |||
IBM Netezza | |||
Impala | |||
Microsoft SQL Server (MSSQL) | |||
MySQL | |||
Oracle Database | |||
PostgresSQL | |||
Redshift | |||
Snowflake | |||
Teradata |