CData Software - Knowledge Base
Recent Articles
-
Add ZohoDesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoDesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Salesloft Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesloft facts in real time.
-
Automated Optimizely Data Replication to Teradata
Use CData Sync to Customize and automate Optimizely data replication to Teradata.
-
Load MailChimp Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MailChimp data to a database.
-
How to Connect to Live SendGrid 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 SendGrid data for you.
-
How to Work with PDFMonkey Data in AWS Glue Jobs Using JDBC
Connect to PDFMonkey from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live QuickBooks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live QuickBooks data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Jira-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Jira Data from Zoho Analytics and import live Jira data.
-
Build Charts with Mailgun Data in Clear Analytics
Create dynamic charts and perform analytics based on Mailgun data in Clear Analytics.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy Desktop
Connect to Azure Synapse data in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Synapse.
-
Work with Avalara AvaTax Data in FoxPro
Load Avalara AvaTax data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Twilio-Connected Dashboards in Grafana
Connect to Twilio Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Twilio data.
-
Publish Reports with Freshdesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshdesk data.
-
Connect to Quickbase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Quickbase data.
-
Use Azure AI Foundry to Talk to Your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Azure Analysis Services data for you.
-
Connect to Scrapfly in SpagoBI
Create reports featuring live Scrapfly data in SpagoBI Studio. Host Scrapfly reports on SpagoBI Server.
-
Automated Continuous Procore Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Procore replication to Google BigQuery.
-
Integrating GitHub Copilot with SAP Ariba Source 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.
-
Enable the Calendly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Calendly data.
-
Connect to Certinia Data from Crystal Reports
Use CData Connect AI to connect to and report on live Certinia data from Crystal Reports.
-
Automate EnterpriseDB Data Replication to Azure Synapse
Use CData Sync to customize and automate EnterpriseDB data replication to Azure Synapse.
-
Working with MongoDB Data in LINQPad
Execute LINQ queries to MongoDB data in LINQPad.
-
LINQ to Azure Analysis Services 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 Azure Analysis Services Data Provider.
-
Access Live Printify 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 Printify data through MCP integration.
-
Integrating Dataiku with Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Blackbaud FE NXT data.
-
Import Real-Time Insightly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Insightly data in ColdFusion.
-
Consume Azure Analysis Services OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Analysis Services data as OData feeds from PowerBuilder using the API Server.
-
Back Up Copper 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 Copper data data.
-
How to Connect to & Open ConvertKit Data in Microsoft Excel
This article uses the CData ODBC driver for ConvertKit to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Outreach.io Data in CloverDX (formerly CloverETL)
Transfer Outreach.io data using the visual workflow in the CloverDX data integration tool.
-
View Reports on Real-Time Chargebee Data in Power BI Report Server
Use the CData ODBC Driver for Chargebee to visualize Chargebee data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Aweber Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Aweber and the SQL Gateway to access Aweber data from Google Apps Script.
-
How to import Placid Data into Apache Solr
Use the CData Software JDBC Driver for Placid in Data Import Handler and create an automated import of Placid data to Apache Solr Enterprise Search platform.
-
How to Connect to Live Sage 200 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 Sage 200 data for you.
-
Creating PingOne-Connected Applications in Unqork
You can use CData Connect AI to feed PingOne data to Unqork and build custom business apps.
-
How to Build an ETL App for SAP SuccessFactors Data in Python with CData
Create ETL applications and real-time data pipelines for SAP SuccessFactors data in Python with petl.
-
Mouseflow Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mouseflow facts in real time.
-
Use the CData ODBC Driver for Quaderno in Microsoft Power Query
You can use the CData Quaderno ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Quaderno data into Microsoft Power Query.
-
Build Charts with Unbounce Data in Clear Analytics
Create dynamic charts and perform analytics based on Unbounce data in Clear Analytics.
-
Create SAP SuccessFactors LMS-Connected Nintex Workflows
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Nintex Workflow Cloud and build custom workflows using live SAP SuccessFactors LMS data.
-
Connect to ZendeskSell Data in Ruby
Connect to ZendeskSell data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Query Live JSON Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live JSON services data in natural language using Python.
-
Query Live Oracle Financials Cloud 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 Oracle Financials Cloud data directly from the development environment.
-
Build CapsuleCRM-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live CapsuleCRM data.
-
Automated Continuous ClickUp Replication to Snowflake
Use CData Sync for automated, continuous, customizable ClickUp replication to Snowflake.
-
Import BigQuery Data Using Azure Data Factory
Use CData Connect AI to connect to BigQuery Data from Azure Data Factory and import live BigQuery data.
-
How to connect and process Chargebee data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Chargebee data.
-
Automated Continuous Hubstaff Replication to SQL Server
Use CData Sync for automated, continuous, customizable Hubstaff replication to SQL Server.
-
Working with Gong Data in LINQPad
Execute LINQ queries to Gong data in LINQPad.
-
Use the CData Software ODBC Driver for Amazon S3 in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon S3 data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon S3.
-
Automate Stack Exchange Data Replication to Couchbase
Use CData Sync to Customize and automate Stack Exchange data replication to Couchbase.
-
Build Automated Workflows with Live Toggl Data in Workato
Use CData Connect AI to connect to live Toggl data and build automated workflows in Workato.
-
Operational Reporting on Jodoo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Jodoo data.
-
How to connect to Suadeo Data from Spring Boot
Connect to Suadeo in a Spring Boot Application using the CData JDBC Driver for Suadeo
-
Automate DB2 for i Data Replication to Azure Data Lake
Use CData Sync to customize and automate DB2 for i data replication to Azure Data Lake.
-
Getting Started with the CData ODBC Driver for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Facebook Ads.
-
Build Automated Workflows with Live PolarTeamPro Data in Workato
Use CData Connect AI to connect to live PolarTeamPro data and build automated workflows in Workato.
-
Use Azure AI Foundry to Talk to Your Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Campaigner data for you.
-
Building Dynamic Web Pages with Azure Data Lake Storage Data Using AngularJS
Create single-page applications with live connectivity to Azure Data Lake Storage using the CData API Server.
-
Automated Continuous FreeAgent Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable FreeAgent replication to Azure SQL Database.
-
Explore Geographical Relationships in Demio Data with Power Map
Create data visualizations with Demio data in Power Map.
-
Create Data Visualizations in Cognos BI with Auth0 Data
Access Auth0 data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Toggl Data in Heroku for Use in Salesforce Connect
Replicate Toggl data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Kiro with Bannerbear 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.
-
Integrating Kiro with Foursquare 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 Easily Query BigQuery Data in OpenOffice Base
Connect to BigQuery data in OpenOffice Base using the CData ODBC Driver for BigQuery and generate reports with live data insights.
-
Work with Live API Data in Power Query
Use CData Connect AI to connect to API data and work with live API data in Microsoft Power Query.
-
Access Live Square 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 Square data through MCP integration.
-
Load EmailOctopus Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load EmailOctopus data to a database.
-
How to Query Live Snowflake Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Snowflake data data in natural language using Python.
-
Integrate LibreChat with Live Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cloudflare data from within the chat interface.
-
Integrate LibreChat with Live Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Odoo data from within the chat interface.
-
Getting Started with the CData ODBC Driver for Lakebase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Lakebase.
-
Integrate Live GraphQL 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 GraphQL data from within the IDE.
-
View Reports on Real-Time Workday Data in Power BI Report Server
Use the CData ODBC Driver for Workday to visualize Workday data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Cline with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Marketo data from within your IDE.
-
Import and Visualize MarkLogic Data in Power View
Create data visualizations based on MarkLogic data in Excel.
-
Automated Continuous Elorus Replication to Vertica
Use CData Sync for automated, continuous, customizable Elorus replication to Vertica.
-
Connect to Discourse from a Connection Pool in WebLogic
Use the CData JDBC Driver for Discourse to connect to Discourse data from Web applications running on WebLogic.
-
Migrating data from NetSuite to Google BigQuery using CData SSIS Components.
Easily push NetSuite data to Google BigQuery using the CData SSIS Tasks for NetSuite and Google BigQuery.
-
Build ClickUp-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ClickUp data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Copper
Provide connectivity to Copper data through an SAP BusinessObjects universe.
-
Integrating Clockify Data in Talend Cloud Data Management Platform
Connect Clockify Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Apps with Live Bitly Data Using the Low-Code Development Platform of Mendix
Connect Bitly data with Mendix to build apps using the CData API Driver for JDBC.
-
How to connect Amazon QuickSight to Zoho Projects Data
Create a connection to Zoho Projects data in CData Connect AI and insert Zoho Projects data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to load Rootly data into Elasticsearch via Logstash
Introducing a simple method to load Rootly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Google's Antigravity Agent with Live Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Aweber data using the Model Context Protocol.
-
Access Live Google Ads Data in AWS Lambda
Connect to live Google Ads data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PolarTeamPro.
-
Replicate Multiple Planio Accounts
Replicate multiple Planio accounts to one or many databases.
-
Build a Singer.io Tap for Foursquare With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Foursquare data using the CData Python Connector.
-
Connect to Outreach.io Data from HeidiSQL
Use CData Connect AI to connect to and query live Outreach.io data from HeidiSQL.
-
Automated Continuous Oracle Sales Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Sales replication to SQL Server.
-
Build Dashboards with CSV Data in Dundas BI
Create dynamic dashboards and perform analytics based on CSV data in Dundas BI.
-
Publish Crystal Reports on FreeAgent Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FreeAgent data.
-
Integrating LangChain with SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SendPulse data within automated workflows.
-
Extract, Transform, and Load Amazon S3 Data in Informatica PowerCenter
Create a simple Workflow for Amazon S3 data in Informatica PowerCenter.
-
Connect to Brex 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 Brex and work with Brex data in your FileMaker application.
-
Connect to Sybase Data in CloverDX (formerly CloverETL)
Transfer Sybase data using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData SSIS Components for Tanda
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Tanda.