CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Adobe Commerce Data in Delphi
DataBind to Adobe Commerce in Delphi with standard data access components and controls.
-
How to use SQLAlchemy ORM to access Authorize.Net Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Authorize.Net.
-
Getting Started with the CData Python Connector for Zoho Books
Learn to install and license the CData Python Connector
-
Connect to eBay Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live eBay from Filemaker Pro on Mac.
-
Build GitLab-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to GitLab Data from Zoho Analytics and import live GitLab.
-
How to Query Live Keap Data in Perplexity MacOS Desktop
Connect to and query live Keap Data in Perplexity Desktop using CData MCP Server.
-
Consume ZeroBounce OData Feeds in PowerBuilder
This article demonstrates how to consume ZeroBounce as OData feeds from PowerBuilder using the API Server.
-
Integrate Live LinkedIn Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to LinkedIn from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live LinkedIn.
-
Connect to Aha! Data from a Connection Pool in Jetty
The Aha! JDBC Driver supports connection pooling: This article shows how to connect faster to Aha! from Web apps in Jetty.
-
Connect to ActiveCampaign Data in JRuby
Create a simple JRuby app with access to live ActiveCampaign.
-
Connect to Amazon S3 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon S3 as an External Source in Dremio.
-
Work with Live Box Data in Power Query
Use CData Connect AI to connect to Box and work with live Box in Microsoft Power Query.
-
Query Sage 300 Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage 300.
-
Integrating Dataiku with CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Apache CouchDB.
-
Import Real-Time TigerGraph Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use TigerGraph in ColdFusion.
-
Access Active Directory Data from MySQL in Amazon QuickSight
Connect to Active Directory and build visualizations of Active Directory using a MySQL Connection in Amazon QuickSight.
-
Automate Power BI XMLA Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Power BI XMLA from PowerShell? This article demonstrates how to utilize the Power BI XMLA Cmdlets for tasks like connecting to Power BI XMLA, automating operations, downloading data, and more.
-
Choosing the Best Method to Connect FTP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FTP Servers from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Charts to AfterShip Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to AfterShip from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to Adobe Target Data in JRuby
Create a simple JRuby app with access to live Adobe Target.
-
Publish Vimeo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Vimeo.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Azure SQL Database.
-
How to Easily Query Typeform Data in OpenOffice Base
Connect to Typeform data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build MVC Applications with Connectivity to Gong Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Gong from an ASP.NET MVC application.
-
Use the CData Software ODBC Driver for Gorgias in MicroStrategy Web
Connect to Gorgias in MicroStrategy Web using the CData Software ODBC Driver for Gorgias.
-
Automated Continuous Paylocity Replication to SQL Server
Use CData Sync for automated, continuous, customizable Paylocity replication to SQL Server.
-
Automated Continuous Marketo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Marketo replication to IBM DB2.
-
Use the CData Software ODBC Driver for GitHub in MicroStrategy
Connect to GitHub in MicroStrategy Developer using the CData Software ODBC Driver for GitHub.
-
Automated Continuous Accelo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Accelo replication to Google BigQuery.
-
Analyze Square Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Square and visualize live Square in Infragistics Reveal.
-
Analyze Amazon S3 Data in Cognos Analytics
Use CData Connect AI to connect to Amazon S3 Data from Cognos Analytics and analyze live Amazon S3.
-
Build Todoist-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Todoist.
-
Access Live Zoho CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho CRM from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for Freshdesk in MicroStrategy
Connect to Freshdesk in MicroStrategy Developer using the CData Software JDBC Driver for Freshdesk.
-
Connect to Acumatica 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 Acumatica ERP.
-
Visualize Live MarkLogic Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MarkLogic using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Process & Analyze Zoho Inventory Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Inventory Data.
-
Connect to and Visualize Live Google Contacts Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Contacts.
-
Choosing the Best Method to Connect Adobe Target to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Adobe Target from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live SuiteCRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SuiteCRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Power BI Reports on Real-Time Supabase Data
Use the CData ODBC Driver for Supabase to visualize Supabase in Power BI Desktop.
-
Create Zoho CRM-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho CRM Data from Nintex Workflow Cloud and build custom workflows using live Zoho CRM.
-
Visualize Acumatica Data in Tableau
The CData ODBC driver for Acumatica enables you integrate Acumatica ERP into Tableau dashboards.
-
Integrate with Microsoft Planner Data in JReport Designer
Create charts and reports based on Microsoft Planner in JReport Designer.
-
Publish Crystal Reports on Oracle Sales Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Sales.
-
How to connect to Instantly Data from Spring Boot
Connect to Instantly in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating OpenCode Terminal with ActiveCampaign 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.
-
Use the CData Software ODBC Driver for Pipeline CRM in MicroStrategy Desktop
Connect to Pipeline CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Pipeline CRM.
-
Integrate Omnisend Data in Pentaho Data Integration
Build ETL pipelines based on Omnisend in the Pentaho Data Integration tool.
-
Establish a Live Connection with Reckon Data using Tableau Bridge
The CData ODBC Driver for Reckon enables you to integrate live Reckon into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Insightly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Insightly and build web apps with connectivity to live Insightly.
-
Easily Integrate Discourse Data in Lazarus Pascal IDE
Learn how to easily integrate live Discourse in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to Exa Data from IntelliJ
Integrate connectivity to Exa with wizards in IntelliJ.
-
Automate SAP SuccessFactors Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP SuccessFactors replication to Azure Data Lake.
-
How to Connect to & Open AlloyDB Data in Microsoft Excel
This article uses the CData ODBC driver for AlloyDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Microsoft Teams Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Teams from Node.js.
-
Analyze Confluence Data in Cognos Analytics
Use CData Connect AI to connect to Confluence Data from Cognos Analytics and analyze live Atlassian Confluence.
-
DataBind Workday Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Workday with the DevExpress Windows Forms and Web controls to provide Workday to a chart.
-
How to Access Mocean Data Using Entity Framework
This article shows how to access Mocean using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connecting Mastra with Act-On 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 Act-On, no replication required.
-
Natively Connect to Cvent Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cvent. Leverage the native support for ODBC in PHP.
-
How to connect to ClickTime Data with Squirrel SQL client
Connect to ClickTime and execute queries in the Squirrel SQL Client.
-
Build AI Agents with Greenhouse 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 Greenhouse through CData Connect AI.
-
How to Connect to QuickBooks Time Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Time. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Zoho Projects Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Amazon Redshift.
-
How to work with Instagram Data in Apache Spark using SQL
Access and process Instagram Data in Apache Spark using the CData Software JDBC Driver.
-
Seamlessly Bring IBM Cloud Object Storage Data into Retool Using CData Connect AI
Integrate IBM Cloud Object Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Live Microsoft Entra ID 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 Entra ID through natural language.
-
Integrate with Front Data in JReport Designer
Create charts and reports based on Front in JReport Designer.
-
Connect to Freshdesk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Freshdesk and the Script function in FileMaker Pro to connect to Freshdesk and work with Freshdesk in your FileMaker application.
-
Query SAP Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP ERP/NetWeaver and perform CRUD operations on SAP from Node.js.
-
Integrate Nuclia Data in the Pentaho Report Designer
Publish reports based on Nuclia in the Pentaho BI tool.
-
Viewing Dynamics 365 Business Central Data in RAD Studio Data Explorer
How to view Dynamics 365 Business Central in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics 365 Business Central.
-
How to connect to Optimizely Data with Squirrel SQL client
Connect to Optimizely and execute queries in the Squirrel SQL Client.
-
Replicate Sage Cloud Accounting Data from PowerShell
Write a quick PowerShell script to query Sage Business Cloud Accounting. Use connectivity to the live data to replicate Sage Business Cloud Accounting to SQL Server.
-
Automated Continuous Keap Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Keap replication to IBM DB2.
-
Build Data Flows from SQL Server to Marketo through SSIS
Easily push SQL Server data to Marketo using the CData SSIS Tasks for Marketo.
-
Query Salesforce Marketing Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce Marketing entities in PHP by modeling them as objects.
-
How to connect SharePoint with ZarMoney Data through external lists
Provide ZarMoney to SharePoint users as an external list.
-
Integrating Cursor CLI with Microsoft Entra ID 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.
-
Analyze Google Directory Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Directory and visualize live Google Directory in Infragistics Reveal.
-
Import eBay Data Using Azure Data Factory
Use CData Connect AI to connect to eBay Data from Azure Data Factory and import live eBay.
-
Query Insightly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Insightly from Node.js.
-
Connect to Toggl Data from a Connection Pool in JBoss
Integrate Toggl into Java servlets: Use the Management Console in JBoss to install the Toggl JDBC Driver.
-
Automated Continuous Airtable Replication to Oracle
Use CData Sync for automated, continuous, customizable Airtable replication to Oracle.
-
Import Real-Time Quaderno Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Quaderno in ColdFusion.
-
Connect to Salesloft Data in DBArtisan
Use wizards in DBArtisan to configure Salesloft as a data source.
-
Integrate with Slack Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Slack in SnapLogic.
-
Automated Continuous Billsby Replication to Oracle
Use CData Sync for automated, continuous, customizable Billsby replication to Oracle.
-
Build Bullhorn CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Bullhorn CRM and build visualizations in Tableau.
-
DataBind Controls to Pinterest Data in Delphi
DataBind to Pinterest in Delphi with standard data access components and controls.
-
Integrate Freshsales with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshsales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshsales.
-
Automated Continuous OneNote Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable OneNote replication to PostgreSQL.
-
Connect to Oracle Financials Cloud Data in RazorSQL
Connect to Oracle Financials Cloud from wizards and query Oracle Financials Cloud from the GUI in the RazorSQL database management tool.
-
Connect to LeadDesk Data from a Connection Pool in JBoss
Integrate LeadDesk into Java servlets: Use the Management Console in JBoss to install the LeadDesk JDBC Driver.
-
How to Connect DBeaver to Sentry via a JDBC Driver
Manage Sentry with visual tools in DBeaver like the query browser.
-
Connect to Phoenix from a Connection Pool in WebLogic
Use the CData JDBC Driver for Phoenix to connect to Apache Phoenix from Web applications running on WebLogic.
-
Automate EmailOctopus Data Replication to Couchbase
Use CData Sync to Customize and automate EmailOctopus replication to Couchbase.
-
Visualize SFTP Data in TIBCO Spotfire through ADO.NET
Integrate SFTP into dashboards in TIBCO Spotfire.
-
Build FormSite-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live FormSite Data in Claude Code to assist with building FormSite-powered applications.