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 [2019/10/30 18:36] – dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database connectors | + | ===== 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 | ||
* MySQL | * MySQL | ||
* Oracle Database | * Oracle Database | ||
- | * Postgres | + | * PostgreSQL |
* SQLite | * SQLite | ||
+ | * Amazon Redshift | ||
+ | * DB2 | ||
+ | * Vertica | ||
+ | * SAP HANA | ||
+ | * Apache Hive | ||
+ | * Generic ODBC (custom SQL only) | ||
- | For these database types EasyMorph already includes necessary client software (drivers) so no any additional client software installation is necessary. | + | === Email connectors === |
- | 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. | + | * Generic email server (IMAP) |
+ | * Microsoft Exchange | ||
- | === Embedded | + | === System |
- | If connectors are embedded into a project then the project can work on different computers using the same connection settings (as long as there is network connectivity for accessing the databases). | + | |
- | === Shared connector repository === | + | * SSH (used also for SFTP/SCP transfers) |
- | Shared connector repositories can be used in cases when many users need to share the same connection settings. Having shared repositories is also convenient | + | * Web location (used also for REST API) |
- | 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, | + | === Enterprise applications === |
- | 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' | + | * Microsoft SharePoint |
+ | * Microsoft PowerBI (coming soon) | ||
+ | * Tableau Server | ||
+ | * Tableau Online | ||
+ | * Qlik Sense | ||
+ | |||
+ | === Cloud services/ | ||
+ | |||
+ | * Amazon S3 | ||
+ | * Google Drive | ||
+ | * Google Sheets | ||
=== Security considerations === | === Security considerations === | ||
Line 30: | 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 [[transformations: | ||
connectors.txt · Last modified: 2024/04/19 00:37 by dmitry