We are excited to tell you that in addition to the existing destinations, you will now be able to load data into MSSQL, Microsoft’s own Relational Database Management System. Not just that, you would also be able to create data models and materialized views on your data in MSSQL.
MSSQL as a Destination
Ability to Edit Data Type while Editing Schema Mapper Mapping
To provide more flexibility while editing the mapped schema, we will soon be adding the capability to choose the data type each time a new column is added.
Support for Nested Columns in BigQuery
To help you exploit BigQuery’s awesome support for Nested JSON, we will be adding support to load data to nested columns on Hevo. This will allow you to load the data as per your use case to your BigQuery Data Warehouse.
Cut Down on Notifications and Alerts
In order to help you stay on top of only the important things that matter to you, we have toned down the number of notifications and alerts that you receive from Hevo. Based on feedback from many of you, we have eliminated many redundant notifications and cleaned up the alerts. We hope this change enhances your experience with Hevo.
Load Status for Redshift, Snowflake, BigQuery
To help you get complete visibility into the events loaded into your warehouse, we have added a “Load Status” tab on Hevo Pipeline Page. This will help you see exactly how many events have been successfully loaded into the destination tables.
Welcome OracleDB as a Source
Yes! We have added OracleDB to the pool of data sources supported by Hevo. You can choose to bring OracleDB data via custom SQL query, Redo Log or by simply loading the entire table.
You can now analyse OracleDB data in real-time within your data warehouse in just a few clicks!
Unique Column querier for all JDBC sources
To help you bring data more flexibly, Hevo now supports incremental data load via a unique incrementing column of any data type. The historic constraint on unique numeric key for append-only mode will be discontinued. The updated constraints will be implemented in its place.
Loading Data from Multiple Databases in MongoDB
Hevo has added support to pull data from multiple databases within a single MongoDB instance via a single pipeline. This will make it faster for you to set up your pipelines and will reduce performance overhead on your MongoDB instance.
More data in Zendesk
Improvements and Fixes
We have added support to extract all the objects on Zendesk. Previously, users were able to pull the data on tickets and conversations. This upgrade will help you extract and analyze your Zendesk data better.
Here is the list of objects supported by Hevo
Change Position Feature - Enabled for All
Improvements and Fixes
A few months ago, we had released a beta version of a highly requested feature that allows you to read the data from an older date in a P