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 [2018/05/09 20:42] – dmitry | connectors [2019/10/30 19:12] – 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 | + | Connectors can be embedded into a project, or can be stored in a shared repository. Connectors can be copied/ |
+ | |||
+ | === Embedded connectors === | ||
+ | Embedded connectors are stored right in 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) then all embedded connectors for this connection should be changed manually. | ||
+ | |||
+ | === Shared | ||
+ | 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 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' | ||
+ | |||
+ | 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 | ||
+ | |||
+ | ==== Database connectors ==== | ||
+ | Currently EasyMorph supports these database types: | ||
* MS SQL Server | * MS SQL Server | ||
Line 13: | Line 29: | ||
* SAP HANA | * SAP HANA | ||
* Apache Hive | * Apache Hive | ||
+ | * Generic ODBC (custom SQL only) | ||
- | Connectors can be embedded into a project, or can be stored in a shared repository which is a file. Connectors can be copied from any location to any location, e.g. from one project to another project, from project to repository, from one repository to another repository, etc. | + | ==== Email connectors ==== |
- | === Embedded connectors === | + | * Generic email server |
- | If connectors are embedded into a project then the project can work on different computers using the same connection settings | + | * Microsoft Exchange |
- | === Shared connector repository | + | ==== System connectors ==== |
- | 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. | + | |
- | 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, | + | * SSH (used also for SFTP/SCP transfers) |
+ | * Web location (used also for REST API) | ||
- | 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' | + | ==== Enterprise applications ==== |
- | === Security considerations === | + | * Microsoft SharePoint |
+ | * Microsoft PowerBI (coming soon) | ||
+ | * Tableau Server | ||
+ | * Tableau Online | ||
+ | * Qlik Sense | ||
+ | |||
+ | ==== Cloud services/ | ||
+ | |||
+ | * Amazon S3 | ||
+ | * Google Drive | ||
+ | * Google Sheets | ||
+ | |||
+ | ==== Security considerations | ||
While EasyMorph encrypts connection passwords stored in projects and repositories, | While EasyMorph encrypts connection passwords stored in projects and repositories, | ||
Line 33: | Line 62: | ||
* When using embedded connectors make sure there is full control over distribution of a project with embedded connectors | * 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 | * Don't use embedded connectors for very sensitive information | ||
- | * Keep in mind that users can write custom SQL queries using connectors | + | * Keep in mind that users may write custom SQL queries using connectors |
- | === Using connectors === | ||
- | To import data from a database using a connector use the [[transformations: | ||
connectors.txt · Last modified: 2024/02/15 15:01 by dmitry