CData Software - Knowledge Base
Recent Articles
-
Connect to Adobe Commerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Stack Exchange Data Replication to Couchbase
Use CData Sync to Customize and automate Stack Exchange replication to Couchbase.
-
Prepare, Blend, and Analyze ShipEngine Data in Alteryx Designer (ODBC)
Build workflows to access live ShipEngine for self-service data analytics.
-
How to connect to Snowflake Data with Squirrel SQL client
Connect to Snowflake and execute queries in the Squirrel SQL Client.
-
Automate DB2 for i Data Replication to Azure Data Lake
Use CData Sync to customize and automate DB2 for i replication to Azure Data Lake.
-
Getting Started with the CData ODBC Driver for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Facebook Ads.
-
Integrate with iContact Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy iContact to a JSON file on disk.
-
Integrate Theia IDE with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Gumloop with SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Concur within automated workflows.
-
Extend Google Sheets with Highrise Data
Make calls to Highrise from Google Apps Script via the API Server.
-
Building Dynamic Web Pages with Azure Data Lake Storage Data Using AngularJS
Create single-page applications with live connectivity to Azure Data Lake Storage using the CData API Server.
-
Integrating Codex CLI with Bitly 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.
-
Consume CapsuleCRM OData Feeds in PowerBuilder
This article demonstrates how to consume CapsuleCRM as OData feeds from PowerBuilder using the API Server.
-
How to connect to FreeAgent Data in DBVisualizer
Integrate FreeAgent with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Python Connector for OpenWeatherMap
Learn to install and license the CData Python Connector
-
Create Data Visualizations in Cognos BI with Auth0 Data
Access Auth0 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Toggl Data in Heroku for Use in Salesforce Connect
Replicate Toggl to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Power BI Reports on Real-Time MySQL Data
Use the CData ODBC Driver for MySQL to visualize MySQL in Power BI Desktop.
-
Integrating Kiro CLI with Foursquare 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.
-
Integrating Cursor CLI with FHIR 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.
-
A PostgreSQL Interface for HCL Domino Data using the CData ODBC Driver
Use the SQL Gateway and HCL Domino ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Reply.io Data in DataGrip
Create a Data Source for Reply.io in DataGrip and use SQL to query live Reply.io.
-
Work with Live API Data in Power Query
Use CData Connect AI to connect to API and work with live API in Microsoft Power Query.
-
Query Airtable Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Airtable and perform CRUD operations on Airtable from Node.js.
-
Replicate Oracle SCM Data in Heroku for Use in Salesforce Connect
Replicate Oracle SCM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build SurveyMonkey-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SurveyMonkey to explore live SurveyMonkey Data in GitHub Copilot to assist with building SurveyMonkey-powered applications.
-
DataBind SAS Data Sets Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAS Data Sets with the DevExpress Windows Forms and Web controls to provide SAS Data Sets to a chart.
-
Connect to Short.io Data in RapidMiner
Integrate Short.io with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Crystal Reports on Stack Exchange Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Stack Exchange.
-
Connect Email to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Email with IBM WebSphere for seamless data integration and connectivity.
-
Use Claude to Talk to Your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Salesforce Pardot for you.
-
Design BIRT Reports on Workable Data
Provide current Workable to your embedded analytics.
-
Configure the CData JDBC Driver for Sybase IQ in a Connection Pool in Tomcat
Connect to Sybase IQ from a connection pool in Tomcat.
-
Automated Continuous Printify Replication to Vertica
Use CData Sync for automated, continuous, customizable Printify replication to Vertica.
-
Using the CData Software ODBC Driver for ScrapingBee in PyCharm
Connect to ScrapingBee as an ODBC data source in PyCharm using the CData Software ODBC Driver for ScrapingBee.
-
Integrating LlamaIndex with Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Directory in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ConvertKit
Provide connectivity to ConvertKit through an SAP BusinessObjects universe.
-
Query Zoho CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho CRM from Node.js.
-
Connect to Neo4J Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Neo4J.
-
Build Dashboards with Email Data in DBxtra
Create dynamic dashboards and perform analytics based on Email in DBxtra.
-
Build Apps with Live Bitly Data Using the Low-Code Development Platform of Mendix
Connect Bitly with Mendix to build apps using the CData API Driver for JDBC.
-
Replicate Multiple Planio Accounts
Replicate multiple Planio accounts to one or many databases.
-
Automated Continuous NetSuite Replication to Databricks
Use CData Sync for automated, continuous, customizable NetSuite replication to Databricks.
-
Connect to Outreach.io Data from HeidiSQL
Use CData Connect AI to connect to and query live Outreach.io from HeidiSQL.
-
Query Cassandra Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apache Cassandra from Node.js.
-
Integrate Kintone Data into Power Automate Desktop using CData Connect
CData Connect for Kintone Data enables you to integrate Kintone into workflows built using Microsoft Power Automate Desktop.
-
Integrating Cursor CLI with Twilio 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.
-
Integrate Open WebUI with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft SQL Server from within the chat interface.
-
Replicate Oracle HCM Cloud Data to Multiple Databases
Replicate Oracle HCM Cloud to disparate databases with a point-and-click configuration.
-
Create Azure DevOps-Connected Nintex Workflows
Use CData Connect AI to connect to Azure DevOps Data from Nintex Workflow Cloud and build custom workflows using live Azure DevOps.
-
How to Create Power BI Visual Reports with Real-Time Active Directory Data
Use CData Power BI Connectors to visualize Active Directory in Power BI.
-
Connect to Sybase Data in CloverDX (formerly CloverETL)
Transfer Sybase using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData SSIS Components for Tanda
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Tanda.
-
Connect to Hugging Face Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Hugging Face as an External Source in Dremio.
-
How to Import Data from Klaviyo into Google Sheets
Import Klaviyo into a Google spreadsheet that is automatically refreshed.
-
Create ServiceNow Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ServiceNow data access from reports, embedded analytics, and more.
-
Use the CData Software JDBC Driver for SuiteCRM in MicroStrategy
Connect to SuiteCRM in MicroStrategy Developer using the CData Software JDBC Driver for SuiteCRM.
-
Create Datasets from Highrise in Domo Workbench and Build Visualizations of Highrise Data in Domo
Use the CData Software ODBC Driver for Highrise to create datasets from Highrise CRM in Domo Workbench and then build visualizations in the Domo service.
-
Migrating data from Mixpanel to Databricks using CData SSIS Components.
Easily push Mixpanel to Databricks using the CData SSIS Tasks for Mixpanel and Databricks.
-
A PostgreSQL Interface for ZohoSubscriptions Data using the CData ODBC Driver
Use the SQL Gateway and ZohoSubscriptions ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for TigerGraph in MicroStrategy
Connect to TigerGraph in MicroStrategy Developer using the CData Software JDBC Driver for TigerGraph.
-
Create Power BI Reports on Real-Time Foursquare Data
Use the CData ODBC Driver for Foursquare to visualize Foursquare in Power BI Desktop.
-
Working with XML Data in LINQPad
Execute LINQ queries to XML Files in LINQPad.
-
Automate SAP Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP ERP/NetWeaver replication to Azure Synapse.
-
Visualize Discord Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Discord into TIBCO Spotfire.
-
Access LionDesk Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for LionDesk.
-
Build Marketo-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Marketo to explore live Marketo Data in GitHub Copilot to assist with building Marketo-powered applications.
-
Visualize ConstantContact Data in Tableau
The CData ODBC driver for ConstantContact enables you integrate ConstantContact into Tableau dashboards.
-
Import Avaza Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Avaza. In this article, you will use the OData format to import Avaza into Microsoft Power Query.
-
How to Access SAS xpt Data Using Entity Framework
This article shows how to access SAS XPORT using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Optimizely Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Optimizely replication to Amazon Redshift.
-
Replicate Templated Data from PowerShell
Write a quick PowerShell script to query Templated. Use connectivity to the live data to replicate Templated to SQL Server.
-
Create SSAS Tabular Models from Copper Data
How to build a SQL Server Analysis Service Tabular Model from Copper using CData drivers.
-
Automated Continuous Omnisend Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Omnisend replication to Amazon Redshift.
-
How to Connect DBeaver to VWO via a JDBC Driver
Manage VWO with visual tools in DBeaver like the query browser.
-
Perform Batch Operations with Dynamics 365 Business Central Data in Apache NiFi
Connect to Dynamics 365 Business Central and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous QuickBooks Time Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Amazon Redshift.
-
Connect to GraphQL Data in NetBeans
Connect to GraphQL in NetBeans with the data source configuration wizard.
-
Design BIRT Reports on SAP SuccessFactors LMS Data
Provide current SAP SuccessFactors LMS to your embedded analytics.
-
How to connect to Chargebee Data from IntelliJ
Integrate connectivity to Chargebee with wizards in IntelliJ.
-
Create Dashboards and Visualize Live Microsoft Ads Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Paymo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Paymo replication to SQL Server.
-
Use Grok to Talk to Your Hive 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 Apache Hive for you.
-
How to Seamlessly Import Impala Data into IBM SPSS Modeler
Integrate Impala data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Attio Data in NetBeans
Connect to Attio in NetBeans with the data source configuration wizard.
-
Build Automated Microsoft OneDrive-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft OneDrive and build automated workflows in Zapier.
-
How to integrate Couchbase with Apache Airflow
Access and process Couchbase in Apache Airflow using the CData JDBC Driver.
-
Connect to Trello Data in CloverDX (formerly CloverETL)
Transfer Trello using the visual workflow in the CloverDX data integration tool.
-
ZohoDesk Reporting in OBIEE with the ZohoDesk JDBC Driver
Deploy the ZohoDesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Salesforce CRM Analytics Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce CRM Analytics.
-
Connect to Strava Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Strava in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for Brex in MicroStrategy Web
Connect to Brex in MicroStrategy Web using the CData Software ODBC Driver for Brex.
-
Build MVC Applications with Connectivity to eBay Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access eBay from an ASP.NET MVC application.
-
Connect to Google Contacts Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Contacts and the Script function in FileMaker Pro to connect to Google Contacts and work with Google Contacts in your FileMaker application.
-
Edit and Search SpaceX External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SpaceX to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SpaceX objects that you can access from apps and the dashboard.
-
Build an OLAP Cube in SSAS from EmailOctopus Data
Establish a connection to EmailOctopus data from SQL Server Analysis Services, and use the EmailOctopus Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Campaigner Replication to Oracle
Use CData Sync for automated, continuous, customizable Campaigner replication to Oracle.
-
Publish Reports with Oracle Financials Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Financials Cloud.
-
How to connect to ClickUp Data with Squirrel SQL client
Connect to ClickUp and execute queries in the Squirrel SQL Client.
-
Build Access-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Access and build web apps with connectivity to live Microsoft Access.