CData Software - Knowledge Base
Recent Articles
-
Connect to Google Tasks Data in HULFT Integrate
Connect to Google Tasks as a JDBC data source in HULFT Integrate
-
Working with Klipfolio Data in LINQPad
Execute LINQ queries to Klipfolio data in LINQPad.
-
Automated Continuous LinkedIn Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Snowflake.
-
Create Azure Data Catalog-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Data Catalog Data from OutSystems and build custom enterprise apps using live Azure Data Catalog data.
-
Connecting Agentforce with OneNote 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 OneNote data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Twitter Ads
Provide connectivity to Twitter Ads data through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Greenhouse
Provide connectivity to Greenhouse data through an SAP BusinessObjects universe.
-
Replicate Multiple Impala Accounts via the CData Sync CLI
Replicate multiple Impala accounts to one or many databases.
-
Integrating Codex with ZohoExpense 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.
-
Build Pipelines with Live CapsuleCRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to CapsuleCRM from Google Cloud Data Fusion, enabling the integration of live CapsuleCRM data into the building and management of effective data pipelines.
-
How to import Square Data into Apache Solr
Use the CData Software JDBC Driver for Square in Data Import Handler and create an automated import of Square data to Apache Solr Enterprise Search platform.
-
Create SAP Ariba Procurement Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Ariba Procurement from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Zuora Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zuora data into TIBCO Spotfire.
-
Integrating LangChain with Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zoho CRM data within automated workflows.
-
Process & Analyze ADP Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ADP Data.
-
Automate Monday.com Data Replication to Azure Data Lake
Use CData Sync to customize and automate Monday.com data replication to Azure Data Lake.
-
Build Okta-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Okta Data from Zoho Analytics and import live Okta data.
-
How to create ChargeOver federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ChargeOver data in MySQL .
-
Build Voice Agents in ElevenLabs with access to Live Acumatica Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Acumatica data.
-
Build Discord Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Discord data and build visualizations in Tableau Cloud.
-
Getting Started with the CData JDBC Driver for ShipStation
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ShipStation.
-
How to Connect to Klaviyo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Klaviyo data. Leverage the pyodbc module for ODBC in Python.
-
How to connect PolyBase to JobNimbus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live JobNimbus data.
-
Build Dynamics 365-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 Dynamics 365 data without replication.
-
Connect to Active Directory Data in NetBeans
Connect to Active Directory data in NetBeans with the data source configuration wizard.
-
Connect to Real-Time ZeroBounce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZeroBounce data in Power Apps.
-
Query Live Instagram 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 Instagram data through a conversational interface.
-
Easily Integrate Reckon Data in Lazarus Pascal IDE
Learn how to easily integrate live Reckon data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Moving Data from Xero to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Xero data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Azure Data Catalog-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Data Catalog data.
-
Connect to and Query Cohere Data in QlikView over ODBC
Create data visualizations with Cohere data in QlikView.
-
Import Real-Time Klaviyo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Klaviyo data in ColdFusion.
-
Connect to Sendwithus Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sendwithus as an External Source in Dremio.
-
Integrating Boomi Agentstudio with PolarTeamPro Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to PolarTeamPro data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build SAP HANA XS Advanced Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP HANA XS Advanced data and build visualizations in Tableau.
-
Build Authorize.Net-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Authorize.Net data.
-
Integrating LlamaIndex with Adobe Experience Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Adobe Experience Manager data in real time.
-
Establish a Live Connection with Drip Data using Tableau Bridge
The CData ODBC Driver for Drip enables you to integrate live Drip data into Tableau Cloud dashboards using the Tableau Bridge.
-
ETL FHIR in Oracle Data Integrator
This article shows how to transfer FHIR data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Pipeline CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pipeline CRM data replication to OneLake in Microsoft Fabric.
-
Create Dynamic NetSuite Grids Using the Infragistics XamDataGrid
Learn how you can connect NetSuite to Infragistics XamDataGrid to build dynamic grids.
-
Create Reports with Neo4J Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Neo4J data.
-
Create Reports from GraphQL Data in Looker Studio
Use CData Connect AI to gain access to live GraphQL data and create custom reports in Looker Studio.
-
Write a Simple Go Application to work with Neo4J Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Neo4J data.
-
Integrating Dataiku with Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce CRM Analytics data.
-
How to connect Amazon QuickSight to Google Ad Manager Data
Create a connection to Google Ad Manager data in CData Connect AI and insert Google Ad Manager data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Reports from Shopify Data in Looker Studio
Use CData Connect AI to gain access to live Shopify data and create custom reports in Looker Studio.
-
Integrate ClickUp with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ClickUp with External Services.
-
How to connect SharePoint with Highrise Data through external lists
Provide Highrise data to SharePoint users as an external list.
-
Create Dynamic LinkedIn Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect LinkedIn Ads to Infragistics XamDataGrid to build dynamic grids.
-
Query, Visualize, and Share live Active Directory Data in Redash
Use CData Connect AI to connect to live Active Directory data in Redash for querying, visualizing, and sharing.
-
Seamlessly Bring Aweber Data into Retool Using CData Connect AI
Integrate Aweber data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData SSIS Components to Insert New or Update Existing OData Records from SQL Server
Easily push SQL Server data to OData using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into OData or update existing records with data from a SQL Server database.
-
Getting Started with the CData Python Connector for Snapchat Ads
Learn to install and license the CData Python Connector and configure a connection to live Snapchat Ads data.
-
Integrating Cursor with Power BI XMLA 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.
-
How to Connect to Pinterest Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pinterest data. Leverage the pyodbc module for ODBC in Python.
-
Integrate with ClickUp Data in JReport Designer
Create charts and reports based on ClickUp data in JReport Designer.
-
Automate Spotify Data Replication to Azure Synapse
Use CData Sync to customize and automate Spotify data replication to Azure Synapse.
-
Build Dashboards with Zoho Projects Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho Projects data in DBxtra.
-
Access Live Microsoft Exchange Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Exchange data from your Excel spreadsheets.
-
Use the CData SSIS Components to Insert New or Update Existing Zoho Inventory Records from SQL Server
Easily push SQL Server data to Zoho Inventory using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zoho Inventory or update existing records with data from a SQL Server database.
-
Generating an Entity Data Model in Visual Studio Express
The Entity Data Model Wizard can be used to easily generate an Entity Data Model in Visual Studio. However this feature is not available in Visual Studio Express. In this article you will use the edmgen utility available with .NET Framework 4.0 to generate the Entity Data Model.
-
ETL QuickBooks Online in Oracle Data Integrator
This article shows how to transfer QuickBooks Online data into a data warehouse using Oracle Data Integrator.
-
Visualize TigerGraph Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to TigerGraph data.
-
View Reports on Real-Time FreshBooks Data in Power BI Report Server
Use the CData ODBC Driver for FreshBooks to visualize FreshBooks data in Power BI Desktop and then publish them to Power BI Report Server.
-
Back Up Avaza data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Avaza data data.
-
Analyze Live Dropbox Data in SAS Viya
Use CData Connect AI to connect to Dropbox data from SAS Viya and deploy self-service analytics using live Dropbox data.
-
Integrating Boomi Agentstudio with Snapchat Ads Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Snapchat Ads data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Jira Assets Data from PowerBuilder via ADO.NET
This article demonstrates how to access Jira Assets data from Appeon PowerBuilder using the CData ADO.NET Provider for Jira Assets.
-
Connect to Beeminder Data in Aqua Data Studio
Access Beeminder data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Object-Relational Mapping (ORM) with ConvertAPI 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 ConvertAPI data into a Java-based ORM framework, Hibernate.
-
Build Aircall-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Aircall data and build web apps with connectivity to live Aircall data.
-
Create Datasets from Microsoft Teams in Domo Workbench and Build Visualizations of Microsoft Teams Data in Domo
Use the CData Software ODBC Driver for Microsoft Teams to create datasets from Microsoft Teams data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Google Sheets Data in Talend Cloud Data Management Platform
Connect Google Sheets Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Sheets.
-
Access Live BigQuery Data in Excel 365 Online (Excel for the web)
Connect to BigQuery data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Excel Add-In for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Ads.
-
Integrating LangChain with Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Tally data within automated workflows.
-
Automated Azure Synapse Data Replication to Teradata
Use CData Sync to Customize and automate Azure Synapse data replication to Teradata.
-
Connect to HDFS Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live HDFS data.
-
Integrate Google's Antigravity Agent with Live TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live TaxJar data using the Model Context Protocol.
-
Automated Continuous Asana Replication to SQL Server
Use CData Sync for automated, continuous, customizable Asana replication to SQL Server.
-
Import SAP HANA XS Advanced Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP HANA XS Advanced Data and provide access to live SAP HANA XS Advanced data for custom reports in the Power BI Service.
-
Integrate Moosend Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Moosend data from Informatica Cloud.
-
Access Foursquare Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Foursquare data from your Oracle system.
-
Import Mailgun Data Using Azure Data Factory
Use CData Connect AI to connect to Mailgun Data from Azure Data Factory and import live Mailgun data.
-
Working with Customer.io Data in LINQPad
Execute LINQ queries to Customer.io data in LINQPad.
-
Create Bright Data-Connected Dashboards in Grafana
Connect to Bright Data Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Bright Data data.
-
Access Live Zuora 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 Zuora data through MCP integration.
-
How to Visualize PayPal Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live PayPal data in Python.
-
Access Live Bitly Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Bitly data from your Google Sheets.
-
Build Google Campaign Manager 360-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Campaign Manager 360 Data and create custom apps in Bubble.
-
How to Connect to Live Act CRM 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 Act CRM data through natural language.
-
Use the CData Software ODBC Driver for Teamwork in SAS for Real-Time Reporting and Analytics
Connect to real-time Teamwork data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Teamwork.
-
How to Use a Microsoft Access Database to Update Impala Data in Real Time
Update Impala data by creating a linked table in Microsoft Access with the CData Impala ODBC Driver.
-
Access Amazon S3 Data from MySQL in Amazon QuickSight
Connect to Amazon S3 and build visualizations of Amazon S3 data using a MySQL Connection in Amazon QuickSight.
-
How to Build an ETL App for SAP SuccessFactors LMS Data in Python with CData Connect AI
Extract and transform live SAP SuccessFactors LMS data in Python with petl and the CData Connect AI Python SDK.
-
Visualize Quickbase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Quickbase data.
-
View Reports on Real-Time Klaviyo Data in Power BI Report Server
Use the CData ODBC Driver for Klaviyo to visualize Klaviyo data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating LangChain with Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Paylocity data within automated workflows.
-
Create AlloyDB-Connected Dashboards in Grafana
Connect to AlloyDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to AlloyDB data.