CData Software - Knowledge Base
Recent Articles
-
Connect to SAP BusinessObjects BI Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI data and execute queries in PowerBuilder.
-
Analyze Amazon S3 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon S3 data and visualize live Amazon S3 data in Infragistics Reveal.
-
Build Data Flows from SQL Server to Quickbase through SSIS
Easily push SQL Server data to Quickbase using the CData SSIS Tasks for Quickbase.
-
Connect to Paymo Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Paymo data in Airbyte.
-
How to connect to SageHR Data in DBVisualizer
Integrate SageHR data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Optimizely Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Optimizely and the SQL Gateway to access Optimizely data from Google Apps Script.
-
Use the CData Software JDBC Driver for Insightly in MicroStrategy Web
Connect to Insightly data in MicroStrategy Web using the CData Software JDBC Driver for Insightly.
-
Connect to and Query Google Translate Data in QlikView over ODBC
Create data visualizations with Google Translate data in QlikView.
-
Automated Continuous SingleStore Replication to Snowflake
Use CData Sync for automated, continuous, customizable SingleStore replication to Snowflake.
-
Build FreshBooks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for FreshBooks Data and create custom apps in Bubble.
-
How to publish and share Pipedrive Data dashboards with Tableau Server
The CData ODBC driver for Pipedrive enables you integrate Pipedrive data into Tableau dashboards.
-
Migrating data from Egnyte to Snowflake using CData SSIS Components.
Easily push Egnyte data to Snowflake using the CData SSIS Tasks for Egnyte and Snowflake.
-
How to Access Accelo Data Using Entity Framework
This article shows how to access Accelo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData ODBC Driver for Basecamp from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Basecamp to connect to Basecamp data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Basecamp data in Excel.
-
DataBind CloudConvert Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide CloudConvert data to a chart.
-
DataBind Controls to Clockify Data in C++Builder
DataBind to Clockify data in C++Builder with standard components and controls.
-
Choosing the Best Method to Connect CSV to SQL Server: 5 Options Explained
Discover multiple ways to connect and use CSV data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Microsoft Exchange Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Exchange data replication to Teradata.
-
Automated Continuous ConvertKit Replication to MongoDB
Use CData Sync for automated, continuous, customizable ConvertKit replication to MongoDB.
-
Operational Reporting on Eventbrite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Eventbrite data.
-
Stream LDAP Objects into Apache Kafka Topics
Access and stream LDAP objects in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Gumroad Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Gumroad replication to Amazon S3.
-
Connect to Instantly Data from PowerBuilder via JDBC
This article demonstrates how to access Instantly data from PowerBuilder using the Instantly JDBC Driver.
-
Build Sage 300-Connected Apps in Choreo
Use CData Connect AI to connect to Sage 300 Data from Choreo and build custom apps using live Sage 300 data.
-
Getting Started with the CData Tableau Connector for Procore
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automate ShipStation Data Replication to Azure Data Lake
Use CData Sync to customize and automate ShipStation data replication to Azure Data Lake.
-
Integrate Basecamp Data into Power Automate Desktop using CData Connect
CData Connect for Basecamp Data enables you to integrate Basecamp data into workflows built using Microsoft Power Automate Desktop.
-
Integrate with Coda Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Coda data in SnapLogic.
-
Bridge Billsby Connectivity with Apache NiFi
Access and process Billsby data in Apache NiFi using the CData JDBC Driver.
-
Visualize Xero Data in TIBCO Spotfire through ADO.NET
Integrate Xero data into dashboards in TIBCO Spotfire.
-
How to import Phoenix Data into Apache Solr
Use the CData Software JDBC Driver for Phoenix in Data Import Handler and create an automated import of Phoenix data to Apache Solr Enterprise Search platform.
-
Feed Oracle HCM Cloud Data into FineReport
How to set Oracle HCM Cloud data as a JDBC data source in FineReport.
-
Automated Continuous BambooHR Replication to SQL Server
Use CData Sync for automated, continuous, customizable BambooHR replication to SQL Server.
-
Visualize Splunk Data in TIBCO Spotfire through OData
Integrate Splunk data into dashboards in TIBCO Spotfire.
-
Create Reports with Salesforce Marketing Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce Marketing data.
-
How to integrate OneNote with Apache Airflow
Access and process OneNote data in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Asana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Asana data.
-
Import Bannerbear Data Using Azure Data Factory
Use CData Connect AI to connect to Bannerbear Data from Azure Data Factory and import live Bannerbear data.
-
Connect to Slack from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Slack data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Python Connector for Quickbase
Learn to install and license the CData Python Connector and configure a connection to live Quickbase data.
-
CData Sync’s Enhanced CDC vs Traditional CDC: A Performance Comparison
Testing how much faster Sync is able to replicate changes using Enhanced CDC vs Traditional CDC.
-
How to Create Power BI Visual Reports with Real-Time Sybase IQ Data
Use CData Power BI Connectors to visualize Sybase IQ data in Power BI.
-
Automated Continuous Klipfolio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Klipfolio replication to SQL Server.
-
Integrating OpenCode with AdRoll 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 Create Power BI Visual Reports with Real-Time Supabase Data
Use CData Power BI Connectors to visualize Supabase data in Power BI.
-
How to Build an ETL App for Odoo Data in Python with CData Connect AI
Build ETL pipelines that read and write live Odoo data in Python with petl and the CData Connect AI Python SDK.
-
Integrate with Excel Data in JReport Designer
Create charts and reports based on Excel data in JReport Designer.
-
How to Connect to Live Oracle SCM 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 Oracle SCM data for you.
-
Create Dynamic Google Spanner Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Spanner to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Zoom Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoom data for self-service data analytics.
-
Access Toggl Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Toggl data from your Oracle system.
-
How to connect to Retently Data from Spring Boot
Connect to Retently in a Spring Boot Application using the CData API Driver for JDBC
-
Query Live xBase Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live xBase data through a conversational interface.
-
Integrate Real-Time Access to Teradata in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Teradata data in real time.
-
Process & Analyze Dotmailer Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dotmailer Data.
-
Connect to Keap Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Keap and work with Keap data in your FileMaker application.
-
How to Connect the Power BI Service to Vercel: Complete Guide
Connect to the CData Software Power BI Connector for Vercel from PowerBI.com to provide real-time Vercel data across the organization.
-
Create Apps from NetSuite SuiteAnalytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data and build apps from live NetSuite SuiteAnalytics data in Qlik Sense Cloud.
-
Connect to Live Printify Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Printify in CData Connect AI and connect to your Printify data from PostgreSQL.
-
Use the CData Software ODBC Driver for CouchDB in SAS for Real-Time Reporting and Analytics
Connect to real-time CouchDB data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CouchDB.
-
Connect and Query Live ShipEngine Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ShipEngine data into Databricks and enable direct, live querying and analysis without replication.
-
Create Data Visualizations in Cognos BI with Gumroad Data
Access Gumroad data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bidirectional Access to Zoho Inventory Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Inventory data in Filemaker Pro for Mac or Windows.
-
Integrate Live Sendwithus Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Sendwithus data from within the IDE.
-
Prepare, Blend, and Analyze Marketo Data in Alteryx Designer (Connect AI)
Build workflows to access live Marketo data for self-service data analytics.
-
Use Manus AI to Talk to Your Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Kintone data.
-
Connect to Redshift Data from PowerBuilder via JDBC
This article demonstrates how to access Redshift data from PowerBuilder using the Redshift JDBC Driver.
-
Integrating Claude Code CLI with Vault CRM 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.
-
Use the CData Software ODBC Driver for Google Tasks in MicroStrategy Desktop
Connect to Google Tasks data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Tasks.
-
Connect to MarkLogic Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MarkLogic data in Airbyte.
-
Connect to Salesforce Data 360 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Data 360 in FileMaker Pro to connect to Salesforce Data 360 and work with Salesforce Data 360 data in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce CRM Analytics data within intelligent agent workflows.
-
Create Zoho Creator-Connected Dashboards in Grafana
Connect to Zoho Creator Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Creator data.
-
Add Amplitude Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amplitude with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Create Power BI Visual Reports with Real-Time Sybase Data
Use CData Power BI Connectors to visualize Sybase data in Power BI.
-
Connect to Confluence Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Confluence data in Airbyte.
-
Connect to LinkedIn Data from a Connection Pool in Jetty
The LinkedIn JDBC Driver supports connection pooling: This article shows how to connect faster to LinkedIn data from Web apps in Jetty.
-
Query Klaviyo Data in DataGrip
Create a Data Source for Klaviyo in DataGrip and use SQL to query live Klaviyo data.
-
Connect to Helpscout from a Connection Pool in WebLogic
Use the CData JDBC Driver for Helpscout to connect to Helpscout data from Web applications running on WebLogic.
-
Integrating Claude Code CLI with Microsoft Dataverse 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.
-
A PostgreSQL Interface for Sybase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sybase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Paylocity-Connected Business Apps in AppSheet
Connect to Paylocity Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Paylocity data.
-
DataBind Controls to Twilio Data in C++Builder
DataBind to Twilio data in C++Builder with standard components and controls.
-
Integrate with QuickBooks Time Data in JReport Designer
Create charts and reports based on QuickBooks Time data in JReport Designer.
-
Pipedrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Pipedrive data through CData Connect AI using different applications and tools.
-
Create Pipeline CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pipeline CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Troubleshooting Column Size Restrictions in Microsoft Query
Microsoft Query limits the total size of all columns selected. When all columns are selected, this may result in an error. The solution is to set the Maximum Column Size property.
-
Using the CData Software ODBC Driver for SAP HANA in PyCharm
Connect to SAP HANA as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP HANA.
-
Create SSAS Tabular Models from SAP ByDesign Data
How to build a SQL Server Analysis Service Tabular Model from SAP ByDesign data using CData drivers.
-
Use the CData Software ODBC Driver for XML in MicroStrategy
Connect to XML data in MicroStrategy Developer using the CData Software ODBC Driver for XML.
-
Access Redis Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Redis data from your Oracle system.
-
ETL Aircall in Oracle Data Integrator
This article shows how to transfer Aircall data into a data warehouse using Oracle Data Integrator.
-
Access Webflow Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Webflow data from HeidiSQL.
-
How to connect PolyBase to FTP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FTP data.
-
Model, Search, and Visualize Live SurveyMonkey Data in ThoughtSpot
Use CData Connect AI to connect to live SurveyMonkey data for modeling, searching, and visualizing.
-
How to Build an ETL App for Avalara AvaTax Data in Python with CData
Create ETL applications and real-time data pipelines for Avalara AvaTax data in Python with petl.
-
Build Apps with Live ZohoMarketingHub Data Using the Low-Code Development Platform of Mendix
Connect ZohoMarketingHub data with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for ConvertAPI in MicroStrategy
Connect to ConvertAPI data in MicroStrategy Developer using the CData Software ODBC Driver for ConvertAPI.
-
Create a Data Access Object for Unbounce Data using JDBI
A brief overview of creating a SQL Object API for Unbounce data in JDBI.
-
Connect and Visualize Live MySQL Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MySQL data into the Databricks platform and create visualization dashboards with real-time MySQL data.