connectors
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
connectors [2016/05/24 00:16] – dmitry | connectors [2021/10/26 15:08] – [Cloud services/applications] dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database connectors | + | ====== |
+ | A connector in EasyMorph holds information about connection settings required to connect to an external system, such as a database, cloud service, email, enterprise application, | ||
- | A database connector | + | Connectors can be embedded into a project or can be stored |
- | * MS SQL Server | + | === Embedded connectors === |
- | * MySQL | + | Embedded connectors are stored right in the project. It allows using projects on different computers using the same connection settings without relying on a shared repository. However, if connection settings change (e.g. credentials changed), all embedded connectors should be changed manually. |
- | * Oracle Database | + | |
- | * Postgres | + | |
- | * SQLite | + | |
- | For these database types EasyMorph already includes necessary client software (drivers) so no any additional client software installation is necessary. | + | === Shared connector repository === |
+ | Shared connector repositories can be used in cases when many users need to use the same connection settings in a controllable, | ||
- | Connectors | + | An empty shared repository is created automatically by EasyMorph upon the first run. It can also be created manually from Connector Manager invoked by menu Project -> Manage connectors, or by pressing F7. It is possible to have several repositories, |
- | === Embedded connectors === | + | To reduce |
- | If connectors are embedded into a project then the project | + | |
- | === Shared | + | Having shared repositories is also convenient for migrating projects from dev to test/prod environments as shared connectors are referenced by name. I.e. a project can query a database that is specified by connector " |
- | Shared connector repositories | + | |
+ | === Server-hosted | ||
+ | A shared repository | ||
+ | |||
+ | * The repository files are not exposed | ||
+ | * Connectors can be protected from copying and thus embedding | ||
+ | * If a repository is provided from a Server space with the Active Directory authentication mode, then only the users that are whitelisted in the space settings | ||
+ | * EasyMorph Server allows locking and encrypting | ||
+ | * User tasks (projects) on EasyMorph Server can be forced | ||
+ | |||
+ | To use a Server-hosted repository, the Server Link must be configured in the Desktop. Please read the " | ||
+ | ==== Database connectors ==== | ||
+ | Currently, EasyMorph supports these database types and SQL dialects: | ||
+ | |||
+ | ^ Database type ^ Driver type ^ Notes ^ | ||
+ | |SQL Server | ||
+ | |Oracle | ||
+ | |MySQL | ||
+ | |PostgreSQL | ||
+ | |MariaDB | ||
+ | |SQLite | ||
+ | |Amazon Redshift | ||
+ | |Snowflake | ||
+ | |Amazon Athena | ||
+ | |DB2 |ODBC only | | | ||
+ | |DB2 for iSeries (AS/400) |ODBC only | | | ||
+ | |Exasol | ||
+ | |Vertica | ||
+ | |SAP HANA |ODBC only | | | ||
+ | |Apache Hive |ODBC only |Only import via visual queries and custom SQL | | ||
+ | |Google BigQuery | ||
+ | |Generic SQL: | ||
+ | |||
+ | Database ODBC connections are configured in EasyMorph by creating an ODBC connector, selecting a 64-bit ODBC DSN configured in Windows, and specifying the required SQL dialect (if it wasn't auto-detected) in the connector settings. | ||
+ | ==== Email connectors ==== | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | |||
+ | ==== System connectors ==== | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | |||
+ | ==== Enterprise applications ==== | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | |||
+ | ==== Cloud services/ | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
- | An empty shared repository is created automatically by EasyMorph upon first run. It can also be created manually from Connector Manager invoked by menu Project -> Manage connectors, or by pressing F7. It is possible to have several repositories, | ||
- | To reduce a chance of human error, a shared repository | + | ==== Security considerations ==== |
+ | While EasyMorph encrypts connection passwords stored in projects and repositories, this can' | ||
- | === Security considerations === | + | * Use Server-hosted connector repositories when possible; otherwise limit access to shared repositories using standard Windows file system permissions |
- | While EasyMorph encrypts connection passwords stored in projects and repositories, | + | * For Server |
+ | * In connectors, use read-only accounts and don' | ||
+ | * Don't use embedded connectors | ||
+ | * Keep in mind that users may write custom SQL queries/ | ||
- | * Make sure that the database account used in connector is read-only and doesn' | ||
- | * Limit access to shared repositories using standard Windows file system permissions | ||
- | * When using embedded connectors make sure there is full control over distribution of a project with embedded connectors | ||
- | * Don't use embedded connectors for very sensitive information | ||
- | * Keep in mind that users can write custom SQL queries using connectors | ||
- | === Using connectors === | ||
- | To import data from a database using a connector use [[transformations: | ||
connectors.txt · Last modified: 2024/04/19 00:37 by dmitry