CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LaunchDarkly
Provide connectivity to LaunchDarkly data through an SAP BusinessObjects universe.
-
Use Biml to Build SSIS Tasks to Replicate LinkedIn Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LinkedIn Ads data to SQL Server.
-
Visualize Pipeline CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Pipeline CRM data.
-
Query Salesloft Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesloft entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for Notion
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Discord-Connected Nintex Workflows
Use CData Connect AI to connect to Discord Data from Nintex Workflow Cloud and build custom workflows using live Discord data.
-
Publish Crystal Reports on Retently Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Retently data.
-
How to Connect to SurveyMonkey Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SurveyMonkey data. Leverage the pyodbc module for ODBC in Python.
-
Work with Live SQL Analysis Services Data in Power Query
Use CData Connect AI to connect to SQL Analysis Services data and work with live SQL Analysis Services data in Microsoft Power Query.
-
Connect to Cloudant Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Cloudant data in Airbyte.
-
Connect to Contentful Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Contentful as an External Source in Dremio.
-
Use Grok to Talk to Your SAP Concur 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 SAP Concur data for you.
-
Automated Continuous Attio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Attio replication to Amazon Redshift.
-
Access Webflow Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Webflow data.
-
Connect to DB2 Data in ACL Analytics
Connect to DB2 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to DB2 data.
-
Connect to Adobe Analytics Data in Ruby
Connect to Adobe Analytics data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Work with MYOB AccountRight Data in ETL Validator JDBC
Connect to MYOB AccountRight from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for CockroachDB in MicroStrategy Desktop
Connect to CockroachDB data in MicroStrategy Desktop using the CData Software ODBC Driver for CockroachDB.
-
Build a Singer.io Tap for MailerSend With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MailerSend data using the CData Python Connector.
-
How to Access Customer.io Data Using Entity Framework
This article shows how to access Customer.io data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Hive Data in DBeaver
Use the CData ODBC Driver to connect to Hive data in DBeaver.
-
Integrate Trae with Live Zoho CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Zoho CRM data from within the AI-powered IDE.
-
How to Connect to Live WordPress Data 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 WordPress data for you.
-
Automate Recurly Data Replication to Azure Data Lake
Use CData Sync to customize and automate Recurly data replication to Azure Data Lake.
-
Access Oracle Eloqua Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Oracle Eloqua data.
-
Automate Keap Data Replication to Azure Synapse
Use CData Sync to customize and automate Keap data replication to Azure Synapse.
-
Use Dash to Build to Web Apps on Dynamics NAV Data
Create Python applications that use pandas and Dash to build Dynamics NAV-connected web apps.
-
How to Build an ETL App for Onfleet Data in Python with CData
Create ETL applications and real-time data pipelines for Onfleet data in Python with petl.
-
How to Connect DBeaver to LinkedIn via a JDBC Driver
Manage LinkedIn data with visual tools in DBeaver like the query browser.
-
Integrating Codex with PostgreSQL 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 Google Spanner Data from a Connection Pool in Jetty
The Google Spanner JDBC Driver supports connection pooling: This article shows how to connect faster to Google Spanner data from Web apps in Jetty.
-
Automate Tickspot Data Replication to Azure Data Lake
Use CData Sync to customize and automate Tickspot data replication to Azure Data Lake.
-
Use the CData Software ODBC Driver for Quickbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Quickbase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Quickbase.
-
Build SAP SuccessFactors LMS-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP SuccessFactors LMS data without replication.
-
How to Connect to Live Xero 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 Xero data for you.
-
How to Create Power BI Visual Reports with Real-Time ZohoMarketingHub Data
Use CData Power BI Connectors to visualize ZohoMarketingHub data in Power BI.
-
How to Connect DBeaver to Perigon via a JDBC Driver
Manage Perigon data with visual tools in DBeaver like the query browser.
-
Create Informatica Mappings From/To an ODBC Data Source for Ontraport
Create an ODBC connection to Ontraport in Informatica and browse and transfer Ontraport data.
-
View Reports on Real-Time Postmark Data in Power BI Report Server
Use the CData ODBC Driver for Postmark to visualize Postmark data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Google Ad Manager Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SQL Server.
-
Automate Samanage Data Replication to Azure Synapse
Use CData Sync to customize and automate Samanage data replication to Azure Synapse.
-
Create Reports with FHIR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FHIR data.
-
Create Reports from ServiceNow Data in Looker Studio
Use CData Connect AI to gain access to live ServiceNow data and create custom reports in Looker Studio.
-
Analyze xBase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of xBase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Interact with Live PayPal Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live PayPal data.
-
Integrating LangGraph with Figshare Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Figshare data within automated workflows.
-
Getting Started with the CData Connect AI Python SDK for Workday
Install the CData Connect AI Python SDK to read and write live Workday data with standard DB-API 2.0 Python code.
-
How to connect to AfterShip Data from IntelliJ
Integrate connectivity to AfterShip data with wizards in IntelliJ.
-
Connect to Timely Data from PowerBuilder via JDBC
This article demonstrates how to access Timely data from PowerBuilder using the Timely JDBC Driver.
-
Create Campaigner-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Campaigner Data from Klipfolio and build custom visualizations using live Campaigner data.
-
Connect to SingleStore Data from Crystal Reports
Use CData Connect AI to connect to and report on live SingleStore data from Crystal Reports.
-
Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy Web
Connect to Oracle HCM Cloud data in MicroStrategy Web using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Back Up SendPulse data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with SendPulse data data.
-
Consume FTP OData Feeds in PowerBuilder
This article demonstrates how to consume FTP data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Perigon Replication to Vertica
Use CData Sync for automated, continuous, customizable Perigon replication to Vertica.
-
Consume Microsoft Teams OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Teams feeds that reflect any changes in SAP Lumira.
-
Connect to and Query Simplesat Data in QlikView over ODBC
Create data visualizations with Simplesat data in QlikView.
-
Natively Connect to DB2 Data in PHP
The CData ODBC driver for DB2 enables you to create PHP applications with connectivity to DB2 data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for ADP in MicroStrategy Desktop
Connect to ADP data in MicroStrategy Desktop using the CData Software JDBC Driver for ADP.
-
Validate Active Directory Data with QuerySurge
Access and validate Active Directory data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous SendInBlue Replication to MySQL
Use CData Sync for automated, continuous, customizable SendInBlue replication to MySQL.
-
Integrate Live Coda Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Coda data and integrate live Coda data into apps built in Microsoft Power Apps.
-
Build a PostgreSQL Interface for Productboard Data using the CData JDBC Driver
Use the Remoting features of the Productboard JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating OpenCode with ConvertKit 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 Salesforce Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce in FileMaker Pro to connect to Salesforce and work with Salesforce data in your FileMaker applications.
-
Create Trello Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Trello from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Perplexity Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Perplexity from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Perplexity data.
-
Build HDFS-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live HDFS data without replication.
-
How to Connect the Power BI Service to Azure Data Catalog: Complete Guide
Connect to the CData Software Power BI Connector for Azure Data Catalog from PowerBI.com to provide real-time Azure Data Catalog data across the organization.
-
Import and Visualize Miro Data in Power View
Create data visualizations based on Miro data in Excel.
-
Connect to API Data from HeidiSQL
Use CData Connect AI to connect to and query live API data from HeidiSQL.
-
Integrate Gong with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Gong with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Gong data.
-
Load PabblySubscriptions Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PabblySubscriptions data to a database.
-
Back Up PhantomBuster data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with PhantomBuster data data.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Sales Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle Sales data.
-
Connect to Grafana Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Grafana and the SQL Gateway to access Grafana data from Google Apps Script.
-
Connect to Live Act-On Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Act-On in CData Connect AI and connect to your Act-On data from PostgreSQL.
-
Use ChatGPT to Talk to Your WordPress 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 WordPress data for you.
-
Easily Integrate SAS Data Sets Data in Lazarus Pascal IDE
Learn how to easily integrate live SAS Data Sets data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to HDFS Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HDFS and the Script function in FileMaker Pro to connect to HDFS and work with HDFS data in your FileMaker application.
-
Back Up Shopify data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Shopify. In this article, we will employ an SSIS workflow to populate a database with Shopify data data.
-
Use Microsoft Copilot Studio to talk to your VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your VWO data for you.
-
Automate Confluence Data Replication to SAP HANA
Use CData Sync to customize and automate Confluence data replication to SAP HANA.
-
Connect to Aha! 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 Aha! and work with Aha! data in your FileMaker application.
-
Integrate Live Humanity Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Humanity data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize MYOB AccountRight Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MYOB AccountRight data.
-
A PostgreSQL Interface for Planio Data using the CData ODBC Driver
Use the SQL Gateway and Planio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build C# / .NET Apps on Your Business Data with the New CData CLI
Learn how to use the CData CLI to ground AI coding agents in your actual data schema, then build data-connected C# .NET apps with the CData ADO.NET Data Provider.
-
How to Query Live Zoho Creator Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Creator data data in natural language using Python.
-
Access Live Dropbox Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dropbox data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use JayDeBeApi to access Exa Data in Python
Use standard Python scripting and the development environment of your choice to access live Exa data.
-
Connect to SAP HANA XS Advanced Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP HANA XS Advanced data.
-
Connect Bright Data Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bright Data data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Dashboards with AgileCRM Data in DBxtra
Create dynamic dashboards and perform analytics based on AgileCRM data in DBxtra.
-
Analyze Short.io Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Short.io from Power Pivot. You will use the Table Import Wizard to load Short.io data. You can visually build the import query or use any SQL supported by the driver.
-
Query Oracle Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle data from Node.js.
-
Build AI/ML Models with Live Paylocity Data using Dataiku
Connect Paylocity Data with Dataiku using the CData JDBC Driver for Paylocity.
-
Integrate Open WebUI with Live Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Paymo data from within the chat interface.
-
Build AI/ML Models with Live FHIR Data using Dataiku
Connect FHIR Data with Dataiku using the CData JDBC Driver for FHIR.
-
Use Grok to Talk to Your Oracle Financials Cloud 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 Oracle Financials Cloud data for you.