CData Software - Knowledge Base
Recent Articles
-
How to connect and process ClickUp from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ClickUp.
-
Visualize Live MariaDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MariaDB into custom reports in Power BI.
-
Visualize Mode Data in TIBCO Spotfire through ADO.NET
Integrate Mode into dashboards in TIBCO Spotfire.
-
Replicate Multiple API Accounts via the CData Sync CLI
Replicate multiple API accounts to one or many databases.
-
Automated Continuous FreshBooks Replication to Oracle
Use CData Sync for automated, continuous, customizable FreshBooks replication to Oracle.
-
ETL Campaigner in Oracle Data Integrator
This article shows how to transfer Campaigner into a data warehouse using Oracle Data Integrator.
-
Analyze Databricks Data in Cognos Analytics
Use CData Connect AI to connect to Databricks Data from Cognos Analytics and analyze live Databricks.
-
Visualize Miro Data in Sisense
Create an ElastiCube in Sisense app with access to Miro.
-
Automated Continuous Mailgun Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mailgun replication to Amazon Redshift.
-
Integrate with Todoist Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Todoist to a JSON file on disk.
-
Connect to Harvest Data in HULFT Integrate
Connect to Harvest as a JDBC data source in HULFT Integrate
-
Integrate Live FHIR Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to FHIR from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live FHIR.
-
Build Microsoft Exchange-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Microsoft Exchange to explore live Microsoft Exchange Data in Gemini Code Assist to assist with building Microsoft Exchange-powered applications.
-
Integrating Kiro CLI with Google Cloud Storage 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 SSIS Components for Sage 200
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage 200.
-
Automate Act-On Data Replication to Azure Data Lake
Use CData Sync to customize and automate Act-On replication to Azure Data Lake.
-
Integrating Cursor CLI with Sugar CRM 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SendPulse
Provide connectivity to SendPulse through an SAP BusinessObjects universe.
-
Integrating Dataiku with Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle Sales.
-
Automated Continuous Humanity Replication to Databricks
Use CData Sync for automated, continuous, customizable Humanity replication to Databricks.
-
Choosing the Best Method to Connect OpenWeatherMap to SQL Server: 5 Options Explained
Discover multiple ways to connect and use OpenWeatherMap from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Salesforce CRM Analytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesforce CRM Analytics.
-
Configure the CData JDBC Driver for Excel in a Connection Pool in Tomcat
Connect to Microsoft Excel from a connection pool in Tomcat.
-
Visualize LaunchDarkly Data in TIBCO Spotfire through ADO.NET
Integrate LaunchDarkly into dashboards in TIBCO Spotfire.
-
Build Apps with Live Helpscout Data Using the Low-Code Development Platform of Mendix
Connect Helpscout with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze Excel Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Excel and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Goose with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Marketo from within the local AI agent.
-
Getting Started with the CData Power BI Connector for PingOne
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for PingOne.
-
Visualize Live TaxJar Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live TaxJar using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Manus AI to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Salesforce Marketing Cloud.
-
Automated Continuous MariaDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable MariaDB replication to Snowflake.
-
Connect and Visualize Live WooCommerce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live WooCommerce into the Databricks platform and create visualization dashboards with real-time WooCommerce.
-
Migrating data from Azure Synapse to Google BigQuery using CData SSIS Components.
Easily push Azure Synapse to Google BigQuery using the CData SSIS Tasks for Azure Synapse and Google BigQuery.
-
Bidirectional Access to Neo4J Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Neo4J in Filemaker Pro for Mac or Windows.
-
Integrate LibreChat with Live HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Apache HBase from within the chat interface.
-
Use the CData SSIS Components to Insert New or Update Existing AlloyDB Records from SQL Server
Easily push SQL Server data to AlloyDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into AlloyDB or update existing records with data from a SQL Server database.
-
Automated Continuous Adobe Commerce Replication to Vertica
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Vertica.
-
How to connect to Nethunt Data from IntelliJ
Integrate connectivity to Nethunt with wizards in IntelliJ.
-
Access Live Drift Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Drift in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for Zoho Books in MicroStrategy Desktop
Connect to Zoho Books in MicroStrategy Desktop using the CData Software ODBC Driver for Zoho Books.
-
Connect to TigerGraph Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for TigerGraph.
-
Visualize Opsgenie Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Opsgenie.
-
Explore Geographical Relationships in NetSuite Data with Power Map
Create data visualizations with NetSuite CRM & ERP in Power Map.
-
Replicate Flowlu Data from PowerShell
Write a quick PowerShell script to query Flowlu. Use connectivity to the live data to replicate Flowlu to SQL Server.
-
Connect to and Query Foursquare Data in QlikView over ODBC
Create data visualizations with Foursquare in QlikView.
-
Use CData Connect AI to Access Google Contacts Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Contacts in the Power Pivot business intelligence tool.
-
Analyze Splunk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Splunk with the CData JDBC Driver for Splunk.
-
Build Instagram-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Instagram.
-
Connect to HubSpot Data in DBeaver
Use the CData ODBC Driver to connect to HubSpot in DBeaver.
-
Build Xero-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Xero Accounting and build Xero-connected web apps with Axios.
-
Build Active Directory Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Active Directory and build visualizations in Tableau Cloud.
-
Working with Samanage Data in LINQPad
Execute LINQ queries to Samanage in LINQPad.
-
Visualize Microsoft Dataverse Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Dataverse (CDS) into dashboards in TIBCO Spotfire.
-
How to use SQLAlchemy ORM to access Asana Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Asana.
-
Connect to Stripe Data in DBArtisan
Use wizards in DBArtisan to configure Stripe as a data source.
-
Feed Azure Data Lake Storage Data into FineReport
How to set Azure Data Lake Storage as a JDBC data source in FineReport.
-
Analyze Oracle Financials Cloud Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle Financials Cloud and visualize Oracle Financials Cloud in SAP Analytics Cloud.
-
Viewing iContact Data in RAD Studio Data Explorer
How to view iContact in RAD Studio Data Explorer using the CData ODBC Driver for iContact.
-
Automated Continuous RSS Replication to Oracle
Use CData Sync for automated, continuous, customizable RSS replication to Oracle.
-
How to Access Live Google Drive Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Drive enables you to integrate Google Drive into workflows built using Microsoft Power Automate Desktop.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Zoho Projects actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Publish Strava-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Strava.
-
How to connect to eBay Data with Squirrel SQL client
Connect to eBay and execute queries in the Squirrel SQL Client.
-
Connect to JobNimbus Data in CloverDX (formerly CloverETL)
Transfer JobNimbus using the visual workflow in the CloverDX data integration tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Pinterest
Create an ODBC connection to Pinterest in Informatica and browse and transfer Pinterest.
-
DataBind Charts to OpenWeatherMap Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to OpenWeatherMap 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.
-
Query Procore Data in DataGrip
Create a Data Source for Procore in DataGrip and use SQL to query live Procore.
-
Build Raisers Edge NXT-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Raisers Edge NXT Data and create custom apps in Mendix.
-
Choosing the Best Method to Connect Google Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Ads from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to OnePageCrm Data in JRuby
Create a simple JRuby app with access to live OnePageCrm.
-
How to work with Pipedrive Data in Apache Spark using SQL
Access and process Pipedrive Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate HDFS with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HDFS with External Services.
-
Replicate Zoho CRM Data from PowerShell
Write a quick PowerShell script to query Zoho CRM. Use connectivity to the live data to replicate Zoho CRM to SQL Server.
-
Create Data Visualizations in Cognos BI with Azure Table Data
Access Azure Table Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Amplitude Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Amplitude into TIBCO Spotfire.
-
How to Build an ETL App for ZarMoney Data in Python with CData
Create ETL applications and real-time data pipelines for ZarMoney in Python with petl.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ADP using the Model Context Protocol.
-
How to Use a Microsoft Access Database to Update Salesforce Pardot Data in Real Time
Update Salesforce Pardot data by creating a linked table in Microsoft Access with the CData Salesforce Pardot ODBC Driver.
-
Stream Hacker News Data into Apache Kafka Topics
Access and stream Hacker News in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Configure the CData JDBC Driver for ServiceNow in a Connection Pool in Tomcat
Connect to ServiceNow from a connection pool in Tomcat.
-
How to Connect DBeaver to Campaigner via a JDBC Driver
Manage Campaigner with visual tools in DBeaver like the query browser.
-
Connect to Office 365 from Asprova with CData Software ODBC Driver for Office 365
This article shows how to connect faster to Office 365 data from Asprova.
-
Query Cvent Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Cvent and perform CRUD operations on Cvent from Node.js.
-
Build a Simple VCL Application for Attio Data
How to build a simple VCL Application to view Attio in RAD Studio using the CData ODBC Driver for Attio.
-
Create Gmail-Connected Dashboards in Grafana
Connect to Gmail Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Gmail.
-
Integrate Real-Time Access to Adobe Analytics in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Adobe Analytics in real time.
-
Create Informatica Mappings From/To an ODBC Data Source for Snowflake
Create an ODBC connection to Snowflake in Informatica and browse and transfer Snowflake.
-
Easily Integrate Azure Analysis Services Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure Analysis Services in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Natively Connect to HDFS Data in PHP
The CData ODBC driver for HDFS enables you to create PHP applications with connectivity to Apache HDFS. Leverage the native support for ODBC in PHP.
-
Bridge SurveyMonkey Connectivity with Apache NiFi
Access and process SurveyMonkey in Apache NiFi using the CData JDBC Driver.
-
Integrate Zoho Creator with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Creator with External Services.
-
Use the CData Software ODBC Driver for Humanity in MicroStrategy
Connect to Humanity in MicroStrategy Developer using the CData Software ODBC Driver for Humanity.
-
Build Data Flows from Avaza to SQL Server using SSIS
Easily back up Avaza to SQL Server using the SSIS components for Avaza.
-
Integrate QuickBooks Data in Pentaho Data Integration
Build ETL pipelines based on QuickBooks Desktop in the Pentaho Data Integration tool.
-
Migrating data from Missive to Databricks using CData SSIS Components.
Easily push Missive to Databricks using the CData SSIS Tasks for Missive and Databricks.
-
How to Access Live Sybase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sybase enables you to integrate Sybase into workflows built using Microsoft Power Automate Desktop.
-
Query Oracle Financials Cloud Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Oracle Financials Cloud and perform CRUD operations on Oracle Financials Cloud from Node.js.
-
Bidirectional Access to Authorize.Net Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Authorize.Net in Filemaker Pro for Mac or Windows.
-
How to import Bullhorn CRM Data into Apache Solr
Use the CData Software JDBC Driver for Bullhorn CRM in Data Import Handler and create an automated import of Bullhorn CRM to Apache Solr Enterprise Search platform.
-
Build MVC Applications with Connectivity to Campaigner Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Campaigner from an ASP.NET MVC application.