CData Software - Knowledge Base
Recent Articles
-
Integrate Real-Time Access to Authorize.Net in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Authorize.Net in real time.
-
Enable the Foursquare JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Foursquare.
-
Automate SAP Netweaver Gateway Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Netweaver Gateway replication to SAP HANA.
-
Connect to Hacker News Data in NetBeans
Connect to Hacker News in NetBeans with the data source configuration wizard.
-
How to create Workable federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Workable in MySQL .
-
Connect to Google Analytics Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Analytics in the Denodo Virtual DataPort Administrator.
-
DataBind Controls to ZeroBounce Data in Delphi
DataBind to ZeroBounce in Delphi with standard data access components and controls.
-
Automated Continuous Xero Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Xero replication to Azure SQL Database.
-
Build PolarTeamPro-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PolarTeamPro and build web apps with connectivity to live PolarTeamPro.
-
Analyze SQL Analysis Services Data in Looker
Use CData Connect AI to connect to SQL Analysis Services Data from Looker and build custom apps using live SQL Analysis Services.
-
Automated Continuous Salesforce Pardot Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to OneLake in Microsoft Fabric.
-
Create SSAS Tabular Models from Klipfolio Data
How to build a SQL Server Analysis Service Tabular Model from Klipfolio using CData drivers.
-
Access Live Cassandra Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Cassandra in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Work with Dynamics CRM Data in AWS Glue Jobs Using JDBC
Connect to Dynamics CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connecting Pipedream with Vault CRM 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 Vault CRM data in real time.
-
Getting Started with the CData ODBC Driver for xBase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for xBase.
-
How to connect to SAP SuccessFactors LMS Data with Squirrel SQL client
Connect to SAP SuccessFactors LMS and execute queries in the Squirrel SQL Client.
-
Build Email-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Email and build web apps with connectivity to live Email.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Eloqua
Provide connectivity to Oracle Eloqua through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Front
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Front.
-
Build MVC Applications with Connectivity to Power BI XMLA Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Power BI XMLA from an ASP.NET MVC application.
-
Create Dashboards and Visualize Live Twilio Data in Geckoboard
Use CData Connect AI to connect to live Twilio and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Live Oracle HCM Cloud Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle HCM Cloud and integrate live Oracle HCM Cloud into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for FreeAgent in MicroStrategy Desktop
Connect to FreeAgent in MicroStrategy Desktop using the CData Software JDBC Driver for FreeAgent.
-
Integrating Claude Code CLI with LightSpeedRetail 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.
-
Getting Started with the CData Power BI Connector for GetResponse
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Feed Acumatica Data into FineReport
How to set Acumatica ERP as a JDBC data source in FineReport.
-
DataBind Controls to Simplesat Data in C++Builder
DataBind to Simplesat in C++Builder with standard components and controls.
-
Automated Continuous CapsuleCRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to SQL Server.
-
Automated Continuous ServiceNow Replication to SingleStore
Use CData Sync for automated, continuous, customizable ServiceNow replication to SingleStore.
-
How to Connect to Live ADP 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 ADP through natural language.
-
Replicate Multiple Oracle SCM Accounts
Replicate multiple Oracle SCM accounts to one or many databases.
-
Choosing the Best Method to Connect Paylocity to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Paylocity from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Grok to Talk to Your Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Email for you.
-
How to connect to Zoho Creator Data from Spring Boot
Connect to Zoho Creator in a Spring Boot Application using the CData JDBC Driver for Zoho Creator
-
Analyze Live SQL Analysis Services Data in SAS Viya
Use CData Connect AI to connect to SQL Analysis Services from SAS Viya and deploy self-service analytics using live SQL Analysis Services.
-
Shortcut Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Shortcut facts in real time.
-
DataBind Simplesat Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Simplesat to a chart.
-
Extract, Transform, and Load Adobe Commerce Data in Informatica PowerCenter
Create a simple Workflow for Adobe Commerce in Informatica PowerCenter.
-
Integrating Claude Code CLI with HDFS 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.
-
How to Work with Elorus Data in ETL Validator JDBC
Connect to Elorus from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Printful Data Replication to Azure Synapse
Use CData Sync to customize and automate Printful replication to Azure Synapse.
-
Visualize Amazon Marketplace Data in TIBCO Spotfire through OData
Integrate Amazon Marketplace into dashboards in TIBCO Spotfire.
-
Automated Continuous SAP HANA XS Advanced Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SingleStore.
-
Analyze Facebook Ads Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Facebook Ads and visualize live Facebook Ads in Infragistics Reveal.
-
Integrate SageHR with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SageHR with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SageHR.
-
How to Seamlessly Import Neo4J Data into IBM SPSS Modeler
Integrate Neo4J data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for xBase in SAS for Real-Time Reporting and Analytics
Connect to real-time xBase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for xBase.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pinterest
Provide connectivity to Pinterest through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Beeminder in SAS for Real-Time Reporting and Analytics
Connect to real-time Beeminder in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Beeminder.
-
Access Live Google Directory Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Directory in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Using the CData Software ODBC Driver for Adobe Experience Manager in PyCharm
Connect to Adobe Experience Manager as an ODBC data source in PyCharm using the CData Software ODBC Driver for Adobe Experience Manager.
-
How to Access Live LDAP Objects in Power Automate Desktop via ODBC
The CData ODBC Driver for LDAP enables you to integrate LDAP into workflows built using Microsoft Power Automate Desktop.
-
Connect to Chargebee Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Chargebee in the Denodo Virtual DataPort Administrator.
-
Moving Data from Reckon to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Reckon data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData Excel Add-In for Coinbase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Coinbase.
-
Use the CData Software JDBC Driver for SAP HANA XS Advanced in MicroStrategy Web
Connect to SAP HANA XS Advanced in MicroStrategy Web using the CData Software JDBC Driver for SAP HANA XS Advanced.
-
Integrate with Google Ad Manager Data in JReport Designer
Create charts and reports based on Google Ad Manager in JReport Designer.
-
DataBind Google Translate Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Google Translate to a chart.
-
How to Access Aha! Data Using Entity Framework
This article shows how to access Aha! using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Workday Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Workday and build visualizations in Tableau.
-
Creating Google Drive-Connected Applications in Unqork
You can use CData Connect AI to feed Google Drive to Unqork and build custom business apps.
-
Connect to CouchDB Data in RazorSQL
Connect to CouchDB from wizards and query Apache CouchDB from the GUI in the RazorSQL database management tool.
-
Bridge Shopify Connectivity with Apache NiFi
Access and process Shopify in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Quaderno Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Quaderno replication to Amazon Redshift.
-
Publish Reports with HDFS Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache HDFS.
-
Use the CData Software ODBC Driver for Gumroad in MicroStrategy
Connect to Gumroad in MicroStrategy Developer using the CData Software ODBC Driver for Gumroad.
-
Explore Geographical Relationships in Google Spanner Data with Power Map
Create data visualizations with Google Spanner in Power Map.
-
Access Live ZeroBounce Data in Coginiti Pro
Connect to and query live ZeroBounce from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Dataiku with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Dropbox.
-
Connect Zoom Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoom using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish SAP BusinessObjects BI-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP BusinessObjects BI.
-
Manage Pipedrive Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pipedrive.
-
How to Connect Flowise AI Agents to Live Cassandra 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 Apache Cassandra without replication.
-
Connect to Oracle SCM Data in Aqua Data Studio
Access Oracle SCM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Codex CLI with Splunk 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 Moosend-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Moosend and build web apps with connectivity to live Moosend.
-
Use Azure AI Foundry to Talk to Your SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP SuccessFactors LMS for you.
-
Import GitHub Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to GitHub Data and provide access to live GitHub for custom reports in the Power BI Service.
-
Connect to Zoho Inventory Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Inventory in FileMaker Pro to connect to Zoho Inventory and work with Zoho Inventory in your FileMaker applications.
-
Build Power BI XMLA Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Power BI XMLA and build visualizations in Tableau Cloud.
-
Connect to MongoDB from Asprova with CData Software ODBC Driver for MongoDB
This article shows how to connect faster to MongoDB data from Asprova.
-
Automated Continuous GraphQL Replication to Amazon S3
Use CData Sync for automated, continuous, customizable GraphQL replication to Amazon S3.
-
Getting Started with the CData JDBC Driver for Beeminder
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Beeminder.
-
Publish RabbitMQ-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live RabbitMQ.
-
Publish Clari-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Clari.
-
Build an OLAP Cube in SSAS from REST Data
Establish a connection to REST data from SQL Server Analysis Services, and use the REST Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Amazon S3 Data in AWS Lambda
Connect to live Amazon S3 in AWS Lambda using the CData JDBC Driver.
-
How to Easily Query PivotalTracker Data in OpenOffice Base
Connect to PivotalTracker data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate with Autopilot Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Autopilot to a JSON file on disk.
-
Import Hive Data Using Azure Data Factory
Use CData Connect AI to connect to Hive Data from Azure Data Factory and import live Apache Hive.
-
Use the CData ODBC Driver for Access from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Access to connect to Microsoft Access from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Access in Excel.
-
Connect and Visualize Live Xero Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Xero Accounting into the Databricks platform and create visualization dashboards with real-time Xero Accounting.
-
How to connect to ZohoDesk Data from Spring Boot
Connect to ZohoDesk in a Spring Boot Application using the CData API Driver for JDBC
-
Bidirectional Access to Scrapfly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Scrapfly in Filemaker Pro for Mac or Windows.
-
Visualize Cosmos DB Data in TIBCO Spotfire through OData
Integrate Azure Cosmos DB into dashboards in TIBCO Spotfire.
-
Manage SparkPost Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SparkPost.
-
Process & Analyze Trello Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Trello Data.
-
Build MVC Applications with Connectivity to Salesforce Marketing Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesforce Marketing from an ASP.NET MVC application.
-
Integrating Claude Code CLI with Mailgun 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.