Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for YouTube Analytics in APOS Live Data Gateway
Use the CData Connector for YouTube Analytics in APOS Live Data Gateway to build Semantic Layer Views for YouTube Analytics.
-
Automated Continuous Azure Active Directory Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Amazon S3.
-
Replicate REST to Multiple Databases
Replicate REST to disparate databases with a point-and-click configuration.
-
Visualize ClickUp in Sisense
Create an ElastiCube in Sisense app with access to ClickUp.
-
Automated Continuous CouchDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CouchDB replication to Amazon Redshift.
-
Build Interactive Dashboards from Email in Amazon QuickSight
Create a virtual SQL Server database for Email in CData Software Connect Server and import Email into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Build an ETL App for Google Spanner in Python with CData
Create ETL applications and real-time data pipelines for Google Spanner in Python with petl.
-
Create Reports with Act-On in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act-On.
-
Replicate Sage 50 UK to Multiple Databases
Replicate Sage 50 UK to disparate databases with a single configuration.
-
Create Act-On-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Act-On from OutSystems and build custom enterprise apps using live Act-On.
-
Create Microsoft Planner-Connected Enterprise Applications in OutSystems
Use CData Connect Cloud to connect to Microsoft Planner from OutSystems and build custom enterprise apps using live Microsoft Planner.
-
Work with Sage Cloud Accounting in FoxPro
Load Sage Business Cloud Accounting into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Dynamics NAV in R
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dynamics NAV in Microsoft R Open.
-
Connect to Sage Intacct in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Sage Intacct and connect to Sage Intacct in Akorbi Digital RunMyProcess.
-
Automated Continuous Jira Replication to Vertica
Use CData Sync for automated, continuous, customizable Jira replication to Vertica.
-
LINQ to Facebook
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Facebook Data Provider.
-
How to Access Live Hive in Power Automate Desktop via ODBC
The CData ODBC Driver for Hive enables you to integrate Apache Hive into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Blackbaud FE NXT Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to PostgreSQL.
-
Automated Continuous Highrise Replication to Snowflake
Use CData Sync for automated, continuous, customizable Highrise replication to Snowflake.
-
Connect to Oracle HCM Cloud in RunMyProcess through Connect Cloud
Use CData Connect Cloud to create on OData API for Oracle HCM Cloud and connect to Oracle HCM Cloud in Akorbi Digital RunMyProcess.
-
Add Oracle Eloqua to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle Eloqua with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with Cosmos DB in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Azure Cosmos DB in SnapLogic.
-
Connect to Teradata from PowerBuilder
This article demonstrates how to use the CData ODBC Driver for Teradata to connect to Teradata and execute queries in PowerBuilder.
-
Query Exact Online through ODBC in Node.js
Use node-odbc to execute SQL queries against Exact Online from Node.js.
-
Automated Continuous Avalara AvaTax Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Microsoft Access.
-
How to Import Active Directory into SQL Server using SSIS
Easily back up Active Directory to SQL Server using the SSIS components for Active Directory.
-
Create Data Visualizations in Cognos BI with EnterpriseDB
Access EnterpriseDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to PostgreSQL from PowerBuilder
This article demonstrates how to access PostgreSQL from PowerBuilder using the PostgreSQL JDBC Driver.
-
How to integrate CouchDB with Apache Airflow
Access and process Apache CouchDB in Apache Airflow using the CData JDBC Driver.
-
Integrate Real-Time Access to Calendly in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Calendly in real time.
-
Access Live Jira in Google Sheets
Use CData Connect Cloud to gain access to live Atlassian Jira from your Google Sheets.
-
Replicate MYOB AccountRight to Multiple Databases
Replicate MYOB AccountRight to disparate databases with a single configuration.
-
Automated Continuous ServiceNow Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable ServiceNow replication to Microsoft Access.
-
Automate Calendly Replication to SAP HANA
Use CData Sync to customize and automate Calendly replication to SAP HANA.
-
SAP Drivers Overview
In this entry, you will find an overview of the SAP products supported by CData as well as the interfaces used to surface their data.
-
Integrate Live QuickBooks Online into Amazon SageMaker Canvas with RDS
Use CData Connect Cloud to connect to QuickBooks Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live QuickBooks Online.
-
Publish Blackbaud FE NXT-Connected Dashboards in Tableau Server
Use CData JDBC drivers and Tableau Server to visualize live Blackbaud FE NXT.
-
Design BIRT Reports on Marketo
Provide current Marketo to your embedded analytics.
-
DataBind Controls to Avro in C++Builder
DataBind to Apache Avro in C++Builder with standard components and controls.
-
Visualize HubDB from Tableau
Use the Tableau Desktop business intelligence tool to connect to HubDB.
-
Build ADP-Connected Apps in Choreo
Use CData Connect Cloud to connect to ADP from Choreo and build custom apps using live ADP.
-
Create Parquet Dashboards in Bold BI
Use CData Software Connect Server to create a virtual SQL Server Database for Apache Parquet to build custom dashboards in Bold BI.
-
LINQ to BigCommerce
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the BigCommerce Data Provider.
-
Visualize Sage 200 in TIBCO Spotfire through ADO.NET
Integrate Sage 200 into dashboards in TIBCO Spotfire.
-
Create SSAS Tabular Models from Smartsheet
How to build a SQL Server Analysis Service Tabular Model from Smartsheet using CData drivers.
-
How to create an RPA flow for Sugar CRM in UiPath Studio
Use the Sugar CRM ODBC Driver to create workflows that access real-time Sugar CRM without any coding.
-
How to connect and process Microsoft Exchange from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Exchange
-
Replicate Multiple SAP Hybris C4C Accounts
Replicate multiple SAP Hybris C4C accounts to one or many databases.
-
Build MariaDB-Connected Web Apps with Axios and CData Connect Cloud
Use CData Connect Cloud to connect to live MariaDB and build MariaDB-connected web apps with Axios.
-
Integrate Trello with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Trello with External Services.
-
How to update SingleStore from Excel
This article explains how to transfer data from Excel to SingleStore using the Excel Add-In for SingleStore.
-
Google Contacts Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Contacts facts in real time.
-
Analyze LinkedIn in R
Use standard R functions and the development environment of your choice to analyze LinkedIn with the CData JDBC Driver for LinkedIn.
-
Connect to MySQL in DBArtisan
Use wizards in DBArtisan to configure MySQL as a data source.
-
Integrate with Elasticsearch in SnapLogic
Use CData Connect Cloud to connect to and integrate with live Elasticsearch in SnapLogic.
-
Enable the Xero JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Xero Accounting.
-
Connect to Marketo in Google Apps Script
Use CData Connect Cloud to access Marketo in Google Apps Script.
-
Access BigCommerce in PHP through Connect Server
Connect to BigCommerce through the standard SQL Server libraries in PHP.
-
How to connect PolyBase to Excel Online
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Excel Online.
-
Use the CData Software ODBC Driver for SurveyMonkey in MicroStrategy Web
Connect to SurveyMonkey in MicroStrategy Web using the CData Software ODBC Driver for SurveyMonkey.
-
Build Automated Microsoft Planner-Connected Workflows in Zapier
Use CData Connect Cloud to connect to live Microsoft Planner and build automated workflows in Zapier.
-
Automated Continuous Paylocity Replication to Snowflake
Use CData Sync for automated, continuous, customizable Paylocity replication to Snowflake.
-
Visualize Google Sheets Data in Tableau
The CData ODBC driver for Google Sheets enables you integrate Google Sheets data into Tableau dashboards.
-
DataBind Controls to Greenplum in C++Builder
DataBind to Pivotal GreenPlum in C++Builder with standard components and controls.
-
Create Active Directory-Connected Visualizations in Klipfolio
Use CData Connect Cloud to connect to Active Directory from Klipfolio and build custom visualizations using live Active Directory.
-
How to connect to ShipStation with Squirrel SQL client
Connect to ShipStation and execute queries in the Squirrel SQL Client.
-
Query BigCommerce in ColdFusion
Write standard ColdFusion data access code to connect to BigCommerce.
-
Add Amazon S3 to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon S3 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Driver Guide: Marketing Analytics Predefined Reports
A basic overview of CData marketing analytics connectivity, including predefined reports for easier access to data.
-
How to Query DocuSign in MySQL Workbench
Execute MySQL queries against live DocuSign from MySQL Workbench.
-
Connect to OData Services from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time OData using standard SQL.
-
A PostgreSQL Interface for BigCommerce
Use the SQL Gateway and BigCommerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Pipedrive in RunMyProcess through Connect Server
Use CData Connect Server to create an OData API for Pipedrive and connect to Pipedrive in Akorbi Digital RunMyProcess.
-
Feed Monday.com into FineReport
How to set Monday.com as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy Desktop
Connect to Microsoft Dynamics 365 in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics 365.
-
How to Connect to Workday in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Workday. Leverage the pyodbc module for ODBC in Python.
-
How to integrate Paylocity with Apache Airflow
Access and process Paylocity in Apache Airflow using the CData JDBC Driver.
-
How to connect to Tableau CRM Analytics from IntelliJ
Integrate connectivity to Tableau CRM Analytics with wizards in IntelliJ.
-
Replicate Multiple Box Accounts
Replicate multiple Box accounts to one or many databases.
-
How to Work with SharePoint in AWS Glue Jobs Using JDBC
Connect to SharePoint from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with live IBM Informix in Jitterbit
Use CData Connect Cloud to connect to and integrate live IBM Informix in Jitterbit.
-
Build Google Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect Cloud to connect to Google Ads from Zoho Analytics and import live Google Ads.
-
Create Apps from Microsoft Teams in Qlik Sense Cloud
Use CData Connect Cloud to connect to Microsoft Teams and build apps from live Microsoft Teams in Qlik Sense Cloud.
-
How to create Amazon Athena federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon Athena in MySQL .
-
Connect to FHIR from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FHIR using standard SQL.
-
Automated Continuous Reckon Replication to Vertica
Use CData Sync for automated, continuous, customizable Reckon replication to Vertica.
-
Integrate with HBase using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache HBase to a JSON file on disk.
-
Visualize Paylocity in TIBCO Spotfire through OData
Integrate Paylocity into dashboards in TIBCO Spotfire.
-
Connect to and Query Spark in QlikView over ODBC
Create data visualizations with Apache Spark SQL in QlikView.
-
Query Jira in ColdFusion
Write standard ColdFusion data access code to connect to Atlassian Jira.
-
How to connect to CockroachDB from IntelliJ
Integrate connectivity to CockroachDB with wizards in IntelliJ.
-
Create Data Visualizations in Cognos BI with Unbounce
Access Unbounce as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Bing Ads in AWS Lambda (with IntelliJ IDEA)
Connect to live Bing Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build to Web Apps on SAP Ariba Procurement
Create Python applications that use pandas and Dash to build SAP Ariba Procurement-connected web apps.
-
Query, Visualize, and Share live MariaDB in Redash
Use CData Connect Cloud to connect to live MariaDB in Redash for querying, visualizing, and sharing.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Harvest
Provide connectivity to Harvest through an SAP BusinessObjects universe.
-
Visualize Live Sage Intacct in the Power BI Service
Use CData Connect Cloud to connect to live Sage Intacct and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Dynamic Hive Grids Using the Infragistics XamDataGrid
Learn how you can connect Hive to Infragistics XamDataGrid to build dynamic grids.
-
Connect to and Query Zenefits in QlikView over ODBC
Create data visualizations with Zenefits in QlikView.
-
Connect to Google Directory as a SQL Server Linked Server
Use CData Connect Cloud to create a linked server for live Google Directory.