CData Software - Knowledge Base
Recent Articles
-
Connect to Twitter Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Twitter Ads using standard SQL.
-
Automate Toggl Data Replication to SAP HANA
Use CData Sync to customize and automate Toggl replication to SAP HANA.
-
Access Workday Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Workday from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pipeliner CRM
Provide connectivity to Pipeliner CRM through an SAP BusinessObjects universe.
-
Integrating Kiro CLI with Adobe Analytics Data 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.
-
How to publish and share Airtable Data dashboards with Tableau Server
The CData ODBC driver for Airtable enables you integrate Airtable into Tableau dashboards.
-
Analyze Slack Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Slack in Microsoft R Open.
-
How to Connect the Power BI Service to Presto: Complete Guide
Connect to the CData Software Power BI Connector for Presto from PowerBI.com to provide real-time Presto across the organization.
-
How to Connect to Live BigCommerce Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live BigCommerce without replication.
-
Automated Continuous Avalara AvaTax Replication to SQL Server
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQL Server.
-
Getting Started with the CData ODBC Driver for ServiceNow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ServiceNow.
-
Integrate SAP SuccessFactors LMS Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP SuccessFactors LMS from Informatica Cloud.
-
Object-Relational Mapping (ORM) with Databricks Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Databricks into a Java-based ORM framework, Hibernate.
-
Visualize Jumpseller Data in Sisense
Create an ElastiCube in Sisense app with access to Jumpseller.
-
Analyze Twilio Data in Looker
Use CData Connect AI to connect to Twilio Data from Looker and build custom apps using live Twilio.
-
Build Semantic Layer Views for Suadeo Data in APOS Live Data Gateway
Use the CData Connector for Suadeo in APOS Live Data Gateway to build Semantic Layer Views for Suadeo.
-
View Reports on Real-Time Power BI XMLA Data in Power BI Report Server
Use the CData ODBC Driver for Power BI XMLA to visualize Power BI XMLA in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Microsoft Entra ID Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Entra ID in Airbyte.
-
Visualize SAP Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP ERP/NetWeaver.
-
Query Wave Financial Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Wave Financial entities in PHP by modeling them as objects.
-
Publish CSV-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CSV/TSV Files.
-
Operational Reporting on SharePoint Excel Services Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SharePoint Excel Services.
-
Use the CData Software JDBC Driver for Monday.com in MicroStrategy
Connect to Monday.com in MicroStrategy Developer using the CData Software JDBC Driver for Monday.com.
-
Replicate Multiple Bitbucket Accounts
Replicate multiple Bitbucket accounts to one or many databases.
-
Connect to Adobe Target Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Target to connect to Adobe Target and execute queries in PowerBuilder.
-
Import Real-Time Apollo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apollo in ColdFusion.
-
Build Dynamics 365 Business Central-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Dynamics 365 Business Central to explore live Dynamics 365 Business Central Data in Claude Code to assist with building Dynamics 365 Business Central-powered applications.
-
Replicate Raisers Edge NXT Data from PowerShell
Write a quick PowerShell script to query Raisers Edge NXT. Use connectivity to the live data to replicate Raisers Edge NXT to SQL Server.
-
Query Marketo Data in ColdFusion
Write standard ColdFusion data access code to connect to Marketo.
-
Connect to and Query Hubstaff Data in QlikView over ODBC
Create data visualizations with Hubstaff in QlikView.
-
How to import Oracle Eloqua Data into Apache Solr
Use the CData Software JDBC Driver for Oracle Eloqua in Data Import Handler and create an automated import of Oracle Eloqua to Apache Solr Enterprise Search platform.
-
Connect to Confluence Data in CloverDX (formerly CloverETL)
Transfer Atlassian Confluence using the visual workflow in the CloverDX data integration tool.
-
Create Informatica Mappings From/To a JDBC Data Source for MailerLite
Create MailerLite data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData JDBC Driver for Square
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Square.
-
Create Informatica Mappings From/To a JDBC Data Source for Keap
Create Keap data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from Datadog to Databricks using CData SSIS Components.
Easily push Datadog to Databricks using the CData SSIS Tasks for Datadog and Databricks.
-
Replicate Salesforce Pardot Data from PowerShell
Write a quick PowerShell script to query Salesforce Pardot. Use connectivity to the live data to replicate Salesforce Pardot to SQL Server.
-
Integrate Gmail Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Gmail and integrate live Gmail into your Power Automate tasks.
-
Automated Continuous Monday.com Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Monday.com replication to AlloyDB.
-
Connect to SAP SuccessFactors LMS Data in Aqua Data Studio
Access SAP SuccessFactors LMS from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Front Data in HULFT Integrate
Connect to Front as a JDBC data source in HULFT Integrate
-
Migrating data from CSV to Snowflake using CData SSIS Components.
Easily push CSV/TSV Files to Snowflake using the CData SSIS Tasks for CSV and Snowflake.
-
Manage Perplexity Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Perplexity.
-
Integrate Perplexity Data in the Pentaho Report Designer
Publish reports based on Perplexity in the Pentaho BI tool.
-
Validate Parquet Data with QuerySurge
Access and validate Apache Parquet in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Freshdesk Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Freshdesk without replication.
-
Work with Redis Data in FoxPro
Load Redis into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import and Visualize Google Drive Data in Power View
Create data visualizations based on Google Drive in Excel.
-
Choosing the Best Method to Connect CData Connect AI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CData Connect AI from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Using the CData Software ODBC Driver for SAP Hybris C4C in PyCharm
Connect to SAP Hybris C4C as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Hybris C4C.
-
View Reports on Real-Time FreeAgent Data in Power BI Report Server
Use the CData ODBC Driver for FreeAgent to visualize FreeAgent in Power BI Desktop and then publish them to Power BI Report Server.
-
Provide OData Services of Google Calendar Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Calendar by developing a WCF Service Application.
-
Build SharePoint-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft SharePoint and build SharePoint-connected web apps with Axios.
-
Build REST-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live REST.
-
Use the CData ODBC Driver for Deel in Microsoft Power Query
You can use the CData Deel ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Deel into Microsoft Power Query.
-
Analyze Dynamics 365 Business Central Data in Looker
Use CData Connect AI to connect to Dynamics 365 Business Central Data from Looker and build custom apps using live Dynamics 365 Business Central.
-
Provide OData Services of SendPulse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SendPulse by developing a WCF Service Application.
-
Automated Continuous Basecamp Replication to Snowflake
Use CData Sync for automated, continuous, customizable Basecamp replication to Snowflake.
-
Import Real-Time Avro Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache Avro in ColdFusion.
-
Connect to Real-Time OneNote Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for OneNote and Dataflow to import and use Microsoft OneNote in Power Apps.
-
How to Work with Avro Data in ETL Validator JDBC
Connect to Avro from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to and Query Mode Data in QlikView over ODBC
Create data visualizations with Mode in QlikView.
-
Integrate with Vault CRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Veeva Vault & Vault CRM to a JSON file on disk.
-
Build Automated Microsoft Planner-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Planner and build automated workflows in Zapier.
-
Create IBM Cloud Object Storage-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to IBM Cloud Object Storage Data from OutSystems and build custom enterprise apps using live IBM Cloud Object Storage.
-
Feed Templated Data into FineReport
How to set Templated as a JDBC data source in FineReport.
-
Use JayDeBeApi to access WordPress Data in Python
Use standard Python scripting and the development environment of your choice to access live WordPress.
-
How to Connect the Power BI Service to GetResponse: Complete Guide
Connect to the CData Software Power BI Connector for GetResponse from PowerBI.com to provide real-time GetResponse across the organization.
-
Operational Reporting on TigerGraph Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote TigerGraph.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for FreshBooks
Provide connectivity to FreshBooks through an SAP BusinessObjects universe.
-
DataBind Controls to SAP HANA Data in Delphi
DataBind to SAP HANA in Delphi with standard data access components and controls.
-
Import Real-Time Landbot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Landbot in ColdFusion.
-
Query Samanage Data as a MySQL Database in Node.js
Execute MySQL queries against Samanage from Node.js.
-
Use the CData Software ODBC Driver for ChargeOver in MicroStrategy Desktop
Connect to ChargeOver in MicroStrategy Desktop using the CData Software ODBC Driver for ChargeOver.
-
Connect to LinkedIn Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live LinkedIn Ads from Filemaker Pro on Mac.
-
Connect to Hubstaff Data from a Connection Pool in JBoss
Integrate Hubstaff into Java servlets: Use the Management Console in JBoss to install the Hubstaff JDBC Driver.
-
Create ShipStation Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ShipStation from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Google Tasks Data in Coginiti Pro
Connect to and query live Google Tasks from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Landbot Data in Sisense
Create an ElastiCube in Sisense app with access to Landbot.
-
Access Notion Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Notion.
-
Integrate Hugging Face Data in Pentaho Data Integration
Build ETL pipelines based on Hugging Face in the Pentaho Data Integration tool.
-
Connect to Keap Data in HULFT Integrate
Connect to Keap as a JDBC data source in HULFT Integrate
-
Automated Continuous Procore Replication to MongoDB
Use CData Sync for automated, continuous, customizable Procore replication to MongoDB.
-
Query VWO Data in ColdFusion
Write standard ColdFusion data access code to connect to VWO.
-
How to create Apollo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apollo in MySQL .
-
Connect and Visualize Live DocuSign Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live DocuSign into the Databricks platform and create visualization dashboards with real-time DocuSign.
-
How to Connect to Live Outreach.io Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Outreach.io securely in real time.
-
Configure the CData JDBC Driver for Ontraport in a Connection Pool in Tomcat
Connect to Ontraport from a connection pool in Tomcat.
-
Integrating Codex CLI with Spotify 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.
-
Connect to SpaceX Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SpaceX and the SQL Gateway to access SpaceX from Google Apps Script.
-
Build a PostgreSQL Interface for SAP ByDesign Data using the CData JDBC Driver
Use the Remoting features of the SAP ByDesign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports with SharePoint Excel Services Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SharePoint Excel Services.
-
Query, Visualize, and Share live SAP Fieldglass Data in Redash
Use CData Connect AI to connect to live SAP Fieldglass in Redash for querying, visualizing, and sharing.
-
Build Semantic Layer Views for ClickTime Data in APOS Live Data Gateway
Use the CData Connector for ClickTime in APOS Live Data Gateway to build Semantic Layer Views for ClickTime.
-
Analyze LDAP Objects in Infragistics Reveal
Use the CData API Server to create an OData API on top of LDAP and visualize live LDAP in Infragistics Reveal.
-
Prepare, Blend, and Analyze SAP SuccessFactors LMS Data in Alteryx Designer (ODBC)
Build workflows to access live SAP SuccessFactors LMS for self-service data analytics.
-
Automated Continuous PagerDuty Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PagerDuty replication to Apache Kafka.
-
Integrate Goose with Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live IBM Informix from within the local AI agent.
-
Analyze Teradata Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Teradata and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Replicate CouchDB Data from PowerShell
Write a quick PowerShell script to query Apache CouchDB. Use connectivity to the live data to replicate Apache CouchDB to SQL Server.