CData Software - Knowledge Base
Recent Articles
-
Access Live Hacker News Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Hacker News into the statistical analysis tools available in SAS JMP. This article shows how to use Hacker News in the Graph Builder and Query Builder.
-
Connect to and Visualize Live Amazon Marketplace Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon Marketplace.
-
How to Connect to Live Trello 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 Trello for you.
-
How to connect to Drift Data from IntelliJ
Integrate connectivity to Drift with wizards in IntelliJ.
-
Create Dynamic ActiveCampaign Grids Using the Infragistics XamDataGrid
Learn how you can connect ActiveCampaign to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live Gmail Data in the Power BI Service
Use CData Connect AI to connect to live Gmail and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Apify Data in Heroku for Use in Salesforce Connect
Replicate Apify to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Power BI Reports on Real-Time Mailgun Data
Use the CData ODBC Driver for Mailgun to visualize Mailgun in Power BI Desktop.
-
Visualize Acumatica Data in TIBCO Spotfire through OData
Integrate Acumatica ERP into dashboards in TIBCO Spotfire.
-
Access Front 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 Front.
-
How to connect PolyBase to Strava
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Strava.
-
Natively Connect to Optimizely Data in PHP
The CData ODBC driver for Optimizely enables you to create PHP applications with connectivity to Optimizely. Leverage the native support for ODBC in PHP.
-
Bridge Parallel Connectivity with Apache NiFi
Access and process Parallel in Apache NiFi using the CData JDBC Driver.
-
Analyze NetSuite SuiteAnalytics Data in Looker
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Looker and build custom apps using live NetSuite SuiteAnalytics.
-
Replicate JotForm Data to Multiple Databases
Replicate JotForm to disparate databases with a point-and-click configuration.
-
Connect to and Query XML Data in QlikView over ODBC
Create data visualizations with XML Files in QlikView.
-
Getting Started with the CData Python Connector for Discourse
Learn to install and license the CData Python Connector
-
How to create an RPA flow for Yelp Data in UiPath Studio
Use the Yelp ODBC Driver to create workflows that access real-time Yelp without any coding.
-
Integrate Live MariaDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MariaDB and integrate live MariaDB into apps built in Microsoft Power Apps.
-
Build Mistral AI-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mistral AI.
-
How to connect SharePoint with TaxJar Data through external lists
Provide TaxJar to SharePoint users as an external list.
-
How to Connect to Humanity Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Humanity. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live Microsoft Planner 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 Microsoft Planner for you.
-
Work with Live Google Analytics Data in Power Query
Use CData Connect AI to connect to Google Analytics and work with live Google Analytics in Microsoft Power Query.
-
Connect to HubSpot Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with HubSpot Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the CData Software ODBC Driver for XML in SAS for Real-Time Reporting and Analytics
Connect to real-time XML Files in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for XML.
-
Automate Autopilot Data Replication to Azure Synapse
Use CData Sync to customize and automate Autopilot replication to Azure Synapse.
-
How to Connect DBeaver to Excel via a JDBC Driver
Manage Microsoft Excel with visual tools in DBeaver like the query browser.
-
Use Dash to Build to Web Apps on Confluence Data
Create Python applications that use pandas and Dash to build Confluence-connected web apps.
-
Working with Hacker News Data in LINQPad
Execute LINQ queries to Hacker News in LINQPad.
-
How to Connect the Power BI Service to PhantomBuster: Complete Guide
Connect to the CData Software Power BI Connector for PhantomBuster from PowerBI.com to provide real-time PhantomBuster across the organization.
-
Integrate OneNote Data in the Pentaho Report Designer
Publish reports based on Microsoft OneNote in the Pentaho BI tool.
-
Integrating LlamaIndex with Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Act CRM in real time.
-
Connect to and Visualize Live FormSite Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FormSite.
-
Visualize Live Sybase Data in the Power BI Service
Use CData Connect AI to connect to live Sybase and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to publish and share Float Data dashboards with Tableau Server
The CData ODBC driver for Float enables you integrate Float into Tableau dashboards.
-
Visualize Tally Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Tally ERP.
-
How to Work with Google Contacts Data in AWS Glue Jobs Using JDBC
Connect to Google Contacts from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Controls to Dynamics 365 Data in Delphi
DataBind to Microsoft Dynamics 365 in Delphi with standard data access components and controls.
-
Automated Amazon DynamoDB Data Replication to Teradata
Use CData Sync to Customize and automate Amazon DynamoDB replication to Teradata.
-
Publish Stack Exchange-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Stack Exchange.
-
Connect to Vertica Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Vertica in Airbyte.
-
Import Office 365 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Office 365. In this article, you will use the OData format to import Microsoft Office 365 into Microsoft Power Query.
-
Create Reports from AlloyDB Data in Looker Studio
Use CData Connect AI to gain access to live Google AlloyDB and create custom reports in Looker Studio.
-
Bind Live Gmail Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Gmail data
-
Build Jira-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Jira to explore live Jira Data in GitHub Copilot to assist with building Jira-powered applications.
-
How to Easily Query Marketo Data in OpenOffice Base
Connect to Marketo data in OpenOffice Base using the CData ODBC Driver for Marketo and generate reports with live data insights.
-
LINQ to Pinecone 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 Pinecone Data Provider.
-
How to Connect to & Open Google Contacts Data in Microsoft Excel
This article uses the CData ODBC driver for Google Contacts to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize ServiceDesk Plus Data in Sisense
Create an ElastiCube in Sisense app with access to ServiceDesk Plus.
-
Prepare, Blend, and Analyze Google Ad Manager Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Ad Manager for self-service data analytics.
-
Use the CData Software JDBC Driver for Airtable in MicroStrategy Desktop
Connect to Airtable in MicroStrategy Desktop using the CData Software JDBC Driver for Airtable.
-
Connect to Live Tally Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Tally in CData Connect AI and connect to your Tally ERP from PostgreSQL.
-
Viewing Wrike Data in RAD Studio Data Explorer
How to view Wrike in RAD Studio Data Explorer using the CData ODBC Driver for Wrike.
-
Integrate with live Square Data in Jitterbit
Use CData Connect AI to connect to and integrate live Square in Jitterbit.
-
Use ChatGPT to Talk to Your Redshift 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 Amazon Redshift for you.
-
Integrating Dataiku with Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Freshservice.
-
How to Build an ETL App for ActiveCampaign Data in Python with CData Connect AI
Build ETL pipelines that read and write live ActiveCampaign in Python with petl and the CData Connect AI Python SDK.
-
Bind Live Microsoft Entra ID Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Entra ID data
-
Visualize PolarTeamPro Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PolarTeamPro.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft SharePoint within intelligent workflows.
-
Integrate with MariaDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MariaDB in SnapLogic.
-
Migrating data from Auth0 to Google BigQuery using CData SSIS Components.
Easily push Auth0 to Google BigQuery using the CData SSIS Tasks for Auth0 and Google BigQuery.
-
Choosing the Best Method to Connect ActiveCampaign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ActiveCampaign from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
CouchDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache CouchDB through CData Connect AI using different applications and tools.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAS XPORT using the Model Context Protocol.
-
Analyze Asana Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Asana and visualize live Asana in Infragistics Reveal.
-
How to publish and share SAP SuccessFactors Data dashboards with Tableau Server
The CData ODBC driver for SAP SuccessFactors enables you integrate SAP SuccessFactors into Tableau dashboards.
-
Choosing the Best Method to Connect Humanity to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Humanity from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Import Real-Time LDAP Objects via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LDAP in ColdFusion.
-
Integrate with Webflow Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Webflow to a JSON file on disk.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live GitHub within intelligent workflows.
-
Import Real-Time Amplitude Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amplitude in ColdFusion.
-
Bridge YouTube Analytics Connectivity with Apache NiFi
Access and process YouTube Analytics in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous SendInBlue Replication to SQLite
Use CData Sync for automated, continuous, customizable SendInBlue replication to SQLite.
-
Integrate with live Google Search Results in Jitterbit
Use CData Connect AI to connect to and integrate live Google Search in Jitterbit.
-
Connect to Facebook Ads Data in HULFT Integrate
Connect to Facebook Ads as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Blackbaud FE NXT
Provide connectivity to Blackbaud FE NXT through an SAP BusinessObjects universe.
-
Analyze RabbitMQ Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze RabbitMQ with the CData JDBC Driver for RabbitMQ.
-
Working with Autopilot Data in LINQPad
Execute LINQ queries to Autopilot in LINQPad.
-
Build SharePoint-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SharePoint to explore live SharePoint Data in Gemini Code Assist to assist with building SharePoint-powered applications.
-
Replicate Jira Data to Multiple Databases via the CData Sync CLI
Replicate Atlassian Jira to disparate databases with a single configuration.
-
Build AI/ML Models with Live Raisers Edge NXT Data using Dataiku
Connect Raisers Edge NXT Data with Dataiku using the CData JDBC Driver for Raisers Edge NXT.
-
Access Copper Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Copper from your Oracle system.
-
Connect to Front Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to SendPulse Data in NetBeans
Connect to SendPulse in NetBeans with the data source configuration wizard.
-
Access Asana Data from MySQL in Amazon QuickSight
Connect to Asana and build visualizations of Asana using a MySQL Connection in Amazon QuickSight.
-
Automate Stripe Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Stripe from PowerShell? This article demonstrates how to utilize the Stripe Cmdlets for tasks like connecting to Stripe, automating operations, downloading data, and more.
-
Connect to Zoho Recruit Data in RapidMiner
Integrate Zoho Recruit with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live Mode Data in AWS Lambda
Connect to live Mode in AWS Lambda using the CData JDBC Driver.
-
DataBind Controls to ConstantContact Data in C++Builder
DataBind to ConstantContact in C++Builder with standard components and controls.
-
How to Connect to & Open Harvest Data in Microsoft Excel
This article uses the CData ODBC driver for Harvest to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Boomi Agentstudio with DocuSign Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to DocuSign, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build a Simple VCL Application for IBM Informix Data
How to build a simple VCL Application to view IBM Informix in RAD Studio using the CData ODBC Driver for IBM Informix.
-
Create Salesforce CRM Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Salesforce CRM Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to LinkedIn from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from LinkedIn, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Instagram Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Instagram and visualize Instagram in SAP Analytics Cloud.
-
Build MVC Applications with Connectivity to DocuSign Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access DocuSign from an ASP.NET MVC application.
-
Automated Continuous Phoenix Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Phoenix replication to PostgreSQL.
-
Integrating Kiro CLI with Printify 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.