CData Software - Knowledge Base
Recent Articles
-
Create Vertica-Connected Applications in Appsmith
Connect to Vertica Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Vertica data.
-
Connect to and Query Notion Data in QlikView over ODBC
Create data visualizations with Notion data in QlikView.
-
Use the CData Software JDBC Driver for Presto in MicroStrategy Web
Connect to Presto data in MicroStrategy Web using the CData Software JDBC Driver for Presto.
-
Build Couchbase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Couchbase data and build visualizations in Tableau Cloud.
-
Publish iContact-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live iContact data.
-
Use the CData Software ODBC Driver for Helpscout in MicroStrategy Desktop
Connect to Helpscout data in MicroStrategy Desktop using the CData Software ODBC Driver for Helpscout.
-
Connect to ConvertAPI Data in Aqua Data Studio
Access ConvertAPI data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect the Power BI Service to Facebook Ads: Complete Guide
Connect to the CData Software Power BI Connector for Facebook Ads from PowerBI.com to provide real-time Facebook Ads data across the organization.
-
Getting Started with the CData Power BI Connector for Google Translate
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Databricks-Connected Nintex Workflows
Use CData Connect AI to connect to Databricks Data from Nintex Workflow Cloud and build custom workflows using live Databricks data.
-
Getting Started with the CData Excel Add-In for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Experience Manager.
-
Write a Simple Go Application to work with Vimeo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Vimeo data.
-
View Reports on Real-Time Google Cloud Storage Data in Power BI Report Server
Use the CData ODBC Driver for Google Cloud Storage to visualize Google Cloud Storage data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Agno to Talk to Your Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Pinterest data for you.
-
Viewing Azure Table Data in RAD Studio Data Explorer
How to view Azure Table data in RAD Studio Data Explorer using the CData ODBC Driver for Azure Table.
-
Automated Continuous SAP SuccessFactors Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Vertica.
-
Connect to Live Splunk Data in MicroStrategy through CData Connect AI
Create a live connection to Splunk Data in CData Connect AI and connect to your Splunk data from MicroStrategy.
-
Stream CampaignMonitor Data into Apache Kafka Topics
Access and stream CampaignMonitor data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Power BI Connector for Reckon
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Reckon.
-
Access Live Mistral AI Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mistral AI data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Postmark Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Postmark replication to Apache Cassandra.
-
Automated Continuous Box Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Box replication to Apache Cassandra.
-
Connect Clio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Clio with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Pushbullet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pushbullet data into the statistical analysis tools available in SAS JMP. This article shows how to use Pushbullet data in the Graph Builder and Query Builder.
-
Getting Started with the CData SSIS Components for MongoDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MongoDB.
-
Use Manus AI to Talk to Your ZohoPeople 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 ZohoPeople data.
-
Import Real-Time SharePoint Excel Services Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SharePoint Excel Services data in ColdFusion.
-
Query Zoho Recruit Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Recruit data.
-
Seamlessly Bring Optimizely Data into Retool Using CData Connect AI
Integrate Optimizely data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Google's Vertex AI Agent with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Campaign Manager 360 data within intelligent workflows.
-
Connect and Visualize Live Azure Synapse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse data into the Databricks platform and create visualization dashboards with real-time Azure Synapse data.
-
Connect to Bannerbear Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Bannerbear Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating OpenCode with LinkedIn Ads 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.
-
Import CockroachDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to CockroachDB Data and provide access to live CockroachDB data for custom reports in the Power BI Service.
-
Integrating LangGraph with Pinterest Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Pinterest data within automated workflows.
-
Build AI Agents with Confluence 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 Confluence data through CData Connect AI.
-
Integrate Theia IDE with Live xBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live xBase data from within the development environment.
-
Choosing the Best Method to Connect SingleStore to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SingleStore data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Epicor Kinetic
Provide connectivity to Epicor Kinetic data through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for HelloSign in SAS for Real-Time Reporting and Analytics
Connect to real-time HelloSign data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HelloSign.
-
Integrate with Live CSV Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to CSV from the MuleSoft Anypoint Platform to integrate live CSV data into custom reports and dashboards.
-
Connect to Apify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Apify to connect to Apify data from Web applications running on WebLogic.
-
Build Discourse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Discourse data.
-
Connect to ServiceDesk Plus Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ServiceDesk Plus as an External Source in Dremio.
-
Automated Continuous Eventbrite Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Eventbrite replication to PostgreSQL.
-
Build Data Flows from Slack to SQL Server using SSIS
Easily back up Slack data to SQL Server using the SSIS components for Slack.
-
Connect to Attio Data in Jaspersoft Studio
Execute SQL to remote Attio data in Jaspersoft Studio.
-
Integrating Antigravity CLI with LinkedIn Ads data via CData CLI
Connect LinkedIn Ads data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connecting Moonlit Workflow with Cvent 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 Cvent data in real time.
-
Visualize Rootly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Rootly data.
-
Natively Connect to Oracle HCM Cloud Data in PHP
The CData ODBC driver for Oracle HCM Cloud enables you to create PHP applications with connectivity to Oracle HCM Cloud data. Leverage the native support for ODBC in PHP.
-
Automated Autopilot Data Replication to Teradata
Use CData Sync to Customize and automate Autopilot data replication to Teradata.
-
Create Informatica Mappings From/To an ODBC Data Source for FHIR
Create an ODBC connection to FHIR in Informatica and browse and transfer FHIR data.
-
Create Reports with Databricks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Databricks data.
-
Build Agents in Relevance AI with Access to Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Analytics data within intelligent agent workflows.
-
Connect to Stripe Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Stripe data in the Denodo Virtual DataPort Administrator.
-
Access Live Airtable Data in Excel 365 Online (Excel for the web)
Connect to Airtable data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Recurly Data in Aqua Data Studio
Access Recurly data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Design BIRT Reports on Spark Data
Provide current Spark data to your embedded analytics.
-
Configure the CData JDBC Driver for Amazon Athena in a Connection Pool in Tomcat
Connect to Amazon Athena data from a connection pool in Tomcat.
-
Explore Geographical Relationships in SAP Netweaver Gateway Data with Power Map
Create data visualizations with SAP Netweaver Gateway data in Power Map.
-
Import Google Spanner Data Using Azure Data Factory
Use CData Connect AI to connect to Google Spanner Data from Azure Data Factory and import live Google Spanner data.
-
Rapidly Develop Paddle-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 Paddle.
-
Integrating Boomi Agentstudio with GitHub Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to GitHub data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to FHIR Data in RapidMiner
Integrate FHIR data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Authorize.Net Replication to Oracle
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Oracle.
-
Integrate Oracle Financials Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Financials Cloud with External Services.
-
Connect to AfterShip from a Connection Pool in WebLogic
Use the CData JDBC Driver for AfterShip to connect to AfterShip data from Web applications running on WebLogic.
-
Connect and Visualize Live Google Cloud Storage Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Cloud Storage data into the Databricks platform and create visualization dashboards with real-time Google Cloud Storage data.
-
Integrate Power BI XMLA Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Power BI XMLA data and integrate live Power BI XMLA data into your Power Automate tasks.
-
Create YouTube Analytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to YouTube Analytics Data from Klipfolio and build custom visualizations using live YouTube Analytics data.
-
Operational Reporting on Opsgenie Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Opsgenie data.
-
Build a Simple VCL Application for Invoiced Data
How to build a simple VCL Application to view Invoiced data in RAD Studio using the CData ODBC Driver for Invoiced.
-
Migrating data from Float to Snowflake using CData SSIS Components.
Easily push Float data to Snowflake using the CData SSIS Tasks for Float and Snowflake.
-
How to Connect to & Open JobNimbus Data in Microsoft Excel
This article uses the CData ODBC driver for JobNimbus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software ODBC Driver for Supabase in MicroStrategy Web
Connect to Supabase data in MicroStrategy Web using the CData Software ODBC Driver for Supabase.
-
Getting Started with the CData Connect AI Python SDK for Zoho Projects
Install the CData Connect AI Python SDK to read and write live Zoho Projects data with standard DB-API 2.0 Python code.
-
Design BIRT Reports on JotForm Data
Provide current JotForm data to your embedded analytics.
-
How to use SQLAlchemy ORM to access Printify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Printify data.
-
Build Data Flows from Foursquare to SQL Server using SSIS
Easily back up Foursquare data to SQL Server using the SSIS components for Foursquare.
-
Connect Marketo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Marketo with IBM WebSphere for seamless data integration and connectivity.
-
Create a Data Access Object for Google Spanner Data using JDBI
A brief overview of creating a SQL Object API for Google Spanner data in JDBI.
-
Automated Continuous Basecamp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Basecamp replication to AlloyDB.
-
Connect to Bright Data 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 Bright Data and work with Bright Data data in your FileMaker application.
-
Connect to Oracle Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle data.
-
Automated Continuous iContact Replication to Amazon S3
Use CData Sync for automated, continuous, customizable iContact replication to Amazon S3.
-
Stream SAP Netweaver Gateway Data into Apache Kafka Topics
Access and stream SAP Netweaver Gateway data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access WordPress Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live WordPress data from HeidiSQL.
-
How to Build an ETL App for Freshservice Data in Python with CData
Create ETL applications and real-time data pipelines for Freshservice data in Python with petl.
-
Analyze Twilio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Twilio data with the CData JDBC Driver for Twilio.
-
Access Live Apollo Data in Excel 365 Online (Excel for the web)
Connect to Apollo data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build an OLAP Cube in SSAS from Pipedrive Data
Establish a connection to Pipedrive data data from SQL Server Analysis Services, and use the Pipedrive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Reports with Cohere Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cohere data.
-
How to Connect SAP ByDesign Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP ByDesign data in real time using natural language.
-
How to update Redshift from Excel
This article explains how to transfer data from Excel to Redshift using the Excel Add-In for Redshift.
-
Extract, Transform, and Load Clari Data in Informatica PowerCenter
Create a simple Workflow for Clari data in Informatica PowerCenter.
-
Replicate Multiple Freshsales Accounts via the CData Sync CLI
Replicate multiple Freshsales accounts to one or many databases.
-
Object-Relational Mapping (ORM) with Outlook Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Outlook data into a Java-based ORM framework, Hibernate.
-
Elorus Reporting in OBIEE with the Elorus JDBC Driver
Deploy the Elorus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create a Data Access Object for MarkLogic Data using JDBI
A brief overview of creating a SQL Object API for MarkLogic data in JDBI.