September 2024

New Connectors

Flipkart Seller

DataChannel now supports the Flipkart Seller connector. The connector can be accessed from the ETL tab on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This Flipkart Seller connector will enable users to stream relevant Flipkart Seller account data 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 various aspects related to the sales such as monitor selling performance, gather business insights and much more.

Available Pipelines

  1. Cash Back Report - Retrieve the Cash Back Report.

  2. Commission Invoice Transaction Details - Retrieve the Commission Invoice Transaction Details Report.

  3. MP Fee Rebate Transactions - Retrieve the MP Fee Rebate Transactions Report.

  4. Sales Report - Retrieve the Sales Report.

  5. Seller Insights - Retrieve the Seller Insights Report.

Possible Destinations

Click here for more details about this connector.

MailChimp

DataChannel now supports the MailChimp connector. The connector can be accessed from the ETL tab on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This MailChimp connector will enable users to stream relevant MailChimp account datasets 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 lists, campaigns, automations and more.

Available Pipelines

  1. Automations - Retrieve a summary of the classic automations in your Mailchimp account.

  2. Campaigns - Retrieve the list of all campaigns in your Mailchimp account.

  3. Lists - Retrieve information about all lists in your Mailchimp account.

  4. List’s Members - Retrieve the information about members in a specific Mailchimp list.

  5. Reports - Retrieve the campaign reports for all campaigns in your Mailchimp account.

Possible Destinations

Click here for more details about this connector.

Blinkit

DataChannel now supports the Blinkit connector. The connector can be accessed from the ETL tab on the DataChannel Dashboard. Please follow the step-by-step Set up Guide for a smooth integration.

This Blinkit connector will enable users to stream relevant Blinkit account datasets 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 monitor sales performance and inventory of their products to draw insights about what is working and what is not.

Available Pipelines

  1. Invoice - Retrieve the invoices for the specified period.

  2. Sales Report - Retrieve the sales report for the specified period.

  3. Score Card Details - Retrieve the manufacturer’s score card details for the specified period.

  4. Score Card Top 5 Potential Loss - Retrieve the manufacturer’s score card details for the top 5 potential loss makers, for the specified period.

  5. Stock on Hand - Retrieve the current stock levels on hand.

Possible Destinations

Click here for more details about this connector.

ClickhouseDB

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

This ClickhouseDB connector will enable users to stream relevant ClickhouseDB 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 ClickhouseDB in their warehouse.

Available Pipelines

  1. Custom Query - Enables a user to transfer data from ClickhouseDB into the DataChannel with the granularity of a Custom Query result.

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

Possible Destinations

Click here for more details about this connector.

New Destinations

Pinecone Reverse ETL

DataChannel now supports Pinecone 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.

The Pinecone Reverse ETL connector enables streaming relevant data from your data warehouse into the Pinecone Vector database.

Available Syncs

  1. Upsert Data- enables you to load data from a user specified data warehouse to the Pinecone vector database.

Supported Reverse ETL Datawarehouses

Click here for more details about this connector.

Feature Updates

Role Based Access Control(RBAC)

We have launched Role Based Access Control(RBAC) to empower you to manage access to your DataChannel account’s resources. This will enable you to secure and protect your data from unauthorized access. DataChannel RBAC helps you manage who has access to which of your DataChannel resources, and what they can do with those resources. By assigning roles to users (based on the nature of their responsibilities in your organization) you can define which user/role has permission to access which resource and what action can they carry out. Click here for more details about this feature.

Flipkart Ads

DataChannel’s Flipkart Ads connector now supports 4 new forward data pipelines. The new and existing pipelines of the Flipkart Ads connector can be accessed from the ETL tab on the Sidebar in the DataChannel UI.

Please follow the step-by-step Set up Guide for a smooth integration of the pipelines.

New Pipelines that are now available

Possible Destinations

Click here for more details about this connector.

Logs Connector

DataChannel’s Logs connector now supports a new forward data pipelines. The new and existing pipelines of the Logs connector can be accessed from the ETL tab on the Sidebar in the DataChannel UI.

Please follow the step-by-step Set up Guide for a smooth integration of the pipelines.

New Pipeline that is now available

  • dbt™ Transformation logs- View logs generated for all errors and successful runs of dbt™ transformations performed on your data.

Possible Data Warehouses

Click here for more details about this connector.

Bug Fixes

We have carried out minor bug fixes in Amazon Marketing Stream connector for seamless pipeline creation and more relevant error reporting.

Bug fixes have also been carried out in the Shopify GraphQL connector.

Google BigQuery

An edit icon placed next to the Access Users field will now enable users to add more Google emails / users to their Google BigQuery warehouse.

edit big query access user

Data Orchestration

While configuring the Power BI Refresh node (to automatically refresh your datasets in the Power BI Analytics dashboards), DataChannel now lends support to both Single & Multi Tenant Apps.

Public API

We have included a new endpoint in the DataChannel Public API, to programmatically pull the status of the Data Orchestration Run.

View Logs

Clients will now be able to access Load Errors which are now visible in View Logs button. This will help them pinpoint the exact field where the load error occured.

Facebook Ads Advanced

Optimisations have been carried out to the Facebook Ads Advanced connector to reduce the pipeline run duration when fetching data.

Webhooks

In certain instances, data loss when running the Webhooks connector had been reported. This is now resolved through enhancements to hold larger amounts of data and avoid data loss even when pipeline does not load data for certain number of runs.

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.