.. _`Datasource`:

.. _`org.sysess.sympathy.datasources.filedatasource`:

Datasource
~~~~~~~~~~

.. image:: datasource.svg
   :width: 48


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: :ref:`org.sysess.sympathy.datasources.filedatasourcemultiple`

*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.

.. automodule:: node_file_datasource

.. class:: FileDatasource


Example flows
#############

* :download:`InputOutputGenerate.syx </_examples/Sympathy/InputOutputGenerate/InputOutputGenerate.syx>`