CData Software - Knowledge Base
Recent Articles
-
Integrate with TaxJar Data in JReport Designer
Create charts and reports based on TaxJar data in JReport Designer.
-
Access Live Act-On Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Act-On data from your Excel spreadsheets.
-
Use Grok to Talk to Your Stripe 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 Stripe data for you.
-
Load Campaigner Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Campaigner data to a database.
-
LINQ to Rootly 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 Rootly Data Provider.
-
Create Power BI Reports on Real-Time Shopify Data
Use the CData ODBC Driver for Shopify to visualize Shopify data in Power BI Desktop.
-
Choosing the Best Method to Connect Procore to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Procore data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Trigger Workday IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Workday with standard wizards in Logic Apps.
-
Interact with Live Smartsheet Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Smartsheet data.
-
Connect to and Visualize Live Pingdom Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pingdom data.
-
Integrate Deel Data in the Pentaho Report Designer
Publish reports based on Deel data in the Pentaho BI tool.
-
Access Live Kintone Data in Excel 365 Online (Excel for the web)
Connect to Kintone data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Certinia Data from PowerShell
Write a quick PowerShell script to query Certinia data. Use connectivity to the live data to replicate Certinia data to SQL Server.
-
Integrate with Monday.com Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Monday.com data in SnapLogic.
-
Extract, Transform, and Load Gong Data in Informatica PowerCenter
Create a simple Workflow for Gong data in Informatica PowerCenter.
-
Build OneNote-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 OneNote data without replication.
-
Load Outlook Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Outlook data to a database.
-
Connect Strava to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Strava data using the CData Python MCP Server.
-
Connect to SAP Ariba Procurement from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Ariba Procurement data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Shortcut Data in HULFT Integrate
Connect to Shortcut as a JDBC data source in HULFT Integrate
-
How to Access Strava Data Using Entity Framework
This article shows how to access Strava data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software ODBC Driver for Mailgun in MicroStrategy Web
Connect to Mailgun data in MicroStrategy Web using the CData Software ODBC Driver for Mailgun.
-
Use Microsoft Copilot Studio to talk to your Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Odoo data for you.
-
Build Automated Sybase IQ-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sybase IQ data and build automated workflows in Zapier.
-
Build Data Flows from Oracle Eloqua Reporting to SQL Server using SSIS
Easily back up Oracle Eloqua Reporting data to SQL Server using the SSIS components for Oracle Eloqua Reporting.
-
How to publish and share Stack Exchange Data dashboards with Tableau Server
The CData ODBC driver for Stack Exchange enables you integrate Stack Exchange data into Tableau dashboards.
-
Connect to CircleCI Data in CloverDX (formerly CloverETL)
Transfer CircleCI data using the visual workflow in the CloverDX data integration tool.
-
Load AgileCRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load AgileCRM data to a database.
-
How to import Campaigner Data into Apache Solr
Use the CData Software JDBC Driver for Campaigner in Data Import Handler and create an automated import of Campaigner data to Apache Solr Enterprise Search platform.
-
Build Automated Workflows with Live Databricks Data in Workato
Use CData Connect AI to connect to live Databricks data and build automated workflows in Workato.
-
Build Visualizations of SageHR Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SageHR data in Birst.
-
How to integrate Jumpseller with Apache Airflow
Access and process Jumpseller data in Apache Airflow using the CData JDBC Driver.
-
Establish a Live Connection with Redshift Data using Tableau Bridge
The CData ODBC Driver for Redshift enables you to integrate live Redshift data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create LaunchDarkly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LaunchDarkly data in MySQL .
-
How to Access SAP Business One Data Using Entity Framework
This article shows how to access SAP Business One data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Link Harvest with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Harvest data in Filemaker Pro for Mac or Windows.
-
Access Live Bullhorn CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bullhorn CRM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating LangChain with Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Data Lake Storage data within automated workflows.
-
Integrate Wave Financial with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wave Financial with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wave Financial data.
-
Extract, Transform, and Load Teamwork Data in Informatica PowerCenter
Create a simple Workflow for Teamwork data in Informatica PowerCenter.
-
Interact with Live Yelp Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Yelp data.
-
Excel Spreadsheet Automation on Tavily Data with the QUERY Formula
Pull data from Tavily, automate spreadsheets, and more with the QUERY formula.
-
Build a Simple VCL Application for Azure Table Data
How to build a simple VCL Application to view Azure Table data in RAD Studio using the CData ODBC Driver for Azure Table.
-
Operational Reporting on Codat Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Codat data.
-
How to create Tickspot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Tickspot data in MySQL .
-
Connect to Azure Table Data from a Connection Pool in Jetty
The Azure Table JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Table data from Web apps in Jetty.
-
Use Dash to Build to Web Apps on Freshdesk Data
Create Python applications that use pandas and Dash to build Freshdesk-connected web apps.
-
Use the CData Software JDBC Driver for GitLab in MicroStrategy Desktop
Connect to GitLab data in MicroStrategy Desktop using the CData Software JDBC Driver for GitLab.
-
Working with SendGrid Data in LINQPad
Execute LINQ queries to SendGrid data in LINQPad.
-
Migrating data from Bitbucket to Databricks using CData SSIS Components.
Easily push Bitbucket data to Databricks using the CData SSIS Tasks for Bitbucket and Databricks.
-
How to connect PolyBase to Zoho Books
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Books data.
-
Connect Act-On to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Act-On with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect DBeaver to MailChimp via a JDBC Driver
Manage MailChimp data with visual tools in DBeaver like the query browser.
-
Automated Continuous VWO Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable VWO replication to delimited files (CSV/TSV).
-
Automated Continuous Cloudflare Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Cloudflare replication to Amazon Redshift.
-
Automated Continuous EnterpriseDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to MongoDB.
-
Integrate MailChimp Data in the Pentaho Report Designer
Publish reports based on MailChimp data in the Pentaho BI tool.
-
Moving Data from Bullhorn CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bullhorn CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
ETL YouTube Analytics in Oracle Data Integrator
This article shows how to transfer YouTube Analytics data into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze ZohoInvoice Data in Alteryx Designer (Connect AI)
Build workflows to access live ZohoInvoice data for self-service data analytics.
-
Integrating OpenCode with PDFMonkey 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.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Desktop
Connect to Salesforce Pardot data in MicroStrategy Desktop using the CData Software JDBC Driver for Salesforce Pardot.
-
Integrating LlamaIndex with HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on HBase data in real time.
-
Connect to Zoho Books Data in Ruby
Connect to Zoho Books data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Figshare Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Figshare replication to Google BigQuery.
-
How to Build an ETL App for Azure DevOps Data in Python with CData Connect AI
Extract and transform live Azure DevOps data in Python with petl and the CData Connect AI Python SDK.
-
Visualize Live ZohoInvoice Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoInvoice data.
-
LINQ to SAP Ariba Procurement 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 SAP Ariba Procurement Data Provider.
-
Connect to Pipeliner CRM Data in DBeaver
Use the CData ODBC Driver to connect to Pipeliner CRM data in DBeaver.
-
Integrate Google's Antigravity Agent with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Cvent data using the Model Context Protocol.
-
Use the CData Software JDBC Driver for Zoho Creator in MicroStrategy
Connect to Zoho Creator data in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Creator.
-
Automated Continuous Nuclia Replication to SQLite
Use CData Sync for automated, continuous, customizable Nuclia replication to SQLite.
-
Analyze Live Sybase Data in SAS Viya
Use CData Connect AI to connect to Sybase data from SAS Viya and deploy self-service analytics using live Sybase data.
-
How to Work with SuiteCRM Data in ETL Validator JDBC
Connect to SuiteCRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Mode Data in ACL Analytics
Connect to Mode data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Mode data.
-
Integrate Live Sage Cloud Accounting Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sage Cloud Accounting from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sage Cloud Accounting data.
-
Import CouchDB Data Using Azure Data Factory
Use CData Connect AI to connect to CouchDB Data from Azure Data Factory and import live CouchDB data.
-
Provide OData Services of Salesforce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce data by developing a WCF Service Application.
-
Access Live SuiteCRM Data in AWS Lambda
Connect to live SuiteCRM data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Webflow Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Webflow replication to IBM DB2.
-
Create Dynamic Workable Grids Using the Infragistics XamDataGrid
Learn how you can connect Workable to Infragistics XamDataGrid to build dynamic grids.
-
Connect to OData Services from a Connection Pool in Jetty
The OData JDBC Driver supports connection pooling: This article shows how to connect faster to OData services from Web apps in Jetty.
-
Connect to Apollo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Apollo.
-
Integrate with Oracle SCM Data in JReport Designer
Create charts and reports based on Oracle SCM data in JReport Designer.
-
Easily Integrate TigerGraph Data in Lazarus Pascal IDE
Learn how to easily integrate live TigerGraph data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to publish and share Pinecone Data dashboards with Tableau Server
The CData ODBC driver for Pinecone enables you integrate Pinecone data into Tableau dashboards.
-
Connect to Slack 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 Slack data.
-
Build Dashboards with Okta Data in DBxtra
Create dynamic dashboards and perform analytics based on Okta data in DBxtra.
-
Automated Continuous Act CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Act CRM replication to Vertica.
-
Build Pipelines with Live Klaviyo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Klaviyo from Google Cloud Data Fusion, enabling the integration of live Klaviyo data into the building and management of effective data pipelines.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams data for you.
-
DataBind Oracle Financials Cloud Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle Financials Cloud with the DevExpress Windows Forms and Web controls to provide Oracle Financials Cloud data to a chart.
-
How to Query NASA Data in MySQL Workbench
Execute MySQL queries against live NASA data from MySQL Workbench.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Ads data for you.
-
Automated Continuous SurveyMonkey Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to PostgreSQL.
-
Build XML-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to XML data and build web apps with connectivity to live XML data.
-
Use the CData Software ODBC Driver for ClickTime in MicroStrategy
Connect to ClickTime data in MicroStrategy Developer using the CData Software ODBC Driver for ClickTime.
-
Connect to and Visualize Live Apify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apify data.
-
Query Attio Data in ColdFusion
Write standard ColdFusion data access code to connect to Attio data.
-
Build AI/ML Models with Live IBM Cloud Object Storage Data using Dataiku
Connect IBM Cloud Object Storage Data with Dataiku using the CData JDBC Driver for IBM Cloud Object Storage.