CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Sybase IQ in MicroStrategy
Connect to Sybase IQ data in MicroStrategy Developer using the CData Software JDBC Driver for Sybase IQ.
-
Integrate Rebilly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Rebilly with External Services.
-
Getting Started with the CData Excel Add-In for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Stack Exchange.
-
Explore Geographical Relationships in Perigon Data with Power Map
Create data visualizations with Perigon data in Power Map.
-
Integrating SAP Business Warehouse Data in Talend Cloud Data Management Platform
Connect SAP Business Warehouse Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Business Warehouse.
-
Use the CData ODBC Driver for Grafana from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Grafana to connect to Grafana data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Grafana data in Excel.
-
How to Connect to Live Phoenix 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 Phoenix data for you.
-
How to Access Live ZendeskSell Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZendeskSell enables you to integrate ZendeskSell data into workflows built using Microsoft Power Automate Desktop.
-
Visualize ServiceDesk Plus Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ServiceDesk Plus data.
-
How to load Coda data into Elasticsearch via Logstash
Introducing a simple method to load Coda data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Amazon Athena-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Amazon Athena Data and create custom apps in Mendix.
-
Access Live ZohoMarketingHub Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ZohoMarketingHub data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Model, Search, and Visualize Live OData Services in ThoughtSpot
Use CData Connect AI to connect to live OData services for modeling, searching, and visualizing.
-
Connecting Agentforce with Azure Synapse 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 Azure Synapse data for you.
-
ETL HubSpot in Oracle Data Integrator
This article shows how to transfer HubSpot data into a data warehouse using Oracle Data Integrator.
-
Jira Assets Reporting in OBIEE with the Jira Assets JDBC Driver
Deploy the Jira Assets JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Reports from BambooHR Data in Looker Studio
Use CData Connect AI to gain access to live BambooHR data and create custom reports in Looker Studio.
-
Deploy the ADO.NET Provider for JSON on an SSRS Report Server
Connect to JSON services 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.
-
Automated Continuous Office 365 Replication to SQLite
Use CData Sync for automated, continuous, customizable Office 365 replication to SQLite.
-
How to update AlloyDB from Excel
This article explains how to transfer data from Excel to AlloyDB using the Excel Add-In for AlloyDB.
-
Analyze Testmonitor Data in Looker
Use CData Connect AI to connect to Testmonitor Data from Looker and build custom apps using live Testmonitor data.
-
Connecting Agentforce with IBM Informix 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 IBM Informix data for you.
-
Connect to Clari 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 Clari and work with Clari data in your FileMaker application.
-
Connect to REST Data from a Connection Pool in Jetty
The REST JDBC Driver supports connection pooling: This article shows how to connect faster to REST data from Web apps in Jetty.
-
Create Microsoft Dataverse-Connected Dashboards in Grafana
Connect to Microsoft Dataverse Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Dataverse data.
-
Automated Continuous OData Replication to Vertica
Use CData Sync for automated, continuous, customizable OData replication to Vertica.
-
Access Live Adobe Experience Manager Data in AWS Lambda
Connect to live Adobe Experience Manager data in AWS Lambda using the CData JDBC Driver.
-
How to Seamlessly Import CircleCI Data into IBM SPSS Modeler
Integrate CircleCI data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Google Forms 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 Google Forms data through MCP integration.
-
Automated Continuous Beeminder Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Beeminder replication to Amazon Redshift.
-
Replicate Multiple Klipfolio Accounts via the CData Sync CLI
Replicate multiple Klipfolio accounts to one or many databases.
-
Build MVC Applications with Connectivity to SAP Concur Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Concur from an ASP.NET MVC application.
-
Integrating Gumloop with Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Grafana data within automated workflows.
-
Connect to AgileCRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live AgileCRM data from Filemaker Pro on Mac.
-
DataBind Charts to Cassandra Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cassandra data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoom
Provide connectivity to Zoom data through an SAP BusinessObjects universe.
-
Integrate ElevenLabs with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ElevenLabs with External Services.
-
How to connect to Google Cloud Storage Data from IntelliJ
Integrate connectivity to Google Cloud Storage data with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Landbot in SAS for Real-Time Reporting and Analytics
Connect to real-time Landbot data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Landbot.
-
Connect to Oracle HCM Cloud Data from a Connection Pool in JBoss
Integrate Oracle HCM Cloud data into Java servlets: Use the Management Console in JBoss to install the Oracle HCM Cloud JDBC Driver.
-
Build a Simple VCL Application for Discourse Data
How to build a simple VCL Application to view Discourse data in RAD Studio using the CData ODBC Driver for Discourse.
-
How to Query Live ServiceDesk Plus Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ServiceDesk Plus data data in natural language using Python.
-
Visualize Qualaroo Data in TIBCO Spotfire through ADO.NET
Integrate Qualaroo data into dashboards in TIBCO Spotfire.
-
Integrate Live Salesforce Pardot Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce Pardot data to Blue Prism using the CData ODBC Driver for Salesforce Pardot to create automated workflows for repetitive business tasks.
-
How to connect PolyBase to Mixpanel
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mixpanel data.
-
Visualize Live SFTP Data in the Power BI Service
Use CData Connect AI to connect to live SFTP data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Crystal Reports on Dynamics 365 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dynamics 365 data.
-
Create Zoho Inventory-Connected Dashboards in Grafana
Connect to Zoho Inventory Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Inventory data.
-
Create Reports with Unbounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Unbounce data.
-
Integrate with MongoDB Data in JReport Designer
Create charts and reports based on MongoDB data in JReport Designer.
-
Connect ZohoPeople Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ZohoPeople data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Live Instagram Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Instagram in CData Connect AI and connect to your Instagram data from PostgreSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dropbox
Provide connectivity to Dropbox data through an SAP BusinessObjects universe.
-
Feed OneNote Data into FineReport
How to set OneNote data as a JDBC data source in FineReport.
-
How to Connect to & Open Amazon S3 Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon S3 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous FreeAgent Replication to Databricks
Use CData Sync for automated, continuous, customizable FreeAgent replication to Databricks.
-
Viewing Oracle Sales Data in RAD Studio Data Explorer
How to view Oracle Sales data in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Sales.
-
Getting Started with the CData Excel Add-In for HCL Domino
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HCL Domino.
-
Replicate Oracle Financials Cloud Data to Multiple Databases
Replicate Oracle Financials Cloud data to disparate databases with a point-and-click configuration.
-
Connect to Insightly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Insightly data.
-
View Reports on Real-Time SAP Fieldglass Data in Power BI Report Server
Use the CData ODBC Driver for SAP Fieldglass to visualize SAP Fieldglass data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for Unbounce in MicroStrategy Desktop
Connect to Unbounce data in MicroStrategy Desktop using the CData Software JDBC Driver for Unbounce.
-
Automated Continuous API Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable API replication to Amazon Redshift.
-
How to Access Oracle Eloqua Data Using Entity Framework
This article shows how to access Oracle Eloqua data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Grok to Talk to Your ZohoInvoice 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 ZohoInvoice data for you.
-
Access Live SAP HANA XS Advanced Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP HANA XS Advanced data from your Excel spreadsheets.
-
Connect to and Visualize Live Chargebee Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Chargebee data.
-
How to Seamlessly Import Teamgate Data into IBM SPSS Modeler
Integrate Teamgate data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect Landbot to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Landbot data using the CData Python MCP Server.
-
Access XML Data from MySQL in PHP
Connect to XML through the standard MySQL libraries in PHP.
-
Enable the Rebilly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Rebilly data.
-
How to Connect to Live Active Directory 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 Active Directory data through natural language.
-
Build Data Flows from Exact Online to SQL Server using SSIS
Easily back up Exact Online data to SQL Server using the SSIS components for Exact Online.
-
Automate Phoenix Data Replication to Couchbase
Use CData Sync to Customize and automate Phoenix data replication to Couchbase.
-
Build Snowflake-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 Snowflake data without replication.
-
Build Microsoft Planner-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft Planner Data from Zoho Analytics and import live Microsoft Planner data.
-
Connect to Strava Data in DBArtisan
Use wizards in DBArtisan to configure Strava data as a data source.
-
Getting Started with the CData SSIS Components for Billsby
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Billsby.
-
Integrate Browserless with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Browserless with External Services.
-
Create Data Visualizations Based On Hive Data in Mode
Use CData Connect AI to connect to Hive Data from Mode and build visualizations using live Hive data.
-
Query Live Zoom 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 Zoom data directly from the development environment.
-
How to Connect the Power BI Service to Helpscout: Complete Guide
Connect to the CData Software Power BI Connector for Helpscout from PowerBI.com to provide real-time Helpscout data across the organization.
-
How to create SendGrid federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SendGrid data in MySQL .
-
Access Live Pinterest Data in Excel 365 Online (Excel for the web)
Connect to Pinterest data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Google Directory from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Directory to connect to Google Directory data from Web applications running on WebLogic.
-
Visualize Live Quaderno Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Quaderno data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Calendly Data in Coginiti Pro
Connect to and query live Calendly data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect DBeaver to Placid via a JDBC Driver
Manage Placid data with visual tools in DBeaver like the query browser.
-
Integrating Boomi Agentstudio with Pinterest Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Pinterest data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Accelo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Accelo replication to Azure SQL Database.
-
Publish Pipedrive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pipedrive data.
-
Visualize Reply.io Data in Tableau
The CData ODBC driver for Reply.io enables you integrate Reply.io data into Tableau dashboards.
-
Automated Continuous Oracle Eloqua Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Google Cloud SQL.
-
Automated Continuous Paylocity Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Paylocity replication to delimited files (CSV/TSV).
-
Create SSAS Tabular Models from Microsoft Exchange Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Exchange data using CData drivers.
-
Natively Connect to ActiveCampaign Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ActiveCampaign data. Leverage the native support for ODBC in PHP.
-
Connect to ADP Data in DBeaver
Use the CData ODBC Driver to connect to ADP data in DBeaver.
-
Build SurveyMonkey-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SurveyMonkey data.
-
View Reports on Real-Time SAP Hybris C4C Data in Power BI Report Server
Use the CData ODBC Driver for SAP Hybris C4C to visualize SAP Hybris C4C data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with Aweber Data in JReport Designer
Create charts and reports based on Aweber data in JReport Designer.