March 2024

New Connectors

MongoDB

DataChannel now supports the MongoDB connector. The connector can be accessed from the Data Sources page on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This MongoDB connector will enable users to stream relevant MongoDB datasets into a pre-determined warehouse of their choice. Users will be able to start accessing their data by setting up a pipeline. Data pulled using such a pipeline will enable users to view data from the MongoDB in their warehouse.

Available Pipelines

  1. Table/View - Retrieve data from the database based on a table/view and/or columns chosen by the user.

Possible Destinations

Click here for more details about this connector.

NetSuite

DataChannel now supports NetSuite connector. The connector can be accessed from the Data Sources page on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This NetSuite connector will enable business managers to stream relevant data from NetSuite platform into a pre-determined warehouse of their choice. Users will be able to start accessing their data by setting up a pipeline. Data acquired using such a pipeline will enable users to analyse company data to improve operational and financial performance.

Available Pipelines

  1. NetSuite Objects - Retrieve a list of all records of a record type from the NetSuite platform.

  2. NetSuite Objects SuiteQL - Retrieve NetSuite records by executing SuiteQL queries.

Possible Destinations

Click here for more details about this connector.

Zoho Books

DataChannel now supports the Zoho Books connector. The connector can be accessed from the Data Sources page on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This Zoho Books connector will enable users to stream relevant data from Zoho Books into a pre-determined warehouse of their choice. Users will be able to start accessing their data by setting up a pipeline. Data acquired using such a pipeline will enable users to access accounting data for controlling spending, overseeing projects, and taking care of GST compliances.

Available Pipelines

  1. Contacts - Retrieve details of the contacts from the Zoho Books platform.

  2. Customer Payments - Retrieve details of the customer payments from the Zoho Books platform.

  3. Invoices - Retrieve details of the Invoices from the Zoho Books platform.

  4. Purchase Orders - Retrieve details of the purchase orders from the Zoho Books platform.

  5. Sales Orders - Retrieve details of the Sales orders from the Zoho Books platform.

Possible Destinations

Click here for more details about this connector.

monday.com

DataChannel now supports the monday.com connector. The connector can be accessed from the Data Sources page on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This monday.com connector will enable users to stream relevant data from monday.com platform into a pre-determined warehouse of their choice. Users will be able to start accessing their data by setting up a pipeline. Data acquired using such a pipeline will enable users to manage and optimize their workflows.

Available Pipelines

  1. Items - Retrieve details of all items on a board.

Possible Destinations

Click here for more details about this connector.

UpScriptHealth (Beta)

DataChannel now supports the UpScriptHealth connector. The connector can be accessed from the Data Sources page on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This UpScriptHealth connector will enable health-care providers to stream relevant data from UpScriptHealth into a pre-determined warehouse of their choice. Users will be able to start accessing their data by setting up a pipeline. Data acquired using such a pipeline will enable a company to access its order, patient and product details.

NOTE

This is presently a Beta version release.

Available Pipelines

  1. Order - Retrieve the details of all orders for a company from the UpScriptHealth platform.

  2. Patient - Retrieve the details of all patients for a company from the UpScriptHealth platform.

  3. Product - Retrieve the details of all products for a company from the UpScriptHealth platform.

Possible Destinations

Click here for more details about this connector.

New Destinations

Google Chat Reverse ETL

DataChannel now supports Google Chat Reverse ETL connector. The connector can be accessed from the Destinations page on the DataChannel Dashboard. Please follow the step-by-step setup guide for a smooth integration. Please ensure that you have requested and obtained a service account key and followed the steps as outlined here to create and publish your app.

The Google Chat Reverse ETL connector enables streaming relevant data from your data warehouse into the Google Chat platform.

Available Syncs

  1. Message- enables you to request and retrieve data and updates on Google Chat from your data warehouse.

Supported Reverse ETL Datawarehouses

Click here for more details about this connector.

Feature Updates

Notifications Support for Microsoft Teams

Users can now directly receive notifications from Datachannel in their Microsoft Teams. The feature can be accessed from the 'Settings' tab which is the bottommost icon on the sidebar.

settings page notifications tab4

dbt™ Core Enhancements

The following advanced options have been added for configuring any dbt™ Project:

  • Fail Fast.

  • Select Tag.

  • Exclude Tag.

  • Custom Selector.

  • Project Arguments(JSON).

Click here for more details about these options.

Transformation notifications

You can now choose whether and how to recieve notifications of your Transformantion (Error and Success). The notifications tab can be accessed from the Settings page from the DataChannel Console.

settings page notifications tab3

Orchestration- 'View Logs' for Reverse Syncs

Earlier when users attempted to see which tasks were executed successfully in an orchestration run, they were only able to access logs of forward pipeline runs. Now, the feature has been extended to support viewing logs for Reverse Syncs as well.

Users can now access recent Orchestration reverse sync run logs from the 'Execution History' tab by following these steps:

  1. The ‘Execution History’ Tab displays the execution details of the configured orchestration.

  2. To view which tasks were completed during any previous run, click on the View Tasks button.

  3. On clicking the View Tasks button, you will be able to see which tasks were executed successfully.

  4. To access detailed logs, click on the View Logs button. Logs will be displayed.

Orchestration- Tableau Node

We have added a new type of node (Tableau Node) for building orchestrations at DataChannel. The Tableau node (when configured) offers an important advantage of automatically refreshing your extracts (as per the desired schedule) in the Tableau Analytics dashboards created by you.

Orchestration- Power BI Node

We have added a new type of node (Power BI Node) for building orchestrations at DataChannel. The PowerBI Refresh node (when configured) offers an important advantage of automatically refreshing your datasets (as per the desired schedule) in the Power BI Analytics dashboards created by you.

Sidebar Menu

In an attempt to make the DataChannel Console more user friendly, the Sidebar menu has been redesigned. The Sidebar menu is in Collapsed mode by default, and you can use the arrow key to expand it.

sidebar expand

Users are advised to browse through and familiarise themselves with the changed menu options now available on the Sidebar of the DataChannel Console.

sidebar new options

Settings Tab

The Settings Tab allows you to view your profile, add multiple users, manage credentials, API keys, set the timezone, view your usage, choose your notification settings and many more such functions. The 'Settings' tab, now has a new layout. Users are advised to acquaint themselves with the changed layout of the 'Settings' tab of the DataChannel Console.

settings tab new
settings tab new 1

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.