connectors
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
connectors [2020/08/12 06:22] – [Email connectors] dmitry | connectors [2020/11/28 06:41] – [Connectors] dmitry | ||
---|---|---|---|
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 " | 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 " | ||
- | ==== Database connectors ==== | + | === Server-hosted connector repository |
- | Currently | + | A shared repository can be served to Desktop users from EasyMorph |
- | * 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 | + | In order to use a Server-hosted repository, the Server Link must be configured in Desktop. For more details please read the " |
- | * Vertica | + | ==== Database connectors ==== |
- | * SAP HANA | + | Currently EasyMorph supports these database types and SQL dialects: |
- | * Apache Hive | + | |
- | * Generic ODBC (custom | + | |
+ | ^ Database type ^ Driver type ^ | ||
+ | |Oracle | ||
+ | |SQL Server | ||
+ | |MySQL | ||
+ | |PostgreSQL | ||
+ | |SQLite | ||
+ | |Azure SQL Database|ODBC / Native | ||
+ | |Amazon Redshift | ||
+ | |DB2 |ODBC only | | ||
+ | |DB2 for iSeries (AS/400) |ODBC only | | ||
+ | |Vertica | ||
+ | |SAP HANA |ODBC only | | ||
+ | |Generic SQL:2003 |ODBC only, custom SQL only | | ||
==== Email connectors ==== | ==== Email connectors ==== | ||
* [[connectors: | * [[connectors: | ||
* [[connectors: | * [[connectors: | ||
+ | * [[connectors: | ||
+ | * [[connectors: | ||
==== System connectors ==== | ==== System connectors ==== | ||
- | * SSH (used also for SFTP/SCP transfers) | + | * [[connectors: |
- | * Web location (used also for REST API) | + | * [[connectors: |
==== Enterprise applications ==== | ==== Enterprise applications ==== | ||
- | * Microsoft SharePoint | + | * [[connectors: |
- | * Microsoft PowerBI | + | * [[connectors: |
- | * Tableau Server | + | * [[connectors: |
- | * Tableau Online | + | * [[connectors: |
- | * Qlik Sense | + | * [[connectors: |
==== Cloud services/ | ==== Cloud services/ | ||
- | * Amazon S3 | + | * [[connectors: |
- | * Google Drive | + | * [[connectors: |
- | * Google Sheets | + | * [[connectors: |
==== Security considerations ==== | ==== Security considerations ==== | ||
While EasyMorph encrypts connection passwords stored in projects and repositories, | While EasyMorph encrypts connection passwords stored in projects and repositories, | ||
- | * Make sure that the database account used in connector is read-only and doesn' | + | * Use Server-hosted |
- | * 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 |
- | * 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' |
- | * Don't use embedded connectors for very sensitive information | + | * Don't use embedded connectors for accessing |
- | * Keep in mind that users may write custom SQL queries using connectors | + | * Keep in mind that users may write custom SQL queries/ |
connectors.txt · Last modified: 2024/04/19 00:37 by dmitry