December 8, 2019 - Patch
Bug Fixes
- Added phone numbers as return attributes for Cognism data services
- Fixed issue where some trigger configurations are not generating alerts
- Fixed issue where SFDC exports with large attribute values could result in HTTP requests above the request limit
- Fixed issue where GDPR Data Deletion can sometimes fail if there are too many emails to delete in a request
December 2, 2019 - Patch
This patch has been rolled out without UI or processing impacts.
Bug Fixes
- Fixed issue the import / export module is not freeing up workers resulting in stuck imports and exports
December 1, 2019 - Patch
Bug Fixes
- Fixed issue where the "Reset bot" option is sometimes shown for long running bots that are not in the stuck state
- Fixed issue where invalidated credentials that cannot be reused show no error messages in the UI
- Fixed issue where Concatenate task adds a space to the end of the concatenated value
- Fixed issue where Microsoft Dynamics On-Prem data source is not authenticating correctly
- Fixed issue where Extract Domain task sometimes result in the incorrect domain if the suffix is uncommon
- Fixed issue where Fill Empty Attribute task does not have an "Add attribute" option
November 19, 2019 - Patch
Bug Fixes
- Fixed issue where Infer task is failing if numbers or booleans are used in the match criteria when using the round robin assignment or priority assignment outputs
- Fixed issue where "is not same as" in filter operations is not working properly when not using case sensitive matching
November 18, 2019 - Patch
Bug Fixes
- Fixed issue where Assign value to range task encounters error when the value passed in is a string representing a very large number such as "9223372036854775807"
- Fixed issue where Upload file task is constantly indicating a FTP data target is off-line even though it is not
- Fixed issue where Infer task is failing if numbers or booleans are used in the match criteria
- Fixed issue where Extract domain task runs into errors if the URL to extract from is too malformed such as
November 17, 2019 - Openprise 2019 Winter Release
New Features and Enhancements
- UI Enhancements
- Major revamp of the Task configuration UI. Please see additional details in our announcement page
- UI modernization efforts will continue in subsequent releases
- Enhanced support for Dynamics
- Support for List, List Member, Campaign and Opportunities object
- Support for merging Leads object (Contacts and Accounts will be supported in a subsequent patch release)
- Support for on-premise Dynamics 365 environments using ADFS Oauth authentication
- Enhanced support for Eloqua
- Support for Segment Members, List Members and Filter Members
- Support for nested email attributes such as subscribed and bounced attributes
- Enhanced support for CSV based data sources
- Attributes that are not configured for import can still be carried through jobs and used in Upload file task, Create Manual Data Source task, and download functionality
- SAML based SSO integration
- This includes Okta, OneLogin and other SAML providers
- A system administrator only backup login URL is available in case of SAML configuration changes
- Data Marketplace enhancements
- Selectabase support - Selectabase provides the definitive UK do-not-call-list
- ZoomInfo enhancement - Support for Match API in addition to Search API
- Data source and data target enhancement
- Ability to stop data source import
- Invalidated credentials are now shown in the data source details in red with an option to reuse the credential
- Marketo People data source type can now import more than 200 attributes
- API Factory now supports enabling Bot APIs in addition to Job APIs
- Virtual Data Integrator chrome extension enhancements
- Support for Analytics Reports
- Miscellaneous
- New "Generate Hash" task to hash values using MD5 and various SHA algorithms to support hashing PII data and allows hashed value matching use cases
- Infer task now supports the "Excludes" operator for matching criteria
- Infer task now supports case sensitive matching for each matching criteria in the advanced configuration section
- Remove junk task now supports "whole word" matching as well as case sensitive matching
- De-duplicate and merge task now supports drag and drop of surviving record criteria
- Job and bot run reports now include the job and bot IDs which increases efficiency when working with Openprise Support for diagnostic purposes
November 3, 2019 - Patch
Enhancements
- Enhanced support for Marketo Custom Objects for import
- To import Marketo Custom Objects, you are required to specify a Marketo static list. This is due to the fact that the custom object's query API is limited in its filtering methods and we have determined that using a static list is the most flexible in terms of usage.
- Given a static list, Openprise will import all the custom objects for each one of the Marketo people in the list.
- If you want to pull every single custom object record for a given custom object, simply create a static list that has all Marketo lead records in it.
- Enhanced support for Marketo Custom Objects for export to create new custom object records or to update existing custom object records
- Note that creating a new custom object record requires no mapping for Marketo GUID attribute and value for any dedupe fields specified for the custom object to be unique.
October 20, 2019 – Patch
Bug Fixes
- Fixed issue where export to Dynamics is not capturing the returned error messages
- Fixed issue where subsequent updates to a manual data source is not being considered
- Fixed issue where Pardot List Membership is timing out on Pardot side due to too many records within the requested timeframe
- Fixed issue where data target attributes that are no longer available are shown as blank attributes
- Fixed issue where Eloqua exports are not honoring the non-blankable attributes configuration in some cases
September 15, 2019 – Patch
Bug Fixes
- Fixed an issue where API Factory jobs with round-robin (counter-based) infer value tasks fails
July 21, 2019 – Patch
Bug Fixes and Enhancements
- Enhanced SynthIO data services to allow using SynthIO’s Append API
- Enhanced API Factory’s concurrency capabilities
- Fixed issue where Change Attribute type converts real numbers into text with scientific notation
- Fixed issue where boolean attributes created within Openprise and used in Export may be sending the incorrect raw value to target system like Marketo. Note that any boolean attribute brought into Openprise do not have this problem.
- Fixed issue where GetEmailIO data services may become stuck when scheduled in a Bot
- Fixed issue where appending with Cognism data services may result in an error if countries attribute sent as part of the configuration
July 2, 2019 – Patch
Bug Fixes and Enhancements
- Fixed issue where Deduplication and merge tasks that are in Production mode jobs are not returning correct results.
June 30, 2019 – Patch
Bug Fixes and Enhancements
- Enhanced security of HTTPS connection to Openprise platform with enforcing TLS 1.2 only communications from browsers as well as removing any ciphers weaker than 256-bit
- Enhanced deduplication and merge task to process faster when data represents only a few very large duplicate groups
- Fixed issue with Dynamics CRM connector export where only contact to contact association (instead of account and contact) was allowed
- Fixed issue with Data Catalog where Access filters with complex filters are not saved properly
- Fixed issue with SFDC merge records task when the data target is SFDC Sandbox
- Fixed issue where remove junk task fails execution when junk values and junk value lists are both specified in the task configuration
- Fixed issue where Marketo List object is difficult to configure if there are more than 1000 lists in the Marketo system
- Fixed issue where API Jobs’ output is not downloadable
June 2, 2019 – Patch
Bug Fixes and Enhancements
- New Dun & Bradstreet Direct Plus integration is now supported in Data Marketplace
- Enhanced Eloqua Custom Data Object export with options to map to Contact or Account records in the Advanced Configuration
- Enhanced SFDC integration to enable import and export of the Contracts object
- Fixed issue where Deduplicate and merge task saves whole numbers as real numbers if a whole number attribute is merged using sum, average, range and min or max operation
- Fixed issue where CSV or Google Sheet data sources may not import records if the record starts with the “#” symbol
- Fixed issue for Eloqua data source imports for full imports (only when initially importing or importing after a purge)
- Fixed issue with API Factory in conjunction with Export: Create manual data source task when the task is configured to export to an existing manual data source instead of a net new one
- Fixed issue when updating number fields with Eloqua Custom Data Objects
May 12, 2019 – Patch
Bug Fixes and Enhancements
- Generate ID task is now available for users to create UUID with optional trailing or leading strings
- Marketo list management task now allows dynamic selection of Marketo lists by list ID
- New Virtual Data Integrator and API Factory only user role that provides users with an API Key but has no ability to log into the Openprise UI platform
- Enhanced API Factory to allow “Export: Create manual data source” task within a API enabled Job
- Enhanced People Data Labs data service to allow retrieving all emails into one comma separated value
- Enhanced Marketo list names with their program names if they are associated to programs
- Enhanced “Export: Add/Update” task to allow transactional API call to SFDC data targets (only for jobs with 1000 or less records to export)
- Enhanced CSV data source providers with the ability to “Validate schema” and verify that the files to be imported are in a compatible format
- Enhanced security by invalidating user session when a user changes password
- Updated login screen with an announcement or content panel
- Fixed issue where some GDPR Data Deletion requests may fail
- Fixed issue with Change attribute type task where converting single-value text to multi-value text may not allow case insensitive searches on the resulting value
- Fixed issue where cloning a Job fails when the Job has GDPR filters used in any of its Tasks
- Fixed issue with Classification and tagging task where multi-value text attributes added in the Job is often not found immediately after creation
April 28, 2019 – Patch
Bug Fixes and Enhancements
- BriteVerify data services have been enhanced to support TLS v1.2
- Maintenance of servers performed including OS level patches and updates to network security configuration
April 1, 2019 – Patch
Bug Fixes and Enhancements
- Maximum number of Tasks per Job is now set as 30. Existing Jobs with more than 30 Tasks will continue to work, but adding new Tasks will be prevented
- Enabled importing of CSV files and Google Sheets by matching column headers instead of using column order
- Enabled Cognism data service provider for enrichment purposes
- Enabled SFDC Manage opportunity contact role task and SFDC Manage campaign member task in API Factory mode
- Enabled invalidating all active user sessions for any user that is deleted in the platform
- Enabled auditing of Bots enablement and disablement as well as CRUD activities
- Fixed issue where searches could return records that does not fit the filter for the search
- Fixed issue with imports from target systems that never completes and result in high API quota consumption
- Fixed issue in data sources where the field order is duplicated causing some imported records to have blank values even though there are non-blank values in the source system
- Fixed issue where De-duplication tasks can be corrupted if attribute to attribute comparison operator is used in the section to determine the survivor record
- Fixed issue in API Factory where de-duplication tasks may result in additional non-relevant records being returned
- Fixed issue where the Marketo manage list member task is not listing all lists in target system if and only if there are more than 300 lists in the target system
- Fixed issue with Dropbox data sources where newly added fields do not allow for data type changes in the configuration screen
March 10, 2019 – Patch
Bug Fixes and Enhancements
- Fixed issue where extra double quotes may be introduced when exporting values that contain special characters
- Fixed issue where Marketo import may skip records if an import aborts
- Fixed issue where some Salesforce records are imported with an internal timekeeping attribute set to blank causing records to be missed during job runs
March 3, 2019 – Patch
Bug Fixes and Enhancements
- Fixed issue where Marketo Activity import is consuming extra APIs
- Fixed issue where some Amazon RDS MySQL data target are running into export issues
- Fixed issue where Salesforce objects with special characters, particularly double quotes in certain attributes, could cause import failures
- Fixed issue where Pardot Visit data source creation encounters issue in the parse screen
- Fixed issue where some Salesforce object’s export task result in no status fields returned in the task output
February 17, 2019 – Patch
Bug Fixes and Enhancements
- Fixed issue where cloned API Factory jobs may require a purge and re-enablement to take effect
- Fixed issue where Job Attributes pop-up clears the task configuration upon exiting when there are more than 100 unused attributes in the job
- Fixed issue where Marketo exports may encounter UTF-8 encoding issues
- Fixed issue where simultaneous exports may result in bot / job status of “Job did not trigger or was lost during an unexpected internal clean up” even after successfully exporting
- Fixed issue where Contact Information Parsing task does not allow returning the sub-premise (suite or apt numbers) attribute when using Google Places
- Fixed issue where RDS MySQL credentials are invalidated erroneously
February 10, 2019 – Patch
Bug Fixes and Enhancements
- Fixed issue where Salesforce imports containing fields that are no longer available in Salesforce but configured in Openprise are causing import failures
- Fixed issue where Infer Value task template may fail when the match criteria is matching whole numbers or real numbers
- Fixed issue where D&B enrichment may fail if there are 20 consecutive records that did not find a match in D&B based on the criteria sent
- Fixed issue where import fails when importing exponential formatted numbers (ie 1.92E+04) when configured to use whole numbers
February 8, 2019 – Openprise 2019 Release 1
New Features and Enhancements
- Beta Release of Virtual Data Integrator
- Virtual Data Integrator (VDI) is a chrome browser extension that works with the API Factory to enable a user to interact with any browser-based application. Here are 2 primary use cases:
- Display in the VDI data from other parts of the application or other systems in the context of the application page being viewed. For example, while viewing a Lead record in Salesforce, display the SFDC account matched to the lead record, account owner, current opportunities, as well as other data from the help desk or financial system that are matched to the Lead or the associated Account, all without having those data being persisted in SFDC
- Dynamically fetch enrichment or validation from any Data Marketplace service and return the data to a webhook or to automatically populate the form. For example, while editing a Salesforce Account record, the VDI can perform a match against Dun & Bradstreet to display matched companies and even automatically insert the D&B data into the form
- Virtual Data Integrator (VDI) is a chrome browser extension that works with the API Factory to enable a user to interact with any browser-based application. Here are 2 primary use cases:
- GDPR Data Deletion
- Given a list of emails, this feature allows you to remove any record in Openprise that has the email in the record even if the email is not in the email field itself
- New Salesforce Objects Support
- Support for the Salesforce Case, Account Contact Role, Opportunity Contact Role, and Campaign Influence objects has been added
- New Task Templates
- SFDC Manage Account Contact Role task template to enable creating, updating, or removing account contact roles in Salesforce
- SFDC Manage Opportunity Contact Role task template to enable creating, updating or removing opportunity contact roles in Salesforce
- Date calculation task to enable calculating the elapsed time between 2 date fields or calculate a new date based on an existing date field and an offset
- Simple math task to enable simple math calculations (e.g. addition, subtraction, multiplication, and division) between 2 whole number or real number fields
- API Factory Enhancements
- API-enabled Jobs can now process multiple requests at the same time instead of being restricted to 1 request at any given time
- Additional task templates are now allowed in an API-enabled Job
- New UI Elements
- Openprise UI is updated page by page – for a preview of what the future would look like, check out the Admin pages.
- Other Enhancements Worth Mentioning
- CSV data sources can now import CSV files 1 at a time
- Data sources can now push attributes to Jobs in bulk from the map screen – particularly useful when adding new attributes to a data source used by many jobs as the input data source
- You can set access expiration dates for any user in the system – particularly for the Support Administrator user
- Support for Percona databases and MySQL databases (only AWS RDS MySQL servers was supported before)
- New and improved UI for managing job attributes
- CSV data sources can now choose the delimiter – particularly useful for tab separated values or pipe character separated values
- Text translation task now returns the detected language if the auto-detect was selected for the source language
Bug Fixes
- Fixed issue with import when some records have fields that have too much data in them such as notes or description fields
- Fixed issue with Search and Replace task where the search string cannot have leading or trailing spaces
- Fixed issue with Eloqua export when only updating email address field
- Fixed issue with Job run reports where the report is not showing the start time of the job while it is still running
- Fixed issue with Concatenate task when using fields that have special characters in their field names
- Fixed issue with Pie chart analytics where some charts show a pie slice with a label of 0