All integrations 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. |
| Oracle | ODBC / Native | Bulk export supported. |
| PostgreSQL | ODBC / Native | Bulk export supported. |
| MySQL | ODBC / Native | |
| MariaDB | ODBC / Native | |
| Amazon Redshift | ODBC / Native | |
| Snowflake | ODBC / Native | Bulk export supported. |
| SQLite | ODBC / Native | |
| Google BigQuery | ODBC only | Bulk export supported. |
| Microsoft 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 | Only import and custom SQL. |
| Denodo | ODBC only | Only import and custom SQL. |
| Databricks | ODBC only | |
| Generic SQL:2003 | ODBC only | |
| Generic ODBC | ODBC only | The "Other SQL" 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: - OAuth2 - API key - HTTP Basic - HTTP Digest |
Send a configured request - HTTP method (any) - URL parameters - Headers - Body (can be a file) Receive response - Status - Headers - Body (can be saved to a file) Receive webhooks (from cloud apps) Custom API server |
| IMAP / SMTP | Fetch emails with attachments Send emails with attachments - Plain text body - HTML body 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 - Arguments as parameters - Capture return value(s) 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 |
Amazon AWS
| APPLICATION | CAPABILITIES |
|---|---|
| Amazon S3 | 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 metrics |
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 |
Other vendors
| APPLICATION | CAPABILITIES |
|---|---|
| Airtable | Import rows from table Insert rows into table Update rows in table Delete rows in table |
| 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 |