CData Software - Knowledge Base
Recent Articles
-
Build Google Analytics-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Analytics to explore live Google Analytics Data in GitHub Copilot to assist with building Google Analytics-powered applications.
-
Access Live Email Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Email from your Google Sheets.
-
Visualize Live LaunchDarkly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LaunchDarkly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for ConvertAPI in MicroStrategy
Connect to ConvertAPI in MicroStrategy Developer using the CData Software JDBC Driver for ConvertAPI.
-
Visualize XML Data in TIBCO Spotfire through OData
Integrate XML Files into dashboards in TIBCO Spotfire.
-
How to create QuickBooks federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for QuickBooks Desktop in MySQL .
-
Automated Continuous Front Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Front replication to Apache Cassandra.
-
How to connect PolyBase to ZohoPeople
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoPeople.
-
Visualize Live AfterShip Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AfterShip.
-
Automated Continuous Cosmos DB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Google Cloud SQL.
-
Automate Freshsales Data Replication to Couchbase
Use CData Sync to Customize and automate Freshsales replication to Couchbase.
-
Getting Started with the CData SSIS Components for Phoenix
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Phoenix.
-
Access Live Oracle Financials Cloud Data in Coginiti Pro
Connect to and query live Oracle Financials Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect PolyBase to Customer.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Customer.io.
-
Build a Simple VCL Application for Spotify Data
How to build a simple VCL Application to view Spotify in RAD Studio using the CData ODBC Driver for Spotify.
-
How to create an RPA flow for CSV Data in UiPath Studio
Use the CSV ODBC Driver to create workflows that access real-time CSV/TSV Files without any coding.
-
Automate SageHR Data Replication to Azure Data Lake
Use CData Sync to customize and automate SageHR replication to Azure Data Lake.
-
Integrate Dynamics CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Dynamics CRM and integrate live Microsoft Dynamics CRM into your Power Automate tasks.
-
Integrate EnterpriseDB Data into Power Automate Desktop using CData Connect
CData Connect for EnterpriseDB Data enables you to integrate EnterpriseDB into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous OneNote Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable OneNote replication to Google BigQuery.
-
Create Informatica Mappings From/To a JDBC Data Source for Amazon DynamoDB
Create Amazon DynamoDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Pinterest Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pinterest facts in real time.
-
Connect to Reckon Data from a Connection Pool in JBoss
Integrate Reckon into Java servlets: Use the Management Console in JBoss to install the Reckon JDBC Driver.
-
Create Dashboards and Visualize Live Raisers Edge NXT Data in Geckoboard
Use CData Connect AI to connect to live Raisers Edge NXT and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating Dataiku with SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAS XPORT.
-
Access Vimeo Data from MySQL in PHP
Connect to Vimeo through the standard MySQL libraries in PHP.
-
Build Microsoft Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Ads and build Microsoft Ads-connected web apps with Axios.
-
Query Twilio Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Twilio entities in PHP by modeling them as objects.
-
Connect to Google Spanner Data in NetBeans
Connect to Google Spanner in NetBeans with the data source configuration wizard.
-
Use Microsoft Copilot Studio to talk to your Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Sheets for you.
-
Build Apps with Live Raisers Edge NXT in Adalo using CData Connect AI
Use CData Connect AI to integrate live Raisers Edge NXT into the Adalo platform and build custom mobile and web applications with real-time Raisers Edge NXT.
-
Connect to Cassandra Data in HULFT Integrate
Connect to Cassandra as a JDBC data source in HULFT Integrate
-
Integrate Cline with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Twitter Ads from within your IDE.
-
Migrating data from SAP SuccessFactors to Databricks using CData SSIS Components.
Easily push SAP SuccessFactors to Databricks using the CData SSIS Tasks for SAP SuccessFactors and Databricks.
-
Connect to Greenhouse Data in Aqua Data Studio
Access Greenhouse from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Create Power BI Visual Reports with Real-Time Aircall Data
Use CData Power BI Connectors to visualize Aircall in Power BI.
-
Integrate Omnisend with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Omnisend with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Omnisend.
-
Moving Data from SAP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Import Data from WordPress into Google Sheets
Import WordPress into a Google spreadsheet that is automatically refreshed.
-
Connect to Pipedrive Data from a Connection Pool in JBoss
Integrate Pipedrive into Java servlets: Use the Management Console in JBoss to install the Pipedrive JDBC Driver.
-
Use JayDeBeApi to access Microsoft Dataverse Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Dataverse (CDS).
-
Enable the Notion JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Notion.
-
IBM Cloud Object Storage Reporting in OBIEE with the IBM Cloud Object Storage JDBC Driver
Deploy the IBM Cloud Object Storage JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live SingleStore Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SingleStore for you.
-
Replicate Helpscout Data from PowerShell
Write a quick PowerShell script to query Helpscout. Use connectivity to the live data to replicate Helpscout to SQL Server.
-
Configure the CData JDBC Driver for SAP Fieldglass in a Connection Pool in Tomcat
Connect to SAP Fieldglass from a connection pool in Tomcat.
-
Prepare, Blend, and Analyze ConstantContact Data in Alteryx Designer (ODBC)
Build workflows to access live ConstantContact for self-service data analytics.
-
Integrate Contentful Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Contentful from Informatica Cloud.
-
Integrating Codex CLI with ServiceDesk Plus via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Enable the Cloudant JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with IBM Cloudant.
-
Use Biml to Build SSIS Tasks to Replicate Mixpanel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Mixpanel to SQL Server.
-
Replicate Multiple Clio Accounts
Replicate multiple Clio accounts to one or many databases.
-
Automate SAP HANA Data Replication to Couchbase
Use CData Sync to Customize and automate SAP HANA replication to Couchbase.
-
Use the CData Software ODBC Driver for SingleStore in MicroStrategy
Connect to SingleStore in MicroStrategy Developer using the CData Software ODBC Driver for SingleStore.
-
Enable the Jumpseller JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Jumpseller.
-
Publish Reports with PagerDuty Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PagerDuty.
-
Build Data Flows from Microsoft Planner to SQL Server using SSIS
Easily back up Microsoft Planner to SQL Server using the SSIS components for Microsoft Planner.
-
How to Access Teradata Data Using Entity Framework
This article shows how to access Teradata using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build IBM Informix-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to IBM Informix and build web apps with connectivity to live IBM Informix.
-
Publish Crystal Reports on HDFS Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache HDFS.
-
Trigger LDAP IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for LDAP with standard wizards in Logic Apps.
-
Use the CData Software ODBC Driver for Mistral AI in SAS for Real-Time Reporting and Analytics
Connect to real-time Mistral AI in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mistral AI.
-
Visualize Live Tally Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Tally ERP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open Lakebase Data in Microsoft Excel
This article uses the CData ODBC driver for Lakebase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live SingleStore Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SingleStore from your Excel spreadsheets.
-
Process & Analyze Sage Intacct Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage Intacct Data.
-
Build Semantic Layer Views for JotForm Data in APOS Live Data Gateway
Use the CData Connector for JotForm in APOS Live Data Gateway to build Semantic Layer Views for JotForm.
-
ETL Demio in Oracle Data Integrator
This article shows how to transfer Demio into a data warehouse using Oracle Data Integrator.
-
Migrating data from Optimizely to Snowflake using CData SSIS Components.
Easily push Optimizely to Snowflake using the CData SSIS Tasks for Optimizely and Snowflake.
-
View Reports on Real-Time Front Data in Power BI Report Server
Use the CData ODBC Driver for Front to visualize Front in Power BI Desktop and then publish them to Power BI Report Server.
-
Natively Connect to Amazon Athena Data in PHP
The CData ODBC driver for Amazon Athena enables you to create PHP applications with connectivity to Amazon Athena. Leverage the native support for ODBC in PHP.
-
Access Live YouTube Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live YouTube Analytics from your Excel spreadsheets.
-
Automated Continuous YouTube Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Apache Kafka.
-
Trigger Salesforce Marketing IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce Marketing with standard wizards in Logic Apps.
-
Connect to Sage Cloud Accounting Data from HeidiSQL
Use CData Connect AI to connect to and query live Sage Business Cloud Accounting from HeidiSQL.
-
Access SAP Concur Data from MySQL in Amazon QuickSight
Connect to SAP Concur and build visualizations of SAP Concur using a MySQL Connection in Amazon QuickSight.
-
How to Access Live Oracle SCM Data in Visual Studio Code via Cline
Run CData MCP Server for Oracle SCM on Windows Subsytem for Linux (WSL) and connect to live Oracle SCM from the Cline extension in Visual Studio Code.
-
Query Demio Data in DataGrip
Create a Data Source for Demio in DataGrip and use SQL to query live Demio.
-
Feed Basecamp Data into FineReport
How to set Basecamp as a JDBC data source in FineReport.
-
Connect to FormSite Data in RazorSQL
Connect to FormSite from wizards and query FormSite from the GUI in the RazorSQL database management tool.
-
Integrating Codex CLI with Airtable via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Build Printful-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Printful and build web apps with connectivity to live Printful.
-
Access Microsoft Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Ads from your Oracle system.
-
Use the CData ODBC Driver for Oracle Eloqua Reporting from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua Reporting to connect to Oracle Eloqua Reporting from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Eloqua Reporting in Excel.
-
Use Dash to Build to Web Apps on VWO Data
Create Python applications that use pandas and Dash to build VWO-connected web apps.
-
Automated Continuous Microsoft OneLake Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Snowflake.
-
Create Informatica Mappings From/To an ODBC Data Source for OpenWeatherMap
Create an ODBC connection to OpenWeatherMap in Informatica and browse and transfer OpenWeatherMap.
-
Automated Discord Data Replication to Teradata
Use CData Sync to Customize and automate Discord replication to Teradata.
-
Build Box-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Box Data and create custom apps in Mendix.
-
Build Presto-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Presto Data and create custom apps in Mendix.
-
Automated Continuous Coinbase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Coinbase replication to delimited files (CSV/TSV).
-
Load Datadog Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Datadog to a database.
-
Provide OData Services of xBase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for xBase by developing a WCF Service Application.
-
Access Discord Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Discord from your Oracle system.
-
How to create Vault CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Veeva Vault & Vault CRM in MySQL .
-
Automated Continuous Billsby Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Billsby replication to IBM DB2.
-
Use the CData ODBC Driver for eBay Analytics from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for eBay Analytics to connect to eBay Analytics from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring eBay Analytics in Excel.
-
How to Easily Query Cassandra Data in OpenOffice Base
Connect to Cassandra data in OpenOffice Base using the CData ODBC Driver for Cassandra and generate reports with live data insights.
-
Connect to Sage Cloud Accounting Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage Business Cloud Accounting.
-
Connecting Pipedream with DocuSign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on DocuSign data in real time.