CData Software - Knowledge Base
Recent Articles
-
Automated Act CRM Data Replication to Teradata
Use CData Sync to Customize and automate Act CRM replication to Teradata.
-
Working with Foursquare Data in LINQPad
Execute LINQ queries to Foursquare in LINQPad.
-
How to Connect to & Open Snowflake Data in Microsoft Excel
This article uses the CData ODBC driver for Snowflake to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Data Flows from Onfleet to SQL Server using SSIS
Easily back up Onfleet to SQL Server using the SSIS components for Onfleet.
-
Integrate Live SAP Ariba Procurement Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Ariba Procurement and integrate live SAP Ariba Procurement into apps built in Microsoft Power Apps.
-
How to Import Data from Microsoft Ads into Google Sheets
Import Microsoft Ads into a Google spreadsheet that is automatically refreshed.
-
Model, Search, and Visualize Live SAP Fieldglass Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Fieldglass for modeling, searching, and visualizing.
-
Automated Continuous Clari Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Clari replication to Google BigQuery.
-
Connect to Instagram Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Instagram Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating OpenCode Terminal with Adobe Experience Manager 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.
-
Build AI Agents with Quickbase 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 Quickbase through CData Connect AI.
-
How to Connect to Live Redshift Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon Redshift securely in real time.
-
How to Access Live Google Spanner Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Spanner enables you to integrate Google Spanner into workflows built using Microsoft Power Automate Desktop.
-
Connecting Pipedream with Google Campaign Manager 360 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Campaign Manager 360 data in real time.
-
Use Biml to Build SSIS Tasks to Replicate SAP Business One Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Business One to SQL Server.
-
Connect to Bannerbear Data from PowerBuilder via JDBC
This article demonstrates how to access Bannerbear from PowerBuilder using the Bannerbear JDBC Driver.
-
Publish Reports with Snowflake Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Snowflake.
-
How to Query Instantly Data in MySQL Workbench
Execute MySQL queries against live Instantly from MySQL Workbench.
-
Connect to Zoho Recruit Data in Jaspersoft Studio
Execute SQL to remote Zoho Recruit in Jaspersoft Studio.
-
Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy Web
Connect to Amazon DynamoDB in MicroStrategy Web using the CData Software JDBC Driver for Amazon DynamoDB.
-
Connect to Zoom Data in DBArtisan
Use wizards in DBArtisan to configure Zoom as a data source.
-
Integrate Excel Online Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Excel Online and integrate live Microsoft Excel Online into your Power Automate tasks.
-
Excel Spreadsheet Automation on CockroachDB Data with the QUERY Formula
Pull data from CockroachDB, automate spreadsheets, and more with the QUERY formula.
-
Build Quaderno-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Quaderno.
-
Natively Connect to Unbounce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Unbounce. Leverage the native support for ODBC in PHP.
-
Use Biml to Build SSIS Tasks to Replicate Instantly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Instantly to SQL Server.
-
How to Seamlessly Import Google Ads Data into IBM SPSS Modeler
Integrate Google Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query eBay Data in DataGrip
Create a Data Source for eBay in DataGrip and use SQL to query live eBay.
-
Analyze Quickbase Data in Cognos Analytics
Use CData Connect AI to connect to Quickbase Data from Cognos Analytics and analyze live Quickbase.
-
Feed SageHR Data into FineReport
How to set SageHR as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for JotForm in SAS for Real-Time Reporting and Analytics
Connect to real-time JotForm in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for JotForm.
-
How to Connect to Live QuickBooks Time Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your QuickBooks Time for you.
-
Integrating OpenCode Terminal with Teamgate 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.
-
Automated Continuous Clio Replication to MySQL
Use CData Sync for automated, continuous, customizable Clio replication to MySQL.
-
Visualize Live Raisers Edge NXT Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Raisers Edge NXT using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Operational Reporting on ZohoExpense Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoExpense.
-
Integrate Theia IDE with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Dashboards with Pipedrive Data in DBxtra
Create dynamic dashboards and perform analytics based on Pipedrive in DBxtra.
-
Connect Telegram to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Telegram with IBM WebSphere for seamless data integration and connectivity.
-
Build Dashboards with Salesforce Marketing Data in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce Marketing Cloud in Dundas BI.
-
Working with TaxJar Data in LINQPad
Execute LINQ queries to TaxJar in LINQPad.
-
Back Up Zoho Recruit to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Zoho Recruit data.
-
Visualize Pipedrive Data in Tableau
The CData ODBC driver for Pipedrive enables you integrate Pipedrive into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Autopilot
Provide connectivity to Autopilot through an SAP BusinessObjects universe.
-
Analyze Live Google Cloud Storage Data in SAS Viya
Use CData Connect AI to connect to Google Cloud Storage from SAS Viya and deploy self-service analytics using live Google Cloud Storage.
-
How to connect and process Omnisend from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Omnisend.
-
Connect to Nethunt Data from a Connection Pool in JBoss
Integrate Nethunt into Java servlets: Use the Management Console in JBoss to install the Nethunt JDBC Driver.
-
Integrate Amazon DynamoDB Data into Power Automate Desktop using CData Connect
CData Connect for Amazon DynamoDB Data enables you to integrate Amazon DynamoDB into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous EnterpriseDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Apache Cassandra.
-
Use ChatGPT to Talk to Your Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Dropbox for you.
-
Prepare, Blend, and Analyze Zoho Projects Data in Alteryx Designer (ODBC)
Build workflows to access live Zoho Projects for self-service data analytics.
-
Build Microsoft Exchange-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Exchange.
-
Connect to Asana from a Connection Pool in WebLogic
Use the CData JDBC Driver for Asana to connect to Asana from Web applications running on WebLogic.
-
Visualize Kafka Data in Sisense
Create an ElastiCube in Sisense app with access to Apache Kafka.
-
Integrating GitHub Copilot CLI with Azure Data Catalog 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.
-
Build a Simple VCL Application for TigerGraph Data
How to build a simple VCL Application to view TigerGraph in RAD Studio using the CData ODBC Driver for TigerGraph.
-
DataBind Controls to Contentful Data in C++Builder
DataBind to Contentful in C++Builder with standard components and controls.
-
Integrating Gumloop with IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on IBM Cloud Object Storage within automated workflows.
-
How to connect PolyBase to Bitly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bitly.
-
Query Live Azure DevOps Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Azure DevOps directly from the development environment.
-
Connect to FTP Data in DBArtisan
Use wizards in DBArtisan to configure FTP Servers as a data source.
-
Getting Started with the CData Connect AI Python SDK for Facebook Ads
Install the CData Connect AI Python SDK to read and write live Facebook Ads with standard DB-API 2.0 Python code.
-
Float Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Float facts in real time.
-
Connect to Coda Data from PowerBuilder via JDBC
This article demonstrates how to access Coda from PowerBuilder using the Coda JDBC Driver.
-
Connect to LinkedIn Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LinkedIn Ads to connect to LinkedIn Ads and execute queries in PowerBuilder.
-
Connecting Pipedream with Marketo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Marketo data in real time.
-
Excel Spreadsheet Automation on IBM Informix Data with the QUERY Formula
Pull data from IBM Informix, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous API Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable API replication to Apache Cassandra.
-
Create a Data Access Object for WordPress Data using JDBI
A brief overview of creating a SQL Object API for WordPress in JDBI.
-
Use the CData Software ODBC Driver for Mixpanel in MicroStrategy Desktop
Connect to Mixpanel in MicroStrategy Desktop using the CData Software ODBC Driver for Mixpanel.
-
Analyze Google Campaign Manager 360 Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Campaign Manager 360 and visualize Google Campaign Manager 360 in SAP Analytics Cloud.
-
Connect to Basecamp Data from HeidiSQL
Use CData Connect AI to connect to and query live Basecamp from HeidiSQL.
-
Create Procore-Connected Business Apps in AppSheet
Connect to Procore Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Procore.
-
Build Microsoft Exchange-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Exchange and build Microsoft Exchange-connected web apps with Axios.
-
Integrate with ConstantContact Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ConstantContact to a JSON file on disk.
-
Publish Act CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Act CRM.
-
Query, Visualize, and Share live Certinia Data in Redash
Use CData Connect AI to connect to live Certinia in Redash for querying, visualizing, and sharing.
-
How to connect to JSON Services in DBVisualizer
Integrate JSON with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Flowlu with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Flowlu with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Flowlu.
-
Integrate with FormSite Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy FormSite to a JSON file on disk.
-
View Reports on Real-Time WordPress Data in Power BI Report Server
Use the CData ODBC Driver for WordPress to visualize WordPress in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect Zoho Books 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 Zoho Books data in real time using natural language.
-
Integrating Codex CLI with Float 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.
-
Access Live Sage Cloud Accounting Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage Business Cloud Accounting in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Live IBM Informix Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live IBM Informix directly from the development environment.
-
Create Reports with Front Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Front.
-
Bidirectional Access to Beeminder Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Beeminder in Filemaker Pro for Mac or Windows.
-
Automated Continuous OneNote Replication to Vertica
Use CData Sync for automated, continuous, customizable OneNote replication to Vertica.
-
Create Power BI Reports on Real-Time Access Data
Use the CData ODBC Driver for Access to visualize Microsoft Access in Power BI Desktop.
-
How to Visualize Google Calendar 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 Calendar in Python.
-
Connect to Sugar CRM Data from AWS Glue
Use CData Connect AI to gain access to live Sugar CRM from your AWS Glue jobs.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Elasticsearch within intelligent workflows.
-
CSV Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to CSV/TSV Files through CData Connect AI using different applications and tools.
-
Automated Continuous Mode Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mode replication to AlloyDB.
-
Work with Live ServiceNow Data in Power Query
Use CData Connect AI to connect to ServiceNow and work with live ServiceNow in Microsoft Power Query.
-
Use the CData Software ODBC Driver for Okta in SAS for Real-Time Reporting and Analytics
Connect to real-time Okta in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Okta.
-
Connect to PolarTeamPro Data from PowerBuilder via ADO.NET
This article demonstrates how to access PolarTeamPro from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Visualize Live Autopilot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Autopilot.
-
Visualize Guru Data in Tableau
The CData ODBC driver for Guru enables you integrate Guru into Tableau dashboards.
-
How to create Mailjet federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mailjet in MySQL .