CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for Exa Data
How to build a simple VCL Application to view Exa in RAD Studio using the CData ODBC Driver for Exa.
-
Connect to Oracle SCM Data in Jaspersoft Studio
Execute SQL to remote Oracle SCM in Jaspersoft Studio.
-
How to Seamlessly Import ZendeskSell Data into IBM SPSS Modeler
Integrate ZendeskSell data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build MVC Applications with Connectivity to Google Analytics Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Analytics from an ASP.NET MVC application.
-
Migrating data from Airtable to Snowflake using CData SSIS Components.
Easily push Airtable to Snowflake using the CData SSIS Tasks for Airtable and Snowflake.
-
Use Dash to Build to Web Apps on Copper Data
Create Python applications that use pandas and Dash to build Copper-connected web apps.
-
Connect to Google Search from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Search, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import Real-Time SendInBlue Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SendInBlue in ColdFusion.
-
Integrate with Authorize.Net Data in JReport Designer
Create charts and reports based on Authorize.Net in JReport Designer.
-
Replicate FreshBooks Data from PowerShell
Write a quick PowerShell script to query FreshBooks. Use connectivity to the live data to replicate FreshBooks to SQL Server.
-
Import Real-Time Teamgate Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Teamgate in ColdFusion.
-
Integrate Clio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Clio from Informatica Cloud.
-
Automated Continuous NetSuite Replication to AlloyDB
Use CData Sync for automated, continuous, customizable NetSuite replication to AlloyDB.
-
Connect to Oracle Service Cloud Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Service Cloud from PowerBuilder using the Oracle Service Cloud JDBC Driver.
-
Access Live Factorial Data in AWS Lambda
Connect to live Factorial in AWS Lambda using the CData JDBC Driver.
-
Import Basecamp Data Using Azure Data Factory
Use CData Connect AI to connect to Basecamp Data from Azure Data Factory and import live Basecamp.
-
Natively Connect to Monday.com Data in PHP
The CData ODBC driver for Monday.com enables you to create PHP applications with connectivity to Monday.com. Leverage the native support for ODBC in PHP.
-
Build Apps with Live Facebook Ads in Adalo using CData Connect AI
Use CData Connect AI to integrate live Facebook Ads into the Adalo platform and build custom mobile and web applications with real-time Facebook Ads.
-
Automated Continuous Microsoft Ads Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to PostgreSQL.
-
Feed Pushbullet Data into FineReport
How to set Pushbullet as a JDBC data source in FineReport.
-
Build Trello-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Trello to explore live Trello Data in Cursor to assist with building Trello-powered applications.
-
Automated Continuous VWO Replication to MongoDB
Use CData Sync for automated, continuous, customizable VWO replication to MongoDB.
-
Getting Started with the CData Power BI Connector for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Data Lake Storage.
-
Access Live MongoDB Data in Coginiti Pro
Connect to and query live MongoDB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Work with Accelo Data in FoxPro
Load Accelo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Onfleet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Onfleet with the CData JDBC Driver for Onfleet.
-
Validate LaunchDarkly Data with QuerySurge
Access and validate LaunchDarkly in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Zoho CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Amazon S3.
-
Connect to and Visualize Live Aweber Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Aweber.
-
Natively Connect to Azure DevOps Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure DevOps. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To an ODBC Data Source for MariaDB
Create an ODBC connection to MariaDB in Informatica and browse and transfer MariaDB.
-
Integrating Claude Code with SAP Hybris C4C Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Hybris C4C within assisted coding and automated development workflows.
-
Work with IBM Informix Data in FoxPro
Load IBM Informix into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to create Visio diagrams from Lakebase Data
Automatically update Lakebase with the changes you make to Visio master shapes.
-
Create Reports with Tavily Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tavily.
-
Natively Connect to Twitter Ads Data in PHP
The CData ODBC driver for Twitter Ads enables you to create PHP applications with connectivity to Twitter Ads. Leverage the native support for ODBC in PHP.
-
Use Biml to Build SSIS Tasks to Replicate OpenWeatherMap Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate OpenWeatherMap to SQL Server.
-
Automated Continuous ActiveCampaign Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to IBM DB2.
-
Connect to RSS Feeds from PowerBuilder via ADO.NET
This article demonstrates how to access RSS Feeds from Appeon PowerBuilder using the CData ADO.NET Provider for RSS.
-
How to connect to Excel Data from Spring Boot
Connect to Excel in a Spring Boot Application using the CData JDBC Driver for Excel
-
Use Databricks Agent Bricks to Talk to Your Microsoft Planner Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Planner for you.
-
Automated Continuous Ontraport Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Ontraport replication to AlloyDB.
-
Connect to JSON Services Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for JSON and the Script function in FileMaker Pro to connect to JSON and work with JSON in your FileMaker application.
-
How to Query Live Azure Table Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Table Storage data in natural language using Python.
-
Validate Pipeline CRM Data with QuerySurge
Access and validate Pipeline CRM in QuerySurge using the CData JDBC Driver.
-
Connect to PayPal Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for PayPal in Airbyte.
-
How to Easily Query Trello Data in OpenOffice Base
Connect to Trello data in OpenOffice Base using the CData ODBC Driver for Trello and generate reports with live data insights.
-
Enable the Mailgun JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mailgun.
-
Integrate with Sage 200 Data in JReport Designer
Create charts and reports based on Sage 200 in JReport Designer.
-
Build Charts with Cassandra Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache Cassandra in Clear Analytics.
-
Build a PostgreSQL Interface for Sage 300 Data using the CData JDBC Driver
Use the Remoting features of the Sage 300 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Cline with Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SingleStore from within your IDE.
-
How to create Jira federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Atlassian Jira in MySQL .
-
Getting Started with the CData Excel Add-In for Splunk
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Splunk.
-
Use ChatGPT to Talk to Your FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your FTP Servers for you.
-
Build Automated ADP-Connected Workflows in Zapier
Use CData Connect AI to connect to live ADP and build automated workflows in Zapier.
-
Connect to Avalara AvaTax Data in HULFT Integrate
Connect to Avalara AvaTax as a JDBC data source in HULFT Integrate
-
Use Databricks Agent Bricks to Talk to Your Twitter Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Twitter Ads for you.
-
Build Dashboards with Phoenix Data in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Phoenix in Dundas BI.
-
Integrate Freshdesk Data into Power Automate Desktop using CData Connect
CData Connect for Freshdesk Data enables you to integrate Freshdesk into workflows built using Microsoft Power Automate Desktop.
-
How to connect to HubDB Data from IntelliJ
Integrate connectivity to HubDB with wizards in IntelliJ.
-
Use Agno to Talk to Your SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP Fieldglass for you.
-
Connect to Gong Data in JRuby
Create a simple JRuby app with access to live Gong.
-
Connect to LinkedIn Data from Crystal Reports
Use CData Connect AI to connect to and report on live LinkedIn from Crystal Reports.
-
Connect to Mistral AI Data in DBArtisan
Use wizards in DBArtisan to configure Mistral AI as a data source.
-
Automate Confluence Data Replication to Azure Data Lake
Use CData Sync to customize and automate Atlassian Confluence replication to Azure Data Lake.
-
DataBind Controls to Campaigner Data in C++Builder
DataBind to Campaigner in C++Builder with standard components and controls.
-
Connect to Live Microsoft Ads Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Ads Data in CData Connect AI and connect to your Microsoft Ads from MicroStrategy.
-
Automated Continuous DocuSign Replication to SQLite
Use CData Sync for automated, continuous, customizable DocuSign replication to SQLite.
-
Build Pipelines with Live Slack Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Slack from Google Cloud Data Fusion, enabling the integration of live Slack into the building and management of effective data pipelines.
-
Add Pushbullet Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pushbullet with the Informatica Enterprise Data Catalog to classify and organize data.
-
Provide OData Services of Pipeline CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Pipeline CRM by developing a WCF Service Application.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Exchange Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Exchange for you.
-
LINQ to Avalara AvaTax 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 Avalara AvaTax Data Provider.
-
Access Live Neo4J Data in Coginiti Pro
Connect to and query live Neo4J from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Live QuickBooks Time Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to QuickBooks Time and integrate live QuickBooks Time into apps built in Microsoft Power Apps.
-
Visualize Live SingleStore Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SingleStore using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Splunk in MicroStrategy Web
Connect to Splunk in MicroStrategy Web using the CData Software JDBC Driver for Splunk.
-
Use ChatGPT to Talk to Your Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Amazon S3 for you.
-
Build AI/ML Models with Live Parquet Data using Dataiku
Connect Parquet Data with Dataiku using the CData JDBC Driver for Parquet.
-
Build EnterpriseDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live EnterpriseDB.
-
View Reports on Real-Time PagerDuty Data in Power BI Report Server
Use the CData ODBC Driver for PagerDuty to visualize PagerDuty in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Semantic Layer Views for SharePoint Excel Services Data in APOS Live Data Gateway
Use the CData Connector for SharePoint Excel Services in APOS Live Data Gateway to build Semantic Layer Views for SharePoint Excel Services.
-
Getting Started with the CData Tableau Connector for GetResponse
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing Cloud without replication.
-
Write a Simple Go Application to work with Zoho Recruit Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Recruit.
-
How to Connect to Live Amazon Marketplace Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Amazon Marketplace for you.
-
Connecting Mastra with MailChimp Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time MailChimp, no replication required.
-
Connect to Box Data from a Connection Pool in JBoss
Integrate Box into Java servlets: Use the Management Console in JBoss to install the Box JDBC Driver.
-
Back Up Certinia to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Certinia. In this article, we will employ an SSIS workflow to populate a database with Certinia data.
-
A PostgreSQL Interface for ZohoPeople Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZohoPeople JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live OData Services in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your OData for you.
-
Connect and Visualize Live DB2 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live IBM DB2 into the Databricks platform and create visualization dashboards with real-time IBM DB2.
-
Use Dash to Build Web Apps on API Data via CData Connect AI
Build interactive Dash web apps on live API using pandas and the CData Connect AI Python SDK.
-
Use Dash to Build Web Apps on Workday Data via CData Connect AI
Build interactive Dash web apps on live Workday using pandas and the CData Connect AI Python SDK.
-
Build a Simple VCL Application for SAP SuccessFactors LMS Data
How to build a simple VCL Application to view SAP SuccessFactors LMS in RAD Studio using the CData ODBC Driver for SAP SuccessFactors LMS.
-
Integrate JobNimbus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate JobNimbus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to JobNimbus.
-
Getting Started with the CData JDBC Driver for Klaviyo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Klaviyo.
-
Integrate with Coda Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Coda to a JSON file on disk.
-
Create CockroachDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CockroachDB from PowerBI.com to create Power BI Dataflows with real-time data.