CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for Adobe Experience Manager With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Adobe Experience Manager data using
-
Use Grok to Talk to Your Avalara AvaTax 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 Avalara AvaTax for you.
-
Integrate QuickBooks Time with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks Time with External Services.
-
How to Easily Query Bright Data Data in OpenOffice Base
Connect to Bright Data data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build an OLAP Cube in SSAS from eBay Data
Establish a connection to eBay data from SQL Server Analysis Services, and use the eBay Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Dynamic ChargeOver Grids Using the Infragistics XamDataGrid
Learn how you can connect ChargeOver to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Bitbucket Replication to Snowflake
Use CData Sync for automated, continuous, customizable Bitbucket replication to Snowflake.
-
Automated Continuous Marketo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Marketo replication to AlloyDB.
-
Prepare, Blend, and Analyze Zoho Books Data in Alteryx Designer (ODBC)
Build workflows to access live Zoho Books for self-service data analytics.
-
A PostgreSQL Interface for Testmonitor Data (MySQL Remoting via JDBC)
Use the Remoting features of the Testmonitor JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Campaigner Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Campaigner to a JSON file on disk.
-
Replicate Multiple GitLab Accounts via the CData Sync CLI
Replicate multiple GitLab accounts to one or many databases.
-
How to Query Live ZohoDesk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoDesk data in natural language using Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Freshdesk within intelligent workflows.
-
Visualize Live Nethunt Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Nethunt.
-
Use the CData ODBC Driver for Simplesat in Microsoft Power Query
You can use the CData Simplesat ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Simplesat into Microsoft Power Query.
-
How to Query Live Snowflake Data in Perplexity MacOS Desktop
Connect to and query live Snowflake Data in Perplexity Desktop using CData MCP Server.
-
Feed ZohoSubscriptions Data into FineReport
How to set ZohoSubscriptions as a JDBC data source in FineReport.
-
Connect JobNimbus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live JobNimbus using the CData Python MCP Server.
-
Automated Continuous Square Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Square replication to Apache Cassandra.
-
Build Oracle Service Cloud-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Service Cloud Data from Choreo and build custom apps using live Oracle Service Cloud.
-
Access CockroachDB Data from MySQL in PHP
Connect to CockroachDB through the standard MySQL libraries in PHP.
-
Query WooCommerce Data in ColdFusion
Write standard ColdFusion data access code to connect to WooCommerce.
-
Moving Data from Certinia to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Certinia data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Work with Billsby Data in AWS Glue Jobs Using JDBC
Connect to Billsby from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Agno to Talk to Your Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft Excel Online for you.
-
View Reports on Real-Time Aweber Data in Power BI Report Server
Use the CData ODBC Driver for Aweber to visualize Aweber in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Bitbucket Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Bitbucket entities in PHP by modeling them as objects.
-
Bridge GetResponse Connectivity with Apache NiFi
Access and process GetResponse in Apache NiFi using the CData JDBC Driver.
-
Consume Oracle Sales OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Sales feeds that reflect any changes in SAP Lumira.
-
Visualize ServiceNow Data in TIBCO Spotfire through OData
Integrate ServiceNow into dashboards in TIBCO Spotfire.
-
Building Dynamic Web Pages with Access Data Using AngularJS
Create single-page applications with live connectivity to Access using the CData API Server.
-
Visualize Live SAP HANA Data in the Power BI Service
Use CData Connect AI to connect to live SAP HANA and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to ClickTime
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ClickTime.
-
Feed Sybase Data into FineReport
How to set Sybase as a JDBC data source in FineReport.
-
Build Data Flows from SQL Server to ActiveCampaign through SSIS
Easily push SQL Server data to ActiveCampaign using the CData SSIS Tasks for ActiveCampaign.
-
Connect to Sentry Data in NetBeans
Connect to Sentry in NetBeans with the data source configuration wizard.
-
How to connect to Zoho CRM Data from IntelliJ
Integrate connectivity to Zoho CRM with wizards in IntelliJ.
-
Create Data Visualizations in Cognos BI with Exact Online Data
Access Exact Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData Excel Add-In for Vercel
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vercel.
-
Replicate Cosmos DB Data to Multiple Databases via the CData Sync CLI
Replicate Azure Cosmos DB to disparate databases with a single configuration.
-
Stream Recurly Data into Apache Kafka Topics
Access and stream Recurly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Google Cloud Storage Data in RapidMiner
Integrate Google Cloud Storage with standard components and data source configuration wizards in RapidMiner Studio.
-
Stripe Reporting in OBIEE with the Stripe JDBC Driver
Deploy the Stripe JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Spark Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apache Spark SQL.
-
Design BIRT Reports on Splunk Data
Provide current Splunk to your embedded analytics.
-
Replicate WordPress Data in Heroku for Use in Salesforce Connect
Replicate WordPress to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to DB2 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from IBM DB2, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Enable the Highrise JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Highrise CRM.
-
Create Data Visualizations in Cognos BI with WooCommerce Data
Access WooCommerce as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Voice Agents in ElevenLabs with access to Live QuickBooks Online Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live QuickBooks Online.
-
Connect to Eventbrite Data from PowerBuilder via ADO.NET
This article demonstrates how to access Eventbrite from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Using the CData Software ODBC Driver for Suadeo in PyCharm
Connect to Suadeo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Suadeo.
-
A PostgreSQL Interface for Google Contacts Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Contacts JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect PhantomBuster to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PhantomBuster with IBM WebSphere for seamless data integration and connectivity.
-
Use JayDeBeApi to access Google Spanner Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Spanner.
-
Automated Continuous Insightly Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Insightly replication to Google Cloud SQL.
-
Easily Integrate Cloudant Data in Lazarus Pascal IDE
Learn how to easily integrate live IBM Cloudant in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Opsgenie Data in the Pentaho Report Designer
Publish reports based on Opsgenie in the Pentaho BI tool.
-
Bridge Coda Connectivity with Apache NiFi
Access and process Coda in Apache NiFi using the CData JDBC Driver.
-
How to work with NASA Data in Apache Spark using SQL
Access and process NASA Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Paylocity Data in Excel 365 Online (Excel for the web)
Connect to Paylocity from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Dash to Build to Web Apps on Google Calendar Data
Create Python applications that use pandas and Dash to build Google Calendar-connected web apps.
-
Integrate with Box Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Box to a JSON file on disk.
-
Connect to ShipEngine from a Connection Pool in WebLogic
Use the CData JDBC Driver for ShipEngine to connect to ShipEngine from Web applications running on WebLogic.
-
Rapidly Develop Avro-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Avro.
-
A PostgreSQL Interface for Gumroad Data (MySQL Remoting via JDBC)
Use the Remoting features of the Gumroad JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Service Cloud Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Service Cloud to SQL Server.
-
How to Connect to Templated Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Templated. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Shopify Data from IntelliJ
Integrate connectivity to Shopify with wizards in IntelliJ.
-
A PostgreSQL Interface for Intercom Data (MySQL Remoting via JDBC)
Use the Remoting features of the Intercom JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Workday Data Replication to Azure Synapse
Use CData Sync to customize and automate Workday replication to Azure Synapse.
-
Build AI/ML Models with Live CampaignMonitor Data using Dataiku
Connect CampaignMonitor Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect DBeaver to Webex via a JDBC Driver
Manage Webex with visual tools in DBeaver like the query browser.
-
Replicate LinkedIn Ads Data from PowerShell
Write a quick PowerShell script to query LinkedIn Ads. Use connectivity to the live data to replicate LinkedIn Ads to SQL Server.
-
Import Real-Time Dynamics NAV Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Dynamics NAV in ColdFusion.
-
Use Dash to Build to Web Apps on Salesforce Marketing Data
Create Python applications that use pandas and Dash to build Salesforce Marketing-connected web apps.
-
Integrating Claude Code with SAP SuccessFactors LMS Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP SuccessFactors LMS within assisted coding and automated development workflows.
-
Access Live AdRoll Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate AdRoll into the statistical analysis tools available in SAS JMP. This article shows how to use AdRoll in the Graph Builder and Query Builder.
-
How to Easily Query ChargeOver Data in OpenOffice Base
Connect to ChargeOver data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Work with Facebook Data in FoxPro
Load Facebook into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Procore Replication to Vertica
Use CData Sync for automated, continuous, customizable Procore replication to Vertica.
-
Create Informatica Mappings From/To a JDBC Data Source for ZendeskSell
Create ZendeskSell data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Act CRM Data in Cognos Analytics
Use CData Connect AI to connect to Act CRM Data from Cognos Analytics and analyze live Act CRM.
-
Edit and Search External Airtable Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Airtable to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Airtable Data objects that you can access from apps and the dashboard.
-
Connect to Tally Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Tally and the Script function in FileMaker Pro to connect to Tally and work with Tally ERP in your FileMaker application.
-
Automated Continuous SendInBlue Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SendInBlue replication to PostgreSQL.
-
Connect to PivotalTracker Data in RapidMiner
Integrate PivotalTracker with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for Oracle Financials Cloud in MicroStrategy
Connect to Oracle Financials Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Access Live Highrise Data in Excel 365 Online (Excel for the web)
Connect to Highrise CRM from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Validate Excel Data with QuerySurge
Access and validate Microsoft Excel in QuerySurge using the CData JDBC Driver.
-
DataBind Charts to Discord Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Discord from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Seamlessly Bring Sage Cloud Accounting Data into Retool Using CData Connect AI
Integrate Sage Cloud Accounting data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect DBeaver to Cloudflare via a JDBC Driver
Manage Cloudflare with visual tools in DBeaver like the query browser.
-
Connect to Guru Data in Aqua Data Studio
Access Guru from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Charts with Apify Data in Clear Analytics
Create dynamic charts and perform analytics based on Apify in Clear Analytics.
-
Access Live AlloyDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live AlloyDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to Live SQL Server 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 Microsoft SQL Server for you.
-
Use Microsoft Copilot Studio to talk to your Smartsheet 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 Smartsheet for you.
-
Replicate Multiple Power BI XMLA Accounts via the CData Sync CLI
Replicate multiple Power BI XMLA accounts to one or many databases.