CData Software - Knowledge Base
Recent Articles
-
Connect to Kintone Data in JRuby
Create a simple JRuby app with access to live Kintone.
-
Build a Simple VCL Application for Kintone Data
How to build a simple VCL Application to view Kintone in RAD Studio using the CData ODBC Driver for Kintone.
-
Stream Oracle HCM Cloud Data into Apache Kafka Topics
Access and stream Oracle HCM Cloud in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jira Assets
Provide connectivity to Jira Assets through an SAP BusinessObjects universe.
-
Build Salesforce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce & Force.com and build web apps with connectivity to live Salesforce & Force.com.
-
Connect to Twilio Data in Claris FileMaker Pro
Use the CData ODBC Driver for Twilio in FileMaker Pro to connect to Twilio and work with Twilio in your FileMaker applications.
-
How to connect to ADP Data with Squirrel SQL client
Connect to ADP and execute queries in the Squirrel SQL Client.
-
Access Live BigCommerce Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to BigCommerce from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Amazon S3
Provide connectivity to Amazon S3 through an SAP BusinessObjects universe.
-
Visualize PostgreSQL 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 PostgreSQL into TIBCO Spotfire.
-
Integrate TaxJar Data in the Pentaho Report Designer
Publish reports based on TaxJar in the Pentaho BI tool.
-
Create Reports with CockroachDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CockroachDB.
-
Connect to Blackbaud FE NXT Data in ACL Analytics
Connect to Blackbaud FE NXT via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Blackbaud FE NXT.
-
Import Couchbase Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Couchbase. In this article, you will use the OData format to import Couchbase into Microsoft Power Query.
-
Bidirectional Access to Todoist Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Todoist in Filemaker Pro for Mac or Windows.
-
Use CData Connect AI to Access CockroachDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live CockroachDB in the Power Pivot business intelligence tool.
-
Automated LeadDesk Data Replication to Teradata
Use CData Sync to Customize and automate LeadDesk replication to Teradata.
-
Create Power BI Reports on Real-Time PolarTeamPro Data
Use the CData ODBC Driver for PolarTeamPro to visualize PolarTeamPro in Power BI Desktop.
-
Automated Continuous Azure Blob Storage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to IBM DB2.
-
Use Biml to Build SSIS Tasks to Replicate Email Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Email to SQL Server.
-
Integrating Boomi Agentstudio with Apollo Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Apollo, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build an OLAP Cube in SSAS from Hugging Face Data
Establish a connection to Hugging Face data from SQL Server Analysis Services, and use the Hugging Face Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Impala Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache Impala securely in real time.
-
Integrating LlamaIndex with Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Shopify in real time.
-
How to Access Freshservice Data Using Entity Framework
This article shows how to access Freshservice using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Build an ETL App for Rootly Data in Python with CData
Create ETL applications and real-time data pipelines for Rootly in Python with petl.
-
Getting Started with the CData SSIS Components for Eventbrite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Eventbrite.
-
How to create an RPA flow for Strava Data in UiPath Studio
Use the Strava ODBC Driver to create workflows that access real-time Strava without any coding.
-
Connect to Trello Data in DBeaver
Use the CData ODBC Driver to connect to Trello in DBeaver.
-
Connect to Todoist Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Todoist and the SQL Gateway to access Todoist from Google Apps Script.
-
Access Live QuickBooks Time Data in Excel 365 Online (Excel for the web)
Connect to QuickBooks Time from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build AI Agents with MongoDB Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live MongoDB through CData Connect AI.
-
Build Data Flows from EnterpriseDB to SQL Server using SSIS
Easily back up EnterpriseDB to SQL Server using the SSIS components for EnterpriseDB.
-
Using the CData Software ODBC Driver for Gorgias in PyCharm
Connect to Gorgias as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gorgias.
-
Integrate with Gmail Data in JReport Designer
Create charts and reports based on Gmail in JReport Designer.
-
Connect to SAP SuccessFactors LMS Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP SuccessFactors LMS as an External Source in Dremio.
-
DataBind Controls to AlloyDB Data in Delphi
DataBind to Google AlloyDB in Delphi with standard data access components and controls.
-
Build AI Agents with Sage Intacct Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Sage Intacct through CData Connect AI.
-
Extend Google Sheets with GraphQL Data
Make calls to GraphQL from Google Apps Script via the API Server.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy
Connect to Dynamics 365 Business Central in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Choosing the Best Method to Connect Discourse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Discourse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to import Google Drive Data into Apache Solr
Use the CData Software JDBC Driver for Google Drive in Data Import Handler and create an automated import of Google Drive to Apache Solr Enterprise Search platform.
-
Build HDFS-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for HDFS to explore live HDFS Data in GitHub Copilot to assist with building HDFS-powered applications.
-
Getting Started with the CData SSIS Components for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PostgreSQL.
-
Build Square-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Square.
-
Connect to Datadog Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Datadog and work with Datadog in your FileMaker application.
-
Easily Integrate Azure Data Catalog Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure Data Catalog in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Migrating data from Zoho Inventory to Databricks using CData SSIS Components.
Easily push Zoho Inventory to Databricks using the CData SSIS Tasks for Zoho Inventory and Databricks.
-
Extract, Transform, and Load Freshdesk Data in Informatica PowerCenter
Create a simple Workflow for Freshdesk in Informatica PowerCenter.
-
Connect Yelp Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Yelp using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create a Data Access Object for Stack Exchange Data using JDBI
A brief overview of creating a SQL Object API for Stack Exchange in JDBI.
-
Build AI Agents with Sage 200 Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Sage 200 through CData Connect AI.
-
How to create an RPA flow for SAP Hybris C4C Data in UiPath Studio
Use the SAP Hybris C4C ODBC Driver to create workflows that access real-time SAP Hybris C4C without any coding.
-
Integrating Cursor CLI with Oracle 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.
-
Connect to Zoho CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho CRM to connect to Zoho CRM from Web applications running on WebLogic.
-
Zoom Reporting in OBIEE with the Zoom JDBC Driver
Deploy the Zoom JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Viewing GetResponse Data in RAD Studio Data Explorer
How to view GetResponse in RAD Studio Data Explorer using the CData ODBC Driver for GetResponse.
-
Access Live Adobe Target Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Target data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect the Power BI Service to ZendeskSell: Complete Guide
Connect to the CData Software Power BI Connector for ZendeskSell from PowerBI.com to provide real-time ZendeskSell across the organization.
-
Integrate HelloSign Data in Pentaho Data Integration
Build ETL pipelines based on HelloSign in the Pentaho Data Integration tool.
-
A PostgreSQL Interface for ServiceNow Data (MySQL Remoting via JDBC)
Use the Remoting features of the ServiceNow JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Microsoft Ads Data in Apache Spark using SQL
Access and process Microsoft Ads Data in Apache Spark using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Browserless Data
Use CData Power BI Connectors to visualize Browserless in Power BI.
-
Integrate Google Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Ads.
-
Build Vault CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Vault CRM Data from Choreo and build custom apps using live Veeva Vault & Vault CRM.
-
Automated Continuous CapsuleCRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to AlloyDB.
-
Integrate with Drift Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Drift to a JSON file on disk.
-
Create a Data Access Object for Dynamics NAV Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Dynamics NAV in JDBI.
-
Import Real-Time MongoDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MongoDB in ColdFusion.
-
Access Zoho CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho CRM from your Oracle system.
-
How to import Avalara AvaTax Data into Apache Solr
Use the CData Software JDBC Driver for Avalara AvaTax in Data Import Handler and create an automated import of Avalara AvaTax to Apache Solr Enterprise Search platform.
-
Build Agents in Relevance AI with Access to Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM DB2 within intelligent agent workflows.
-
Connect to Simplesat Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Salesforce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce facts in real time.
-
Use the CData Software ODBC Driver for Keap in MicroStrategy
Connect to Keap in MicroStrategy Developer using the CData Software ODBC Driver for Keap.
-
Integrate ScrapingBee Data in Pentaho Data Integration
Build ETL pipelines based on ScrapingBee in the Pentaho Data Integration tool.
-
How to Connect to Live Zoho Projects 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 Zoho Projects for you.
-
Integrate with live Freshservice Data in Jitterbit
Use CData Connect AI to connect to and integrate live Freshservice in Jitterbit.
-
Using the CData Software ODBC Driver for Vimeo in PyCharm
Connect to Vimeo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Vimeo.
-
Getting Started with the CData JDBC Driver for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Campaign Manager 360.
-
Access Jira Data from MySQL in PHP
Connect to Jira through the standard MySQL libraries in PHP.
-
Add SendPulse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SendPulse with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create a Data Access Object for Oracle Data using JDBI
A brief overview of creating a SQL Object API for Oracle Database in JDBI.
-
Automated Continuous Elorus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Elorus replication to Google BigQuery.
-
Connect Phoenix to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apache Phoenix using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for Brex in MicroStrategy Desktop
Connect to Brex in MicroStrategy Desktop using the CData Software ODBC Driver for Brex.
-
Connect to PabblySubscriptions Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PabblySubscriptions using standard SQL.
-
Automated Continuous Mouseflow Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mouseflow replication to IBM DB2.
-
Integrating LangChain with Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Marketo within automated workflows.
-
Visualize Redis Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Redis.
-
Build Automated Spark-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Spark SQL and build automated workflows in Zapier.
-
Access Live Tickspot Data in Coginiti Pro
Connect to and query live Tickspot from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous eBay Analytics Replication to Databricks
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Databricks.
-
How to connect to Neo4J Data from IntelliJ
Integrate connectivity to Neo4J with wizards in IntelliJ.
-
Access Outreach.io Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Outreach.io from HeidiSQL.
-
How to Connect to & Open Simplesat Data in Microsoft Excel
This article uses the CData ODBC driver for Simplesat to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SQL Server
Provide connectivity to Microsoft SQL Server through an SAP BusinessObjects universe.
-
Build a Singer.io Tap for Salesforce Pardot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce Pardot data using
-
Connect Excel Online to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Excel Online using the CData Python MCP Server.
-
Build a Simple VCL Application for Oracle Service Cloud Data
How to build a simple VCL Application to view Oracle Service Cloud in RAD Studio using the CData ODBC Driver for Oracle Service Cloud.