Connect directly to a database
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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.
The adaptor you'll need depends on the type of database you're accessing.
Very different from the other database connections
uses connection string instead of hostname, database, port
Allows specification of "read only" intent.