User Tools

Site Tools


connectors

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revisionBoth sides next revision
connectors [2015/10/19 11:50] – created dmitryconnectors [2018/05/09 20:42] dmitry
Line 6: Line 6:
   * MySQL   * MySQL
   * Oracle Database   * Oracle Database
 +  * PostgreSQL
   * SQLite   * SQLite
- +  * Amazon Redshift  
-For these database types EasyMorph already includes necessary client software (drivers) so no any additional client software installation is necessary.+  * 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. 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.
Line 23: Line 27:
  
 === Security considerations === === Security considerations ===
-While EasyMorph encrypts connection passwords stored in projects and in repositoryit can't be considered a strong security measure. Therefore for addition protection consider the following:+While EasyMorph encrypts connection passwords stored in projects and repositoriesthis 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.)   * Make sure that the database account used in connector is read-only and doesn't expose unnecessary objects (e.g. schemas, tables, etc.)
Line 32: Line 36:
  
 === Using connectors === === Using connectors ===
-To import data from a database using a connector use [[transformations:importsql|Import from database]] transformation.+To import data from a database using a connector use the [[transformations:importsql|Import from database]] action.
  
connectors.txt · Last modified: 2024/04/19 00:37 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki