Datasource¶
Create Datasource with path to a data source.
A datasource represents a way of obtaining data and supports three different formats: File (local file), Database (configurable to use ODBC or sqlalchemy) and URL (for example, http request).
| Ref. nodes: | File Datasources |
|---|
- Output ports:
port1: datasource
Datasource with path to file
- Configuration:
- Filename (filename)
- A filename including path if needed
- SQLAlchemy engine URL (db_sqlalchemy_engine_url)
- SQLAlchemy engine URL for connecting to the database
- Database connection method (db_method)
- Select which Database connection method that you want to use.
- Database driver (db_driver)
- Database driver to use.
- Server name (db_servername)
- A valid name to a database server.
- Database name (db_databasename)
- The name of the database.
- User (db_user)
- A valid database user.
- Password (db_password)
- A valid password for the selected user.
- Connection string (db_connection_string)
- A connection string that will override other settings.
- URL string (url_str)
- Uniform Resource Locator (URL) string
- Url environment (url_env)
- Environment for URL. Used as headers in case of HTTP URL. Input as a Python expression that evaluates to.
- Datasource type (datasource_type)
- Type of datasource.
In Sympathy for Data, the action of pointing out where data is located and actual import of data are separated into two different categories of nodes. The internal data type Datasource is used to carry the information about the location of the data to the import nodes.
There exist two nodes for establishing paths to locations with data, either you are interested in a single source of data, Datasource, or several sources, File Datasources. The single source can either be a data file or a location in a data base. While for multiple sources only several data files are handled.
