Author: Jerod Johnson

CData Blog


January 31, 2019

SQL Access to Elasticsearch

by Jerod Johnson

Elasticsearch is a distributed, RESTful search and analytics engine capable of solving a growing number of use cases. It centrally stores your data so you can discover the expected and uncover the unexpected. As Elasticsearch offers some limited driver interfaces we are often asked how ou...

Read more

database image
January 17, 2019

What is Amazon DocumentDB? CData Connectivity Solutions

by Jerod Johnson

Amazon DocumentDB, a fully managed NoSQL database service by Amazon Web Services (AWS), is designed to be compatible with MongoDB workloads. CData connectivity solutions seamlessly integrate with DocumentDB, enhancing data access in the analytics platform, applications, and ETL tools of your choice.

Read more

January 09, 2019

Expanding Data Connectivity in Microsoft Power BI, Flow, and PowerApps

by Jerod Johnson

Microsoft offers a full suite of low-code solutions for building business applications and working with data. From the Power BI service for self-service analytics, to PowerApps and Flow for building applications, workflows, and tasks that consume, move, transform, or otherwise work with e...

Read more

netsuite snowflake
December 18, 2018

How to Load Data from Netsuite to Snowflake Data Warehouse

by Jerod Johnson

In previous articles, we discussed how you can replicate data to Google BigQuery and Amazon S3 . In this article, we review the features and benefits of CData Sync as a replication solution for NetSuite users and link to a short tutorial for replicating your NetSuite data to Snowflake , a...

Read more

December 06, 2018

Consolidating Enterprise Data to a Data Lake on Amazon S3 with CData Sync

by Jerod Johnson

We recently discussed the benefits and challenges involved in building a data warehouse and gave an example with Google BigQuery . BigQuery is only one of many popular solutions for data warehousing. Lately, flat-file ingestion-based destinations have become popular due to their ubiquity ...

Read more

November 30, 2018

Data Warehousing with Google BigQuery and CData Sync

by Jerod Johnson

The popularity of data warehousing continues to surge as tools for business intelligence (BI), artificial intelligence (AI), and machine learning (ML) are helping organizations realize new business value from their enterprise data. Advances in data warehousing, and subsequent tooling, is ...

Read more

July 25, 2018

Build Dynamic Power BI Dashboards Using Live Data

by Jerod Johnson

The addition of custom connectors has dramatically broadened the connectivity potential for Power BI users. Coming off of the Microsoft Business Applications Summit, we are pleased to announce the release of CData Power BI Connectors . Our new Power BI Connectors enable access to live dat...

Read more

April 10, 2018

Build Dynamic Tableau Dashboards Using Live Couchbase Data

by Jerod Johnson

Using the CData ODBC Driver for Couchbase, enterprises can unite the powerful visualization and reporting features of Tableau with their Couchbase NoSQL data stores to build dynamic dashboards based on live Couchbase data. Thanks to the innovative features of the CData ODBC Driver, users ...

Read more

CSV Logo
March 13, 2018

Virtual Database Access to Delimited Files (CSV/TSV) Stored Remotely

by Jerod Johnson

Delimited files are commonly used when importing and exporting data with relational databases and other data stores. As cloud storage services like Google Drive, Box.com, Amazon S3, and more evolve, enterprises are increasingly using them as repositories for data that has already been col...

Read more