CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze Google Ad Manager Data in Alteryx Designer (ODBC)
Build workflows to access live Google Ad Manager data for self-service data analytics.
-
Integrate with live Act CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Act CRM data in Jitterbit.
-
Build AI Agents with EnterpriseDB 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 EnterpriseDB data through CData Connect AI.
-
Connect Samanage to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Samanage with IBM WebSphere for seamless data integration and connectivity.
-
Access Live OneNote Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live OneNote data from your Excel spreadsheets.
-
DataBind Charts to LaunchDarkly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LaunchDarkly data 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.
-
Connect to Dynamics CRM in SpagoBI
Create reports featuring live Dynamics CRM data in SpagoBI Studio. Host Dynamics CRM reports on SpagoBI Server.
-
Integrate Google's Vertex AI Agent with Live Microsoft Teams 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 Microsoft Teams data within intelligent workflows.
-
Use Grok to Talk to Your Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Jumpseller data for you.
-
Analyze Elasticsearch Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Elasticsearch from Power Pivot. You will use the Table Import Wizard to load Elasticsearch data. You can visually build the import query or use any SQL supported by the driver.
-
Use Grok to Talk to Your Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Greenhouse data for you.
-
How to integrate Metabase with Testmonitor Data
Use CData Connect AI to connect to live Testmonitor data and create an interactive dashboard in Metabase from Testmonitor data.
-
Use the CData ODBC Driver for PhantomBuster from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PhantomBuster to connect to PhantomBuster data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PhantomBuster data in Excel.
-
Automated Continuous CouchDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CouchDB replication to Google BigQuery.
-
Integrating Kiro with Azure Data Lake 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.
-
Integrating Cursor with Azure DevOps 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.
-
Replicate Google Campaign Manager 360 Data in Heroku for Use in Salesforce Connect
Replicate Google Campaign Manager 360 data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Bugsnag Data in DBeaver
Use the CData ODBC Driver to connect to Bugsnag data in DBeaver.
-
Integrating Kiro with Aha! 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, Search, and Visualize Live LinkedIn Ads Data in ThoughtSpot
Use CData Connect AI to connect to live LinkedIn Ads data for modeling, searching, and visualizing.
-
Automated Continuous Facebook Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Facebook Ads replication to delimited files (CSV/TSV).
-
Getting Started with the CData Connect AI Python SDK for Microsoft Exchange
Install the CData Connect AI Python SDK to read and write live Microsoft Exchange data with standard DB-API 2.0 Python code.
-
Bridge Excel Connectivity with Apache NiFi
Access and process Excel data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Oracle Financials Cloud Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to SQL Server.
-
Connect and Visualize Live Zoho Inventory Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho Inventory data into the Databricks platform and create visualization dashboards with real-time Zoho Inventory data.
-
Build Dashboards with GitLab Data in Dundas BI
Create dynamic dashboards and perform analytics based on GitLab data in Dundas BI.
-
How to Visualize DB2 Data in Python with pandas
Use pandas and other modules to analyze and visualize live DB2 data in Python.
-
How to Visualize Adobe Analytics 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 Adobe Analytics data in Python.
-
Integrating Gumloop with SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Hybris C4C data within automated workflows.
-
Connecting Moonlit Workflow with Facebook Ads 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 Facebook Ads data in real time.
-
Automated Continuous Slack Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Slack replication to Amazon Redshift.
-
Automate Dynamics CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Dynamics CRM data replication to Couchbase.
-
Consume Wave Financial OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Wave Financial feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Vertica Replication to SingleStore
Use CData Sync for automated, continuous, customizable Vertica replication to SingleStore.
-
Automated Continuous ConvertAPI Replication to MySQL
Use CData Sync for automated, continuous, customizable ConvertAPI replication to MySQL.
-
Create SSAS Tabular Models from CockroachDB Data
How to build a SQL Server Analysis Service Tabular Model from CockroachDB data using CData drivers.
-
How to Query SAP HANA XS Advanced Data in MySQL Workbench
Execute MySQL queries against live SAP HANA XS Advanced data from MySQL Workbench.
-
LINQ to Telegram 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 Telegram Data Provider.
-
Create Apps from Avro Data in Qlik Sense Cloud
Use CData Connect AI to connect to Avro Data and build apps from live Avro data in Qlik Sense Cloud.
-
How to connect to Close Data with Squirrel SQL client
Connect to Close data and execute queries in the Squirrel SQL Client.
-
Connect to Discourse Data in NetBeans
Connect to Discourse data in NetBeans with the data source configuration wizard.
-
Analyze Google Tasks Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Tasks data with the CData JDBC Driver for Google Tasks.
-
Publish XML-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live XML data.
-
Visualize PhantomBuster Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PhantomBuster data.
-
Google Directory Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Directory facts in real time.
-
Connecting GenSpark with Square Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Square data without any replication or custom integration required.
-
Import and Visualize Act CRM Data in Power View
Create data visualizations based on Act CRM data in Excel.
-
Connect to Vertica Data in ACL Analytics
Connect to Vertica data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Vertica data.
-
Access SAP Ariba Procurement 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 SAP Ariba Procurement data.
-
Connect to Strava Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Strava and work with Strava data in your FileMaker applications.
-
Build Data Flows from SQL Server to Google Contacts through SSIS
Easily push SQL Server data to Google Contacts using the CData SSIS Tasks for Google Contacts.
-
Automated Continuous Amazon Athena Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Oracle.
-
Integrate Trae with Live Oracle HCM Cloud Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Oracle HCM Cloud data from within the AI-powered IDE.
-
Visualize Live Miro Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Miro data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Pipeliner CRM Data in MySQL Workbench
Execute MySQL queries against live Pipeliner CRM data from MySQL Workbench.
-
Build a Simple VCL Application for Azure DevOps Data
How to build a simple VCL Application to view Azure DevOps data in RAD Studio using the CData ODBC Driver for Azure DevOps.
-
Create Informatica Mappings From/To an ODBC Data Source for Nuclia
Create an ODBC connection to Nuclia in Informatica and browse and transfer Nuclia data.
-
Connect to JotForm in SpagoBI
Create reports featuring live JotForm data in SpagoBI Studio. Host JotForm reports on SpagoBI Server.
-
Easily Integrate EnterpriseDB Data in Lazarus Pascal IDE
Learn how to easily integrate live EnterpriseDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
LINQ to SAP Fieldglass 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 SAP Fieldglass Data Provider.
-
Replicate Multiple IBM Informix Accounts
Replicate multiple IBM Informix accounts to one or many databases.
-
How to connect PolyBase to ElevenLabs
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ElevenLabs data.
-
Access Live Google Forms Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Forms data from your Excel spreadsheets.
-
Connecting Moonlit Workflow with Adobe Target 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 Adobe Target data in real time.
-
Automated Continuous Cloudflare Replication to SQL Server
Use CData Sync for automated, continuous, customizable Cloudflare replication to SQL Server.
-
How to work with Pushbullet Data in Apache Spark using SQL
Access and process Pushbullet Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Sage Cloud Accounting Data to Multiple Databases
Replicate Sage Cloud Accounting data to disparate databases with a point-and-click configuration.
-
Write a Simple Go Application to work with Xero Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Xero data.
-
How to import GetResponse Data into Apache Solr
Use the CData Software JDBC Driver for GetResponse in Data Import Handler and create an automated import of GetResponse data to Apache Solr Enterprise Search platform.
-
How to Visualize Copper Data in Python with pandas
Use pandas and other modules to analyze and visualize live Copper data in Python.
-
Integrating SendPulse Data in Talend Cloud Data Management Platform
Connect SendPulse Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize ZohoSubscriptions Data in TIBCO Spotfire through ADO.NET
Integrate ZohoSubscriptions data into dashboards in TIBCO Spotfire.
-
Use Dash to Build to Web Apps on OpenWeatherMap Data
Create Python applications that use pandas and Dash to build OpenWeatherMap-connected web apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Flowlu
Provide connectivity to Flowlu data through an SAP BusinessObjects universe.
-
Automated Continuous Wistia Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Wistia replication to Apache Cassandra.
-
Model, Search, and Visualize Live Phoenix Data in ThoughtSpot
Use CData Connect AI to connect to live Phoenix data for modeling, searching, and visualizing.
-
Visualize Jira Assets Data in TIBCO Spotfire through ADO.NET
Integrate Jira Assets data into dashboards in TIBCO Spotfire.
-
Connect to Outreach.io Data in DBArtisan
Use wizards in DBArtisan to configure Outreach.io data as a data source.
-
Connect to and Query Onfleet Data in QlikView over ODBC
Create data visualizations with Onfleet data in QlikView.
-
Use the CData Software ODBC Driver for MariaDB in MicroStrategy
Connect to MariaDB data in MicroStrategy Developer using the CData Software ODBC Driver for MariaDB.
-
Access Live Jumpseller Data in Coginiti Pro
Connect to and query live Jumpseller data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect Pipeline CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pipeline CRM data using the CData Python MCP Server.
-
Integrating Cursor with SendGrid 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.
-
Connect to ZohoInvoice Data in ACL Analytics
Connect to ZohoInvoice data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ZohoInvoice data.
-
How to Build an ETL App for Paylocity Data in Python with CData
Create ETL applications and real-time data pipelines for Paylocity data in Python with petl.
-
How to Connect to Live Zoho Projects Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zoho Projects data without replication.
-
Build Agents in Relevance AI with Access to Live BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on BenchmarkEmail data within intelligent agent workflows.
-
Connect to Jumpseller Data in Aqua Data Studio
Access Jumpseller data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Bullhorn CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Bullhorn CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData SSIS Components for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ServiceDesk Plus.
-
Process & Analyze RSS Feeds in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live RSS Feeds.
-
Automated Continuous Google Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Ads replication to Apache Kafka.
-
Visualize Live Gmail Data in the Power BI Service
Use CData Connect AI to connect to live Gmail data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bind Live Highrise Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Highrise data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect Flowise AI Agents to Live Jira Assets Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Jira Assets data without replication.
-
Build Visualizations of Attio Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Attio data in Birst.
-
A PostgreSQL Interface for ZarMoney Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZarMoney JDBC Driver to create a PostgreSQL entry-point for data access.
-
Load Amplitude Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amplitude data to a database.
-
How to connect to Google Ad Manager Data in DBVisualizer
Integrate Google Ad Manager data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate LinkedIn Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LinkedIn Ads data from PowerShell? This article demonstrates how to utilize the LinkedIn Ads Cmdlets for tasks like connecting to LinkedIn Ads data, automating operations, downloading data, and more.