CData Software - Knowledge Base
Recent Articles
-
Connect to and Query Rootly Data in QlikView over ODBC
Create data visualizations with Rootly in QlikView.
-
Replicate QuickBooks Time Data in Heroku for Use in Salesforce Connect
Replicate QuickBooks Time to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Creating Dropbox-Connected Applications in Unqork
You can use CData Connect AI to feed Dropbox to Unqork and build custom business apps.
-
Build Agents in Relevance AI with Access to Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on LinkedIn within intelligent agent workflows.
-
Connect and Query Live Google Ad Manager Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Ad Manager into Databricks
-
Build Visualizations of Okta Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Okta in Birst.
-
Connect to Figshare Data in CloverDX (formerly CloverETL)
Transfer Figshare using the visual workflow in the CloverDX data integration tool.
-
Integrate Google Search Results in Pentaho Data Integration
Build ETL pipelines based on Google Search in the Pentaho Data Integration tool.
-
Query Excel Online Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Excel Online from Node.js.
-
Automated Continuous Freshsales Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Freshsales replication to Amazon S3.
-
How to Access Live FreshBooks Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FreshBooks enables you to integrate FreshBooks into workflows built using Microsoft Power Automate Desktop.
-
Publish Reports with Excel Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Excel Online.
-
Build Outreach.io-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Outreach.io and build web apps with connectivity to live Outreach.io.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure DevOps within intelligent workflows.
-
A PostgreSQL Interface for SharePoint Data using the CData ODBC Driver
Use the SQL Gateway and SharePoint ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Bright Data Data in ETL Validator JDBC
Connect to Bright Data from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Multiple Elasticsearch Accounts via the CData Sync CLI
Replicate multiple Elasticsearch accounts to one or many databases.
-
Integrate Microsoft Dataverse Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Dataverse Data enables you to integrate Microsoft Dataverse (CDS) into workflows built using Microsoft Power Automate Desktop.
-
Query Deel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Deel from Node.js.
-
Integrating Claude Code with Google Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Ads within assisted coding and automated development workflows.
-
Integrate with CapsuleCRM Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CapsuleCRM to a JSON file on disk.
-
Connect to and Query Redshift Data in QlikView over ODBC
Create data visualizations with Amazon Redshift in QlikView.
-
How to create Samanage federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Samanage in MySQL .
-
Connect to and Visualize Live Hugging Face Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Hugging Face.
-
Add Zoho Recruit Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Recruit with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind IBM Cloud Object Storage Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for IBM Cloud Object Storage with the DevExpress Windows Forms and Web controls to provide IBM Cloud Object Storage to a chart.
-
Visualize Paylocity Data in Sisense
Create an ElastiCube in Sisense app with access to Paylocity.
-
LINQ to Front 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 Front Data Provider.
-
Integrating LangGraph with Zuora Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zuora within automated workflows.
-
Excel Spreadsheet Automation on Oracle Service Cloud Data with the QUERY Formula
Pull data from Oracle Service Cloud, automate spreadsheets, and more with the QUERY formula.
-
Integrate GitLab with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate GitLab with External Services.
-
Build Data Flows from Amazon Athena to SQL Server using SSIS
Easily back up Amazon Athena to SQL Server using the SSIS components for Amazon Athena.
-
Manage IBM Cloud Object Storage Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for IBM Cloud Object Storage.
-
How to connect to ZohoDesk Data in DBVisualizer
Integrate ZohoDesk with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Optimizely Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Optimizely.
-
Prepare, Blend, and Analyze Amazon Marketplace Data in Alteryx Designer (ODBC)
Build workflows to access live Amazon Marketplace for self-service data analytics.
-
Query PingOne Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume PingOne entities in PHP by modeling them as objects.
-
Visualize Excel Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Excel.
-
DataBind Controls to Retently Data in Delphi
DataBind to Retently in Delphi with standard data access components and controls.
-
Automated Continuous PabblySubscriptions Replication to Vertica
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Vertica.
-
Connect to ZarMoney Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZarMoney in the Denodo Virtual DataPort Administrator.
-
Extract, Transform, and Load Foursquare Data in Informatica PowerCenter
Create a simple Workflow for Foursquare in Informatica PowerCenter.
-
How to integrate Pinterest with Apache Airflow
Access and process Pinterest in Apache Airflow using the CData JDBC Driver.
-
Design BIRT Reports on Tavily Data
Provide current Tavily to your embedded analytics.
-
Build MySQL-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for MySQL to explore live MySQL Data in Claude Code to assist with building MySQL-powered applications.
-
Replicate Oracle Sales Data in Heroku for Use in Salesforce Connect
Replicate Oracle Sales to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating LangGraph with Vertica Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Vertica within automated workflows.
-
Prepare, Blend, and Analyze Spark Data in Alteryx Designer (ODBC)
Build workflows to access live Apache Spark SQL for self-service data analytics.
-
Integrate with Tally Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Tally ERP in SnapLogic.
-
Connect to SpaceX Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to SpaceX and work with SpaceX in your FileMaker applications.
-
How to Build an ETL App for WooCommerce Data in Python with CData Connect AI
Build ETL pipelines that read and write live WooCommerce in Python with petl and the CData Connect AI Python SDK.
-
Connect and Query Live Excel Online Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Excel Online into Databricks
-
How to Visualize Pingdom Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pingdom in Python.
-
Use JayDeBeApi to access ConstantContact Data in Python
Use standard Python scripting and the development environment of your choice to access live ConstantContact.
-
Access Live Jira Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Atlassian Jira from your Excel spreadsheets.
-
Explore Geographical Relationships in Mailjet Data with Power Map
Create data visualizations with Mailjet in Power Map.
-
Integrate Access with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Access with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Access.
-
Automated Acumatica Data Replication to Teradata
Use CData Sync to Customize and automate Acumatica ERP replication to Teradata.
-
Connect to Drip Data in RazorSQL
Connect to Drip from wizards and query Drip from the GUI in the RazorSQL database management tool.
-
Natively Connect to JobNimbus Data in PHP
The CData ODBC driver for JobNimbus enables you to create PHP applications with connectivity to JobNimbus. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics CRM
Provide connectivity to Microsoft Dynamics CRM through an SAP BusinessObjects universe.
-
Building Dynamic Web Pages with Lakebase Data Using AngularJS
Create single-page applications with live connectivity to Lakebase using the CData API Server.
-
Create a Data Access Object for SparkPost Data using JDBI
A brief overview of creating a SQL Object API for SparkPost in JDBI.
-
How to connect to Mouseflow Data from IntelliJ
Integrate connectivity to Mouseflow with wizards in IntelliJ.
-
Query SAP Ariba Source Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Ariba Source from Node.js.
-
Connect to and Query Microsoft OneDrive Data in QlikView over ODBC
Create data visualizations with Microsoft OneDrive in QlikView.
-
Connecting Mastra with Salesforce Marketing Data 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 Salesforce Marketing Cloud, no replication required.
-
Explore Geographical Relationships in Apollo Data with Power Map
Create data visualizations with Apollo in Power Map.
-
Connect to Hubstaff from Asprova with CData Software ODBC Driver for Hubstaff
This article shows how to connect faster to Hubstaff data from Asprova.
-
Use the CData Software JDBC Driver for Hugging Face in MicroStrategy
Connect to Hugging Face in MicroStrategy Developer using the CData Software JDBC Driver for Hugging Face.
-
Replicate QuickBooks Data to Multiple Databases via the CData Sync CLI
Replicate QuickBooks Desktop to disparate databases with a single configuration.
-
Build MariaDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MariaDB.
-
View Reports on Real-Time Mode Data in Power BI Report Server
Use the CData ODBC Driver for Mode to visualize Mode in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Sage Intacct Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage Intacct to connect to Sage Intacct and execute queries in PowerBuilder.
-
Query PayPal Data from Node.js
Use the OData endpoint of the CData API Server to connect to your PayPal and perform CRUD operations on PayPal from Node.js.
-
How to Easily Query OpenWeatherMap Data in OpenOffice Base
Connect to OpenWeatherMap data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to create an RPA flow for Dynamics 365 Data in UiPath Studio
Use the Dynamics 365 ODBC Driver to create workflows that access real-time Microsoft Dynamics 365 without any coding.
-
Enable the Testmonitor JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Testmonitor.
-
Build an OLAP Cube in SSAS from Rootly Data
Establish a connection to Rootly data from SQL Server Analysis Services, and use the Rootly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Easily Integrate Sybase Data in Lazarus Pascal IDE
Learn how to easily integrate live Sybase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Write a Simple Go Application to work with SAP Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP ERP/NetWeaver.
-
Build an OLAP Cube in SSAS from Spark Data
Establish a connection to Apache Spark SQL data from SQL Server Analysis Services, and use the Spark Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Crystal Reports on OnePageCrm Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date OnePageCrm.
-
Connect to Bitbucket Data in NetBeans
Connect to Bitbucket in NetBeans with the data source configuration wizard.
-
How to publish and share Samanage Data dashboards with Tableau Server
The CData ODBC driver for Samanage enables you integrate Samanage into Tableau dashboards.
-
Create Reports with SAP Business One Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business One.
-
Access IBM Informix Data from MySQL in PHP
Connect to IBM Informix through the standard MySQL libraries in PHP.
-
Publish Intercom-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Intercom.
-
Write a Simple Go Application to work with Greenplum Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pivotal GreenPlum.
-
Build Monday.com-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Monday.com Data from Zoho Analytics and import live Monday.com.
-
Integrate with Facebook Ads Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Facebook Ads in SnapLogic.
-
Consume Oracle OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Database as OData feeds from PowerBuilder using the API Server.
-
Build a Singer.io Tap for HubDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HubDB data using
-
Connect to SQL Analysis Services Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SQL Analysis Services using standard SQL.
-
Build Dashboards with ElevenLabs Data in Dundas BI
Create dynamic dashboards and perform analytics based on ElevenLabs in Dundas BI.
-
Connect to Miro Data in JRuby
Create a simple JRuby app with access to live Miro.
-
Bind Live Pinterest Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Pinterest data
-
Access Live SendGrid Data in AWS Lambda
Connect to live SendGrid in AWS Lambda using the CData JDBC Driver.
-
Working with Mixpanel Data in LINQPad
Execute LINQ queries to Mixpanel in LINQPad.
-
Use the CData ODBC Driver for CloudConvert from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CloudConvert to connect to CloudConvert from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CloudConvert in Excel.