CData Software - Knowledge Base
Recent Articles
-
Access Live Toggl Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Toggl data from your Excel spreadsheets.
-
Automated Continuous Google Forms Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Forms replication to MySQL.
-
Process & Analyze ZohoPeople Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoPeople Data.
-
Create Informatica Mappings From/To an ODBC Data Source for NASA
Create an ODBC connection to NASA in Informatica and browse and transfer NASA data.
-
Connect to FHIR Data from Crystal Reports
Use CData Connect AI to connect to and report on live FHIR data from Crystal Reports.
-
How to connect PolyBase to PabblySubscriptions
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PabblySubscriptions data.
-
Automated Continuous ZohoInvoice Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Google BigQuery.
-
Edit and Search External MySQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MySQL data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MySQL Data objects that you can access from apps and the dashboard.
-
Integrate Presto Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Presto data from Informatica Cloud.
-
Viewing ChargeOver Data in RAD Studio Data Explorer
How to view ChargeOver data in RAD Studio Data Explorer using the CData ODBC Driver for ChargeOver.
-
Connect to Real-Time LaunchDarkly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use LaunchDarkly data in Power Apps.
-
How to connect to Printify Data in DBVisualizer
Integrate Printify data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Data Flows from Eventbrite to SQL Server using SSIS
Easily back up Eventbrite data to SQL Server using the SSIS components for Eventbrite.
-
Create GraphQL-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to GraphQL Data from Klipfolio and build custom visualizations using live GraphQL data.
-
Getting Started with the CData Tableau Connector for xBase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for xBase.
-
Use the CData ODBC Driver for Excel Online in Microsoft Power Query
You can use the CData Excel Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Excel Online data into Microsoft Power Query.
-
Integrate with Spotify Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Spotify data to a JSON file on disk.
-
DataBind Controls to GitHub Data in C++Builder
DataBind to GitHub data in C++Builder with standard components and controls.
-
How to Visualize CapsuleCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live CapsuleCRM data in Python.
-
Access Live Klipfolio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Klipfolio data into the statistical analysis tools available in SAS JMP. This article shows how to use Klipfolio data in the Graph Builder and Query Builder.
-
Integrating Kiro with Egnyte 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 Adobe Target Data in CloverDX (formerly CloverETL)
Transfer Adobe Target data using the visual workflow in the CloverDX data integration tool.
-
Connect to and Visualize Live Salesforce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce data.
-
Build an OLAP Cube in SSAS from Perplexity Data
Establish a connection to Perplexity data data from SQL Server Analysis Services, and use the Perplexity Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Salesforce-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 Salesforce data without replication.
-
Connect to Amazon Athena Data in ACL Analytics
Connect to Amazon Athena data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Athena data.
-
Building Dynamic Web Pages with SurveyMonkey Data Using AngularJS
Create single-page applications with live connectivity to SurveyMonkey using the CData API Server.
-
Connect to Telegram Data in DBeaver
Use the CData ODBC Driver to connect to Telegram data in DBeaver.
-
Integrate with Live Office 365 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Office 365 from the MuleSoft Anypoint Platform to integrate live Office 365 data into custom reports and dashboards.
-
Getting Started with the CData ODBC Driver for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for OpenWeatherMap.
-
Create Power BI Reports on Real-Time Zoho Inventory Data
Use the CData ODBC Driver for Zoho Inventory to visualize Zoho Inventory data in Power BI Desktop.
-
How to Easily Query Postmark Data in OpenOffice Base
Connect to Postmark data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to ActiveCampaign Data from Crystal Reports
Use CData Connect AI to connect to and report on live ActiveCampaign data from Crystal Reports.
-
Connect to Auth0 Data from a Connection Pool in JBoss
Integrate Auth0 data into Java servlets: Use the Management Console in JBoss to install the Auth0 JDBC Driver.
-
How to Connect to Live Yelp 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 Yelp data for you.
-
How to Connect to Live IBM Cloud Object Storage Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live IBM Cloud Object Storage data without replication.
-
Create Amazon Athena-Connected Dashboards in Grafana
Connect to Amazon Athena Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Amazon Athena data.
-
Getting Started with the CData SSIS Components for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP ByDesign.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy Web
Connect to Redis data in MicroStrategy Web using the CData Software JDBC Driver for Redis.
-
Connect to Google Analytics Data in CloverDX (formerly CloverETL)
Transfer Google Analytics data using the visual workflow in the CloverDX data integration tool.
-
How to connect to Adobe Target Data from IntelliJ
Integrate connectivity to Adobe Target data with wizards in IntelliJ.
-
Integrate Google's Antigravity Agent with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Procore data using the Model Context Protocol.
-
Automated Continuous Jira Assets Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jira Assets replication to IBM DB2.
-
Access MarkLogic Data from MySQL in PHP
Connect to MarkLogic through the standard MySQL libraries in PHP.
-
Connect to Live Adobe Commerce Data in MicroStrategy through CData Connect AI
Create a live connection to Adobe Commerce Data in CData Connect AI and connect to your Adobe Commerce data from MicroStrategy.
-
Build Voice Agents in ElevenLabs with access to Live Suadeo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Suadeo data.
-
Integrating LlamaIndex with Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Ads data in real time.
-
Getting Started with the CData JDBC Driver for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dynamics NAV.
-
Use the CData SSIS Components to Insert New or Update Existing Exact Online Records from SQL Server
Easily push SQL Server data to Exact Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Exact Online or update existing records with data from a SQL Server database.
-
Connect Excel Online to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Excel Online with IBM WebSphere for seamless data integration and connectivity.
-
Build Dashboards with EnterpriseDB Data in DBxtra
Create dynamic dashboards and perform analytics based on EnterpriseDB data in DBxtra.
-
Build MVC Applications with Connectivity to Accelo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Accelo from an ASP.NET MVC application.
-
Import GraphQL Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to GraphQL Data and provide access to live GraphQL data for custom reports in the Power BI Service.
-
How to Query Live Freshdesk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshdesk data data in natural language using Python.
-
How to Connect to Live Zendesk Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Zendesk data for you.
-
Perform Batch Operations with Active Directory Data in Apache NiFi
Connect to Active Directory data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Anaplan Data in JRuby
Create a simple JRuby app with access to live Anaplan data.
-
How to Connect to & Open Vault CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Vault CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData ODBC Driver for LightSpeedRetail
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LightSpeedRetail.
-
Query, Visualize, and Share live Twitter Ads Data in Redash
Use CData Connect AI to connect to live Twitter Ads data in Redash for querying, visualizing, and sharing.
-
Bridge SAP Business One Connectivity with Apache NiFi
Access and process SAP Business One data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Cloudflare Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cloudflare replication to SingleStore.
-
How to connect to Contentful Data from IntelliJ
Integrate connectivity to Contentful data with wizards in IntelliJ.
-
Use the CData Software JDBC Driver for Okta in MicroStrategy Web
Connect to Okta data in MicroStrategy Web using the CData Software JDBC Driver for Okta.
-
Automated Continuous Trello Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Trello replication to PostgreSQL.
-
LINQ to Discourse Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Discourse Data Provider.
-
Automated Continuous Salesforce Pardot Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Vertica.
-
Automate Clio Data Replication to SAP HANA
Use CData Sync to customize and automate Clio data replication to SAP HANA.
-
How to Connect to Live SAS xpt 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 SAS xpt data for you.
-
Connecting Moonlit Workflow with Trello Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Trello data in real time.
-
How to connect and process Todoist data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Todoist data.
-
Automated Continuous Accelo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Accelo replication to MongoDB.
-
Work with EmailOctopus Data in FoxPro
Load EmailOctopus data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate with Rebilly Data in JReport Designer
Create charts and reports based on Rebilly data in JReport Designer.
-
Build DocuSign Visualizations in Tableau Desktop
Use CData Connect AI to connect to live DocuSign data and build visualizations in Tableau.
-
How to Seamlessly Import Superchat Data into IBM SPSS Modeler
Integrate Superchat data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Live HDFS Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live HDFS data through a conversational interface.
-
Access Live Amazon Marketplace Data in Coginiti Pro
Connect to and query live Amazon Marketplace data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Query LDAP Objects in MySQL Workbench
Execute MySQL queries against live LDAP objects from MySQL Workbench.
-
Creating LinkedIn Ads-Connected Applications in Unqork
You can use CData Connect AI to feed LinkedIn Ads data to Unqork and build custom business apps.
-
Build MVC Applications with Connectivity to Dropbox Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dropbox from an ASP.NET MVC application.
-
How to Connect DBeaver to Google Ad Manager via a JDBC Driver
Manage Google Ad Manager data with visual tools in DBeaver like the query browser.
-
Provide OData Services of Klipfolio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Klipfolio data by developing a WCF Service Application.
-
How to connect Amazon QuickSight to Shopify Data
Create a connection to Shopify data in CData Connect AI and insert Shopify data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Goose with Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live QuickBooks Online data from within the local AI agent.
-
Query, Visualize, and Share live ZohoInvoice Data in Redash
Use CData Connect AI to connect to live ZohoInvoice data in Redash for querying, visualizing, and sharing.
-
Create Data Visualizations in Cognos BI with Sugar CRM Data
Access Sugar CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Choosing the Best Method to Connect SAP BusinessObjects BI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP BusinessObjects BI data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Impala with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Impala with External Services.
-
Create Power BI Reports on Real-Time BigCommerce Data
Use the CData ODBC Driver for BigCommerce to visualize BigCommerce data in Power BI Desktop.
-
Integrate Theia IDE with Live Twitter Ads 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 Twitter Ads data from within the development environment.
-
Design BIRT Reports on Google Translate Data
Provide current Google Translate data to your embedded analytics.
-
Use the CData Software ODBC Driver for SAP in MicroStrategy Desktop
Connect to SAP data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP.
-
Migrating data from Gorgias to Snowflake using CData SSIS Components.
Easily push Gorgias data to Snowflake using the CData SSIS Tasks for Gorgias and Snowflake.
-
Create Data Visualizations in Cognos BI with Recurly Data
Access Recurly data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind QuickBooks Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for QuickBooks with the DevExpress Windows Forms and Web controls to provide QuickBooks data to a chart.
-
Access Live Box Data in Excel 365 Online (Excel for the web)
Connect to Box data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connecting Pipedream with Microsoft Entra ID Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Microsoft Entra ID data in real time.
-
Integrate Live ZohoDesk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live ZohoDesk data from within the IDE.
-
Grafana Reporting in OBIEE with the Grafana JDBC Driver
Deploy the Grafana JDBC driver on OBIEE to provide real-time reporting across the enterprise.