CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for OnePageCrm Data
How to build a simple VCL Application to view OnePageCrm in RAD Studio using the CData ODBC Driver for OnePageCrm.
-
Access Live Airtable Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Airtable in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Adobe Commerce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Commerce in Microsoft R Open.
-
Build AI Agents with Avro 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 Apache Avro through CData Connect AI.
-
Connect to SingleStore Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SingleStore and the Script function in FileMaker Pro to connect to SingleStore and work with SingleStore in your FileMaker application.
-
Write a Simple Go Application to work with Delighted Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Delighted.
-
Build Data Flows from FTP to SQL Server using SSIS
Easily back up FTP Servers to SQL Server using the SSIS components for FTP.
-
Query Float Data in DataGrip
Create a Data Source for Float in DataGrip and use SQL to query live Float.
-
Automated Continuous SAP Business One Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Business One replication to Apache Kafka.
-
Connect GraphQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GraphQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Marketo Data in Pentaho Data Integration
Build ETL pipelines based on Marketo in the Pentaho Data Integration tool.
-
Extract, Transform, and Load Bannerbear Data in Informatica PowerCenter
Create a simple Workflow for Bannerbear in Informatica PowerCenter.
-
How to connect to Notion Data from Spring Boot
Connect to Notion in a Spring Boot Application using the CData API Driver for JDBC
-
Use JayDeBeApi to access SAS xpt Data in Python
Use standard Python scripting and the development environment of your choice to access live SAS XPORT.
-
Automated Continuous Figshare Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Figshare replication to Amazon S3.
-
Connect to Drift Data from a Connection Pool in Jetty
The Drift JDBC Driver supports connection pooling: This article shows how to connect faster to Drift from Web apps in Jetty.
-
Connect to GitLab Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for GitLab in the Denodo Virtual DataPort Administrator.
-
Create SSAS Tabular Models from Zuora Data
How to build a SQL Server Analysis Service Tabular Model from Zuora using CData drivers.
-
Integrate with Kintone Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Kintone in SnapLogic.
-
Connect to Cassandra Data in CloverDX (formerly CloverETL)
Transfer Apache Cassandra using the visual workflow in the CloverDX data integration tool.
-
Excel Spreadsheet Automation on Discord Data with the QUERY Formula
Pull data from Discord, automate spreadsheets, and more with the QUERY formula.
-
Connect to SuiteCRM Data in Jaspersoft Studio
Execute SQL to remote SuiteCRM in Jaspersoft Studio.
-
Access Moosend Data from MySQL in Amazon QuickSight
Connect to Moosend and build visualizations of Moosend using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build Web Apps on IBM Cloud Object Storage Data via CData Connect AI
Build interactive Dash web apps on live IBM Cloud Object Storage using pandas and the CData Connect AI Python SDK.
-
Connect to ZohoExpense Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoExpense.
-
Connect to Foursquare Data from PowerBuilder via JDBC
This article demonstrates how to access Foursquare from PowerBuilder using the Foursquare JDBC Driver.
-
Automate HubSpot Data Replication to Couchbase
Use CData Sync to Customize and automate HubSpot replication to Couchbase.
-
Build a PostgreSQL Interface for NASA Data using the CData JDBC Driver
Use the Remoting features of the NASA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Printful Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Printful to a JSON file on disk.
-
Import Real-Time Zoho Books Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Books in ColdFusion.
-
Connect to Sybase IQ Data from a Connection Pool in Jetty
The Sybase IQ JDBC Driver supports connection pooling: This article shows how to connect faster to Sybase IQ from Web apps in Jetty.
-
Integrating Excel Online Data in Talend Cloud Data Management Platform
Connect Excel Online Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Excel Online.
-
Access Epicor Kinetic Data from MySQL in Amazon QuickSight
Connect to Epicor Kinetic and build visualizations of Epicor Kinetic using a MySQL Connection in Amazon QuickSight.
-
Connect to Trello Data in JRuby
Create a simple JRuby app with access to live Trello.
-
How to Query Live IBM Cloud Object Storage Data in Perplexity MacOS Desktop
Connect to and query live IBM Cloud Object Storage Data in Perplexity Desktop using CData MCP Server.
-
Analyze Zoho Projects Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho Projects and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use Biml to Build SSIS Tasks to Replicate YouTube Analytics Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate YouTube Analytics to SQL Server.
-
Connect Typeform to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Typeform with IBM WebSphere for seamless data integration and connectivity.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for OpenWeatherMap
Provide connectivity to OpenWeatherMap through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze FormSite Data in Alteryx Designer (ODBC)
Build workflows to access live FormSite for self-service data analytics.
-
Automate SparkPost Data Replication to Azure Data Lake
Use CData Sync to customize and automate SparkPost replication to Azure Data Lake.
-
Connect to Authorize.Net Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Authorize.Net from Filemaker Pro on Mac.
-
Integrating Kiro CLI with Zoho Creator 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.
-
Model Greenplum Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Greenplum, enabling the direct import of real-time Pivotal GreenPlum.
-
How to Query Live SurveyMonkey Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SurveyMonkey data in natural language using Python.
-
Connect to Google Spanner Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Spanner and the Script function in FileMaker Pro to connect to Google Spanner and work with Google Spanner in your FileMaker application.
-
Work with Pipeline CRM Data in FoxPro
Load Pipeline CRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Asana Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Asana from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Samanage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Samanage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Testmonitor Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Testmonitor replication to OneLake in Microsoft Fabric.
-
Connect to Sugar CRM in SpagoBI
Create reports featuring live Sugar CRM in SpagoBI Studio. Host Sugar CRM reports on SpagoBI Server.
-
Build Dashboards with Dynamics CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Dynamics CRM in Dundas BI.
-
Connect to Aircall Data from PowerBuilder via ADO.NET
This article demonstrates how to access Aircall from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate Live Flowlu Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Flowlu to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Consume Microsoft Dataverse OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Dataverse (CDS) as OData feeds from PowerBuilder using the API Server.
-
Validate Nuclia Data with QuerySurge
Access and validate Nuclia in QuerySurge using the CData JDBC Driver.
-
Feed Google Campaign Manager 360 Data into FineReport
How to set Google Campaign Manager 360 as a JDBC data source in FineReport.
-
Access SQL Analysis Services Data from MySQL in Amazon QuickSight
Connect to SQL Analysis Services and build visualizations of SQL Analysis Services using a MySQL Connection in Amazon QuickSight.
-
DataBind Charts to Okta Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Okta 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.
-
Integrate SAP Ariba Procurement Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Ariba Procurement from Informatica Cloud.
-
How to Query Live SAP ByDesign Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Business ByDesign data in natural language using Python.
-
Getting Started with the CData Excel Add-In for Couchbase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Couchbase.
-
Rapidly Develop Telegram-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 Telegram.
-
Validate Google Translate Data with QuerySurge
Access and validate Google Translate in QuerySurge using the CData JDBC Driver.
-
Build Keap-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Keap and build web apps with connectivity to live Keap.
-
Write a Simple Go Application to work with Zoom Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoom.
-
Query Salesforce Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce & Force.com.
-
Use the CData Software ODBC Driver for Snapchat Ads in MicroStrategy Desktop
Connect to Snapchat Ads in MicroStrategy Desktop using the CData Software ODBC Driver for Snapchat Ads.
-
Import Real-Time PagerDuty Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PagerDuty in ColdFusion.
-
Creating Sybase-Connected Applications in Unqork
You can use CData Connect AI to feed Sybase to Unqork and build custom business apps.
-
Enable the ConvertAPI JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ConvertAPI.
-
Access Samanage Data from MySQL in PHP
Connect to Samanage through the standard MySQL libraries in PHP.
-
How to Use a Microsoft Access Database to Update Box Data in Real Time
Update Box data by creating a linked table in Microsoft Access with the CData Box ODBC Driver.
-
Create Data Visualizations in Cognos BI with Jodoo Data
Access Jodoo as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Dynamics NAV Data in RapidMiner
Integrate Microsoft Dynamics NAV with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Work with Neo4J Data in ETL Validator JDBC
Connect to Neo4J from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy Desktop
Connect to Zoho Projects in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Projects.
-
Connect to QuickBooks Time Data in Ruby
Connect to QuickBooks Time in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Sage 200 Data as a MySQL Database in Node.js
Execute MySQL queries against Sage 200 from Node.js.
-
Build an OLAP Cube in SSAS from ADP Data
Establish a connection to ADP data from SQL Server Analysis Services, and use the ADP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Salesforce CRM Analytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against Salesforce CRM Analytics from Node.js.
-
How to connect PolyBase to Confluence
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Atlassian Confluence.
-
Connect Float to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Float with IBM WebSphere for seamless data integration and connectivity.
-
Using the CData Software ODBC Driver for Yelp in PyCharm
Connect to Yelp as an ODBC data source in PyCharm using the CData Software ODBC Driver for Yelp.
-
How to publish and share Salesforce Data dashboards with Tableau Server
The CData ODBC driver for Salesforce enables you integrate Salesforce & Force.com into Tableau dashboards.
-
How to Build an ETL App for Facebook Data in Python with CData
Create ETL applications and real-time data pipelines for Facebook in Python with petl.
-
Access Live Apify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apify in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Spark Data in AWS Lambda
Connect to live Apache Spark SQL in AWS Lambda using the CData JDBC Driver.
-
Import and Visualize Google Tasks Data in Power View
Create data visualizations based on Google Tasks in Excel.
-
Getting Started with the CData JDBC Driver for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CapsuleCRM.
-
Automated Continuous Access Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Access replication to Apache Kafka.
-
How to Connect to & Open Google Forms Data in Microsoft Excel
This article uses the CData ODBC driver for Google Forms to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData ODBC Driver for Facebook Ads in Microsoft Power Query
You can use the CData Facebook Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Facebook Ads into Microsoft Power Query.
-
Connecting Agentforce with Klaviyo 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 Klaviyo for you.
-
Access Live WordPress Data in Coginiti Pro
Connect to and query live WordPress from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Lakebase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Lakebase replication to Apache Cassandra.
-
Integrating LlamaIndex with Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Redis in real time.
-
Analyze Certinia Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Certinia and visualize Certinia in SAP Analytics Cloud.
-
Build AI/ML Models with Live Factorial Data using Dataiku
Connect Factorial Data with Dataiku using the CData API Driver for JDBC.
-
How to Import Data from Amazon S3 into Google Sheets
Import Amazon S3 into a Google spreadsheet that is automatically refreshed.