CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in Outlook Data with Power Map
Create data visualizations with Outlook data in Power Map.
-
Build SAP Hybris C4C-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Hybris C4C Data and create custom apps in Bubble.
-
Integrate Trae with Live Azure DevOps Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Azure DevOps data from within the AI-powered IDE.
-
Integrate Basecamp Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Basecamp data from Informatica Cloud.
-
Connect to BigCommerce Data from a Connection Pool in Jetty
The BigCommerce JDBC Driver supports connection pooling: This article shows how to connect faster to BigCommerce data from Web apps in Jetty.
-
Design BIRT Reports on ZeroBounce Data
Provide current ZeroBounce data to your embedded analytics.
-
Rapidly Develop SuiteCRM-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 SuiteCRM.
-
How to Build an ETL App for Egnyte Data in Python with CData Connect AI
Extract and transform live Egnyte data in Python with petl and the CData Connect AI Python SDK.
-
Replicate Klipfolio Data to Multiple Databases via the CData Sync CLI
Replicate Klipfolio data to disparate databases with a single configuration.
-
Integrate with eBay Analytics Data in JReport Designer
Create charts and reports based on eBay Analytics data in JReport Designer.
-
Natively Connect to Zuora Data in PHP
The CData ODBC driver for Zuora enables you to create PHP applications with connectivity to Zuora data. Leverage the native support for ODBC in PHP.
-
Integrating Gumloop with GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on GraphQL data within automated workflows.
-
Access Live Amazon S3 Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Amazon S3 data through MCP integration.
-
Deploy the ADO.NET Provider for ClickUp on an SSRS Report Server
Connect to ClickUp data 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.
-
Connect to Klipfolio Data from AWS Glue
Use CData Connect AI to gain access to live Klipfolio data from your AWS Glue jobs.
-
Viewing Recurly Data in RAD Studio Data Explorer
How to view Recurly data in RAD Studio Data Explorer using the CData ODBC Driver for Recurly.
-
Create MYOB AccountRight Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MYOB AccountRight data access from reports, embedded analytics, and more.
-
Integrate Google's Vertex AI Agent with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Okta data within intelligent workflows.
-
Use Agno to Talk to Your Google Contacts 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 Google Contacts data for you.
-
How to connect to Klaviyo Data from Spring Boot
Connect to Klaviyo in a Spring Boot Application using the CData JDBC Driver for Klaviyo
-
Integrate Clio Data in the Pentaho Report Designer
Publish reports based on Clio data in the Pentaho BI tool.
-
Build Optimizely Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Optimizely data and build visualizations in Tableau Cloud.
-
Getting Started with the CData ADO.NET Provider for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Excel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Excel data access from reports, embedded analytics, and more.
-
Integrating GitHub Copilot with Dropbox 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.
-
Manage SendPulse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SendPulse.
-
Integrate Cline with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Databricks data from within your IDE.
-
How to Access Klaviyo Data Using Entity Framework
This article shows how to access Klaviyo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Amazon Athena Data from PowerBuilder via ADO.NET
This article demonstrates how to access Amazon Athena data from Appeon PowerBuilder using the CData ADO.NET Provider for Amazon Athena.
-
Integrate Devin with Live SAP Concur Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SAP Concur data.
-
How to Connect to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Getting Started with the CData ODBC Driver for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Business Warehouse.
-
How to Connect to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data for you.
-
Create Dashboards and Visualize Live Amazon S3 Data in Geckoboard
Use CData Connect AI to connect to live Amazon S3 data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access FHIR Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FHIR data from HeidiSQL.
-
Create SSAS Tabular Models from Trello Data
How to build a SQL Server Analysis Service Tabular Model from Trello data using CData drivers.
-
Automate Simplesat Data Replication to SAP HANA
Use CData Sync to customize and automate Simplesat data replication to SAP HANA.
-
Connect to Couchbase Data from HeidiSQL
Use CData Connect AI to connect to and query live Couchbase data from HeidiSQL.
-
Publish Crystal Reports on Auth0 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Auth0 data.
-
Working with Trello Data in LINQPad
Execute LINQ queries to Trello data in LINQPad.
-
Create a Data Access Object for Productboard Data using JDBI
A brief overview of creating a SQL Object API for Productboard data in JDBI.
-
Use JayDeBeApi to access Jodoo Data in Python
Use standard Python scripting and the development environment of your choice to access live Jodoo data.
-
How to Visualize Zoho Books Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Zoho Books data in Python.
-
How to Query Live Sybase IQ Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sybase IQ data data in natural language using Python.
-
Connect to Redis from Asprova with CData Software ODBC Driver for Redis
This article shows how to connect faster to Redis data from Asprova.
-
Use ChatGPT to Talk to Your CSV 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 CSV data for you.
-
Publish Reports with ClickTime Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ClickTime data.
-
Build Data Flows from Datadog to SQL Server using SSIS
Easily back up Datadog data to SQL Server using the SSIS components for Datadog.
-
Visualize Live Eventbrite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Eventbrite data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData SSIS Components to Insert New or Update Existing SharePoint Excel Services Records from SQL Server
Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SharePoint Excel Services or update existing records with data from a SQL Server database.
-
Visualize Live Zuora Data in the Power BI Service
Use CData Connect AI to connect to live Zuora data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Excel Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Excel replication to Google BigQuery.
-
A PostgreSQL Interface for Instagram Data (MySQL Remoting via JDBC)
Use the Remoting features of the Instagram JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Jira Assets Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Jira Assets replication to Amazon Redshift.
-
Automated Continuous Google Campaign Manager 360 Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to SQLite.
-
Automated Continuous Short.io Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Short.io replication to AlloyDB.
-
Use the CData Software JDBC Driver for Oracle in MicroStrategy Desktop
Connect to Oracle data in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle.
-
Manage Clockify Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Clockify.
-
Getting Started with the CData Connect AI Python SDK for JSON
Install the CData Connect AI Python SDK to read and write live JSON services with standard DB-API 2.0 Python code.
-
Replicate Codat Data in Heroku for Use in Salesforce Connect
Replicate Codat data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated QuickBooks Time Data Replication to Teradata
Use CData Sync to Customize and automate QuickBooks Time data replication to Teradata.
-
Migrating data from Recurly to Snowflake using CData SSIS Components.
Easily push Recurly data to Snowflake using the CData SSIS Tasks for Recurly and Snowflake.
-
Build Omnisend-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Omnisend data.
-
Getting Started with the CData SSIS Components for Ontraport
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Ontraport.
-
Access Live Cosmos DB Data in AWS Lambda
Connect to live Cosmos DB data in AWS Lambda using the CData JDBC Driver.
-
Back Up RSS feeds to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for RSS. In this article, we will employ an SSIS workflow to populate a database with RSS feeds data.
-
Getting Started with the CData ODBC Driver for Oracle
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle.
-
Natively Connect to Billsby Data in PHP
The CData ODBC driver for Billsby enables you to create PHP applications with connectivity to Billsby data. Leverage the native support for ODBC in PHP.
-
DataBind Controls to ADP Data in Delphi
DataBind to ADP data in Delphi with standard data access components and controls.
-
Feed Bitbucket Data into FineReport
How to set Bitbucket data as a JDBC data source in FineReport.
-
Automated Continuous MongoDB Replication to SQLite
Use CData Sync for automated, continuous, customizable MongoDB replication to SQLite.
-
LINQ to Stripe 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 Stripe Data Provider.
-
Analyze AlloyDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of AlloyDB data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Work with Live Supabase Data in Power Query
Use CData Connect AI to connect to Supabase data and work with live Supabase data in Microsoft Power Query.
-
Publish Act-On-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Act-On data.
-
Connecting Mastra with Slack 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 Slack data, no replication required.
-
How to Connect the Power BI Service to AdRoll: Complete Guide
Connect to the CData Software Power BI Connector for AdRoll from PowerBI.com to provide real-time AdRoll data across the organization.
-
Query FreeAgent Data as a MySQL Database in Node.js
Execute MySQL queries against FreeAgent data from Node.js.
-
Use the CData ODBC Driver for Instantly in Microsoft Power Query
You can use the CData Instantly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Instantly data into Microsoft Power Query.
-
Build HCL Domino-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to HCL Domino Data from Zoho Analytics and import live HCL Domino data.
-
Object-Relational Mapping (ORM) with ZohoMarketingHub 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 ZohoMarketingHub data into a Java-based ORM framework, Hibernate.
-
Building Dynamic Web Pages with Exact Online Data Using AngularJS
Create single-page applications with live connectivity to Exact Online using the CData API Server.
-
Access Live Figshare Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Figshare data into the statistical analysis tools available in SAS JMP. This article shows how to use Figshare data in the Graph Builder and Query Builder.
-
MessageBird Reporting in OBIEE with the MessageBird JDBC Driver
Deploy the MessageBird JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Provide OData Services of VWO Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for VWO data by developing a WCF Service Application.
-
Publish Crystal Reports on Clari Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clari data.
-
Integrating Gumloop with Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Gmail data within automated workflows.
-
How to Query Webflow Data in MySQL Workbench
Execute MySQL queries against live Webflow data from MySQL Workbench.
-
Connect to SAP SuccessFactors LMS Data in NetBeans
Connect to SAP SuccessFactors LMS data in NetBeans with the data source configuration wizard.
-
Create Monday.com-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Monday.com Data from OutSystems and build custom enterprise apps using live Monday.com data.
-
Working with Access Data in LINQPad
Execute LINQ queries to Access data in LINQPad.
-
Create SSAS Tabular Models from Apollo Data
How to build a SQL Server Analysis Service Tabular Model from Apollo data using CData drivers.
-
Validate LightSpeedRetail Data with QuerySurge
Access and validate LightSpeedRetail data in QuerySurge using the CData JDBC Driver.
-
Query Slack Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Slack data from Node.js.
-
Build Data Flows from SQL Server to Cosmos DB through SSIS
Easily push SQL Server data to Cosmos DB using the CData SSIS Tasks for Cosmos DB.
-
How to Work with SendGrid Data in ETL Validator JDBC
Connect to SendGrid from ETL Validator jobs using the CData Software JDBC Driver.
-
Object-Relational Mapping (ORM) with Paylocity 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 Paylocity data into a Java-based ORM framework, Hibernate.
-
Connect to Pipedrive Data from HeidiSQL
Use CData Connect AI to connect to and query live Pipedrive data from HeidiSQL.
-
Import and Visualize Simplesat Data in Power View
Create data visualizations based on Simplesat data in Excel.
-
ETL Clari in Oracle Data Integrator
This article shows how to transfer Clari data into a data warehouse using Oracle Data Integrator.