CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live CSV Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your CSV/TSV Files for you.
-
Automated Continuous Supabase Replication to Vertica
Use CData Sync for automated, continuous, customizable Supabase replication to Vertica.
-
Create Datasets from BigCommerce in Domo Workbench and Build Visualizations of BigCommerce Data in Domo
Use the CData Software ODBC Driver for BigCommerce to create datasets from BigCommerce in Domo Workbench and then build visualizations in the Domo service.
-
Publish Crystal Reports on Airtable Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Airtable.
-
Connect to Real-Time Float Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Float in Power Apps.
-
Working with Google Calendar Data in LINQPad
Execute LINQ queries to Google Calendar in LINQPad.
-
Manage IBM Informix Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for IBM Informix.
-
Connect to Templated Data from a Connection Pool in JBoss
Integrate Templated into Java servlets: Use the Management Console in JBoss to install the Templated JDBC Driver.
-
How to connect and process Trello from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Trello.
-
Create a Data Access Object for Epicor Kinetic Data using JDBI
A brief overview of creating a SQL Object API for Epicor Kinetic in JDBI.
-
Integrating Boomi Agentstudio with Microsoft OneDrive Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft OneDrive, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Work with Live Oracle Service Cloud Data in Power Query
Use CData Connect AI to connect to Oracle Service Cloud and work with live Oracle Service Cloud in Microsoft Power Query.
-
Access Suadeo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Suadeo from HeidiSQL.
-
Publish Crystal Reports on Snapchat Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Snapchat Ads.
-
Query HubSpot Data as a SQL Server Database in Node.js
Execute SQL Server queries against HubSpot from Node.js.
-
Automated Continuous eBay Analytics Replication to MongoDB
Use CData Sync for automated, continuous, customizable eBay Analytics replication to MongoDB.
-
How to Seamlessly Import Tally Data into IBM SPSS Modeler
Integrate Tally data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Trigger HubDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for HubDB with standard wizards in Logic Apps.
-
LINQ to EnterpriseDB Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the EnterpriseDB Data Provider.
-
Automated Continuous HBase Replication to Vertica
Use CData Sync for automated, continuous, customizable HBase replication to Vertica.
-
Build Dashboards with Pingdom Data in DBxtra
Create dynamic dashboards and perform analytics based on Pingdom in DBxtra.
-
Getting Started with the CData Excel Add-In for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for IBM Cloud Object Storage.
-
Automated Continuous Optimizely Replication to MySQL
Use CData Sync for automated, continuous, customizable Optimizely replication to MySQL.
-
Automated Continuous Splunk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Splunk replication to Snowflake.
-
Analyze Live Google Ad Manager Data in SAS Viya
Use CData Connect AI to connect to Google Ad Manager from SAS Viya and deploy self-service analytics using live Google Ad Manager.
-
Viewing Freshsales Data in RAD Studio Data Explorer
How to view Freshsales in RAD Studio Data Explorer using the CData ODBC Driver for Freshsales.
-
Integrating Antigravity CLI with Front via CData CLI
Connect Front to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LangGraph with Outreach.io Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Outreach.io within automated workflows.
-
Explore Geographical Relationships in Redis Data with Power Map
Create data visualizations with Redis in Power Map.
-
Visualize Live Excel Online Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Excel Online.
-
Create SAP SuccessFactors LMS-Connected Business Apps in AppSheet
Connect to SAP SuccessFactors LMS Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP SuccessFactors LMS.
-
Connect WordPress Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your WordPress using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData ODBC Driver for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Snapchat Ads.
-
Use the CData Software ODBC Driver for Typeform in MicroStrategy Web
Connect to Typeform in MicroStrategy Web using the CData Software ODBC Driver for Typeform.
-
Use the CData Software ODBC Driver for Freshdesk in MicroStrategy
Connect to Freshdesk in MicroStrategy Developer using the CData Software ODBC Driver for Freshdesk.
-
Build Dashboards with Dynamics NAV Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Dynamics NAV in DBxtra.
-
Migrating data from Salesforce Data 360 to Google BigQuery using CData SSIS Components.
Easily push Salesforce Data 360 to Google BigQuery using the CData SSIS Tasks for Salesforce Data 360 and Google BigQuery.
-
Build Mode-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mode and build web apps with connectivity to live Mode.
-
Access SAP Data from MySQL in PHP
Connect to SAP through the standard MySQL libraries in PHP.
-
Integrating Claude Code CLI with Teradata 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.
-
Easily Integrate Instagram Data in Lazarus Pascal IDE
Learn how to easily integrate live Instagram in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for Webex from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Webex to connect to Webex from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Webex in Excel.
-
How to use SQLAlchemy ORM to access SAP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP ERP/NetWeaver.
-
Integrate Theia IDE with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Build an ETL App for Databricks Data in Python with CData Connect AI
Build ETL pipelines that read and write live Databricks in Python with petl and the CData Connect AI Python SDK.
-
Connect to Postmark Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Postmark to connect to Postmark and execute queries in PowerBuilder.
-
Replicate Multiple HDFS Accounts via the CData Sync CLI
Replicate multiple HDFS accounts to one or many databases.
-
Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy Web
Connect to SurveyMonkey in MicroStrategy Web using the CData Software JDBC Driver for SurveyMonkey.
-
Integrate Live HubSpot Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use CData Connect AI to Access Klaviyo Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Klaviyo in the Power Pivot business intelligence tool.
-
Connect to MailerLite Data in JRuby
Create a simple JRuby app with access to live MailerLite.
-
Integrate Theia IDE with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create Reports with Freshservice Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshservice.
-
DataBind ZohoSubscriptions Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoSubscriptions to a chart.
-
Connect to Pipeliner CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pipeliner CRM in the Denodo Virtual DataPort Administrator.
-
How to Work with Twilio Data in ETL Validator JDBC
Connect to Twilio from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Tally Data from IntelliJ
Integrate connectivity to Tally ERP with wizards in IntelliJ.
-
How to Connect DBeaver to Salesforce Data 360 via a JDBC Driver
Manage Salesforce Data 360 with visual tools in DBeaver like the query browser.
-
How to connect to Zoho Inventory Data with Squirrel SQL client
Connect to Zoho Inventory and execute queries in the Squirrel SQL Client.
-
Operational Reporting on Workable Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Workable.
-
Create Reports with Salesforce CRM Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce CRM Analytics.
-
Connect to Monday.com Data in CloverDX (formerly CloverETL)
Transfer Monday.com using the visual workflow in the CloverDX data integration tool.
-
Configure the CData JDBC Driver for LDAP in a Connection Pool in Tomcat
Connect to LDAP from a connection pool in Tomcat.
-
Automated Continuous QuickBooks Time Replication to AlloyDB
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to AlloyDB.
-
Connect to SAP Ariba Procurement Data in RapidMiner
Integrate SAP Ariba Procurement with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous SAS xpt Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAS xpt replication to PostgreSQL.
-
Create Dynamic LeadDesk Grids Using the Infragistics XamDataGrid
Learn how you can connect LeadDesk to Infragistics XamDataGrid to build dynamic grids.
-
Deploy the ADO.NET Provider for Jira Assets on an SSRS Report Server
Connect to Jira Assets from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Cursor CLI with ServiceDesk Plus 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.
-
Connect to CSV Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for CSV/TSV Files in Airbyte.
-
Automated Continuous CData Connect AI Replication to Oracle
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Oracle.
-
Analyze Phoenix Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Phoenix and visualize live Apache Phoenix in Infragistics Reveal.
-
Add SharePoint Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SharePoint with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to ConvertAPI Data in Ruby
Connect to ConvertAPI in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Dotmailer Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dotmailer in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect to Dynamics NAV Data from IntelliJ
Integrate connectivity to Microsoft Dynamics NAV with wizards in IntelliJ.
-
How to work with Google Ad Manager Data in Apache Spark using SQL
Access and process Google Ad Manager Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData ODBC Driver for NetSuite in MicroStrategy
Connect to NetSuite data in MicroStrategy Developer using the CData ODBC Driver for NetSuite.
-
Automated Continuous Impala Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Impala replication to Amazon Redshift.
-
Visualize Dynamics CRM Data in Tableau
The CData ODBC driver for Dynamics CRM enables you integrate Microsoft Dynamics CRM into Tableau dashboards.
-
Create BambooHR-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BambooHR Data from OutSystems and build custom enterprise apps using live BambooHR.
-
Extend Google Sheets with Greenhouse Data
Make calls to Greenhouse from Google Apps Script via the API Server.
-
Extract, Transform, and Load Telegram Data in Informatica PowerCenter
Create a simple Workflow for Telegram in Informatica PowerCenter.
-
Build Pipelines with Live Google Ads Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Ads from Google Cloud Data Fusion, enabling the integration of live Google Ads into the building and management of effective data pipelines.
-
How to work with Adobe Target Data in Apache Spark using SQL
Access and process Adobe Target Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Airtable Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Airtable in Airbyte.
-
Use Claude to Talk to Your PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your PayPal for you.
-
Create Dynamic BenchmarkEmail Grids Using the Infragistics XamDataGrid
Learn how you can connect BenchmarkEmail to Infragistics XamDataGrid to build dynamic grids.
-
Automate HubSpot Data Replication to Azure Data Lake
Use CData Sync to customize and automate HubSpot replication to Azure Data Lake.
-
Connect to Impala Data in HULFT Integrate
Connect to Impala as a JDBC data source in HULFT Integrate
-
Create Dynamic iContact Grids Using the Infragistics XamDataGrid
Learn how you can connect iContact to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Zuora Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zuora replication to delimited files (CSV/TSV).
-
Integrate with Confluence Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Atlassian Confluence in SnapLogic.
-
Use Grok to Talk to Your Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Act-On for you.
-
DataBind Controls to Microsoft Ads Data in Delphi
DataBind to Microsoft Ads in Delphi with standard data access components and controls.
-
Access Live Office 365 Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Office 365 from your Excel spreadsheets.
-
Integrating Kiro CLI with MarkLogic 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.
-
Connect to QuickBooks Data from PowerBuilder via ADO.NET
This article demonstrates how to access QuickBooks Desktop from Appeon PowerBuilder using the CData ADO.NET Provider for QuickBooks.
-
Create Tally Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tally from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Supabase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Supabase replication to IBM DB2.