CData Software - Knowledge Base
Recent Articles
-
Connect to Opsgenie Data from a Connection Pool in Jetty
The Opsgenie JDBC Driver supports connection pooling: This article shows how to connect faster to Opsgenie from Web apps in Jetty.
-
Getting Started with the CData Python Connector for Elasticsearch
Learn to install and license the CData Python Connector
-
How to create an RPA flow for AdRoll Data in UiPath Studio
Use the AdRoll ODBC Driver to create workflows that access real-time AdRoll without any coding.
-
Build MVC Applications with Connectivity to Aircall Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aircall from an ASP.NET MVC application.
-
Use Dash to Build Web Apps on Raisers Edge NXT Data via CData Connect AI
Build interactive Dash web apps on live Raisers Edge NXT using pandas and the CData Connect AI Python SDK.
-
Access Live Google Contacts Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Contacts data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Codex CLI with Invoiced 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.
-
Edit and Search External Avalara AvaTax Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Avalara AvaTax to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Avalara AvaTax Data objects that you can access from apps and the dashboard.
-
Integrate Facebook Ads Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Facebook Ads from Informatica Cloud.
-
Use the CData ODBC Driver for Rebilly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Rebilly to connect to Rebilly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Rebilly in Excel.
-
How to Easily Query Scrapfly Data in OpenOffice Base
Connect to Scrapfly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Design BIRT Reports on Zoho Recruit Data
Provide current Zoho Recruit to your embedded analytics.
-
Integrate Gong Data in the Pentaho Report Designer
Publish reports based on Gong in the Pentaho BI tool.
-
Validate Templated Data with QuerySurge
Access and validate Templated in QuerySurge using the CData JDBC Driver.
-
Publish FreshBooks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live FreshBooks.
-
Use the CData Software ODBC Driver for ADP in MicroStrategy
Connect to ADP in MicroStrategy Developer using the CData Software ODBC Driver for ADP.
-
Validate Accelo Data with QuerySurge
Access and validate Accelo in QuerySurge using the CData JDBC Driver.
-
Build SAP SuccessFactors LMS-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP SuccessFactors LMS and build web apps with connectivity to live SAP SuccessFactors LMS.
-
Connect to Klipfolio in SpagoBI
Create reports featuring live Klipfolio in SpagoBI Studio. Host Klipfolio reports on SpagoBI Server.
-
Connect Optimizely to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Optimizely using the CData Python MCP Server.
-
Connecting Local LLMs to Real-Time Data with CData MCP Server
Power LM Studio with CData MCP Server to run local LLMs on live data. Connect to SaaS apps, APIs, and databases for secure AI insights.
-
How to connect to Stack Exchange Data in DBVisualizer
Integrate Stack Exchange with visual data analysis tools and data connection wizards in DBVisualizer
-
Work with MailerSend Data in FoxPro
Load MailerSend into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to FHIR Data in DBArtisan
Use wizards in DBArtisan to configure FHIR as a data source.
-
Integrate ClickUp Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ClickUp from Informatica Cloud.
-
Query DocuSign Data in DataGrip
Create a Data Source for DocuSign in DataGrip and use SQL to query live DocuSign.
-
Connect to SAP ByDesign Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Business ByDesign in Airbyte.
-
Bidirectional Access to Google Cloud Storage Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Cloud Storage in Filemaker Pro for Mac or Windows.
-
How to publish and share Humanity Data dashboards with Tableau Server
The CData ODBC driver for Humanity enables you integrate Humanity into Tableau dashboards.
-
Access Live SAP Concur Data in AWS Lambda
Connect to live SAP Concur in AWS Lambda using the CData JDBC Driver.
-
How to Connect to & Open GraphQL Data in Microsoft Excel
This article uses the CData ODBC driver for GraphQL to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Power BI Reports on Real-Time OpenWeatherMap Data
Use the CData ODBC Driver for OpenWeatherMap to visualize OpenWeatherMap in Power BI Desktop.
-
Connect to GraphQL Data from AWS Glue
Use CData Connect AI to gain access to live GraphQL from your AWS Glue jobs.
-
Connect to Vimeo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Vimeo and the SQL Gateway to access Vimeo from Google Apps Script.
-
Connect to LinkedIn Ads Data from PowerBuilder via ADO.NET
This article demonstrates how to access LinkedIn Ads from Appeon PowerBuilder using the CData ADO.NET Provider for LinkedIn Ads.
-
How to Connect to Live Pipedrive 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 Pipedrive for you.
-
Integrate Theia IDE with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate Zoho Recruit with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho Recruit with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho Recruit.
-
Analyze WooCommerce Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of WooCommerce and visualize WooCommerce in SAP Analytics Cloud.
-
Automated Continuous FormSite Replication to MongoDB
Use CData Sync for automated, continuous, customizable FormSite replication to MongoDB.
-
Build Automated DocuSign-Connected Workflows in Zapier
Use CData Connect AI to connect to live DocuSign and build automated workflows in Zapier.
-
Bidirectional Access to OpenWeatherMap Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate OpenWeatherMap in Filemaker Pro for Mac or Windows.
-
Automated Continuous Retently Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Retently replication to Apache Cassandra.
-
Import Real-Time Couchbase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Couchbase in ColdFusion.
-
Connect Webex to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Webex using the CData Python MCP Server.
-
Analyze Elasticsearch Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Elasticsearch and visualize live Elasticsearch in Infragistics Reveal.
-
Automated Jira Assets Data Replication to Teradata
Use CData Sync to Customize and automate Jira Assets replication to Teradata.
-
Create Power BI Reports on Real-Time RabbitMQ Data
Use the CData ODBC Driver for RabbitMQ to visualize RabbitMQ in Power BI Desktop.
-
Visualize Live GitHub Data in the Power BI Service
Use CData Connect AI to connect to live GitHub and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Elasticsearch Data in ACL Analytics
Connect to Elasticsearch via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Elasticsearch.
-
Natively Connect to Pipedrive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pipedrive. Leverage the native support for ODBC in PHP.
-
How to Use a Microsoft Access Database to Update Sage Intacct Data in Real Time
Update Sage Intacct data by creating a linked table in Microsoft Access with the CData Sage Intacct ODBC Driver.
-
Integrate with AlloyDB Data in JReport Designer
Create charts and reports based on Google AlloyDB in JReport Designer.
-
How to connect to Google Search Results in DBVisualizer
Integrate Google Search with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate YouTube Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate YouTube Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to YouTube Analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SparkPost
Provide connectivity to SparkPost through an SAP BusinessObjects universe.
-
Create Apps from Amazon S3 Data in Qlik Sense Cloud
Use CData Connect AI to connect to Amazon S3 Data and build apps from live Amazon S3 in Qlik Sense Cloud.
-
How to Visualize Perigon Data in Python with pandas
Use pandas and other modules to analyze and visualize live Perigon in Python.
-
Query Jira Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Atlassian Jira and perform CRUD operations on Jira from Node.js.
-
Integrate Live SAP Ariba Source Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Ariba Source and integrate live SAP Ariba Source into apps built in Microsoft Power Apps.
-
Automated Continuous Testmonitor Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Testmonitor replication to Amazon S3.
-
Integrate Cursor with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Snowflake from within the editor.
-
Build Data Flows from PDFMonkey to SQL Server using SSIS
Easily back up PDFMonkey to SQL Server using the SSIS components for PDFMonkey.
-
Build Google Forms-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Forms and build web apps with connectivity to live Google Forms.
-
Integrate with live Google Campaign Manager 360 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Campaign Manager 360 in Jitterbit.
-
Build Adobe Commerce Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Adobe Commerce and build visualizations in Tableau Cloud.
-
Connect to Sage Cloud Accounting Data in ACL Analytics
Connect to Sage Business Cloud Accounting via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage Business Cloud Accounting.
-
Create Reports with Cassandra Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Cassandra.
-
Connect to Microsoft Dataverse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Codat Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Codat replication to OneLake in Microsoft Fabric.
-
Access MarkLogic Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MarkLogic from HeidiSQL.
-
Getting Started with the CData SSIS Components for SpaceX
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SpaceX.
-
Migrating data from ZohoMarketingHub to Databricks using CData SSIS Components.
Easily push ZohoMarketingHub to Databricks using the CData SSIS Tasks for ZohoMarketingHub and Databricks.
-
Query CouchDB Data in DataGrip
Create a Data Source for CouchDB in DataGrip and use SQL to query live Apache CouchDB.
-
Integrating Codex CLI with Azure Data Catalog 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.
-
Build a PostgreSQL Interface for PingOne Data using the CData JDBC Driver
Use the Remoting features of the PingOne JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Reckon Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Vault CRM Data in AWS Lambda
Connect to live Veeva Vault & Vault CRM in AWS Lambda using the CData JDBC Driver.
-
Rapidly Develop Campaigner-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 Campaigner.
-
Import API Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to API Data and provide access to live API for custom reports in the Power BI Service.
-
Use the CData Software ODBC Driver for Freshteam in MicroStrategy Desktop
Connect to Freshteam in MicroStrategy Desktop using the CData Software ODBC Driver for Freshteam.
-
How to create an RPA flow for Calendly Data in UiPath Studio
Use the Calendly ODBC Driver to create workflows that access real-time Calendly without any coding.
-
How to Create Power BI Visual Reports with Real-Time Planio Data
Use CData Power BI Connectors to visualize Planio in Power BI.
-
Extend Google Sheets with Amazon Marketplace Data
Make calls to Amazon Marketplace from Google Apps Script via the API Server.
-
Import Real-Time ElevenLabs Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ElevenLabs in ColdFusion.
-
Build Google Search-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Search Results and create custom apps in Mendix.
-
Integrating GitHub Copilot CLI with Discord 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.
-
Integrate Live Acumatica Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Acumatica from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Acumatica ERP.
-
Configure the CData JDBC Driver for SAP in a Connection Pool in Tomcat
Connect to SAP ERP/NetWeaver from a connection pool in Tomcat.
-
Enable the YouTube Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with YouTube Analytics.
-
Visualize JotForm Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to JotForm.
-
Create Dynamic Placid Grids Using the Infragistics XamDataGrid
Learn how you can connect Placid to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Pingdom Data in JRuby
Create a simple JRuby app with access to live Pingdom.
-
Create Data Visualizations Based On Oracle Financials Cloud Data in Mode
Use CData Connect AI to connect to Oracle Financials Cloud Data from Mode and build visualizations using live
-
Publish Crystal Reports on ConvertAPI Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ConvertAPI.
-
How to Query Live AlloyDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google AlloyDB data in natural language using Python.
-
Work with Live Vault CRM Data in Power Query
Use CData Connect AI to connect to Veeva Vault & Vault CRM and work with live Veeva Vault & Vault CRM in Microsoft Power Query.
-
Moving Data from Bright Data to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bright Data data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to use SQLAlchemy ORM to access Avalara AvaTax Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Avalara AvaTax.
-
Automated Continuous Tanda Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Tanda replication to Google Cloud SQL.