CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for Redshift
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Redshift.
-
Visualize Clari Data in Tableau
The CData ODBC driver for Clari enables you integrate Clari into Tableau dashboards.
-
Validate Invoiced Data with QuerySurge
Access and validate Invoiced in QuerySurge using the CData JDBC Driver.
-
How to Access ZohoPeople Data Using Entity Framework
This article shows how to access ZohoPeople using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Bidirectional Access to Hive Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Apache Hive in Filemaker Pro for Mac or Windows.
-
Query Twitter Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to Twitter Ads.
-
Use Manus AI to Talk to Your Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Azure DevOps.
-
Prepare, Blend, and Analyze SQL Analysis Services Data in Alteryx Designer (Connect AI)
Build workflows to access live SQL Analysis Services for self-service data analytics.
-
How to Connect to & Open Authorize.Net Data in Microsoft Excel
This article uses the CData ODBC driver for Authorize.Net to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Reply.io Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Reply.io from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build AI Agents with Adobe Analytics Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Adobe Analytics through CData Connect AI.
-
How to Connect to Live SingleStore Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SingleStore through natural language.
-
Use the CData Software ODBC Driver for Google Drive in MicroStrategy
Connect to Google Drive in MicroStrategy Developer using the CData Software ODBC Driver for Google Drive.
-
How to connect to Oracle Eloqua Data in DBVisualizer
Integrate Oracle Eloqua with visual data analysis tools and data connection wizards in DBVisualizer
-
Validate Google Search Results with QuerySurge
Access and validate Google Search in QuerySurge using the CData JDBC Driver.
-
Explore Geographical Relationships in Placid Data with Power Map
Create data visualizations with Placid in Power Map.
-
How to connect to PolarTeamPro Data in DBVisualizer
Integrate PolarTeamPro with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate PayPal Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live PayPal and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrate Highrise Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Highrise CRM from Informatica Cloud.
-
Natively Connect to ShipEngine Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ShipEngine. Leverage the native support for ODBC in PHP.
-
Integrating Gumloop with Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Slack within automated workflows.
-
Automated Continuous SAP Netweaver Gateway Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to delimited files (CSV/TSV).
-
Integrating Claude Code CLI with Acumatica 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.
-
Create Reckon Accounts Hosted-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Klipfolio and build custom visualizations using live Reckon Accounts Hosted.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Sheets
Create an ODBC connection to Google Sheets in Informatica and browse and transfer Google Sheets.
-
Automate Avro Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Avro replication to SAP HANA.
-
Object-Relational Mapping (ORM) with AfterShip 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 AfterShip into a Java-based ORM framework, Hibernate.
-
Work with Live Okta Data in Power Query
Use CData Connect AI to connect to Okta and work with live Okta in Microsoft Power Query.
-
Integrate Cline with Live Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sage Intacct from within your IDE.
-
Query Jira Data as a MySQL Database in Node.js
Execute MySQL queries against Atlassian Jira from Node.js.
-
Automated Continuous Twitter Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Azure SQL Database.
-
Connect to Active Directory Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Active Directory in Airbyte.
-
Create Reports with Google Search Results in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Search.
-
Working with OneNote Data in LINQPad
Execute LINQ queries to Microsoft OneNote in LINQPad.
-
Integrating Cursor CLI with FTP 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.
-
Use Dash to Build to Web Apps on Postmark Data
Create Python applications that use pandas and Dash to build Postmark-connected web apps.
-
Visualize Airtable Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Airtable.
-
Use the CData ODBC Driver for Monday.com from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Monday.com to connect to Monday.com from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Monday.com in Excel.
-
Validate SingleStore Data with QuerySurge
Access and validate SingleStore in QuerySurge using the CData JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Office 365 within intelligent workflows.
-
Publish Landbot-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Landbot.
-
Connect to SingleStore Data in JRuby
Create a simple JRuby app with access to live SingleStore.
-
Access ZohoPeople Data from MySQL in Amazon QuickSight
Connect to ZohoPeople and build visualizations of ZohoPeople using a MySQL Connection in Amazon QuickSight.
-
Query Sugar CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sugar CRM entities in PHP by modeling them as objects.
-
Automated Continuous Oracle Eloqua Reporting Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Databricks.
-
Integrate with Xero Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Xero Accounting to a JSON file on disk.
-
Integrating Kiro CLI with Sage Intacct 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 Suadeo Data in Lazarus Pascal IDE
Learn how to easily integrate live Suadeo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Klaviyo Data in Talend Cloud Data Management Platform
Connect Klaviyo Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Klaviyo.
-
Use the CData Software JDBC Driver for Keap in MicroStrategy
Connect to Keap in MicroStrategy Developer using the CData Software JDBC Driver for Keap.
-
Use the CData Software JDBC Driver for Freshteam in MicroStrategy Desktop
Connect to Freshteam in MicroStrategy Desktop using the CData Software JDBC Driver for Freshteam.
-
Analyze Redis Data in Looker
Use CData Connect AI to connect to Redis Data from Looker and build custom apps using live Redis.
-
Automated Continuous Google Search Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Search replication to SQLite.
-
Configure the CData JDBC Driver for Phoenix in a Connection Pool in Tomcat
Connect to Apache Phoenix from a connection pool in Tomcat.
-
Building Dynamic Web Pages with FHIR Data Using AngularJS
Create single-page applications with live connectivity to FHIR using the CData API Server.
-
Connecting Agentforce with Impala Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Apache Impala for you.
-
Object-Relational Mapping (ORM) with PingOne 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 PingOne into a Java-based ORM framework, Hibernate.
-
Establish a Live Connection with Spark Data using Tableau Bridge
The CData ODBC Driver for Spark enables you to integrate live Apache Spark SQL into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect SharePoint with Oracle Financials Cloud Data through external lists
Provide Oracle Financials Cloud to SharePoint users as an external list.
-
Access MailerSend Data from MySQL in Amazon QuickSight
Connect to MailerSend and build visualizations of MailerSend using a MySQL Connection in Amazon QuickSight.
-
Build Apps with Live Paddle Data Using the Low-Code Development Platform of Mendix
Connect Paddle with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Live SAP Ariba Procurement Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Viewing ServiceDesk Plus Data in RAD Studio Data Explorer
How to view ServiceDesk Plus in RAD Studio Data Explorer using the CData ODBC Driver for ServiceDesk Plus.
-
Connect to Salesforce CRM Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce CRM Analytics and the Script function in FileMaker Pro to connect to Salesforce CRM Analytics and work with Salesforce CRM Analytics in your FileMaker application.
-
Stream Email Data into Apache Kafka Topics
Access and stream Email in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Object-Relational Mapping (ORM) with Salesforce Pardot 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 Salesforce Pardot into a Java-based ORM framework, Hibernate.
-
Connecting Mastra with Shopify 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 Shopify, no replication required.
-
Visualize ZohoSubscriptions Data in Tableau
The CData ODBC driver for ZohoSubscriptions enables you integrate ZohoSubscriptions into Tableau dashboards.
-
Integrating Antigravity CLI with Redis via CData CLI
Connect Redis to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with live Azure Analysis Services Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Analysis Services in Jitterbit.
-
A PostgreSQL Interface for Salesloft Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesloft JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ServiceNow Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ServiceNow in Airbyte.
-
Query Live Smartsheet Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Smartsheet directly from the development environment.
-
Seamlessly Bring Box Data into Retool Using CData Connect AI
Integrate Box data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Getting Started with the CData ADO.NET Provider for Vercel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Snapchat Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Snapchat Ads to connect to Snapchat Ads and execute queries in PowerBuilder.
-
Connect to SparkPost Data in RazorSQL
Connect to SparkPost from wizards and query SparkPost from the GUI in the RazorSQL database management tool.
-
How to Work with Aha! Data in ETL Validator JDBC
Connect to Aha! from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Snapchat Ads
Create an ODBC connection to Snapchat Ads in Informatica and browse and transfer Snapchat Ads.
-
Automate Kintone Data Replication to Couchbase
Use CData Sync to Customize and automate Kintone replication to Couchbase.
-
Connect to and Query Salesforce Data 360 Data in QlikView over ODBC
Create data visualizations with Salesforce Data 360 in QlikView.
-
Create JSON-Connected Nintex Workflows
Use CData Connect AI to connect to JSON Services from Nintex Workflow Cloud and build custom workflows using live JSON.
-
Connect to HCL Domino Data in JRuby
Create a simple JRuby app with access to live HCL Domino.
-
How to publish and share ConvertKit Data dashboards with Tableau Server
The CData ODBC driver for ConvertKit enables you integrate ConvertKit into Tableau dashboards.
-
Visualize Workable Data in TIBCO Spotfire through ADO.NET
Integrate Workable into dashboards in TIBCO Spotfire.
-
View Reports on Real-Time SAP ByDesign Data in Power BI Report Server
Use the CData ODBC Driver for SAP ByDesign to visualize SAP Business ByDesign in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Power BI Connector for Hugging Face
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Import and Visualize Factorial Data in Power View
Create data visualizations based on Factorial in Excel.
-
Visualize Live Oracle Financials Cloud Data in the Power BI Service
Use CData Connect AI to connect to live Oracle Financials Cloud and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a PostgreSQL Interface for Amazon DynamoDB Data using the CData JDBC Driver
Use the Remoting features of the Amazon DynamoDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for Google Campaign Manager 360 Data in APOS Live Data Gateway
Use the CData Connector for Google Campaign Manager 360 in APOS Live Data Gateway to build Semantic Layer Views for Google Campaign Manager 360.
-
Automated Continuous OData Replication to Databricks
Use CData Sync for automated, continuous, customizable OData replication to Databricks.
-
Use the CData SSIS Components to Insert New or Update Existing SendGrid Records from SQL Server
Easily push SQL Server data to SendGrid using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SendGrid or update existing records with data from a SQL Server database.
-
Build Semantic Layer Views for Deel Data in APOS Live Data Gateway
Use the CData Connector for Deel in APOS Live Data Gateway to build Semantic Layer Views for Deel.
-
How to Create Power BI Visual Reports with Real-Time Factorial Data
Use CData Power BI Connectors to visualize Factorial in Power BI.
-
Replicate Factorial Data from PowerShell
Write a quick PowerShell script to query Factorial. Use connectivity to the live data to replicate Factorial to SQL Server.
-
Automated Continuous Freshservice Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Freshservice replication to Azure SQL Database.
-
Build Automated Workflows with Live OneNote Data in Workato
Use CData Connect AI to connect to live Microsoft OneNote and build automated workflows in Workato.
-
Query Figshare Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Figshare from Node.js.
-
Use CData Connect AI to Access Instagram Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Instagram in the Power Pivot business intelligence tool.