CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for Hive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Hive to connect to Apache Hive from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Hive in Excel.
-
Analyze Oracle Financials Cloud Data in Cognos Analytics
Use CData Connect AI to connect to Oracle Financials Cloud Data from Cognos Analytics and analyze live Oracle Financials Cloud.
-
Connect Google Tasks to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Tasks with IBM WebSphere for seamless data integration and connectivity.
-
Create Data Visualizations in Cognos BI with MarkLogic Data
Access MarkLogic as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Codex CLI with Contentful 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.
-
Automate SAP Fieldglass Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Fieldglass replication to Azure Data Lake.
-
Access Live Quickbase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Quickbase from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Microsoft Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Ads.
-
Getting Started with the CData JDBC Driver for Apify
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Apify.
-
Build Automated Workflows with Live ActiveCampaign Data in Workato
Use CData Connect AI to connect to live ActiveCampaign and build automated workflows in Workato.
-
Create Certinia-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Certinia Data from Klipfolio and build custom visualizations using live Certinia.
-
Automated Continuous Snapchat Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to delimited files (CSV/TSV).
-
Connecting Moonlit Workflow with Act CRM 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 Act CRM in real time.
-
Query Marketo Data as a MySQL Database in Node.js
Execute MySQL queries against Marketo from Node.js.
-
Replicate Multiple CampaignMonitor Accounts
Replicate multiple CampaignMonitor accounts to one or many databases.
-
Automate Sugar CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Sugar CRM replication to SAP HANA.
-
Connect to AdRoll Data from a Connection Pool in JBoss
Integrate AdRoll into Java servlets: Use the Management Console in JBoss to install the AdRoll JDBC Driver.
-
Automate Samanage Data Replication to SAP HANA
Use CData Sync to customize and automate Samanage replication to SAP HANA.
-
Working with Confluence Data in LINQPad
Execute LINQ queries to Atlassian Confluence in LINQPad.
-
Create Reports with Coda Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Coda.
-
Build AI Agents with Dropbox Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Dropbox through CData Connect AI.
-
Query SQL Analysis Services Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SQL Analysis Services entities in PHP by modeling them as objects.
-
Visualize Live SAP Netweaver Gateway Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Netweaver Gateway into custom reports in Power BI.
-
Build Redshift-Connected Apps in Choreo
Use CData Connect AI to connect to Redshift Data from Choreo and build custom apps using live Amazon Redshift.
-
Automated Continuous Sugar CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Amazon S3.
-
How to Connect Avro Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Avro data in real time using natural language.
-
Connect to Box Data in Claris FileMaker Pro
Use the CData ODBC Driver for Box in FileMaker Pro to connect to Box and work with Box in your FileMaker applications.
-
Publish Greenhouse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Greenhouse.
-
DataBind LaunchDarkly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide LaunchDarkly to a chart.
-
How to use SQLAlchemy ORM to access AdRoll Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of AdRoll.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Vault CRM actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Build Semantic Layer Views for SAP SuccessFactors Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP SuccessFactors.
-
Use the CData Software JDBC Driver for Exa in MicroStrategy Web
Connect to Exa in MicroStrategy Web using the CData Software JDBC Driver for Exa.
-
Process & Analyze AlloyDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live AlloyDB Data.
-
How to Connect to & Open BenchmarkEmail Data in Microsoft Excel
This article uses the CData ODBC driver for BenchmarkEmail to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Mailjet Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Mailjet replication to Google Cloud SQL.
-
Deploy the ADO.NET Provider for Tally on an SSRS Report Server
Connect to Tally ERP from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate Chargebee with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Chargebee with External Services.
-
How to use SQLAlchemy ORM to access JobNimbus Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of JobNimbus.
-
Build Twitter Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Twitter Ads to explore live Twitter Ads Data in GitHub Copilot to assist with building Twitter Ads-powered applications.
-
Integrating Claude Code CLI with Microsoft Ads 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.
-
ETL Mailgun in Oracle Data Integrator
This article shows how to transfer Mailgun into a data warehouse using Oracle Data Integrator.
-
Use Biml to Build SSIS Tasks to Replicate Vault CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Veeva Vault & Vault CRM to SQL Server.
-
Connect to Shortcut 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 Shortcut and work with Shortcut in your FileMaker application.
-
Build Charts with Sendwithus Data in Clear Analytics
Create dynamic charts and perform analytics based on Sendwithus in Clear Analytics.
-
Access Live FHIR Data in TIBCO Data Virtualization
Use the FHIR Tibco DV Adapter to create a FHIR data source in TIBCO Data Virtualization Studio and gain access to live FHIR from your TDV Server.
-
Access Live Google Translate Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Translate in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Cloudflare Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cloudflare replication to Amazon S3.
-
How to use SQLAlchemy ORM to access Opsgenie Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Opsgenie.
-
DataBind Controls to Twilio Data in Delphi
DataBind to Twilio in Delphi with standard data access components and controls.
-
DataBind Typeform Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Typeform to a chart.
-
Create Informatica Mappings From/To an ODBC Data Source for Drift
Create an ODBC connection to Drift in Informatica and browse and transfer Drift.
-
Access Live Salesforce CRM Analytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesforce CRM Analytics from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Oracle Sales Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle Sales.
-
Access Live Microsoft Teams Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Teams from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze Browserless Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Browserless from Power Pivot. You will use the Table Import Wizard to load Browserless. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Float
Create an ODBC connection to Float in Informatica and browse and transfer Float.
-
Automated Continuous Pipeliner CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Google Cloud SQL.
-
Perform Batch Operations with Zoho Projects Data in Apache NiFi
Connect to Zoho Projects and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Codat Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Codat into the statistical analysis tools available in SAS JMP. This article shows how to use Codat in the Graph Builder and Query Builder.
-
Build Semantic Layer Views for ZeroBounce Data in APOS Live Data Gateway
Use the CData Connector for ZeroBounce in APOS Live Data Gateway to build Semantic Layer Views for ZeroBounce.
-
Integrate Microsoft Planner with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Microsoft Planner with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Planner.
-
Integrate Microsoft OneDrive with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Microsoft OneDrive with External Services.
-
Use the CData Software ODBC Driver for Miro in MicroStrategy
Connect to Miro in MicroStrategy Developer using the CData Software ODBC Driver for Miro.
-
Deploy the ADO.NET Provider for Facebook Ads on an SSRS Report Server
Connect to Facebook Ads from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Enable the SendInBlue JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SendInBlue.
-
Analyze Odoo Data in Looker
Use CData Connect AI to connect to Odoo Data from Looker and build custom apps using live Odoo ERP.
-
Integrating LangChain with WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on WooCommerce within automated workflows.
-
Manage Toggl Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Toggl.
-
Create Oracle Financials Cloud-Connected Applications in Appsmith
Connect to Oracle Financials Cloud Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Financials Cloud.
-
Visualize Live HubDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HubDB.
-
Query Intercom Data in DataGrip
Create a Data Source for Intercom in DataGrip and use SQL to query live Intercom.
-
Build Stripe-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Stripe.
-
Build MVC Applications with Connectivity to Telegram Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Telegram from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for Calendly in MicroStrategy Desktop
Connect to Calendly in MicroStrategy Desktop using the CData Software JDBC Driver for Calendly.
-
Build AI/ML Models with Live CSV Data using Dataiku
Connect CSV Data with Dataiku using the CData JDBC Driver for CSV.
-
Bridge ServiceNow Connectivity with Apache NiFi
Access and process ServiceNow in Apache NiFi using the CData JDBC Driver.
-
Migrating data from SAP ByDesign to Google BigQuery using CData SSIS Components.
Easily push SAP Business ByDesign to Google BigQuery using the CData SSIS Tasks for SAP ByDesign and Google BigQuery.
-
Integrate Amazon S3 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Amazon S3 with External Services.
-
How to use SQLAlchemy ORM to access LinkedIn Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LinkedIn.
-
How to connect SharePoint with Instagram Data through external lists
Provide Instagram to SharePoint users as an external list.
-
Integrate with Dynamics 365 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Dynamics 365 to a JSON file on disk.
-
A PostgreSQL Interface for Adobe Commerce Data (MySQL Remoting via JDBC)
Use the Remoting features of the Adobe Commerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Stream Excel Online Data into Apache Kafka Topics
Access and stream Microsoft Excel Online in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Antigravity CLI with Browserless via CData CLI
Connect Browserless to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Paylocity Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Paylocity to connect to Paylocity and execute queries in PowerBuilder.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Suadeo
Provide connectivity to Suadeo through an SAP BusinessObjects universe.
-
Integrating Presto Data in Talend Cloud Data Management Platform
Connect Presto Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Presto.
-
Connect to WordPress in SpagoBI
Create reports featuring live WordPress in SpagoBI Studio. Host WordPress reports on SpagoBI Server.
-
How to Query Live ZohoInvoice Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoInvoice data in natural language using Python.
-
Using the CData Software ODBC Driver for Twilio in PyCharm
Connect to Twilio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twilio.
-
Integrate Cursor with Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sage Business Cloud Accounting from within the editor.
-
Replicate Google Spanner Data to Multiple Databases via the CData Sync CLI
Replicate Google Spanner to disparate databases with a single configuration.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zoho CRM to Power BI dashboards. Simply drag and drop Zoho CRM into data visuals on the Power BI canvas.
-
How to connect to Accelo Data from IntelliJ
Integrate connectivity to Accelo with wizards in IntelliJ.
-
LINQ to Vimeo 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 Vimeo Data Provider.
-
Connecting GenSpark with SharePoint Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft SharePoint without any replication or custom integration required.
-
Connect to Kintone Data in Aqua Data Studio
Access Kintone from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to use SQLAlchemy ORM to access ZohoPeople Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZohoPeople.
-
Integrate with Live BigQuery Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BigQuery from the MuleSoft Anypoint Platform to integrate live Google BigQuery into custom reports and dashboards.