All integrations in EasyMorph
See also: All actions in EasyMorph.
Files
Supported file formats and typical file extensions.
Import
| Description | File extensions |
|---|---|
| Delimited text file (e.g. CSV) | .csv, .psv, .tsv, .txt or other |
| Text with fixed width columns | .txt or other |
| Plain text | .txt or other |
| Excel spreadsheets | .xls, .xlsx, .xlsm |
| XML files | .xml |
| JSON files | .json |
| Apache Parquet files | .parquet |
| Qlik QVD files | .qvd |
| SAS data files | .sas7bdat |
| SPSS/PSPP data files | .sav |
| EasyMorph datasets | .dset |
Export
| Description | File extensions |
|---|---|
| Delimited text file (e.g. CSV) | .csv, .psv, .tsv, .txt or other |
| Plain text | .txt or other |
| Excel spreadsheets | .xlsx |
| XML files | .xml |
| Tableau extracts | .tde, .hyper |
| Qlik QVD files | .qvd |
| EasyMorph datasets | .dset |
Remarks
All file import actions support importing and appending multiple uniform files at once.
Databases
Supported SQL-compatible relational databases and operations with them.
| Database system | Driver type | Notes |
|---|---|---|
| SQL Server / Azure SQL Database | ODBC / Native | Bulk export supported (only for the native driver). |
| Oracle | ODBC / Native | Bulk export supported. |
| MySQL | ODBC / Native | Bulk export supported. |
| PostgreSQL | ODBC / Native | Bulk export supported (only for the native driver). Tested with versions 10,12, and 15. |
| MariaDB | ODBC / Native | |
| SQLite | ODBC / Native | |
| Amazon Redshift | ODBC / Native | |
| Snowflake | ODBC / Native | Bulk export supported (only for the ODBC driver). |
| Teradata | ODBC / Native | |
| DuckDB | ODBC / Native | |
| Google BigQuery | ODBC only | Bulk export is supported. |
| MS Access | ODBC only | |
| Amazon Athena | ODBC only | |
| DB2 | ODBC only | |
| DB2 for iSeries (AS/400) | ODBC only | |
| Exasol | ODBC only | |
| SAP HANA | ODBC only | |
| Sybase IQ | ODBC only | |
| Vertica | ODBC only | |
| Apache Hive | ODBC only | Import via visual queries only, custom SQL statements. |
| Denodo | ODBC only | Import via visual queries only, custom SQL statements. |
| Databricks | ODBC only | |
| Generic SQL:2003 | ODBC only | Custom SQL only |
| Other SQL | ODBC only | A generic connector for any ODBC driver. Custom SQL only. |
Supported operations with databases
- Import data using a visual query builder (no knowledge of SQL required)
- Import rows with IDs in a list in EasyMorph
- Export (via SQL Insert by batches of 1-10000 rows)
- Bulk export (selected database types, see notes in the table above)
- Update table rows
- Delete table rows (using a visual filtering condition)
- Delete table rows with IDs in a list in EasyMorph
- Create table
- Delete table
- Delete all rows in table
- List all tables
- List all fields in table
- Custom SQL statements that return data (including calling stored functions)
- Custom SQL statements that don't return data (including calling stored procedures)
Remarks
- The native drivers are built into EasyMorph and don't require installing anything else.
- All database connectors support adding arbitrary connection settings.
- The visual queries and customer SQL statements can be parameterized using EasyMorph parameters.
Standard protocols
| Protocol | Capabilities |
|---|---|
| HTTP(S) Supported authentication:
| Send a configured request
Receive response
Receive webhooks (from cloud apps) Custom API server |
| OData Supported authentication:
| Import table (entity) |
| IMAP / SMTP | Fetch emails with attachments Send emails with attachments
Move email to folder Mark read/unread Delete email |
| FTP(S) | Download file |
| SFTP | Download file(s) Upload file(s) Delete file(s) List file(s) |
| SCP | Download file(s) Upload file(s) |
| SSH | Execute any command remotely Capture text output |
Cloud / enterprise applications
Microsoft
| Application | Capabilities |
|---|---|
| Excel | Import sheet/range Export into sheet (existing or new) Replace sheet Run VBA macro
Recalculate workbook List sheets/ranges Rename sheet Delete sheet |
| Power BI | Export into a push-dataset Trigger refresh of a regular dataset Export into streaming dataset Trigger flow |
| SharePoint / SharePoint Online | Import list Export list Delete rows in list Update rows in list List files in a folder Upload a file or a list of files Download a file or a list of files Delete a file or a list of files |
| Exchange / Exchange Online | Fetch emails with attachments Send emails with attachments Move email to folder Mark read/unread Delete email |
| OneDrive | List files in a folder Upload a file or a list of files Download a file or a list of files Delete a file or a list of files |
| Teams | Send message to channel |
| Dataverse | Import entity List entities List entity attributes |
| SQL Server / Azure SQL Database | See "Databases" above |
| Access | See "Databases" above |
| Outlook.com (Hotmail, Live) | Fetch emails with attachments Send emails with attachments Move email to folder Mark read/unread Delete email |
| Azure Blob Storage | List files in a folder Upload a file or a list of files Download a file or a list of files Delete a file or a list of files List folders in a folder Create folder Rename folder Delete folder |
Amazon AWS
| Application | Capabilities |
|---|---|
| Amazon S3 / S3-compatible | List files in a folder List folders in a folder Upload file or folder with files Download file or folder with files Delete file or folder with files |
| Amazon SES | Send emails with attachments |
| Amazon Redshift | See "Databases" above |
| Amazon Athena | See "Databases" above |
| Application | Capabilities |
|---|---|
| Gmail | Fetch emails with attachments Send emails with attachments Move email to folder Mark read/unread Delete email |
| Google Sheets | Import sheet Export sheets |
| Google Drive | List files in a folder Upload a file or a list of files Download a file or a list of files Delete a file or a list of files List folders in a folder Create folder Rename folder Delete folder |
| Google Analytics | Import metrics (classic, v4) |
| Google BigQuery | See "Databases" above |
| Google Cloud SQL | See "Databases" above |
| Google Search Console | Import data |
Salesforce
| Application | Capabilities |
|---|---|
| Salesforce | Import records from object Insert records in object Update records in object Delete records in object |
| Tableau Server/Online | Export dataset (.hyper, .tde) Publish dataset Trigger extract refresh Trigger flow |
| Slack | Send message to channel |
Other vendors
| Application | Capabilities |
|---|---|
| Airtable | Import rows from table Insert rows into table Update rows in table Delete rows in table |
| Airtable | Import records Insert records Update records Delete records |
| Pipedrive | Import deals Import leads Import organizations Import persons |
| Pushover | Send message |
| Qlik Sense | Import QVD file Export QVD file Trigger QMC task |
| Qlik Cloud | List applications Reload application List files Export QVD file Upload file Delete file |
| ChatGPT / OpenAI-compatible | Ask AI |
| Jira | Import issues Raise issue Change issue status Delete issue |
| Zendesk | Import tickets Create ticket Update ticket Delete ticket |
| Ntfy | Send message to channel |
| Dropbox | List files in a folder Upload a file or a list of files Download a file or a list of files Delete a file or a list of files List folders in a folder Create folder Rename folder Delete folder |