User Tools

Site Tools


connectors

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
connectors [2018/05/10 00:42]
dmitry
connectors [2019/10/30 23:12] (current)
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,​ or REST API.
  
-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/​pasted 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. 
 + 
 +=== 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 ​connector ​repository === 
 +Shared connector repositories can be used in cases when many users need to use the same connection settings ​in a controllable,​ centralized fashion. 
 + 
 +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,​ but only one repository can be active in EasyMorph. Switching ​to another repository can be done through Connector Manager. Shared connectors are referenced in projects by name. Therefore, if you switch between two repositories (e.g. one for development and one for production),​ make sure that connector name is the same in both repositories. 
 + 
 +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'​t require a password. Passwords can be set up and changed in Connector Manager. 
 + 
 +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 "​Customers"​. In a test environment a connector named "​Customers"​ can point to a test database, while in a production environment a connector named also "​Customers"​ point to a production database. When moved from one environment to another, the project will use necessary connector automatically. 
 + 
 +==== 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 ​(IMAP) 
-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).+  * 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,​ but only one repository can be active in EasyMorph. Switching to another repository can be done through Connector Manager. Shared connectors are referenced in projects by name. Therefore, if you switch between two repositories ​(e.g. one for development and one for production), make sure that connector name is the same in both 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'​t require a password. Passwords can be set up and changed in Connector Manager.+==== Enterprise applications ====
  
-=== Security considerations ===+  * Microsoft SharePoint 
 +  * Microsoft PowerBI (coming soon) 
 +  * Tableau Server 
 +  * Tableau Online 
 +  * Qlik Sense 
 + 
 +==== Cloud services/​applications ==== 
 + 
 +  * Amazon S3 
 +  * Google Drive 
 +  * Google Sheets 
 + 
 +==== Security considerations ​====
 While EasyMorph encrypts connection passwords stored in projects and repositories,​ this can't be considered a strong security measure. Therefore for addition security consider the following: While EasyMorph encrypts connection passwords stored in projects and repositories,​ this can't be considered a strong security measure. Therefore for addition security consider the following:
  
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:​importsql|Import from database]] action. 
  
connectors.1525912947.txt.gz · Last modified: 2018/05/10 00:42 by dmitry