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 [2020/11/28 07:28] – [Database connectors] 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 in EasyMorph holds information about connection settings required to connect to a particular database. Currently EasyMorph supports these database types: | + | Connectors can be embedded into a project, or can be stored in a shared repository. Connectors can be copied/ |
- | + | ||
- | * MS SQL Server | + | |
- | * MySQL | + | |
- | * Oracle Database | + | |
- | * Postgres | + | |
- | * SQLite | + | |
- | + | ||
- | For these database types EasyMorph already includes necessary client software (drivers) so no any additional client software installation is necessary. | + | |
- | + | ||
- | Connectors can be embedded into a project, or can be stored in a shared repository | + | |
=== Embedded connectors === | === Embedded connectors === | ||
- | If connectors are embedded into a project | + | Embedded |
=== Shared connector repository === | === Shared connector repository === | ||
- | Shared connector repositories can be used in cases when many users need to share the same connection settings. Having shared repositories is also convenient for migrating projects from dev to test/prod environments. | + | Shared connector repositories can be used in cases when many users need to use the same connection settings |
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, | 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, | ||
Line 23: | Line 14: | ||
To reduce a chance of human error, a shared repository can be protected with a password requested for adding new or modifying existing connectors. Using a connector for importing data doesn' | To reduce a chance of human error, a shared repository can be protected with a password requested for adding new or modifying existing connectors. Using a connector for importing data doesn' | ||
- | === Security considerations === | + | 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 " |
+ | |||
+ | === Server-hosted connector repository === | ||
+ | A shared repository can be served to Desktop users from EasyMorph Server. This ensures stronger security: | ||
+ | |||
+ | * The repository files are not exposed to users | ||
+ | * 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 can access and use the repository | ||
+ | * EasyMorph Server allows locking and encrypting repositories | ||
+ | * User tasks (projects) on EasyMorph Server can be forced to run under Windows accounts that don't have access to the system folder that holds repositories. | ||
+ | |||
+ | In order to use a Server-hosted repository, the Server Link must be configured in Desktop. For more details please read the " | ||
+ | ==== Database connectors ==== | ||
+ | Currently EasyMorph supports these database types and SQL dialects: | ||
+ | |||
+ | ^ Database type ^ Driver type ^ Notes ^ | ||
+ | |SQL Server / Azure SQL Database | ||
+ | |Oracle | ||
+ | |MySQL | ||
+ | |PostgreSQL | ||
+ | |SQLite | ||
+ | |Amazon Redshift | ||
+ | |Snowflake | ||
+ | |DB2 |ODBC only | | | ||
+ | |DB2 for iSeries (AS/400) |ODBC only | | | ||
+ | |Vertica | ||
+ | |SAP HANA |ODBC only | | | ||
+ | |Apache Hive |ODBC only |Only import via visual queries, and custom SQL | | ||
+ | |Google BigQuery | ||
+ | |Generic SQL: | ||
+ | |||
+ | Database ODBC connection are configured in EasyMorph by creating an ODBC connector, selecting a 64-bit ODBC DSN configured in Windows, and then specifying the required SQL dialect (if it wasn't auto-detected) in the connector settings. | ||
+ | ==== Email connectors ==== | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | |||
+ | ==== System connectors ==== | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | |||
+ | ==== Enterprise applications ==== | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | |||
+ | ==== Cloud services/ | ||
+ | |||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
+ | |||
+ | ==== Security considerations | ||
While EasyMorph encrypts connection passwords stored in projects and repositories, | While EasyMorph encrypts connection passwords stored in projects and repositories, | ||
- | * Make sure that the database account used in connector is read-only and doesn' | + | * Use Server-hosted |
- | * Limit access to shared repositories using standard Windows file system permissions | + | * For Server repositories consider using the option for locking and encrypting repository; the option |
- | * When using embedded connectors make sure there is full control over distribution of a project with embedded connectors | + | * In connectors, use accounts that are read-only and doesn' |
- | * Don't use embedded connectors for very sensitive information | + | * Don't use embedded connectors for accessing |
- | * Keep in mind that users can write custom SQL queries using connectors | + | * Keep in mind that users may write custom SQL queries/ |
- | === Using connectors === | ||
- | To import data from a database using a connector use [[transformations: | ||
connectors.txt · Last modified: 2024/04/19 00:37 by dmitry