All integrations in EasyMorph

Contents:

Files

Supported file formats and typical file extensions.

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

All file import actions support importing and appending multiple uniform files at once.

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.

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)

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.

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

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
SQL Server / Azure SQL Database	See "Databases" above
Access	See "Databases" above

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

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

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