CData Software - Knowledge Base
Recent Articles
-
Connect to Confluence Data from AWS Glue
Use CData Connect AI to gain access to live Atlassian Confluence from your AWS Glue jobs.
-
Bidirectional Access to Auth0 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Auth0 in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Exact Online in MicroStrategy Desktop
Connect to Exact Online in MicroStrategy Desktop using the CData Software ODBC Driver for Exact Online.
-
How to publish and share Amplitude Data dashboards with Tableau Server
The CData ODBC driver for Amplitude enables you integrate Amplitude into Tableau dashboards.
-
Query Google Search Results in DataGrip
Create a Data Source for Google Search in DataGrip and use SQL to query live Google Search.
-
Build Data Flows from SQL Server to SharePoint through SSIS
Easily push SQL Server data to SharePoint using the CData SSIS Tasks for SharePoint.
-
Integrate with Reckon Accounts Hosted Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reckon Accounts Hosted to a JSON file on disk.
-
Integrating Invoiced Data in Talend Cloud Data Management Platform
Connect Invoiced Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Build an ETL App for Flowlu Data in Python with CData
Create ETL applications and real-time data pipelines for Flowlu in Python with petl.
-
Import PostgreSQL Data Using Azure Data Factory
Use CData Connect AI to connect to PostgreSQL Data from Azure Data Factory and import live PostgreSQL.
-
How to Access Live CouchDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CouchDB enables you to integrate Apache CouchDB into workflows built using Microsoft Power Automate Desktop.
-
Integrate Cline with Live Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Calendar from within your IDE.
-
Build Neo4J-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Neo4J.
-
Integrating Kiro CLI with Smartsheet 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 connect to IBM Cloud Object Storage Data from IntelliJ
Integrate connectivity to IBM Cloud Object Storage with wizards in IntelliJ.
-
Moving Data from PingOne to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PingOne data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData ADO.NET Provider for RSS
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for RSS.
-
Connect to Omnisend Data in CloverDX (formerly CloverETL)
Transfer Omnisend using the visual workflow in the CloverDX data integration tool.
-
Build Semantic Layer Views for Google Ad Manager Data in APOS Live Data Gateway
Use the CData Connector for Google Ad Manager in APOS Live Data Gateway to build Semantic Layer Views for Google Ad Manager.
-
Use JayDeBeApi to access Active Directory Data in Python
Use standard Python scripting and the development environment of your choice to access live Active Directory.
-
Build Data Flows from SAP BusinessObjects BI to SQL Server using SSIS
Easily back up SAP BusinessObjects BI to SQL Server using the SSIS components for SAP BusinessObjects BI.
-
Use the CData API Server to Access Gmail Data in Microsoft PowerPivot
Use the CData API Server to connect to live Gmail in the Power Pivot business intelligence tool.
-
Import Real-Time ZohoSubscriptions Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoSubscriptions in ColdFusion.
-
Replicate Bullhorn CRM Data from PowerShell
Write a quick PowerShell script to query Bullhorn CRM. Use connectivity to the live data to replicate Bullhorn CRM to SQL Server.
-
Creating Authorize.Net-Connected Applications in Unqork
You can use CData Connect AI to feed Authorize.Net to Unqork and build custom business apps.
-
Visualize Snowflake Data in TIBCO Spotfire through OData
Integrate Snowflake into dashboards in TIBCO Spotfire.
-
Connect to XML Data as an External Source in Dremio
Use the CData JDBC Driver to connect to XML as an External Source in Dremio.
-
How to work with WordPress Data in Apache Spark using SQL
Access and process WordPress Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Cloudflare from Asprova with CData Software ODBC Driver for Cloudflare
This article shows how to connect faster to Cloudflare data from Asprova.
-
Publish Reports with RSS Feeds in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date RSS Feeds.
-
Consume Amazon S3 OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon S3 as OData feeds from PowerBuilder using the API Server.
-
How to connect SharePoint with Dynamics CRM Data through external lists
Provide Microsoft Dynamics CRM to SharePoint users as an external list.
-
Rapidly Develop Nuclia-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 Nuclia.
-
Integrate Paddle Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Paddle from Informatica Cloud.
-
Connect to Okta Data in RazorSQL
Connect to Okta from wizards and query Okta from the GUI in the RazorSQL database management tool.
-
Connecting Moonlit Workflow with Microsoft Exchange Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Exchange in real time.
-
Validate Spotify Data with QuerySurge
Access and validate Spotify in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Greenplum Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Greenplum replication to AlloyDB.
-
Automate Salesloft Data Replication to Azure Data Lake
Use CData Sync to customize and automate Salesloft replication to Azure Data Lake.
-
Integrating LlamaIndex with Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Apache Impala in real time.
-
Automate Attio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Attio replication to Azure Data Lake.
-
View Reports on Real-Time Ontraport Data in Power BI Report Server
Use the CData ODBC Driver for Ontraport to visualize Ontraport in Power BI Desktop and then publish them to Power BI Report Server.
-
Edit and Search External HubSpot Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of HubSpot to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create HubSpot Data objects that you can access from apps and the dashboard.
-
Connect to Foursquare Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Foursquare in the Denodo Virtual DataPort Administrator.
-
Connect to Dynamics CRM from Asprova with CData Software ODBC Driver for Dynamics CRM
This article shows how to connect faster to Dynamics CRM data from Asprova.
-
Use JayDeBeApi to access Okta Data in Python
Use standard Python scripting and the development environment of your choice to access live Okta.
-
Build MVC Applications with Connectivity to Drift Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Drift from an ASP.NET MVC application.
-
Publish Shortcut-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Shortcut.
-
Analyze SingleStore Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SingleStore and visualize live SingleStore in Infragistics Reveal.
-
Configure the CData JDBC Driver for Harvest in a Connection Pool in Tomcat
Connect to Harvest from a connection pool in Tomcat.
-
How to Connect to Live BigCommerce Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your BigCommerce for you.
-
Prepare, Blend, and Analyze SAP Fieldglass Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Fieldglass for self-service data analytics.
-
Create Microsoft Dataverse-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Dataverse Data from Klipfolio and build custom visualizations using live Microsoft Dataverse (CDS).
-
Replicate Multiple Omnisend Accounts via the CData Sync CLI
Replicate multiple Omnisend accounts to one or many databases.
-
Connect to OneNote Data in Jaspersoft Studio
Execute SQL to remote Microsoft OneNote in Jaspersoft Studio.
-
Connect to Gmail Data in HULFT Integrate
Connect to Gmail as a JDBC data source in HULFT Integrate
-
Create Dashboards and Visualize Live Hive Data in Geckoboard
Use CData Connect AI to connect to live Apache Hive and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to connect and process Azure Cosmos DB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Cosmos DB.
-
Use the CData Software ODBC Driver for Intercom in MicroStrategy
Connect to Intercom in MicroStrategy Developer using the CData Software ODBC Driver for Intercom.
-
DataBind Controls to Salesforce Pardot Data in C++Builder
DataBind to Salesforce Pardot in C++Builder with standard components and controls.
-
Use Biml to Build SSIS Tasks to Replicate CapsuleCRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate CapsuleCRM to SQL Server.
-
Use the CData Software ODBC Driver for Reckon Accounts Hosted in MicroStrategy
Connect to Reckon Accounts Hosted in MicroStrategy Developer using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Integrating Claude Code with Google Calendar Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Calendar within assisted coding and automated development workflows.
-
How to use SQLAlchemy ORM to access Quaderno Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Quaderno.
-
Access Live Salesforce Data in AWS Lambda
Connect to live Salesforce & Force.com in AWS Lambda using the CData JDBC Driver.
-
Connect to Attio Data in RazorSQL
Connect to Attio from wizards and query Attio from the GUI in the RazorSQL database management tool.
-
Access QuickBooks from Aqua Data Studio
Connect to the CData JDBC Driver for QuickBooks through the Aqua Data Studio connection manager.
-
Query Productboard Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Productboard from Node.js.
-
Connect to Todoist Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Todoist.
-
Connect to Power BI XMLA Data from a Connection Pool in JBoss
Integrate Power BI XMLA into Java servlets: Use the Management Console in JBoss to install the Power BI XMLA JDBC Driver.
-
Build a Singer.io Tap for Paymo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Paymo data using
-
How to Seamlessly Import REST Data into IBM SPSS Modeler
Integrate REST data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to ZohoPeople Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoPeople to connect to ZohoPeople and execute queries in PowerBuilder.
-
Access Live GitLab 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 GitLab through MCP integration.
-
Visualize ADP Data in Tableau
The CData ODBC driver for ADP enables you integrate ADP into Tableau dashboards.
-
Connect to Bugsnag Data in CloverDX (formerly CloverETL)
Transfer Bugsnag using the visual workflow in the CloverDX data integration tool.
-
Build Charts with Gong Data in Clear Analytics
Create dynamic charts and perform analytics based on Gong in Clear Analytics.
-
Build Printful-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Printful.
-
Connect to Retently Data from PowerBuilder via ADO.NET
This article demonstrates how to access Retently from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Load Amazon Athena Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Athena to a database.
-
How to connect to Unbounce Data in DBVisualizer
Integrate Unbounce with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Adobe Target Data with Squirrel SQL client
Connect to Adobe Target and execute queries in the Squirrel SQL Client.
-
Visualize XML Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to XML Files.
-
How to Visualize Delighted Data in Python with pandas
Use pandas and other modules to analyze and visualize live Delighted in Python.
-
Import and Visualize Mailjet Data in Power View
Create data visualizations based on Mailjet in Excel.
-
Prepare, Blend, and Analyze Bitly Data in Alteryx Designer (ODBC)
Build workflows to access live Bitly for self-service data analytics.
-
Connect to Gong Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Gong Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Salesforce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Datasets from Brex in Domo Workbench and Build Visualizations of Brex Data in Domo
Use the CData Software ODBC Driver for Brex to create datasets from Brex in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Wistia Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Wistia as an External Source in Dremio.
-
DataBind Controls to Teamgate Data in Delphi
DataBind to Teamgate in Delphi with standard data access components and controls.
-
How to Access Live Azure Data Lake Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Data Lake Storage enables you to integrate Azure Data Lake Storage into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Parquet Replication to Snowflake
Use CData Sync for automated, continuous, customizable Parquet replication to Snowflake.
-
Use the CData Software ODBC Driver for Todoist in MicroStrategy
Connect to Todoist in MicroStrategy Developer using the CData Software ODBC Driver for Todoist.
-
Connect to and Visualize Live Email Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Email.
-
How to Connect to Google Contacts Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Contacts. Leverage the pyodbc module for ODBC in Python.
-
Create Informatica Mappings From/To a JDBC Data Source for ZarMoney
Create ZarMoney data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Aha!-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Aha!.
-
Connect to Supabase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Supabase in the Denodo Virtual DataPort Administrator.
-
Migrating data from Bannerbear to Databricks using CData SSIS Components.
Easily push Bannerbear to Databricks using the CData SSIS Tasks for Bannerbear and Databricks.