DataChannel expands its connector portfolio with the release of three new connectors

by | Jul 1, 2021 | Blog, Data Science | 0 comments

We are excited to announce the addition of three new and exciting data connectors into an ever-growing list of 100+ connectors offered by DataChannel – Google Drive, Amazon S3, and FTP. 

“The pandemic validated cloud’s value proposition. The ability to use on-demand, scalable cloud models to achieve cost efficiency and business continuity is providing the impetus for organizations to rapidly accelerate their digital business transformation plans.”

  • Sid Nag, Research Vice President at Gartner

With every new connector addition, DataChannel users are able to experience a more inclusive and exhaustive overall data integration, making their modern data stacks much more efficient and viable. The connectors offered by DataChannel require no-code, no-maintenance, and are fully automated, enabling seamless data consolidation into a modern data analytics warehouse of your choice. 

Features

Support

Automated replication

Fully-managed maintenance

Schema management

Custom Transformation

Failure recovery

Incremental updates

Log-based change data capture

Let’s take a look at each of the connectors in brief.

Amazon S3

Amazon S3 (“Simple Storage Service”) is a scalable, reliable, low-cost, cloud-enabled object storage service, offered by Amazon Web Services (AWS). DataChannel now supports syncing files directly from the Amazon S3 bucket, where multiple files can be synched as unique tables in your data warehouse.

User Profile(s): Sales, Marketing, Analytics, CXO Suite, Content, Customer Support, etc.

Setup Time: 15 minutes or so (Self-Service)

Destination Choice: AWS Redshift, Google BigQuery, Snowflake, PostgreSQL, MySQL, etc.

Visualization & Analytics: Tableau, Google Studio, Zoho Analytics, Looker, Power BI, etc.

DataChannel’s Amazon S3 connector provides an integrated analytics experience to its user, by bringing together siloed and disparate Amazon S3 accounts, buckets, and objects, which are then ingested into a user-chosen data warehouse automatically on a set schedule. 

  • The connector offers dedicated pipelines enabling granular access to the bucket data. 
  • Objects pulled from your Amazon S3 will be stored as a dedicated table within a schema in your chosen destination.
  • Data is stored in a standardized manner to facilitate advanced analytics, dashboard reporting, Business Intelligence (BI) & Artificial Intelligence (AI) inquiries. 
  • You can set up advanced rules such as importing only last modified files, files matching a certain search criteria like name contains ‘xyz’,  importing multiple files, moving files to another location after insert etc.

FTP

FTP (“File Transfer Protocol”) is used to transmit files between computers from a server to a client connected via a dedicated computer network. DataChannel now supports syncing files directly from an FTP server in your data warehouse. 

User Profile(s): Sales, Marketing, Analytics, CXO Suite, Content, Customer Support, etc.

Setup Time: 15 minutes or so (Self-Service)

Destination Choice: AWS Redshift, Google BigQuery, Snowflake, PostgreSQL, MySQL, etc.

Visualization & Analytics: Tableau, Google Studio, Zoho Analytics, Looker, Power BI, etc.

DataChannel’s FTP connector provides an integrated analytics experience to its user, by bringing together siloed and disparate FTP files, which are then ingested into a user-chosen data warehouse automatically on a set schedule. 

  • The connector offers dedicated pipelines enabling granular access to the FTP data. 
  • Files pulled from your FTP server will be stored as a dedicated table within a schema in your chosen destination.
  • Data is stored in a standardized manner to facilitate advanced analytics, dashboard reporting, Business Intelligence (BI) & Artificial Intelligence (AI) inquiries. 

Google Drive

Google Drive is a cloud file storage service that provides users with personal storage space, called My Drive, and an option to access collaborative shared folders called shared drives. It offers file storage, synchronization, and sharing capabilities to its users. DataChannel now supports syncing files directly from your Google Drive, where multiple files can be synched as unique tables in your data warehouse.

User Profile(s): Sales, Marketing, Analytics, CXO Suite, Content, Customer Support, etc.

Setup Time: 15 minutes or so (Self-Service)

Destination Choice: AWS Redshift, Google BigQuery, Snowflake, PostgreSQL, MySQL, etc.

Visualization & Analytics: Tableau, Google Studio, Zoho Analytics, Looker, Power BI, etc.

DataChannel’s Google Drive connector provides an integrated analytics experience to its user, by bringing together siloed and disparate Google Drive accounts, files, and folders, which are then ingested into a user-chosen data warehouse automatically on a set schedule. 

  • The connector offers dedicated pipelines enabling granular access to the drive’s data. 
  • Files pulled from your drive will be stored as a dedicated table within a schema in your chosen destination.
  • Data is stored in a standardized manner to facilitate advanced analytics, dashboard reporting, Business Intelligence (BI) & Artificial Intelligence (AI) inquiries. 

About DataChannel

DataChannel is a cloud-native SaaS-based platform, which centralizes an organization’s data from 100+ disaparate and siloed data sources using pre-built connectors into a single warehouse without needing any coding or maintenance from a user’s end. It also provides a dashboard (or you can plug in your favorite ones) for convenient reporting and presentation.

Base your business decisions in detailed data analysis, actionable insights, and predictive forecasts, rather than your gut by reaching out to DataChannel. 

For more information on the connectors refer to the product documentation.

Request a Demo