CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Zoho Creator Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Apache Cassandra.
-
Automated Continuous Act CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Act CRM replication to Google BigQuery.
-
Write a Simple Go Application to work with Microsoft Exchange Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Exchange.
-
ETL Templated in Oracle Data Integrator
This article shows how to transfer Templated into a data warehouse using Oracle Data Integrator.
-
Building Dynamic Web Pages with Avalara AvaTax Data Using AngularJS
Create single-page applications with live connectivity to Avalara AvaTax using the CData API Server.
-
Connect to Pipedrive Data in ACL Analytics
Connect to Pipedrive via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Pipedrive.
-
Access Live Optimizely Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Optimizely into the statistical analysis tools available in SAS JMP. This article shows how to use Optimizely in the Graph Builder and Query Builder.
-
Easily Integrate LionDesk Data in Lazarus Pascal IDE
Learn how to easily integrate live LionDesk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Bright Data Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bright Data into the statistical analysis tools available in SAS JMP. This article shows how to use Bright Data in the Graph Builder and Query Builder.
-
How to create ChartMogul federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ChartMogul in MySQL .
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ActiveCampaign
Provide connectivity to ActiveCampaign through an SAP BusinessObjects universe.
-
Hive Reporting in OBIEE with the Hive JDBC Driver
Deploy the Hive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Design BIRT Reports on Intercom Data
Provide current Intercom to your embedded analytics.
-
How to Connect to Live Salesforce Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Salesforce & Force.com for you.
-
How to Query SparkPost Data in MySQL Workbench
Execute MySQL queries against live SparkPost from MySQL Workbench.
-
Query LaunchDarkly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against LaunchDarkly from Node.js.
-
Connect to Supabase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Supabase and the SQL Gateway to access Supabase from Google Apps Script.
-
Visualize Azure Data Lake Storage Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Data Lake Storage.
-
Integrate BambooHR with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate BambooHR with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to BambooHR.
-
Build Voice Agents in ElevenLabs with access to Live Instagram Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Instagram.
-
Getting Started with the CData Excel Add-In for JobNimbus
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for JobNimbus.
-
Connect to Google Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Analytics in Airbyte.
-
LINQ to CampaignMonitor 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 CampaignMonitor Data Provider.
-
Integrate with Mixpanel Data in JReport Designer
Create charts and reports based on Mixpanel in JReport Designer.
-
Connect to Chargebee Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Chargebee using standard SQL.
-
How to Visualize NetSuite SuiteAnalytics Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live NetSuite SuiteAnalytics in Python.
-
Connect to Real-Time ADP Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ADP and Dataflow to import and use ADP in Power Apps.
-
Automated Continuous Certinia Replication to Oracle
Use CData Sync for automated, continuous, customizable Certinia replication to Oracle.
-
Integrate Live Dynamics 365 Business Central Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Dashboards with Basecamp Data in Dundas BI
Create dynamic dashboards and perform analytics based on Basecamp in Dundas BI.
-
Connect to Azure Data Catalog Data in NetBeans
Connect to Azure Data Catalog in NetBeans with the data source configuration wizard.
-
Connect to ZohoInvoice Data from a Connection Pool in JBoss
Integrate ZohoInvoice into Java servlets: Use the Management Console in JBoss to install the ZohoInvoice JDBC Driver.
-
How to Query Live Simplesat Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Simplesat data in natural language using Python.
-
Create Datasets from Sage Intacct in Domo Workbench and Build Visualizations of Sage Intacct Data in Domo
Use the CData Software ODBC Driver for Sage Intacct to create datasets from Sage Intacct in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to & Open Auth0 Data in Microsoft Excel
This article uses the CData ODBC driver for Auth0 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Natively Connect to Coda Data in PHP
The CData ODBC driver for Coda enables you to create PHP applications with connectivity to Coda. Leverage the native support for ODBC in PHP.
-
A PostgreSQL Interface for Testmonitor Data using the CData ODBC Driver
Use the SQL Gateway and Testmonitor ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query SharePoint Data in DataGrip
Create a Data Source for SharePoint in DataGrip and use SQL to query live Microsoft SharePoint.
-
Access Live Cloudant Data in Excel 365 Online (Excel for the web)
Connect to IBM Cloudant from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live SAP HANA XS Advanced Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA XS Advanced data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Provide OData Services of Phoenix Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Phoenix by developing a WCF Service Application.
-
Connect to Highrise Data in CloverDX (formerly CloverETL)
Transfer Highrise CRM using the visual workflow in the CloverDX data integration tool.
-
Prepare, Blend, and Analyze ZohoExpense Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoExpense for self-service data analytics.
-
Edit and Search MarkLogic External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of MarkLogic to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create MarkLogic objects that you can access from apps and the dashboard.
-
Migrating data from iContact to Databricks using CData SSIS Components.
Easily push iContact to Databricks using the CData SSIS Tasks for iContact and Databricks.
-
Access Vercel Data from MySQL in PHP
Connect to Vercel through the standard MySQL libraries in PHP.
-
Connect to Cvent Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Cvent.
-
Use the CData API Server to Access Couchbase Data in Microsoft PowerPivot
Use the CData API Server to connect to live Couchbase in the Power Pivot business intelligence tool.
-
Integrating Codex CLI with FreshBooks 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 Greenhouse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Greenhouse with IBM WebSphere for seamless data integration and connectivity.
-
Query Live Amazon Athena Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Amazon Athena directly from the development environment.
-
Connect to Chargebee Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Egnyte in MicroStrategy Web
Connect to Egnyte in MicroStrategy Web using the CData Software ODBC Driver for Egnyte.
-
Create Dynamic Cassandra Grids Using the Infragistics XamDataGrid
Learn how you can connect Cassandra to Infragistics XamDataGrid to build dynamic grids.
-
Integrate with Stripe Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Stripe in SnapLogic.
-
Integrate Cline with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Workday from within your IDE.
-
Validate Elorus Data with QuerySurge
Access and validate Elorus in QuerySurge using the CData JDBC Driver.
-
ETL OData in Oracle Data Integrator
This article shows how to transfer OData into a data warehouse using Oracle Data Integrator.
-
Use ChatGPT to Talk to Your SingleStore 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 SingleStore for you.
-
Connect to Splunk Data in Ruby
Connect to Splunk in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Facebook Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Facebook Data and connect to Facebook in Akorbi Digital RunMyProcess.
-
Use Biml to Build SSIS Tasks to Replicate Intercom Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Intercom to SQL Server.
-
Add Zoho CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Using the CData Software ODBC Driver for LinkedIn Ads in PyCharm
Connect to LinkedIn Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for LinkedIn Ads.
-
Build AI Agents with Zuora 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 Zuora through CData Connect AI.
-
How to connect to Microsoft Dataverse Data with Squirrel SQL client
Connect to Microsoft Dataverse (CDS) and execute queries in the Squirrel SQL Client.
-
Connect to Power BI XMLA from a Connection Pool in WebLogic
Use the CData JDBC Driver for Power BI XMLA to connect to Power BI XMLA from Web applications running on WebLogic.
-
Edit and Search MariaDB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of MariaDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create MariaDB objects that you can access from apps and the dashboard.
-
Perform Batch Operations with Odoo Data in Apache NiFi
Connect to Odoo ERP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build AI/ML Models with Live PabblySubscriptions Data using Dataiku
Connect PabblySubscriptions Data with Dataiku using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with iContact Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to iContact.
-
Integrate Google Sheets Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Sheets from Informatica Cloud.
-
Connect to Oracle Sales Data in ACL Analytics
Connect to Oracle Sales via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Sales.
-
Configure the CData JDBC Driver for iContact in a Connection Pool in Tomcat
Connect to iContact from a connection pool in Tomcat.
-
Integrating Antigravity CLI with Wistia via CData CLI
Connect Wistia to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LangGraph with Google Sheets Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Sheets within automated workflows.
-
Query Live Zendesk Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Zendesk directly from the development environment.
-
Creating Shopify-Connected Applications in Unqork
You can use CData Connect AI to feed Shopify to Unqork and build custom business apps.
-
Build AI/ML Models with Live Confluence Data using Dataiku
Connect Confluence Data with Dataiku using the CData JDBC Driver for Confluence.
-
Stream Cosmos DB Data into Apache Kafka Topics
Access and stream Azure Cosmos DB in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Easily Query Productboard Data in OpenOffice Base
Connect to Productboard data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Publish Jodoo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Jodoo.
-
Analyze Confluence Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Atlassian Confluence with the CData JDBC Driver for Confluence.
-
Build AI Agents with Oracle 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 Oracle Database through CData Connect AI.
-
Automate LaunchDarkly Data Replication to Azure Data Lake
Use CData Sync to customize and automate LaunchDarkly replication to Azure Data Lake.
-
Build Apps with Live Foursquare Data Using the Low-Code Development Platform of Mendix
Connect Foursquare with Mendix to build apps using the CData API Driver for JDBC.
-
Boost Your Amazon Athena Performance by 4x with CData Streaming API Support
Boost Amazon Athena query speeds by up to 4x with the CData Amazon Athena JDBC driver’s new Streaming API support.
-
Connect Oracle Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Oracle Database using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Connect AI Python SDK for SAP Ariba Procurement
Install the CData Connect AI Python SDK to read and write live SAP Ariba Procurement with standard DB-API 2.0 Python code.
-
Visualize HDFS Data in Sisense
Create an ElastiCube in Sisense app with access to Apache HDFS.
-
Automated Continuous AfterShip Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable AfterShip replication to Azure SQL Database.
-
Access Tanda Data from MySQL in PHP
Connect to Tanda through the standard MySQL libraries in PHP.
-
Build Dashboards with Bright Data Data in DBxtra
Create dynamic dashboards and perform analytics based on Bright Data in DBxtra.
-
Connect to SuiteCRM Data in Ruby
Connect to SuiteCRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Design Google Sheets Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Google Sheets from mobile and tablet Power Apps.
-
Connect to Google Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Analytics and the Script function in FileMaker Pro to connect to Google Analytics and work with Google Analytics in your FileMaker application.
-
LINQ to Okta 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 Okta Data Provider.
-
DataBind Controls to Basecamp Data in C++Builder
DataBind to Basecamp in C++Builder with standard components and controls.
-
Create Blackbaud FE NXT-Connected Business Apps in AppSheet
Connect to Blackbaud FE NXT Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Blackbaud FE NXT.
-
Connect to NetSuite Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for NetSuite and the SQL Gateway to access NetSuite CRM & ERP from Google Apps Script.