CData Software - Knowledge Base
Recent Articles
-
Connect to Azure Synapse Data in Jaspersoft Studio
Execute SQL to remote Azure Synapse in Jaspersoft Studio.
-
Integrate with LDAP Objects in JReport Designer
Create charts and reports based on LDAP in JReport Designer.
-
DataBind Controls to Amazon Marketplace Data in Delphi
DataBind to Amazon Marketplace in Delphi with standard data access components and controls.
-
Publish Crystal Reports on Oracle Financials Cloud Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Financials Cloud.
-
Integrating Kiro CLI with Tally 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.
-
Bind Live Google Campaign Manager 360 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Campaign Manager 360 data
-
How to connect to Strava Data from Spring Boot
Connect to Strava in a Spring Boot Application using the CData API Driver for JDBC
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cloudflare
Provide connectivity to Cloudflare through an SAP BusinessObjects universe.
-
Connect to Twitter Ads Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Twitter Ads and the Script function in FileMaker Pro to connect to Twitter Ads and work with Twitter Ads in your FileMaker application.
-
Build Pipelines with Live Confluence Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Confluence from Google Cloud Data Fusion, enabling the integration of live Atlassian Confluence into the building and management of effective data pipelines.
-
Working with HubSpot Data in LINQPad
Execute LINQ queries to HubSpot in LINQPad.
-
Build Automated Power BI XMLA-Connected Workflows in Zapier
Use CData Connect AI to connect to live Power BI XMLA and build automated workflows in Zapier.
-
Design BIRT Reports on QuickBooks Online Data
Provide current QuickBooks Online to your embedded analytics.
-
Visualize GraphQL Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to GraphQL.
-
Create Data Visualizations in Cognos BI with Google Tasks Data
Access Google Tasks as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Wistia Replication to Snowflake
Use CData Sync for automated, continuous, customizable Wistia replication to Snowflake.
-
How to connect SharePoint with Confluence Data through external lists
Provide Atlassian Confluence to SharePoint users as an external list.
-
View Reports on Real-Time Flowlu Data in Power BI Report Server
Use the CData ODBC Driver for Flowlu to visualize Flowlu in Power BI Desktop and then publish them to Power BI Report Server.
-
Write a Simple Go Application to work with Bugsnag Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Bugsnag.
-
Connect to Adobe Analytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access Adobe Analytics in Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Raisers Edge NXT
Provide connectivity to Raisers Edge NXT through an SAP BusinessObjects universe.
-
Connect to IBM Cloud Object Storage Data from AWS Glue
Use CData Connect AI to gain access to live IBM Cloud Object Storage from your AWS Glue jobs.
-
Integrating AfterShip Data in Talend Cloud Data Management Platform
Connect AfterShip Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Manage Recurly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Recurly.
-
Use JayDeBeApi to access Miro Data in Python
Use standard Python scripting and the development environment of your choice to access live Miro.
-
Publish Crystal Reports on Pushbullet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pushbullet.
-
Connect to Azure Table Data from AWS Glue
Use CData Connect AI to gain access to live Azure Table Storage from your AWS Glue jobs.
-
Connect to Real-Time IBM Informix Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for IBM Informix and Dataflow to import and use IBM Informix in Power Apps.
-
Zendesk Reporting in OBIEE with the Zendesk JDBC Driver
Deploy the Zendesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Instagram from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Instagram, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Power BI Connector for CloudConvert
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Working with Pipeliner CRM Data in LINQPad
Execute LINQ queries to Pipeliner CRM in LINQPad.
-
Choosing the Best Method to Connect Basecamp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Basecamp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with Certinia Data
Access Certinia as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Exact Online 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 Exact Online.
-
How to Visualize Oracle SCM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle SCM in Python.
-
Integrating Boomi Agentstudio with Facebook Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Facebook, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData ODBC Driver for Phoenix in Microsoft Power Query
You can use the CData Phoenix ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Phoenix into Microsoft Power Query.
-
Feed CircleCI Data into FineReport
How to set CircleCI as a JDBC data source in FineReport.
-
How to Connect to Live Dropbox Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Dropbox securely in real time.
-
Access Live SharePoint Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft SharePoint in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build DocuSign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to DocuSign and build web apps with connectivity to live DocuSign.
-
Integrating GitHub Copilot CLI with XML Files 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.
-
Migrating data from Humanity to Snowflake using CData SSIS Components.
Easily push Humanity to Snowflake using the CData SSIS Tasks for Humanity and Snowflake.
-
ETL MessageBird in Oracle Data Integrator
This article shows how to transfer MessageBird into a data warehouse using Oracle Data Integrator.
-
Provide OData Services of Printify Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Printify by developing a WCF Service Application.
-
Automated Continuous Sage Cloud Accounting Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to SQLite.
-
Visualize Printful Data in Tableau
The CData ODBC driver for Printful enables you integrate Printful into Tableau dashboards.
-
Natively Connect to Jodoo Data in PHP
The CData ODBC driver for Jodoo enables you to create PHP applications with connectivity to Jodoo. Leverage the native support for ODBC in PHP.
-
Access Live YouTube Analytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to YouTube Analytics from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to and Query Google Campaign Manager 360 Data in QlikView over ODBC
Create data visualizations with Google Campaign Manager 360 in QlikView.
-
Integrate LibreChat with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live HubSpot from within the chat interface.
-
Build AI Agents with Pipedrive Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Pipedrive through CData Connect AI.
-
Use Biml to Build SSIS Tasks to Replicate Chargebee Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Chargebee to SQL Server.
-
Prepare, Blend, and Analyze PingOne Data in Alteryx Designer (ODBC)
Build workflows to access live PingOne for self-service data analytics.
-
Connect to REST Data in CloverDX (formerly CloverETL)
Transfer REST using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData ADO.NET Provider for Hugging Face
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Load Ontraport Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Ontraport to a database.
-
Analyze Live Airtable Data in SAS Viya
Use CData Connect AI to connect to Airtable from SAS Viya and deploy self-service analytics using live Airtable.
-
How to Query Live SQL Server Data in Claude Desktop
Connect to and query live SQL Server Data in Claude Desktop using CData MCP Server.
-
Integrating Claude Code with API Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on API within assisted coding and automated development workflows.
-
How to Connect to & Open Box Data in Microsoft Excel
This article uses the CData ODBC driver for Box to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Perform Batch Operations with Salesforce Data in Apache NiFi
Connect to Salesforce & Force.com and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Scrapfly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Scrapfly from your Oracle system.
-
Getting Started with the CData ADO.NET Provider for Printful
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Charts with Short.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Short.io in Clear Analytics.
-
Build a Simple VCL Application for Google Campaign Manager 360 Data
How to build a simple VCL Application to view Google Campaign Manager 360 in RAD Studio using the CData ODBC Driver for Google Campaign Manager 360.
-
Use the CData ODBC Driver for Okta from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Okta to connect to Okta from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Okta in Excel.
-
Natively Connect to Customer.io Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Customer.io. Leverage the native support for ODBC in PHP.
-
How to import Invoiced Data into Apache Solr
Use the CData Software JDBC Driver for Invoiced in Data Import Handler and create an automated import of Invoiced to Apache Solr Enterprise Search platform.
-
View Reports on Real-Time LaunchDarkly Data in Power BI Report Server
Use the CData ODBC Driver for LaunchDarkly to visualize LaunchDarkly in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to CSV Data in Google Apps Script via Connect AI
Use CData Connect AI to access CSV/TSV Files in Google Apps Script.
-
Use JayDeBeApi to access Calendly Data in Python
Use standard Python scripting and the development environment of your choice to access live Calendly.
-
How to Easily Query Printify Data in OpenOffice Base
Connect to Printify data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Marketo Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Marketo and the Script function in FileMaker Pro to connect to Marketo and work with Marketo in your FileMaker application.
-
Create CSV Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CSV data access from reports, embedded analytics, and more.
-
Bind Live Excel Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Excel Online data
-
Connect Zoho Inventory to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho Inventory with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Theia IDE with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Natively Connect to Adobe Commerce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Commerce. Leverage the native support for ODBC in PHP.
-
Access Live Gong Data in Excel 365 Online (Excel for the web)
Connect to Gong from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate CouchDB Data in Pentaho Data Integration
Build ETL pipelines based on Apache CouchDB in the Pentaho Data Integration tool.
-
Load Hugging Face Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Hugging Face to a database.
-
Work with Gumroad Data in FoxPro
Load Gumroad into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Datasets from Zoho Recruit in Domo Workbench and Build Visualizations of Zoho Recruit Data in Domo
Use the CData Software ODBC Driver for Zoho Recruit to create datasets from Zoho Recruit in Domo Workbench and then build visualizations in the Domo service.
-
Rapidly Develop Factorial-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Factorial.
-
Choosing the Best Method to Connect ZarMoney to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZarMoney from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Freshteam Data in Sisense
Create an ElastiCube in Sisense app with access to Freshteam.
-
Model Pipedrive Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Pipedrive, enabling the direct import of real-time Pipedrive.
-
Getting Started with the CData ODBC Driver for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle Eloqua Reporting.
-
FreshBooks Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to FreshBooks through CData Connect AI using different applications and tools.
-
Access Live Redshift Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Redshift from your Google Sheets.
-
Integrating Antigravity CLI with Box via CData CLI
Connect Box to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Vault CRM 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 Veeva Vault & Vault CRM.
-
Connect to OnePageCrm Data in RapidMiner
Integrate OnePageCrm with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Postmark Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Postmark with the CData JDBC Driver for Postmark.
-
How to Build an ETL App for Kintone Data in Python with CData
Create ETL applications and real-time data pipelines for Kintone in Python with petl.
-
Use the CData Software ODBC Driver for Zoho Recruit in MicroStrategy Web
Connect to Zoho Recruit in MicroStrategy Web using the CData Software ODBC Driver for Zoho Recruit.
-
Integrate Copper Data in the Pentaho Report Designer
Publish reports based on Copper in the Pentaho BI tool.
-
Automated Continuous Tickspot Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tickspot replication to OneLake in Microsoft Fabric.