CData Software - Knowledge Base
Recent Articles
-
Edit and Search Redis External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Redis to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Redis objects that you can access from apps and the dashboard.
-
Visualize Reply.io Data in Sisense
Create an ElastiCube in Sisense app with access to Reply.io.
-
Publish Crystal Reports on Avro Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Avro.
-
How to Connect the Power BI Service to Calendly: Complete Guide
Connect to the CData Software Power BI Connector for Calendly from PowerBI.com to provide real-time Calendly across the organization.
-
Deploy the ADO.NET Provider for Autopilot on an SSRS Report Server
Connect to Autopilot 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.
-
Add Todoist Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Todoist with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Visualizations of Microsoft Dataverse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Dataverse (CDS) in Birst.
-
Use the CData Software ODBC Driver for AfterShip in MicroStrategy Desktop
Connect to AfterShip in MicroStrategy Desktop using the CData Software ODBC Driver for AfterShip.
-
Replicate Multiple Grafana Accounts via the CData Sync CLI
Replicate multiple Grafana accounts to one or many databases.
-
Create a Data Access Object for Amazon DynamoDB Data using JDBI
A brief overview of creating a SQL Object API for Amazon DynamoDB in JDBI.
-
Build MVC Applications with Connectivity to Basecamp Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Basecamp from an ASP.NET MVC application.
-
Perform Batch Operations with Zoho CRM Data in Apache NiFi
Connect to Zoho CRM and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Real-Time Access to LDAP in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to LDAP in real time.
-
Connect to Blackbaud FE NXT Data from HeidiSQL
Use CData Connect AI to connect to and query live Blackbaud FE NXT from HeidiSQL.
-
Create Reports from LinkedIn Data in Looker Studio
Use CData Connect AI to gain access to live LinkedIn and create custom reports in Looker Studio.
-
Create Data Visualizations in Cognos BI with SAP HANA XS Advanced Data
Access SAP HANA XS Advanced as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Work with Exa Data in AWS Glue Jobs Using JDBC
Connect to Exa from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Real-Time Access to QuickBooks Time in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to QuickBooks Time in real time.
-
A PostgreSQL Interface for SpaceX Data using the CData ODBC Driver
Use the SQL Gateway and SpaceX ODBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with Front Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Front.
-
Build MVC Applications with Connectivity to CapsuleCRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CapsuleCRM from an ASP.NET MVC application.
-
Create BigQuery Dataflows on PowerBI.com
Connect to the CData Power BI Connector for BigQuery from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Live Discord Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Discord data in natural language using Python.
-
Use Dash to Build to Web Apps on SAP HANA Data
Create Python applications that use pandas and Dash to build SAP HANA-connected web apps.
-
Integrating Claude Code with HCL Domino Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on HCL Domino within assisted coding and automated development workflows.
-
How to Query Live Instantly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Instantly data in natural language using Python.
-
Integrating Kiro CLI with Clio 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.
-
Build Gong Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Gong and build visualizations in Tableau Cloud.
-
Access Live Strava Data in AWS Lambda
Connect to live Strava in AWS Lambda using the CData JDBC Driver.
-
Prepare, Blend, and Analyze Dynamics CRM Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Dynamics CRM for self-service data analytics.
-
Access SparkPost 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 SparkPost.
-
Provide OData Services of LionDesk Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LionDesk by developing a WCF Service Application.
-
Build Pipelines with Live Kintone Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Kintone from Google Cloud Data Fusion, enabling the integration of live Kintone into the building and management of effective data pipelines.
-
How to load Microsoft Teams data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft Teams data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build MVC Applications with Connectivity to GitLab Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access GitLab from an ASP.NET MVC application.
-
Stream Oracle SCM Data into Apache Kafka Topics
Access and stream Oracle SCM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a PostgreSQL Interface for Opsgenie Data using the CData JDBC Driver
Use the Remoting features of the Opsgenie JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Zoho CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho CRM data access from reports, embedded analytics, and more.
-
Automate Paylocity Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Paylocity and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Replicate Multiple Google Calendar Accounts
Replicate multiple Google Calendar accounts to one or many databases.
-
Replicate Multiple Salesforce Accounts via the CData Sync CLI
Replicate multiple Salesforce accounts to one or many databases.
-
Replicate Clio Data to Multiple Databases
Replicate Clio to disparate databases with a point-and-click configuration.
-
Configure the CData JDBC Driver for Act-On in a Connection Pool in Tomcat
Connect to Act-On from a connection pool in Tomcat.
-
Connect to Real-Time Planio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Planio in Power Apps.
-
Integrating LlamaIndex with SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft SQL Server in real time.
-
Extract, Transform, and Load Freshteam Data in Informatica PowerCenter
Create a simple Workflow for Freshteam in Informatica PowerCenter.
-
Connect to and Visualize Live Landbot Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Landbot.
-
How to Connect to Live Stripe Data 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 Stripe for you.
-
How to create an RPA flow for Hubstaff Data in UiPath Studio
Use the Hubstaff ODBC Driver to create workflows that access real-time Hubstaff without any coding.
-
Build Visualizations of Webex Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Webex in Birst.
-
How to Connect the Power BI Service to SendGrid: Complete Guide
Connect to the CData Software Power BI Connector for SendGrid from PowerBI.com to provide real-time SendGrid across the organization.
-
Automated Continuous Accelo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Accelo replication to Apache Kafka.
-
Automated Continuous ADP Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ADP replication to Google Cloud SQL.
-
Use Dash to Build to Web Apps on Figshare Data
Create Python applications that use pandas and Dash to build Figshare-connected web apps.
-
Connect to WooCommerce Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for WooCommerce and the Script function in FileMaker Pro to connect to WooCommerce and work with WooCommerce in your FileMaker application.
-
Connect Azure Synapse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Synapse using the CData Python MCP Server.
-
Hugging Face Reporting in OBIEE with the Hugging Face JDBC Driver
Deploy the Hugging Face JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Process & Analyze Box Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Box Data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Hugging Face
Provide connectivity to Hugging Face through an SAP BusinessObjects universe.
-
Replicate Parquet Data in Heroku for Use in Salesforce Connect
Replicate Apache Parquet to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Access Zoho Books Data Using Entity Framework
This article shows how to access Zoho Books using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Microsoft OneDrive Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft OneDrive in Airbyte.
-
How to integrate Coda with Apache Airflow
Access and process Coda in Apache Airflow using the CData JDBC Driver.
-
Build Semantic Layer Views for Pinterest Data in APOS Live Data Gateway
Use the CData Connector for Pinterest in APOS Live Data Gateway to build Semantic Layer Views for Pinterest.
-
Getting Started with the CData JDBC Driver for Mocean
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mocean.
-
Import and Visualize Oracle Service Cloud Data in Power View
Create data visualizations based on Oracle Service Cloud in Excel.
-
Connect to Kintone Data in Claris FileMaker Pro
Use the CData ODBC Driver for Kintone in FileMaker Pro to connect to Kintone and work with Kintone in your FileMaker applications.
-
Configure the CData JDBC Driver for CSV in a Connection Pool in Tomcat
Connect to CSV/TSV Files from a connection pool in Tomcat.
-
Access Eventbrite Data from MySQL in PHP
Connect to Eventbrite through the standard MySQL libraries in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Mocean
Provide connectivity to Mocean through an SAP BusinessObjects universe.
-
Query Dropbox Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Dropbox from Node.js.
-
Natively Connect to Moosend Data in PHP
The CData ODBC driver for Moosend enables you to create PHP applications with connectivity to Moosend. Leverage the native support for ODBC in PHP.
-
Import Apollo Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Apollo Data and provide access to live Apollo for custom reports in the Power BI Service.
-
Connect to Slack Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Slack Data and connect to Slack in Akorbi Digital RunMyProcess.
-
Connect to ZohoDesk Data in RapidMiner
Integrate ZohoDesk with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect and Query Live HCL Domino Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live HCL Domino into Databricks
-
Automated Continuous eBay Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable eBay replication to Azure SQL Database.
-
How to Seamlessly Import Act CRM Data into IBM SPSS Modeler
Integrate Act CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Codex CLI with SFTP 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.
-
How to create an RPA flow for Microsoft Teams Data in UiPath Studio
Use the Microsoft Teams ODBC Driver to create workflows that access real-time Microsoft Teams without any coding.
-
Object-Relational Mapping (ORM) with Splunk Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Splunk into a Java-based ORM framework, Hibernate.
-
Edit and Search External Adobe Analytics Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Adobe Analytics to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Adobe Analytics Data objects that you can access from apps and the dashboard.
-
DataBind PivotalTracker Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PivotalTracker to a chart.
-
Use ChatGPT to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MYOB AccountRight for you.
-
How to connect to Simplesat Data from IntelliJ
Integrate connectivity to Simplesat with wizards in IntelliJ.
-
How to load ConstantContact data into Elasticsearch via Logstash
Introducing a simple method to load ConstantContact data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with Email Data in JReport Designer
Create charts and reports based on Email in JReport Designer.
-
Access Live NetSuite Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to NetSuite CRM & ERP from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Excel Add-In for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle HCM Cloud.
-
Publish HubDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HubDB.
-
Automate Tally Data Replication to Azure Synapse
Use CData Sync to customize and automate Tally ERP replication to Azure Synapse.
-
Create BigCommerce-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to BigCommerce Data from Klipfolio and build custom visualizations using live BigCommerce.
-
Build MVC Applications with Connectivity to Vimeo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Vimeo from an ASP.NET MVC application.
-
Bind Live Presto Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Presto data
-
Bind Live Zoho Projects Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Projects data
-
Use the CData Software JDBC Driver for Google Ads in MicroStrategy
Connect to Google Ads in MicroStrategy Developer using the CData Software JDBC Driver for Google Ads.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Dataverse
Provide connectivity to Microsoft Dataverse (CDS) through an SAP BusinessObjects universe.
-
How to Query Toggl Data in MySQL Workbench
Execute MySQL queries against live Toggl from MySQL Workbench.
-
Import Real-Time Webex Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Webex in ColdFusion.
-
Build Charts with Zuora Data in Clear Analytics
Create dynamic charts and perform analytics based on Zuora in Clear Analytics.