CData Software - Knowledge Base
Recent Articles
-
Connect to SAP SuccessFactors LMS from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS from Web applications running on WebLogic.
-
Access Live Reckon in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Reckon into the statistical analysis tools available in SAS JMP. This article shows how to use Reckon in the Graph Builder and Query Builder.
-
Analyze Google Ad Manager with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Ad Manager from Power Pivot. You will use the Table Import Wizard to load Google Ad Manager. You can visually build the import query or use any SQL supported by the driver.
-
Connect Square to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Square with IBM WebSphere for seamless data integration and connectivity.
-
Build Adobe Experience Manager-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Adobe Experience Manager and build web apps with connectivity to live Adobe Experience Manager.
-
Visualize Cvent in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Cvent into TIBCO Spotfire.
-
Connect to Elasticsearch 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 Elasticsearch.
-
Use Claude to Talk to Your Adobe Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Adobe Analytics for you.
-
How to connect and process Microsoft OneDrive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft OneDrive.
-
Configure the CData JDBC Driver for Odoo in a Connection Pool in Tomcat
Connect to Odoo ERP from a connection pool in Tomcat.
-
Connecting Mastra with Azure Synapse via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Build a Singer.io Tap for REST With the CData Python Connector
Learn how to easily build a Singer.io Tap for live REST data using
-
How to create Google Cloud Storage federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Cloud Storage in MySQL .
-
How to Connect to Live Google Spanner 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 Google Spanner for you.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy Desktop
Connect to Microsoft SharePoint in MicroStrategy Desktop using the CData Software JDBC Driver for SharePoint.
-
Integrate Live Google Sheets into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Sheets and integrate live Google Sheets into apps built in Microsoft Power Apps.
-
Connect to Live Blackbaud FE NXT in MicroStrategy through CData Connect AI
Create a live connection to Blackbaud FE NXT in CData Connect AI and connect to your Blackbaud FE NXT from MicroStrategy.
-
Integrating Claude Code with Exact Online via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Exact Online within assisted coding and automated development workflows.
-
How to connect to Asana from IntelliJ
Integrate connectivity to Asana with wizards in IntelliJ.
-
Connect to EnterpriseDB as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for EnterpriseDB.
-
Automate Power BI XMLA Replication to SAP HANA
Use CData Sync to customize and automate Power BI XMLA replication to SAP HANA.
-
Feed NetSuite into FineReport
How to set NetSuite CRM & ERP as a JDBC data source in FineReport.
-
How to import Office 365 into Apache Solr
Use the CData Software JDBC Driver for Office 365 in Data Import Handler and create an automated import of Microsoft Office 365 to Apache Solr Enterprise Search platform.
-
Access Live Oracle Financials Cloud in Coginiti Pro
Connect to and query live Oracle Financials Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Consume Azure Data Catalog OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Data Catalog as OData feeds from PowerBuilder using the API Server.
-
Connect to LDAP Objects in HULFT Integrate
Connect to LDAP as a JDBC data source in HULFT Integrate
-
Use Biml to Build SSIS Tasks to Replicate Dynamics CRM to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Dynamics CRM to SQL Server.
-
Build Zendesk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zendesk from Zoho Analytics and import live Zendesk.
-
Automate Splunk Replication to Azure Synapse
Use CData Sync to customize and automate Splunk replication to Azure Synapse.
-
Design BIRT Reports on Certinia
Provide current Certinia to your embedded analytics.
-
Query Kintone in ColdFusion
Write standard ColdFusion data access code to connect to Kintone.
-
Rapidly Develop ADP-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Automated Continuous EventBrite Replication to SQL Server
Use CData Sync for automated, continuous, customizable EventBrite replication to SQL Server.
-
Connect to YouTube Analytics in Google Apps Script via Connect AI
Use CData Connect AI to access YouTube Analytics in Google Apps Script.
-
How to connect to Marketo with Squirrel SQL client
Connect to Marketo and execute queries in the Squirrel SQL Client.
-
Create Sage 300 Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Enable the Dynamics 365 Business Central JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Dynamics 365 Business Central.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Inventory
Provide connectivity to Zoho Inventory through an SAP BusinessObjects universe.
-
How to Access Zoho Creator Using Entity Framework
This article shows how to access Zoho Creator using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Working with SAP Hybris C4C in LINQPad
Execute LINQ queries to SAP Hybris C4C in LINQPad.
-
How to integrate Metabase with Acumatica
Use CData Connect AI to connect to live Acumatica ERP and create an interactive dashboard in Metabase from Acumatica ERP.
-
How to connect to Google Contacts from Spring Boot
Connect to Google Contacts in a Spring Boot Application using CData JDBC Google Contacts Driver
-
Automated Continuous Twitter Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Twitter Ads replication to AlloyDB.
-
Automated WooCommerce Replication to Teradata
Use CData Sync to Customize and automate WooCommerce replication to Teradata.
-
Getting Started with the CData ODBC Driver for Basecamp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Basecamp.
-
Automated Continuous IBM Informix Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable IBM Informix replication to Apache Cassandra.
-
Analyze Sybase IQ in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sybase IQ and visualize live Sybase IQ in Infragistics Reveal.
-
Create Dynamic Zoho Creator Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Creator to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Sage 300 in Ruby
Connect to Sage 300 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData Excel Add-In for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Facebook Ads.
-
Extract, Transform, and Load Unbounce in Informatica PowerCenter
Create a simple Workflow for Unbounce in Informatica PowerCenter.
-
How to pipe MongoDB to CSV in PowerShell
Use standard PowerShell cmdlets to access MongoDB tables.
-
Create Dynamic Google Drive Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Drive to Infragistics XamDataGrid to build dynamic grids.
-
Deploy the ADO.NET Provider for Jira Service Management on an SSRS Report Server
Connect to Atlassian Jira Service Management 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.
-
How to Query Live Elasticsearch in Perplexity MacOS Desktop
Connect to and query live Elasticsearch in Perplexity Desktop using CData Code Assist MCP.
-
Access Live SFTP in AWS Lambda
Connect to live SFTP in AWS Lambda using the CData JDBC Driver.
-
Integrate QuickBooks Time in the Pentaho Report Designer
Publish reports based on QuickBooks Time in the Pentaho BI tool.
-
How to connect to GraphQL in DBVisualizer
Integrate GraphQL with visual data analysis tools and data connection wizards in DBVisualizer
-
Work with Redis in FoxPro
Load Redis into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Dynamics 365 in DataGrip
Create a Data Source for Dynamics 365 in DataGrip and use SQL to query live Microsoft Dynamics 365.
-
ETL JotForm in Oracle Data Integrator
This article shows how to transfer JotForm into a data warehouse using Oracle Data Integrator.
-
Automated Continuous HubSpot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HubSpot replication to Apache Cassandra.
-
How to import HubDB into Apache Solr
Use the CData Software JDBC Driver for HubDB in Data Import Handler and create an automated import of HubDB to Apache Solr Enterprise Search platform.
-
How to Connect to Live SendGrid from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SendGrid for you.
-
Use Azure AI Foundry to Talk to Your Spark 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 Apache Spark SQL for you.
-
Seamlessly Bring Google Search Results into Retool Using CData Connect AI
Integrate Google Search data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to update IBM Informix from Excel
This article explains how to transfer data from Excel to IBM Informix using the Excel Add-In for IBM Informix.
-
Analyze Salesforce Marketing in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Marketing Cloud with the CData JDBC Driver for Salesforce Marketing.
-
Connect to Slack in Google Apps Script via Connect AI
Use CData Connect AI to access Slack in Google Apps Script.
-
Build Elasticsearch-Powered Applications in Cursor with CData Code Assist MCP
-