CData Software - Knowledge Base
Recent Articles
-
Publish Reports with BigQuery Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google BigQuery.
-
DataBind Charts to Microsoft Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Ads from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
DataBind Controls to Google Campaign Manager 360 Data in C++Builder
DataBind to Google Campaign Manager 360 in C++Builder with standard components and controls.
-
How to Access Live Box Data in Visual Studio Code via Cline
Run CData MCP Server for Box on Windows Subsytem for Linux (WSL) and connect to live Box from the Cline extension in Visual Studio Code.
-
Connect to PayPal Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live PayPal.
-
Connect to Stack Exchange from Asprova with CData Software ODBC Driver for Stack Exchange
This article shows how to connect faster to Stack Exchange data from Asprova.
-
Automated Continuous JSON Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable JSON replication to Apache Kafka.
-
How to integrate Miro with Apache Airflow
Access and process Miro in Apache Airflow using the CData JDBC Driver.
-
Import and Visualize Oracle Financials Cloud Data in Power View
Create data visualizations based on Oracle Financials Cloud in Excel.
-
Build Google Directory-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Directory Data and create custom apps in Bubble.
-
Access Live Shopify Data in TIBCO Data Virtualization
Use the Shopify Tibco DV Adapter to create a Shopify data source in TIBCO Data Virtualization Studio and gain access to live Shopify from your TDV Server.
-
Design BIRT Reports on Productboard Data
Provide current Productboard to your embedded analytics.
-
Access Oracle Eloqua Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle Eloqua from your Oracle system.
-
Visualize Live Marketo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Marketo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Reply.io Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Reply.io in Microsoft R Open.
-
Work with Superchat Data in FoxPro
Load Superchat into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate Metabase with Databricks Data
Use CData Connect AI to connect to live Databricks and create an interactive dashboard in Metabase from Databricks.
-
Automate Freshdesk Data Replication to Azure Data Lake
Use CData Sync to customize and automate Freshdesk replication to Azure Data Lake.
-
Feed Copper Data into FineReport
How to set Copper as a JDBC data source in FineReport.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics 365
Provide connectivity to Microsoft Dynamics 365 through an SAP BusinessObjects universe.
-
Use Biml to Build SSIS Tasks to Replicate JobNimbus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate JobNimbus to SQL Server.
-
Natively Connect to Zoom Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoom. Leverage the native support for ODBC in PHP.
-
Automate Google Ad Manager Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Ad Manager replication to Azure Data Lake.
-
Build Visualizations of Impala Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Impala in Birst.
-
Automated Continuous Lakebase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Lakebase replication to Azure SQL Database.
-
Automated Continuous Neo4J Replication to Vertica
Use CData Sync for automated, continuous, customizable Neo4J replication to Vertica.
-
Publish Reports with LightSpeedRetail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LightSpeedRetail.
-
Connect to Blackbaud FE NXT Data in RazorSQL
Connect to Blackbaud FE NXT from wizards and query Blackbaud FE NXT from the GUI in the RazorSQL database management tool.
-
Connect and Query Live Amazon S3 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon S3 into Databricks
-
Automate Apify Data Replication to Couchbase
Use CData Sync to Customize and automate Apify replication to Couchbase.
-
Configure the CData JDBC Driver for Oracle in a Connection Pool in Tomcat
Connect to Oracle Database from a connection pool in Tomcat.
-
Build a Singer.io Tap for SendInBlue With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendInBlue data using
-
Automate LaunchDarkly Data Replication to Azure Synapse
Use CData Sync to customize and automate LaunchDarkly replication to Azure Synapse.
-
Access Live Trello Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Trello through MCP integration.
-
Build Visualizations of Highrise Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Highrise CRM in Birst.
-
Object-Relational Mapping (ORM) with Stripe 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 Stripe into a Java-based ORM framework, Hibernate.
-
Integrating Kiro CLI with MariaDB 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 update Oracle Eloqua from Excel
This article explains how to transfer data from Excel to Oracle Eloqua using the Excel Add-In for Oracle Eloqua.
-
Back Up Coda to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Coda data.
-
Build Automated Workflows with Live Cassandra Data in Workato
Use CData Connect AI to connect to live Apache Cassandra and build automated workflows in Workato.
-
Create Power BI Reports on Real-Time Aha! Data
Use the CData ODBC Driver for Aha! to visualize Aha! in Power BI Desktop.
-
Integrate Live Pingdom Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pingdom to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Live Coinbase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Coinbase to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Greenhouse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Greenhouse from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Webex
Provide connectivity to Webex through an SAP BusinessObjects universe.
-
Automated Continuous Sybase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sybase replication to SQL Server.
-
Automated Continuous JotForm Replication to SingleStore
Use CData Sync for automated, continuous, customizable JotForm replication to SingleStore.
-
Use the CData Software ODBC Driver for Google Spanner in MicroStrategy Desktop
Connect to Google Spanner in MicroStrategy Desktop using the CData Software ODBC Driver for Google Spanner.
-
How to work with Calendly Data in Apache Spark using SQL
Access and process Calendly Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Nethunt in MicroStrategy Desktop
Connect to Nethunt in MicroStrategy Desktop using the CData Software JDBC Driver for Nethunt.
-
A PostgreSQL Interface for Harvest Data using the CData ODBC Driver
Use the SQL Gateway and Harvest ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to GetResponse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GetResponse to connect to GetResponse and execute queries in PowerBuilder.
-
How to Easily Query WordPress Data in OpenOffice Base
Connect to WordPress data in OpenOffice Base using the CData ODBC Driver for WordPress and generate reports with live data insights.
-
Connect to and Query Power BI XMLA Data in QlikView over ODBC
Create data visualizations with Power BI XMLA in QlikView.
-
Integrate with LionDesk Data in JReport Designer
Create charts and reports based on LionDesk in JReport Designer.
-
Visualize ZohoMarketingHub Data in TIBCO Spotfire through ADO.NET
Integrate ZohoMarketingHub into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Tableau Connector for Browserless
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze AdRoll Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for AdRoll from Power Pivot. You will use the Table Import Wizard to load AdRoll. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live Redis Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Redis using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Airtable-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Airtable to explore live Airtable Data in Claude Code to assist with building Airtable-powered applications.
-
Integrate Amazon Marketplace Data in the Pentaho Report Designer
Publish reports based on Amazon Marketplace in the Pentaho BI tool.
-
Integrate Live Wrike Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Wrike to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build a PostgreSQL Interface for Google Search Results using the CData JDBC Driver
Use the Remoting features of the Google Search JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Amazon DynamoDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Google Cloud SQL.
-
Adobe Analytics Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Adobe Analytics facts in real time.
-
Validate Neo4J Data with QuerySurge
Access and validate Neo4J in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Microsoft Entra ID Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Amazon S3.
-
Use the CData Software JDBC Driver for BigQuery in MicroStrategy Desktop
Connect to Google BigQuery in MicroStrategy Desktop using the CData Software JDBC Driver for BigQuery.
-
How to Work with Ontraport Data in AWS Glue Jobs Using JDBC
Connect to Ontraport from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Choosing the Best Method to Connect Sage Cloud Accounting to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage Business Cloud Accounting from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze SharePoint Excel Services Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SharePoint Excel Services in Microsoft R Open.
-
Replicate Shopify Data from PowerShell
Write a quick PowerShell script to query Shopify. Use connectivity to the live data to replicate Shopify to SQL Server.
-
Create Act CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Act CRM Data from Nintex Workflow Cloud and build custom workflows using live Act CRM.
-
How to publish and share AgileCRM Data dashboards with Tableau Server
The CData ODBC driver for AgileCRM enables you integrate AgileCRM into Tableau dashboards.
-
Visualize Presto Data in TIBCO Spotfire through ADO.NET
Integrate Presto into dashboards in TIBCO Spotfire.
-
Build Semantic Layer Views for Elorus Data in APOS Live Data Gateway
Use the CData Connector for Elorus in APOS Live Data Gateway to build Semantic Layer Views for Elorus.
-
How to load Google Search data into Elasticsearch via Logstash
Introducing a simple method to load Google Search data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Instagram 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 Instagram without replication.
-
DataBind Controls to Shippo Data in C++Builder
DataBind to Shippo in C++Builder with standard components and controls.
-
Getting Started with the CData ADO.NET Provider for Box
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Box.
-
Getting Started with the CData ADO.NET Provider for OData
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for OData.
-
Connect to SAP Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP in FileMaker Pro to connect to SAP and work with SAP ERP/NetWeaver in your FileMaker applications.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zuora within intelligent workflows.
-
Import Couchbase Data Using Azure Data Factory
Use CData Connect AI to connect to Couchbase Data from Azure Data Factory and import live Couchbase.
-
Integrate PhantomBuster Data in Pentaho Data Integration
Build ETL pipelines based on PhantomBuster in the Pentaho Data Integration tool.
-
Analyze Highrise Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Highrise CRM and visualize Highrise CRM in SAP Analytics Cloud.
-
Build Apps with Live SingleStore Data Using the Low-Code Development Platform of Mendix
Connect SingleStore with Mendix to build apps using the CData JDBC Driver for SingleStore.
-
Edit and Search External PostgreSQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PostgreSQL to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PostgreSQL Data objects that you can access from apps and the dashboard.
-
Create Informatica Mappings From/To a JDBC Data Source for LinkedIn
Create LinkedIn data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Publish Reports with LeadDesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LeadDesk.
-
Choosing the Best Method to Connect ZohoDesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoDesk from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Salesforce CRM Analytics Replication to SQLite
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to SQLite.
-
Visualize Bitly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Bitly.
-
Connect to Pipedrive Data from AWS Glue
Use CData Connect AI to gain access to live Pipedrive from your AWS Glue jobs.
-
Build Semantic Layer Views for ShipStation Data in APOS Live Data Gateway
Use the CData Connector for ShipStation in APOS Live Data Gateway to build Semantic Layer Views for ShipStation.
-
Build Agents in Relevance AI with Access to Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Authorize.Net within intelligent agent workflows.
-
Use Databricks Agent Bricks to Talk to Your WooCommerce Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your WooCommerce for you.
-
Integrate Avro Data in the Pentaho Report Designer
Publish reports based on Apache Avro in the Pentaho BI tool.
-
Process & Analyze AgileCRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live AgileCRM Data.
-
Integrate with Jira Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Atlassian Jira to a JSON file on disk.