Differences

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

--- connectors [2019/10/30 18:36] – dmitry
+++ connectors [2020/11/28 07:28] – [Database connectors] dmitry
@@ Line 1: / Line 1: @@
-===== 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.
@@ Line 16: / Line 16: @@
 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 ===
+=== Server-hosted connector repository ===
-Currently EasyMorph supports these database types:
+A shared repository can be served to Desktop users from EasyMorph Server. This ensures stronger security:
-  * MS SQL Server
+  * The repository files are not exposed to users
-  * MySQL
+  * Connectors can be protected from copying and thus embedding
-  * Oracle Database
+  * 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
-  * PostgreSQL
+  * EasyMorph Server allows locking and encrypting repositories
-  * SQLite
+  * 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.
-  * Amazon Redshift
-  * DB2
-  * Vertica
-  * SAP HANA
-  * Apache Hive
-  * Generic ODBC (custom SQL only)
-=== Email connectors ===
+In order to use a Server-hosted repository, the Server Link must be configured in Desktop. For more details please read the "EasyMorph Server Administrator Guide" which comes with the Server installer.
+==== Database connectors ====
+Currently EasyMorph supports these database types and SQL dialects:
-  * Generic email server (IMAP)
+^ Database type   ^ Driver type ^ Notes ^
-  * Microsoft Exchange
+|SQL Server / Azure SQL Database	   |ODBC / Native  |Bulk export supported (only for the native driver) |
+|Oracle	           |ODBC / Native  | |
+|MySQL	           |ODBC / Native  | |
+|PostgreSQL	   |ODBC / Native  |Bulk export supported (only for the native driver) |
+|SQLite	           |ODBC / Native  | |
+|Amazon Redshift   |ODBC / Native  | |
+|Snowflake         |ODBC / Native  |Bulk export supported (only for the ODBC driver) |
+|DB2               |ODBC only  | |
+|DB2 for iSeries (AS/400) |ODBC only  | |
+|Vertica           |ODBC only  | |
+|SAP HANA          |ODBC only  | |
+|Apache Hive       |ODBC only  |Only import via visual queries, and custom SQL |
+|Google BigQuery   |ODBC only  |Only import via visual queries, and custom SQL |
+|Generic SQL:2003  |ODBC only  |Custom SQL only |
-=== System connectors ===
+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 ====
-  * SSH (used also for SFTP/SCP transfers)
+  * [[connectors:email|Generic email server (IMAP)]]
-  * Web location (used also for REST API)
+  * [[connectors:exchange|Microsoft Exchange]]
+  * [[connectors:awsses|Amazon SES]]
+  * [[connectors:outlook|Outlook.com (Hotmail, Live)]]
-=== Enterprise applications ===
+==== System connectors ====
-  * Microsoft SharePoint
+  * [[connectors:ssh|SSH]] (used also for SFTP/SCP transfers)
-  * Microsoft PowerBI (coming soon)
+  * [[connectors:weblocation|Web location]] (used also for REST API)
-  * Tableau Server
-  * Tableau Online
-  * Qlik Sense
-=== Cloud services/applications ===
+==== Enterprise applications ====
-  * Amazon S3
+  * [[connectors:sharepoint|Microsoft SharePoint]]
-  * Google Drive
+  * [[connectors:powerbi|Microsoft PowerBI]]
-  * Google Sheets
+  * [[connectors:tableau|Tableau Server]]
+  * [[connectors:tableauonline|Tableau Online]]
+  * [[connectors:qlik|Qlik Sense]]
-=== Security considerations ===
+==== Cloud services/applications ====
+  * [[connectors:awss3|Amazon S3]]
+  * [[connectors:googledrive|Google Drive]]
+  * [[connectors:googlesheets|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:
-  * Make sure that the database account used in connector is read-only and doesn't expose unnecessary objects (e.g. schemas, tables, etc.)
+  * Use Server-hosted connector repositories when possible, otherwise limit access to shared repositories using standard Windows file system permissions
-  * 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 is described in the "EasyMorph Server Administrator Guide" that comes with the Server installer
-  * 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't expose unnecessary objects (e.g. schemas, tables, etc.)
-  * Don't use embedded connectors for very sensitive information
+  * Don't use embedded connectors for accessing sensitive information because they can be easily copied unless dynamic authentication is used (such as "Windows integrated")
-  * Keep in mind that users may write custom SQL queries using connectors
+  * Keep in mind that users may write custom SQL queries/statements using connectors