CData Software - Knowledge Base
Recent Articles
-
Connect to Adobe Experience Manager Data in JRuby
Create a simple JRuby app with access to live Adobe Experience Manager.
-
Consume Onfleet OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Onfleet feeds that reflect any changes in SAP Lumira.
-
Connect to Oracle Eloqua Reporting Data in RapidMiner
Integrate Oracle Eloqua Reporting with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Zoho Projects Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Projects from Node.js.
-
How to Connect the Power BI Service to SAP Business Warehouse: Complete Guide
Connect to the CData Software Power BI Connector for SAP Business Warehouse from PowerBI.com to provide real-time SAP Business Warehouse across the organization.
-
Integrating Antigravity CLI with Microsoft Dataverse (CDS) via CData CLI
Connect Microsoft Dataverse (CDS) to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Azure Data Lake Storage to Power BI dashboards. Simply drag and drop Azure Data Lake Storage into data visuals on the Power BI canvas.
-
Connect MySQL to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MySQL with IBM WebSphere for seamless data integration and connectivity.
-
How to create Codat federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Codat in MySQL .
-
Build AI/ML Models with Live Pinecone Data using Dataiku
Connect Pinecone Data with Dataiku using the CData API Driver for JDBC.
-
Analyze Salesforce Marketing Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Salesforce Marketing Cloud and visualize Salesforce Marketing Cloud in SAP Analytics Cloud.
-
Visualize BigCommerce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to BigCommerce.
-
How to connect and process Google Calendar from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Calendar.
-
Create Productboard Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Productboard data access from reports, embedded analytics, and more.
-
Deploy the ADO.NET Provider for Drift on an SSRS Report Server
Connect to Drift 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.
-
Rapidly Develop Zoho Creator-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 Zoho Creator.
-
Build an OLAP Cube in SSAS from Cosmos DB Data
Establish a connection to Azure Cosmos DB data from SQL Server Analysis Services, and use the Cosmos DB Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Import Data from SAP Ariba Source into Google Sheets
Import SAP Ariba Source into a Google spreadsheet that is automatically refreshed.
-
Access Twilio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Twilio from HeidiSQL.
-
How to load SpaceX data into Elasticsearch via Logstash
Introducing a simple method to load SpaceX data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Boomi Agentstudio with Amazon S3 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Amazon S3, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Natively Connect to OnePageCrm Data in PHP
The CData ODBC driver for OnePageCrm enables you to create PHP applications with connectivity to OnePageCrm. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for Microsoft Exchange Data
How to build a simple VCL Application to view Microsoft Exchange in RAD Studio using the CData ODBC Driver for Microsoft Exchange.
-
Access Live ADP Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ADP from your Excel spreadsheets.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via ADO.NET
This article demonstrates how to access Dynamics 365 Business Central from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365 Business Central.
-
Model, Search, and Visualize Live NetSuite SuiteAnalytics Data in ThoughtSpot
Use CData Connect AI to connect to live NetSuite SuiteAnalytics for modeling, searching, and visualizing.
-
Query Tanda Data in DataGrip
Create a Data Source for Tanda in DataGrip and use SQL to query live Tanda.
-
Build Pushbullet-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Pushbullet Data in Gemini Code Assist to assist with building Pushbullet-powered applications.
-
Amazon Athena Reporting in OBIEE with the Amazon Athena JDBC Driver
Deploy the Amazon Athena JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connecting GenSpark with Oracle Sales Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle Sales without any replication or custom integration required.
-
Connecting Agentforce with Twilio Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Twilio for you.
-
How to use SQLAlchemy ORM to access Dynamics NAV Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics NAV.
-
Connect to ServiceDesk Plus Data in Ruby
Connect to ServiceDesk Plus in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Tally Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tally ERP into the statistical analysis tools available in SAS JMP. This article shows how to use Tally ERP in the Graph Builder and Query Builder.
-
Use the CData API Server to Access Sage 300 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sage 300 in the Power Pivot business intelligence tool.
-
Analyze Demio Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Demio and visualize live Demio in Infragistics Reveal.
-
How to Connect to Live SAP Fieldglass Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Fieldglass securely in real time.
-
Connect to and Query Toggl Data in QlikView over ODBC
Create data visualizations with Toggl in QlikView.
-
Connecting Mastra with eBay Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time eBay, no replication required.
-
Use Databricks Agent Bricks to Talk to Your Airtable Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Airtable for you.
-
Access Live Sybase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sybase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Work with Salesforce CRM Analytics Data in ETL Validator JDBC
Connect to Salesforce CRM Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Dashboards with Mocean Data in DBxtra
Create dynamic dashboards and perform analytics based on Mocean in DBxtra.
-
Connect to Oracle Sales Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Sales from HeidiSQL.
-
Access Live PivotalTracker Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PivotalTracker in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect to SFTP Data from IntelliJ
Integrate connectivity to SFTP with wizards in IntelliJ.
-
Migrating data from Scrapfly to Snowflake using CData SSIS Components.
Easily push Scrapfly to Snowflake using the CData SSIS Tasks for Scrapfly and Snowflake.
-
Connect to Power BI XMLA in SpagoBI
Create reports featuring live Power BI XMLA in SpagoBI Studio. Host Power BI XMLA reports on SpagoBI Server.
-
Explore Geographical Relationships in SparkPost Data with Power Map
Create data visualizations with SparkPost in Power Map.
-
Integrate Cursor with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce & Force.com from within the editor.
-
Integrate with Customer.io Data in JReport Designer
Create charts and reports based on Customer.io in JReport Designer.
-
How to Import Data from LightSpeedRetail into Google Sheets
Import LightSpeedRetail into a Google spreadsheet that is automatically refreshed.
-
Automate Telegram Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Telegram from PowerShell? This article demonstrates how to utilize the Telegram Cmdlets for tasks like connecting to Telegram, automating operations, downloading data, and more.
-
Create Apps from Blackbaud FE NXT Data in Qlik Sense Cloud
Use CData Connect AI to connect to Blackbaud FE NXT Data and build apps from live Blackbaud FE NXT in Qlik Sense Cloud.
-
DataBind Mailjet Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mailjet to a chart.
-
How to Connect Flowise AI Agents to Live PostgreSQL Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live PostgreSQL without replication.
-
Replicate Shopify Data to Multiple Databases
Replicate Shopify to disparate databases with a point-and-click configuration.
-
Connecting Pipedream with Exact Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Exact Online data in real time.
-
Using the CData Software ODBC Driver for CockroachDB in PyCharm
Connect to CockroachDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for CockroachDB.
-
Integrate with live Okta Data in Jitterbit
Use CData Connect AI to connect to and integrate live Okta in Jitterbit.
-
How to Access Phoenix Data Using Entity Framework
This article shows how to access Apache Phoenix using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live Office 365 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 Microsoft Office 365 through natural language.
-
Integrate Instantly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Instantly from Informatica Cloud.
-
How to Connect DBeaver to Active Directory via a JDBC Driver
Manage Active Directory with visual tools in DBeaver like the query browser.
-
Import Real-Time Dropbox Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dropbox in ColdFusion.
-
Query Customer.io Data in ColdFusion
Write standard ColdFusion data access code to connect to Customer.io.
-
Add Reckon Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Reckon with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Oracle Eloqua Data in Heroku for Use in Salesforce Connect
Replicate Oracle Eloqua to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous AlloyDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable AlloyDB replication to Google BigQuery.
-
Automated Continuous SAP Fieldglass Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Amazon S3.
-
Connect to Workday Data in HULFT Integrate
Connect to Workday as a JDBC data source in HULFT Integrate
-
Visualize Templated Data in TIBCO Spotfire through OData
Integrate Templated into dashboards in TIBCO Spotfire.
-
Connect to Live Spark Data in MicroStrategy through CData Connect AI
Create a live connection to Spark Data in CData Connect AI and connect to your Apache Spark SQL from MicroStrategy.
-
Build Apps with Live Omnisend Data Using the Low-Code Development Platform of Mendix
Connect Omnisend with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Oracle SCM 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 Oracle SCM.
-
Connect to iContact Data in RazorSQL
Connect to iContact from wizards and query iContact from the GUI in the RazorSQL database management tool.
-
Access Live Snowflake Data in AWS Lambda
Connect to live Snowflake in AWS Lambda using the CData JDBC Driver.
-
Consume Facebook OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Facebook feeds that reflect any changes in SAP Lumira.
-
How to connect PolyBase to Wave Financial
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Wave Financial.
-
WooCommerce Reporting in OBIEE with the WooCommerce JDBC Driver
Deploy the WooCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import Qualaroo Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Qualaroo. In this article, you will use the OData format to import Qualaroo into Microsoft Power Query.
-
Build Paylocity-Connected Apps in Choreo
Use CData Connect AI to connect to Paylocity Data from Choreo and build custom apps using live Paylocity.
-
Connect to FreeAgent Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FreeAgent in the Denodo Virtual DataPort Administrator.
-
Connecting Agentforce with Zoho Books Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zoho Books for you.
-
Connect to LinkedIn Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live LinkedIn Ads.
-
Connect to Cvent Data in RazorSQL
Connect to Cvent from wizards and query Cvent from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData SSIS Components for ShipStation
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ShipStation.
-
Automated Continuous Yelp Replication to Databricks
Use CData Sync for automated, continuous, customizable Yelp replication to Databricks.
-
How to work with Spark Data in Apache Spark using SQL
Access and process Spark Data in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Coda Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Coda in ColdFusion.
-
Getting Started with the CData Excel Add-In for NetSuite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for NetSuite.
-
Import Real-Time Vimeo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Vimeo in ColdFusion.
-
Build Quickbase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Quickbase.
-
Automated Continuous iContact Replication to SQL Server
Use CData Sync for automated, continuous, customizable iContact replication to SQL Server.
-
How to work with Microsoft Planner Data in Apache Spark using SQL
Access and process Microsoft Planner Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Monday.com Data in Google Apps Script via Connect AI
Use CData Connect AI to access Monday.com in Google Apps Script.
-
Integrate Cursor with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SendGrid from within the editor.
-
Getting Started with the CData Power BI Connector for Teamwork
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Gorgias
Create Gorgias data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Bitbucket Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bitbucket to connect to Bitbucket and execute queries in PowerBuilder.