Connect directly to a database

Instead of downloading data from a database into a file, and then importing that file into Data-flo, you may want to directly query the database using Data-flo.

There are multiple database adaptors, each for different kinds of databases, and more database connections may be added in the future.

Credentials

Connecting to a database from Data-flo requires knowing connection details like the database hostname, connection port, database username & password, etc. as well as having a query to pass to the database. Each type/adaptor is slightly different.

If you connect directly to the database already (e.g. via software like SQL Navigator, SQL Developer, Toad, HeidiSQL, etc), you probably know the necessary credentials already. If not, you may need your Data team or IT department to get you the information.

Which adaptor to use

The adaptor you'll need depends on the type of database you're accessing.

Adaptor	Database type	Notes
sqlite-database	SQLite	Very different from the other database connections
mysql-database	MySQL
oracle-database	Oracle	uses connection string instead of hostname, database, port
postgres-database	PostgreSQL
sql-server-database	MS SQL Server	Allows specification of "read only" intent.