User Tools

Site Tools


connectors

Database connectors

A database connector in EasyMorph holds information about connection settings required to connect to a particular database. Currently EasyMorph supports these database types:

  • MS SQL Server
  • MySQL
  • Oracle Database
  • PostgreSQL
  • SQLite
  • Amazon Redshift
  • DB2
  • Vertica
  • SAP HANA
  • Apache Hive

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.

Embedded connectors

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

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.

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.

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 can write custom SQL queries using connectors

Using connectors

To import data from a database using a connector use the Import from database action.

connectors.txt · Last modified: 2018/05/10 00:42 by dmitry