This is what keeps us busy for the next few months. Subject to change without notice.
|5.1||Data catalog. Action "Import from data catalog". The "Recent data" screen. Prompt for database credentials. Analysis View in Launcher.||Sep'2021|
|5.0||New Connector Manager. Connector and actions for Salesforce. Excel report generator. Using a first column value in action settings. Webhooks and cloud-based Webhook Gateway. Desktop: crosstables. Server: multiple simultaneous run sessions per task. Event journal.||Jul'2021|
|4.7.1||SQL dialect for MS Access. Diagnostic trace log in Desktop. New function: coalesce. New options in actions: Export to Tableau, Project metadata, Iterate/Web request and a few more.|
|4.7||Connector for Google Analytics. SQL dialect for Sybase (SAP) IQ. New actions: Import from Google Analytics, Export to Airtable, Update/delete rows in Airtable, Replace with lookup, Generate documentation. Pipedrive: support for OAuth, importing Leads. Diagnostic trace log in Server. Desktop: Dependencies in the workflow diagram. Favorite/hidden actions. Elapsed execution time for actions/tables.|
|4.6.2||Support for Exasol. Connector and import action for Airtable. New function: mround. Optional argument for functions find, keepbefore, keepafter.|
|4.6.1||Connector for Pipedrive. Connector and SQL dialect for MariaDB. New actions: Import from Pipedrive, Import JSON, Import plain text, Export plain text, Start/finish exclusive access. Profiler metrics in the "Table metadata" action. The ASSUME operator. Desktop: collapsible chart controls.|
|4.6||Connector for GMail (with support for OAuth2). Native connectors for Snowflake and Redshift. Bulk (fast) export to PostgreSQL and Snowflake. Encrypted columns in datasets. Financial functions. Faster loading from text/XML files. Desktop: Associative filtering in the full table view. Full table profiling. External dependencies of module/group/table. Switchable chart category. Server: License administration for Desktop users.|
|4.5.2||Cumulative bugfixes. Query performance optimization.|
|4.5.1||New parameter type: Multiple choice selector. New action: Project Metadata (generates lists of actions, connectors, etc. in EasyMorph projects). Triggering Power BI dataflows.|
|4.5||New parameter types: fixed list of choices, checkbox. New actions: Repeat, Halt on data type mismatch, Bulk export to DB (SQL Server only). Supported dataset size increased to 500M rows. Desktop: simplified Parameter Editor, module overview diagram. Server: running tasks under a different Windows account (Enterprise edition only).|
|4.4.1||Cumulative bugfixes. New functions: isemail, hexencode, hexdecode. New email connectors: Outlook.com, Amazon SES. SQL dialect DB2/AS400. Triggering Tableau Server flows. Query Editor: pre-filter column values in list selector.|
New, extended expression syntax, faster expression evaluation.
New actions: Update database table, Skip actions on condition.
Faster import/export of CSV files.
Support for OAuth in the Web Location connector.
Much faster aggregation, pivoting.
Desktop: in-app license purchase/renewal.
|4.3.1||Cumulative bugfixes. Desktop: connector documentation link in Query Editor, indicators of annotated actions. Server: option for disabling a public list of spaces.|
|4.3||Super-compression of in-memory data (experimental). Tableau Hyper add-on. Support for delegated (shared) inboxes in Exchange. Regex functions. Function eval(). Improved Server Link, support for Server Link in Import/Export dataset actions. Desktop: numerous UI improvements. Server: repository encryption, task timeout.|
|4.2.1||Support for shared workspaces in Power BI. Bugfixes.|
|4.2||Connector for Power BI. New actions: Export to Power BI, Power BI Command, Import from web API, Parse XML. Parameter validation rules. Support for Google BigQuery. Desktop: New parameter editor. Server: automatic log rolling.|
|4.1||New actions: Parse JSON, Construct JSON, Create buckets, Linear regression, Statistical aggregation, Make date/time columns, Iterate columns. Post-filter in queries (SQL HAVING). Server: Custom HTML pages in spaces. Creating/deleting folders. Renaming folders and files.|
|4.0.1||Bugfixes. Web Request and Iterate Web Request now available in the free edition (HTTP GET only). New function: strip().|
Embedded project modules that can be used in iterations instead of projects.
Actions for REST APIs: Web Request, Iterate Web Request.
New actions: Repeat Rows, Enumerage Groups, Distribute total.
New connector: Web location.
Web-functions to work with URLs, XML and JSON.
Aggregations in queries.
Significant performance improvements.
Desktop: Accessing/editing Server space repositories from Desktop. Column lineage. Context bar and instant column profiling. Task tags in Launcher.
Server: Email notifications about failed scheduled tasks. Additional access control settings for spaces and repositories.
|3.9.5||New actions: Import SharePoint List, SharePoint Command. New connector: SharePoint.|
New actions: Google Drive Command, Export to Google Sheets, Remove empty rows.
New file commands: Copy/move list of files, Rename list of files, Delete list of files.
Trigonometric functions: pi, sin, cos, tan, asin, acos, atan, arctan.
Server: Mapping network drives from the Server web-console.
Import from Google Sheets.
Export to XML files.
Connector for Tableau Online.
Desktop: EasyMorph Launcher replaced EasyMorph Scheduler. New example - "2 spreadsheets merged".
Explicit column-to-field mapping for the "Export to database" action.
Uploading/downloading files and folders from/to Amazon S3.
Desktop: Full window table view. Full table search. New workflow for adding data.
Server: Authentication via Active Directory. Option for prompting task parameters on start.
Advanced data types for creating database tables.
Publishing datasets to and receiving from EasyMorph Server.
Auto-documentation for queries.
The "Other SQL" dialect.
Desktop: Server Link. Project thumbnails. Thumbnail editor.
SFTP, SCP file transfers.
Fetching emails with attachements from IMAP and Exchange servers.
Executing remote SSH commands.
Import/export into native EasyMorph data format.
The limit for actions/iterations in the free edition is reduced to 24.
Desktop: New Start Screen.
Server: Monthly schedule.
New action "Create list".
Updated data drivers.
Desktop: Built-in examples.
New actions: Remove empty columns, Sanitize, Total/Subtotal, Keep min/max, Cross Merge.
New functions: monthstart, monthend, weekstart, weekend, yearday, isoweeknumber.
Desktop: Automated data quality suggestions. Quick export to file. Error cards for call/iteration errors.
Any transformation can be inserted at any position.
Email connector for Exchange.
SQL connector for Apache Hive SQL (experimental).
Desktop: Column profiler with various counts and distribution histogram.
Server: HTTPS-only mode.
|3.7.2||New transformations: Qlik Sense Server Command (triggers QMC task reloads), EasyMorph Server Command, Filter by data type. A Qlik Sense extension for reloading EasyMorph Server tasks. See also:|
|3.7.1||New transformations: Tableau Server Command (triggers extract refreshes), Send email, Table metadata. New parameter type: Folder path. Adding new parameters right from transformation properties. See also:|
|1.3||EasyMorph Server: Multiple password-protected spaces for files and tasks. Support for space types: Tasks and files, Tasks only, Files only. Password-protected admin role. See also:|
|3.7||Conditional "if-then-else" workflows. Disabled state for transformations. New transformations: PowerShell Command, Replace, File Command, XSLT. New text editor for expressions and custom SQL queries/commands. Shareable, reusable connectors for Tableau Server. Import of SPSS .sav files. Export to 1010data. Database connectors specified by parameters. Compatibility with EasyMorph Server v1.3. See Release notes v3.7 for more details.|
Bugfix: degraded performance on wide tables (>10'000 columns).
Bugfix: columns with valid names could be automatically renamed in some cases.
Bugfix: Windows 10 Fall Creator's Update (build 1709) made application freeze when showing progress popup.
|3.6.2||Improved error handling for the "Export to database" transformation. Multiple commands in the Run Program transformation. See Release notes v3.6.2 for more details.|
|1.2||EasyMorph Server: Web file manager for downloading/uploading files and publishing projects through a web browser. Open-source EasyMorph Server .NET SDK and a command line API client for the Server. See Release notes v1.2 for more details.|
|3.6.1||Support for quoted line breaks in delimited text files (as per RFC 4180). Publishing projects to EasyMorph Server v1.2. Date literals and comments in expressions. Improved export to Tableau. Append mode for export to text. See Release notes v3.6.1 for more details.|
|1.1||EasyMorph Server: Continuous schedule; file picker and date picker for parameters; search for tasks; support for the Status transformation.|
|3.6||Loading multiple uniform files without using iterations. New transformations: Import fixed width text, Split fixed width text, Split delimited text, Regular expression, Download file, Status, Fill right, Select with lookup, Convert data type. New functions: system(), filename(), combinepath(). Publishing TDEs to Tableau Server. Support for SAP HANA. See Release notes v3.6 for more details.|
|1.0||EasyMorph Server: Web console. Schedules: Once, Hourly, Daily/Weekly. Real-time task logs in the web console. EasyMorph Server Monitor.|
|3.5||Visual WHERE condition builder for database queries. New Filter pop-up (replaces the Unique Values pop-up). New transformations: "Filter by search" (with support for regular expressions), "Delete database rows", "Delete matching database rows", "Select matching database rows". File splitter (partitioner) for large text files. Full outer join in the Merge transformation. Fuzzy matching in Match transformation. Support for DB2 and Vertica. See Release notes v3.5 for more details.|
|3.3||Direct export to databases (via SQL INSERT). New Query Editor tool and standalone database queries. Custom connection properties for database connectors. Black/white-listed database schemas in database connectors. "Interval merge" transformation. Faster QVD reading. Run/Iterate program removed from the free edition. See Release notes v3.3 for more details.|
|3.1||New transformations: Running total, Iterate another table, Rename with lookup, Generate UIDs. Support for data type Date in Export to Tableau. New commands in "SQL command" transformation: Create table, Delete table, Delete rows. New functions: mirror, roundxl, now. Annotations for parameters. Support for Amazon Redshift. See Release notes v3.1 for more details.|
|3.0||Basic PDF reporting. Import from XML files. New transformations: Clean Up, Shift Column, Match, Call and Input. New functions: substringcount, padstart, padend, removetext, removechars, keepchars. See Release notes v3.0 for more details.|