CData Software - Knowledge Base
Recent Articles
-
Integrate Live Google Directory Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Directory from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Directory.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amazon Athena
Provide connectivity to Amazon Athena through an SAP BusinessObjects universe.
-
Connect to Klaviyo Data in DBArtisan
Use wizards in DBArtisan to configure Klaviyo as a data source.
-
Access Live Greenhouse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Greenhouse in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Visualizations of Adobe Target Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Adobe Target in Birst.
-
Integrate with Front Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Front to a JSON file on disk.
-
Stream SuiteCRM Data into Apache Kafka Topics
Access and stream SuiteCRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
LINQ to Planio 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 Planio Data Provider.
-
Deploy the ADO.NET Provider for MailerSend on an SSRS Report Server
Connect to MailerSend 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.
-
Use the CData Software ODBC Driver for Email in MicroStrategy Desktop
Connect to Email in MicroStrategy Desktop using the CData Software ODBC Driver for Email.
-
Connect to Twilio Data in NetBeans
Connect to Twilio in NetBeans with the data source configuration wizard.
-
Automated Continuous Teamwork Replication to Vertica
Use CData Sync for automated, continuous, customizable Teamwork replication to Vertica.
-
Create a Data Access Object for Impala Data using JDBI
A brief overview of creating a SQL Object API for Apache Impala in JDBI.
-
Enable the Smartsheet JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Smartsheet.
-
Connect to and Query Azure DevOps Data in QlikView over ODBC
Create data visualizations with Azure DevOps in QlikView.
-
Query Strava Data as a MySQL Database in Node.js
Execute MySQL queries against Strava from Node.js.
-
Bidirectional Access to Perigon Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Perigon in Filemaker Pro for Mac or Windows.
-
Use JayDeBeApi to access Tavily Data in Python
Use standard Python scripting and the development environment of your choice to access live Tavily.
-
Build Semantic Layer Views for Freshteam Data in APOS Live Data Gateway
Use the CData Connector for Freshteam in APOS Live Data Gateway to build Semantic Layer Views for Freshteam.
-
How to Query Live Dynamics 365 Data in Perplexity MacOS Desktop
Connect to and query live Dynamics 365 Data in Perplexity Desktop using CData MCP Server.
-
Visualize Bullhorn CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Bullhorn CRM.
-
DataBind Discourse Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Discourse to a chart.
-
Query Jira Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Atlassian Jira from Node.js.
-
Connect to SAP Fieldglass Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Fieldglass from Crystal Reports.
-
How to Import Data from Cvent into Google Sheets
Import Cvent into a Google spreadsheet that is automatically refreshed.
-
How to Connect DBeaver to ClickUp via a JDBC Driver
Manage ClickUp with visual tools in DBeaver like the query browser.
-
Automate Keap Data Replication to Couchbase
Use CData Sync to Customize and automate Keap replication to Couchbase.
-
Integrating Codex CLI with Printify 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 Demio in SAS for Real-Time Reporting and Analytics
Connect to real-time Demio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Demio.
-
Visualize Live Gumroad Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Gumroad using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Pipelines with Live Cloudant Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Cloudant from Google Cloud Data Fusion, enabling the integration of live IBM Cloudant into the building and management of effective data pipelines.
-
Creating Google Directory-Connected Applications in Unqork
You can use CData Connect AI to feed Google Directory to Unqork and build custom business apps.
-
Automate Vertica Data Replication to Couchbase
Use CData Sync to Customize and automate Vertica replication to Couchbase.
-
Use Microsoft Copilot Studio to talk to your SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Concur for you.
-
Create Datasets from GraphQL in Domo Workbench and Build Visualizations of GraphQL Data in Domo
Use the CData Software ODBC Driver for GraphQL to create datasets from GraphQL in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software JDBC Driver for PDFMonkey in MicroStrategy
Connect to PDFMonkey in MicroStrategy Developer using the CData Software JDBC Driver for PDFMonkey.
-
Prepare, Blend, and Analyze ZohoInvoice Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoInvoice for self-service data analytics.
-
How to Build an ETL App for CouchDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live Apache CouchDB in Python with petl and the CData Connect AI Python SDK.
-
Connecting Mastra with SAP Concur 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 SAP Concur, no replication required.
-
DataBind Charts to Salesforce Marketing Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce Marketing Cloud 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.
-
DataBind Charts to CircleCI Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to CircleCI 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 Hive Data in Pentaho Data Integration
Build ETL pipelines based on Apache Hive in the Pentaho Data Integration tool.
-
Connect to Okta Data in Claris FileMaker Pro
Use the CData ODBC Driver for Okta in FileMaker Pro to connect to Okta and work with Okta in your FileMaker applications.
-
Integrate Billsby Data in Pentaho Data Integration
Build ETL pipelines based on Billsby in the Pentaho Data Integration tool.
-
Stream Freshteam Data into Apache Kafka Topics
Access and stream Freshteam in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live SingleStore Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SingleStore through MCP integration.
-
Build Apps with Live Mocean Data Using the Low-Code Development Platform of Mendix
Connect Mocean with Mendix to build apps using the CData API Driver for JDBC.
-
Bind Live Anaplan Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Anaplan data
-
Build MVC Applications with Connectivity to Microsoft Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Ads from an ASP.NET MVC application.
-
Validate XML Data with QuerySurge
Access and validate XML Files in QuerySurge using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Hubstaff in SAS for Real-Time Reporting and Analytics
Connect to real-time Hubstaff in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Hubstaff.
-
Build Gmail-Connected Apps in Choreo
Use CData Connect AI to connect to Gmail Data from Choreo and build custom apps using live Gmail.
-
ETL Google Contacts in Oracle Data Integrator
This article shows how to transfer Google Contacts into a data warehouse using Oracle Data Integrator.
-
How to integrate Facebook with Apache Airflow
Access and process Facebook in Apache Airflow using the CData JDBC Driver.
-
Access Instantly Data from MySQL in Amazon QuickSight
Connect to Instantly and build visualizations of Instantly using a MySQL Connection in Amazon QuickSight.
-
Create Data Visualizations in Cognos BI with Mocean Data
Access Mocean as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access PostgreSQL Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for PostgreSQL.
-
Automated Continuous Sage 200 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage 200 replication to Apache Cassandra.
-
How to Connect to Live Azure Analysis Services Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Azure Analysis Services for you.
-
Import and Visualize Coda Data in Power View
Create data visualizations based on Coda in Excel.
-
Automate Freshsales Data Replication to Azure Synapse
Use CData Sync to customize and automate Freshsales replication to Azure Synapse.
-
Access Live LeadDesk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live LeadDesk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Okta-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Okta Data and create custom apps in Bubble.
-
How to Create Power BI Visual Reports with Real-Time Greenplum Data
Use CData Power BI Connectors to visualize Pivotal GreenPlum in Power BI.
-
Connect to Couchbase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Couchbase to connect to Couchbase from Web applications running on WebLogic.
-
Working with Reckon Accounts Hosted Data in LINQPad
Execute LINQ queries to Reckon Accounts Hosted in LINQPad.
-
How to Query Live Google Search Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Search data in natural language using Python.
-
Build a Singer.io Tap for Google Cloud Storage With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Cloud Storage data using
-
Connect to OpenWeatherMap Data in RazorSQL
Connect to OpenWeatherMap from wizards and query OpenWeatherMap from the GUI in the RazorSQL database management tool.
-
Connecting Agentforce with eBay 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 eBay for you.
-
Connect to Shopify Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Shopify.
-
Query Epicor Kinetic Data in ColdFusion
Write standard ColdFusion data access code to connect to Epicor Kinetic.
-
How to Connect DBeaver to Scrapfly via a JDBC Driver
Manage Scrapfly with visual tools in DBeaver like the query browser.
-
How to Build an ETL App for Smartsheet Data in Python with CData Connect AI
Build ETL pipelines that read and write live Smartsheet in Python with petl and the CData Connect AI Python SDK.
-
Configure the CData JDBC Driver for Teamgate in a Connection Pool in Tomcat
Connect to Teamgate from a connection pool in Tomcat.
-
Integrating Antigravity CLI with OnePageCrm via CData CLI
Connect OnePageCrm to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use Claude to Talk to Your Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Teams for you.
-
Connect to TigerGraph Data in JRuby
Create a simple JRuby app with access to live TigerGraph.
-
Manage Neo4J Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Neo4J.
-
Use the CData ODBC Driver for Oracle Eloqua Reporting in Microsoft Power Query
You can use the CData Oracle Eloqua Reporting ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Eloqua Reporting into Microsoft Power Query.
-
Rapidly Develop ConstantContact-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 ConstantContact.
-
Moving Data from Aircall to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Aircall data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Discord Replication to Vertica
Use CData Sync for automated, continuous, customizable Discord replication to Vertica.
-
Automated Continuous SageHR Replication to Snowflake
Use CData Sync for automated, continuous, customizable SageHR replication to Snowflake.
-
Connect to Quaderno Data in Aqua Data Studio
Access Quaderno from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Quaderno Data from MySQL in PHP
Connect to Quaderno through the standard MySQL libraries in PHP.
-
Build Data Flows from Microsoft Teams to SQL Server using SSIS
Easily back up Microsoft Teams to SQL Server using the SSIS components for Microsoft Teams.
-
Analyze PayPal Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PayPal from Power Pivot. You will use the Table Import Wizard to load PayPal. You can visually build the import query or use any SQL supported by the driver.
-
DataBind Controls to Pushbullet Data in C++Builder
DataBind to Pushbullet in C++Builder with standard components and controls.
-
Create Zoho Inventory Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho Inventory from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Yelp Data in Aqua Data Studio
Access Yelp from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Access Live Billsby Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Billsby enables you to integrate Billsby into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Codat Replication to SingleStore
Use CData Sync for automated, continuous, customizable Codat replication to SingleStore.
-
Connect to Samanage Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Samanage and work with Samanage in your FileMaker application.
-
Import Real-Time MariaDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MariaDB in ColdFusion.
-
Query, Visualize, and Share live WordPress Data in Redash
Use CData Connect AI to connect to live WordPress in Redash for querying, visualizing, and sharing.
-
Automated Continuous Cassandra Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cassandra replication to SQL Server.
-
How to Visualize Google Ads 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 Google Ads in Python.
-
Use Biml to Build SSIS Tasks to Replicate Elorus Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Elorus to SQL Server.
-
How to load Paddle data into Elasticsearch via Logstash
Introducing a simple method to load Paddle data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.