All integrations in EasyMorph

Contents:


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
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
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
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
Vertica ODBC only
Apache Hive ODBC only Only import and custom SQL.
Google BigQuery ODBC only Only import and custom SQL.
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 10-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
  • 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:
  • Basic
  • OAuth2
  • API key
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)
IMAP / SMTP Fetch emails with attachments
Send emails with attachments
  • Plain text body
  • HTML body
FTP(S) Download file
SFTP / 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
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
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

Google


APPLICATION
CAPABILITIES
Gmail Fetch emails with attachments
Send emails with attachments
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
Google Analytics Import metrics
Google BigQuery See "Databases" above
Google Cloud SQL See "Databases" above

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
EasyMorph Server Trigger task
List files in a folder
Upload file or list of files
Download file or list of files
Delete file or list of files
Pipedrive Import deals
Import leads
Import organizations
Import persons
Qlik Sense Import QVD file
Export QVD file
Trigger QMC task

The joy of automation. Experience it today.

Free download   Book a demo