CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Testmonitor Replication to Databricks
Use CData Sync for automated, continuous, customizable Testmonitor replication to Databricks.
-
Build Data Flows from Qualaroo to SQL Server using SSIS
Easily back up Qualaroo data to SQL Server using the SSIS components for Qualaroo.
-
Add CloudConvert Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CloudConvert with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Claude to Talk to Your Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Tavily data for you.
-
Import Real-Time Authorize.Net Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Authorize.Net data in ColdFusion.
-
Replicate Multiple Trello Accounts
Replicate multiple Trello accounts to one or many databases.
-
Integrate Live Tally Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Tally from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Tally data.
-
Use JayDeBeApi to access Twitter Ads Data in Python
Use standard Python scripting and the development environment of your choice to access live Twitter Ads data.
-
Access Live Freshdesk Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Freshdesk data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Hive Data in NetBeans
Connect to Hive data in NetBeans with the data source configuration wizard.
-
Working with SAP ByDesign Data in LINQPad
Execute LINQ queries to SAP ByDesign data in LINQPad.
-
How to Connect to Live Lakebase 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 Lakebase data for you.
-
Publish Printify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Printify data.
-
Build Charts with LDAP Objects in Clear Analytics
Create dynamic charts and perform analytics based on LDAP objects in Clear Analytics.
-
Connect to Avro from a Connection Pool in WebLogic
Use the CData JDBC Driver for Avro to connect to Avro data from Web applications running on WebLogic.
-
Publish Reports with Impala Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Impala data.
-
Automate Adobe Commerce Data Replication to Azure Synapse
Use CData Sync to customize and automate Adobe Commerce data replication to Azure Synapse.
-
Connect to Float 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 Float and work with Float data in your FileMaker application.
-
Automated HubDB Data Replication to Teradata
Use CData Sync to Customize and automate HubDB data replication to Teradata.
-
Analyze Sentry Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sentry from Power Pivot. You will use the Table Import Wizard to load Sentry data. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce Data 360
Create an ODBC connection to Salesforce Data 360 in Informatica and browse and transfer Salesforce Data 360 data.
-
How to Connect to Live Outreach.io 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 Outreach.io data for you.
-
Automated Continuous Google Campaign Manager 360 Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Oracle.
-
How to Access SAS Data Sets Data Using Entity Framework
This article shows how to access SAS Data Sets data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Link Foursquare with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Foursquare data in Filemaker Pro for Mac or Windows.
-
Bridge Marketo Connectivity with Apache NiFi
Access and process Marketo data in Apache NiFi using the CData JDBC Driver.
-
A PostgreSQL Interface for Wrike Data (MySQL Remoting via JDBC)
Use the Remoting features of the Wrike JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Twilio Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Twilio data for you.
-
Connecting GenSpark with XML Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to XML data without any replication or custom integration required.
-
Integrating GitHub Copilot with Discourse 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.
-
Visualize Live Hacker News Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Hacker News data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Seamlessly Import Oracle Eloqua Data into IBM SPSS Modeler
Integrate Oracle Eloqua data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SAS xpt Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAS xpt to connect to SAS xpt data and execute queries in PowerBuilder.
-
Use Dash to Build to Web Apps on EnterpriseDB Data
Create Python applications that use pandas and Dash to build EnterpriseDB-connected web apps.
-
How to Visualize Paddle Data in Python with pandas
Use pandas and other modules to analyze and visualize live Paddle data in Python.
-
Connect to MySQL Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MySQL data in the Denodo Virtual DataPort Administrator.
-
Connect to Clio Data in RazorSQL
Connect to Clio from wizards and query Clio data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData JDBC Driver for Paddle
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Paddle.
-
Getting Started with the CData JDBC Driver for Highrise
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Highrise.
-
Connecting GenSpark with Omnisend Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Omnisend data without any replication or custom integration required.
-
How to connect to Todoist Data in DBVisualizer
Integrate Todoist data with visual data analysis tools and data connection wizards in DBVisualizer
-
Suadeo Reporting in OBIEE with the Suadeo JDBC Driver
Deploy the Suadeo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Interact with Live Sage 200 Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Sage 200 data.
-
Integrate Live Facebook Ads Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Facebook Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Facebook Ads data.
-
Use Claude to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zoho CRM data for you.
-
Getting Started with the CData SSIS Components for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Ads.
-
Operational Reporting on Raisers Edge NXT Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Raisers Edge NXT data.
-
Build Semantic Layer Views for Presto Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Presto data.
-
How to Use a Microsoft Access Database to Update Odoo Data in Real Time
Update Odoo data by creating a linked table in Microsoft Access with the CData Odoo ODBC Driver.
-
Migrating data from Redis to Databricks using CData SSIS Components.
Easily push Redis data to Databricks using the CData SSIS Tasks for Redis and Databricks.
-
Integrate SAP Netweaver Gateway Data in the Pentaho Report Designer
Publish reports based on SAP Netweaver Gateway data in the Pentaho BI tool.
-
DataBind Controls to Invoiced Data in Delphi
DataBind to Invoiced data in Delphi with standard data access components and controls.
-
Connect to FHIR Data in NetBeans
Connect to FHIR data in NetBeans with the data source configuration wizard.
-
Migrating data from HelloSign to Google BigQuery using CData SSIS Components.
Easily push HelloSign data to Google BigQuery using the CData SSIS Tasks for HelloSign and Google BigQuery.
-
Build a Simple VCL Application for SAP Business One Data
How to build a simple VCL Application to view SAP Business One data in RAD Studio using the CData ODBC Driver for SAP Business One.
-
Integrate LibreChat with Live ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ShipEngine data from within the chat interface.
-
Connect to BigQuery Data in ACL Analytics
Connect to BigQuery data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to BigQuery data.
-
How to create an RPA flow for Accelo Data in UiPath Studio
Use the Accelo ODBC Driver to create workflows that access real-time Accelo data without any coding.
-
How to Connect to Live IBM Cloud Object Storage Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your IBM Cloud Object Storage data for you.
-
Integrate with HelloSign Data in JReport Designer
Create charts and reports based on HelloSign data in JReport Designer.
-
Integrate LibreChat with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Elasticsearch data from within the chat interface.
-
Automate Samanage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Samanage data from PowerShell? This article demonstrates how to utilize the Samanage Cmdlets for tasks like connecting to Samanage data, automating operations, downloading data, and more.
-
Integrate Theia IDE with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Amazon Athena data from within the development environment.
-
Access Live SurveyMonkey Data in Excel 365 Online (Excel for the web)
Connect to SurveyMonkey data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Using the CData Software ODBC Driver for Act CRM in PyCharm
Connect to Act CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Act CRM.
-
How to integrate QuickBooks with Apache Airflow
Access and process QuickBooks data in Apache Airflow using the CData JDBC Driver.
-
Integrating Codex with Azure DevOps 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.
-
Excel Spreadsheet Automation on Twilio Data with the QUERY Formula
Pull data from Twilio, automate spreadsheets, and more with the QUERY formula.
-
Build ZohoExpense-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ZohoExpense data.
-
Integrating Boomi Agentstudio with FHIR Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to FHIR data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Connect to Shippo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Shippo data. Leverage the pyodbc module for ODBC in Python.
-
Load Clockify Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Clockify data to a database.
-
Build Oracle Eloqua-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 Oracle Eloqua data without replication.
-
Connect to Attio from Asprova with CData Software ODBC Driver for Attio
This article shows how to connect faster to Attio data from Asprova.
-
Connect to Live Jumpseller Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Jumpseller in CData Connect AI and connect to your Jumpseller data from PostgreSQL.
-
Access Live SAP Fieldglass Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Fieldglass data from your Excel spreadsheets.
-
Connect to Microsoft Entra ID Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Entra ID data.
-
Build Visualizations of SAP Business Warehouse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Business Warehouse data in Birst.
-
Connect to OData Services from a Connection Pool in JBoss
Integrate OData services into Java servlets: Use the Management Console in JBoss to install the OData JDBC Driver.
-
How to create an RPA flow for Sage Cloud Accounting Data in UiPath Studio
Use the Sage Cloud Accounting ODBC Driver to create workflows that access real-time Sage Cloud Accounting data without any coding.
-
Prepare, Blend, and Analyze Splunk Data in Alteryx Designer (ODBC)
Build workflows to access live Splunk data for self-service data analytics.
-
Create PolarTeamPro Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PolarTeamPro data access from reports, embedded analytics, and more.
-
Query Live SAP BusinessObjects BI 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 SAP BusinessObjects BI data directly from the development environment.
-
Operational Reporting on Outreach.io Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Outreach.io data.
-
Integrating Flowlu Data in Talend Cloud Data Management Platform
Connect Flowlu Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Connect to & Open Paylocity Data in Microsoft Excel
This article uses the CData ODBC driver for Paylocity to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Kafka Data in TIBCO Spotfire through OData
Integrate Kafka data into dashboards in TIBCO Spotfire.
-
Connect to Outlook Data in JRuby
Create a simple JRuby app with access to live Outlook data.
-
Build Egnyte-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Egnyte data and build web apps with connectivity to live Egnyte data.
-
Visualize Live FTP Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FTP data.
-
Analyze XML Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of XML data and visualize XML data in SAP Analytics Cloud.
-
Access Live JSON Services in AWS Lambda (with IntelliJ IDEA)
Connect to live JSON services in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Bitbucket Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Bitbucket data through MCP integration.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Web
Connect to SAP Netweaver Gateway data in MicroStrategy Web using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Build Pipelines with Live Dynamics 365 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 from Google Cloud Data Fusion, enabling the integration of live Dynamics 365 data into the building and management of effective data pipelines.
-
Automate Oracle Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle data from PowerShell? This article demonstrates how to utilize the Oracle Cmdlets for tasks like connecting to Oracle data, automating operations, downloading data, and more.
-
Connecting GenSpark with Highrise Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Highrise data without any replication or custom integration required.
-
Replicate OpenWeatherMap Data from PowerShell
Write a quick PowerShell script to query OpenWeatherMap data. Use connectivity to the live data to replicate OpenWeatherMap data to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MailerLite
Provide connectivity to MailerLite data through an SAP BusinessObjects universe.
-
Automated Box Data Replication to Teradata
Use CData Sync to Customize and automate Box data replication to Teradata.