User Tools

Site Tools


connectors

This is an old revision of the document!


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.

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
  • MySQL
  • Oracle Database
  • PostgreSQL
  • SQLite
  • Amazon Redshift
  • DB2
  • Vertica
  • SAP HANA
  • Apache Hive
  • Generic ODBC (custom SQL only)

Email connectors

  • Generic email server (IMAP)
  • Microsoft Exchange

System connectors

  • SSH (used also for SFTP/SCP transfers)
  • Web location (used also for REST API)

Enterprise applications

  • 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:

  • Make sure that the database account used in connector is read-only and doesn't expose unnecessary objects (e.g. schemas, tables, etc.)
  • Limit access to shared repositories using standard Windows file system permissions
  • 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
  • Keep in mind that users may write custom SQL queries using connectors
connectors.1572474987.txt.gz · Last modified: 2019/10/30 22:36 by dmitry