CData Software - Knowledge Base
Recent Articles
-
Edit and Search External Certinia Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Certinia to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Certinia Data objects that you can access from apps and the dashboard.
-
Query GitHub Data from Node.js
Use the OData endpoint of the CData API Server to connect to your GitHub and perform CRUD operations on GitHub from Node.js.
-
How to Connect to Live Oracle Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle Database through natural language.
-
Connect to SAP Business Warehouse in SpagoBI
Create reports featuring live SAP Business Warehouse in SpagoBI Studio. Host SAP Business Warehouse reports on SpagoBI Server.
-
Replicate Amplitude Data in Heroku for Use in Salesforce Connect
Replicate Amplitude to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous ZendeskSell Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZendeskSell replication to IBM DB2.
-
Stream Spark Data into Apache Kafka Topics
Access and stream Apache Spark SQL in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Drip Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Drip from HeidiSQL.
-
Provide OData Services of Square Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Square by developing a WCF Service Application.
-
How to Query Live Zoom Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoom data in natural language using Python.
-
Connect PabblySubscriptions to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PabblySubscriptions using the CData Python MCP Server.
-
Automated Continuous eBay Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable eBay replication to Apache Cassandra.
-
Building Dynamic Web Pages with SAP Business Warehouse Data Using AngularJS
Create single-page applications with live connectivity to SAP Business Warehouse using the CData API Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Tanda
Create Tanda data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live Adobe Commerce Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Adobe Commerce.
-
Automate Parallel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Parallel from PowerShell? This article demonstrates how to utilize the Parallel Cmdlets for tasks like connecting to Parallel, automating operations, downloading data, and more.
-
DataBind Controls to NASA Data in C++Builder
DataBind to NASA in C++Builder with standard components and controls.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google AlloyDB to Power BI dashboards. Simply drag and drop Google AlloyDB into data visuals on the Power BI canvas.
-
Analyze Azure Analysis Services Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Azure Analysis Services and visualize live Azure Analysis Services in Infragistics Reveal.
-
How to Query Live Microsoft Exchange Data in Perplexity MacOS Desktop
Connect to and query live Microsoft Exchange Data in Perplexity Desktop using CData MCP Server.
-
Access Live Sugar CRM Data in Coginiti Pro
Connect to and query live Sugar CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Certinia Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Certinia replication to Google Cloud SQL.
-
Connect to Live ActiveCampaign Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ActiveCampaign in CData Connect AI and connect to your ActiveCampaign from PostgreSQL.
-
Build Dashboards with Bullhorn CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Bullhorn CRM in Dundas BI.
-
Build an OLAP Cube in SSAS from FreeAgent Data
Establish a connection to FreeAgent data from SQL Server Analysis Services, and use the FreeAgent Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Oracle Eloqua with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Eloqua with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Eloqua.
-
Integrate with CircleCI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy CircleCI to a JSON file on disk.
-
Use the CData Software JDBC Driver for Sybase IQ in MicroStrategy Desktop
Connect to Sybase IQ in MicroStrategy Desktop using the CData Software JDBC Driver for Sybase IQ.
-
How to Query Live QuickBooks Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live QuickBooks Desktop data in natural language using Python.
-
Connect to Paddle Data from PowerBuilder via JDBC
This article demonstrates how to access Paddle from PowerBuilder using the Paddle JDBC Driver.
-
Create SendPulse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SendPulse data access from reports, embedded analytics, and more.
-
Import Gmail Data Using Azure Data Factory
Use CData Connect AI to connect to Gmail Data from Azure Data Factory and import live Gmail.
-
How to connect to MailerLite Data from IntelliJ
Integrate connectivity to MailerLite with wizards in IntelliJ.
-
Integrate with Pipeliner CRM Data in JReport Designer
Create charts and reports based on Pipeliner CRM in JReport Designer.
-
Integrate with live Presto Data in Jitterbit
Use CData Connect AI to connect to and integrate live Presto in Jitterbit.
-
How to load Shortcut data into Elasticsearch via Logstash
Introducing a simple method to load Shortcut data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Apps with Live Scrapfly Data Using the Low-Code Development Platform of Mendix
Connect Scrapfly with Mendix to build apps using the CData API Driver for JDBC.
-
DataBind Charts to Supabase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Supabase 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.
-
Connect and Query Live ServiceNow Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ServiceNow into Databricks
-
Integrating LangGraph with Oracle Financials Cloud Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Financials Cloud within automated workflows.
-
Build a PostgreSQL Interface for SAP Ariba Source Data using the CData JDBC Driver
Use the Remoting features of the SAP Ariba Source JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to Act CRM via a JDBC Driver
Manage Act CRM with visual tools in DBeaver like the query browser.
-
Automated Continuous Humanity Replication to SingleStore
Use CData Sync for automated, continuous, customizable Humanity replication to SingleStore.
-
Connect to and Visualize Live Basecamp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Basecamp.
-
Analyze Jira Assets Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Jira Assets with the CData JDBC Driver for Jira Assets.
-
Use Dash to Build to Web Apps on Smartsheet Data
Create Python applications that use pandas and Dash to build Smartsheet-connected web apps.
-
Access Timely Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Timely from your Oracle system.
-
Create Reports with Google Sheets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Sheets.
-
Analyze Excel Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Excel and visualize live Microsoft Excel in Infragistics Reveal.
-
Visualize MongoDB Data in TIBCO Spotfire through ADO.NET
Integrate MongoDB into dashboards in TIBCO Spotfire.
-
Automate Jira Assets Data Replication to Azure Synapse
Use CData Sync to customize and automate Jira Assets replication to Azure Synapse.
-
Analyze SAP ByDesign Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Business ByDesign and visualize live SAP Business ByDesign in Infragistics Reveal.
-
Build Semantic Layer Views for Pipeline CRM Data in APOS Live Data Gateway
Use the CData Connector for Pipeline CRM in APOS Live Data Gateway to build Semantic Layer Views for Pipeline CRM.
-
Connect to Square Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Square using standard SQL.
-
Automated Continuous Pipeliner CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Oracle.
-
Consume Oracle Eloqua Reporting OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Eloqua Reporting as OData feeds from PowerBuilder using the API Server.
-
How to Connect the Power BI Service to Grafana: Complete Guide
Connect to the CData Software Power BI Connector for Grafana from PowerBI.com to provide real-time Grafana across the organization.
-
Use the CData Software ODBC Driver for Zoho Books in MicroStrategy Web
Connect to Zoho Books in MicroStrategy Web using the CData Software ODBC Driver for Zoho Books.
-
Rapidly Develop Clari-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 Clari.
-
Integrating OpenCode Terminal with Teradata 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.
-
Automated Continuous iContact Replication to SQLite
Use CData Sync for automated, continuous, customizable iContact replication to SQLite.
-
Automated Continuous Sage 200 Replication to Databricks
Use CData Sync for automated, continuous, customizable Sage 200 replication to Databricks.
-
Integrate MarkLogic Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MarkLogic from Informatica Cloud.
-
Use Manus AI to Talk to Your Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Adobe Commerce.
-
Build Automated GraphQL-Connected Workflows in Zapier
Use CData Connect AI to connect to live GraphQL and build automated workflows in Zapier.
-
Connect to Google Tasks Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Tasks and the SQL Gateway to access Google Tasks from Google Apps Script.
-
Access Twilio Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Twilio from your Oracle system.
-
How to Access Live SurveyMonkey Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SurveyMonkey enables you to integrate SurveyMonkey into workflows built using Microsoft Power Automate Desktop.
-
Access PayPal 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 PayPal.
-
How to Connect to Clari Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Clari. Leverage the pyodbc module for ODBC in Python.
-
Integrate Google Spanner Data in Pentaho Data Integration
Build ETL pipelines based on Google Spanner in the Pentaho Data Integration tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Adobe Analytics
Create Adobe Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Publish Crystal Reports on Dropbox Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dropbox.
-
Use the CData Software ODBC Driver for SAP Concur in MicroStrategy Web
Connect to SAP Concur in MicroStrategy Web using the CData Software ODBC Driver for SAP Concur.
-
Create AdRoll Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time AdRoll data access from reports, embedded analytics, and more.
-
Use the CData Software JDBC Driver for SQL Server in MicroStrategy Desktop
Connect to Microsoft SQL Server in MicroStrategy Desktop using the CData Software JDBC Driver for SQL Server.
-
Automate Bannerbear Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bannerbear from PowerShell? This article demonstrates how to utilize the Bannerbear Cmdlets for tasks like connecting to Bannerbear, automating operations, downloading data, and more.
-
Build Dashboards with Front Data in DBxtra
Create dynamic dashboards and perform analytics based on Front in DBxtra.
-
Use the CData Software ODBC Driver for Excel Online in MicroStrategy
Connect to Microsoft Excel Online in MicroStrategy Developer using the CData Software ODBC Driver for Excel Online.
-
Automate Sage 300 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sage 300 replication to Azure Data Lake.
-
Operational Reporting on HelloSign Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HelloSign.
-
Connect to Azure Analysis Services Data in Jaspersoft Studio
Execute SQL to remote Azure Analysis Services in Jaspersoft Studio.
-
Google Drive Reporting in OBIEE with the Google Drive JDBC Driver
Deploy the Google Drive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Amazon DynamoDB Replication to Vertica
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Vertica.
-
Query Todoist Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Todoist from Node.js.
-
How to Work with Clio Data in ETL Validator JDBC
Connect to Clio from ETL Validator jobs using the CData Software JDBC Driver.
-
Connecting Moonlit Workflow with Facebook 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 Facebook in real time.
-
Write a Simple Go Application to work with Slack Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Slack.
-
Use Biml to Build SSIS Tasks to Replicate Clockify Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Clockify to SQL Server.
-
Visualize Oracle Eloqua Reporting Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle Eloqua Reporting.
-
Connect to SAP Ariba Source Data in Jaspersoft Studio
Execute SQL to remote SAP Ariba Source in Jaspersoft Studio.
-
Working with Sage Cloud Accounting Data in LINQPad
Execute LINQ queries to Sage Business Cloud Accounting in LINQPad.
-
Automated Continuous Clockify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Clockify replication to Google BigQuery.
-
Automate Freshservice Data Replication to Couchbase
Use CData Sync to Customize and automate Freshservice replication to Couchbase.
-
Automated Continuous Dynamics NAV Replication to MongoDB
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to MongoDB.
-
Publish Reports with Bullhorn CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bullhorn CRM.
-
Create Dynamic Yelp Grids Using the Infragistics XamDataGrid
Learn how you can connect Yelp to Infragistics XamDataGrid to build dynamic grids.
-
How to work with Sybase Data in Apache Spark using SQL
Access and process Sybase Data in Apache Spark using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoInvoice
Provide connectivity to ZohoInvoice through an SAP BusinessObjects universe.
-
Write a Simple Go Application to work with QuickBooks Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to QuickBooks Desktop.