CData Software - Knowledge Base
Recent Articles
-
Back Up CircleCI data 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 CircleCI data data.
-
Create Dashboards and Visualize Live Databricks Data in Geckoboard
Use CData Connect AI to connect to live Databricks data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous ZohoInvoice Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Google Cloud SQL.
-
Connect to Dynamics 365 Business Central Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Dynamics 365 Business Central.
-
Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy
Connect to Amazon DynamoDB data in MicroStrategy Developer using the CData Software JDBC Driver for Amazon DynamoDB.
-
Connect to SQL Analysis Services from a Connection Pool in WebLogic
Use the CData JDBC Driver for SQL Analysis Services to connect to SQL Analysis Services data from Web applications running on WebLogic.
-
Seamlessly Bring Dropbox Data into Retool Using CData Connect AI
Integrate Dropbox data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Load Productboard Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Productboard data to a database.
-
Use Microsoft Copilot Studio to talk to your Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Adobe Analytics data for you.
-
Migrating data from Yelp to Databricks using CData SSIS Components.
Easily push Yelp data to Databricks using the CData SSIS Tasks for Yelp and Databricks.
-
Connecting Agentforce with Testmonitor Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Testmonitor data for you.
-
Automated Continuous DocuSign Replication to Vertica
Use CData Sync for automated, continuous, customizable DocuSign replication to Vertica.
-
Connect to LaunchDarkly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LaunchDarkly data in the Denodo Virtual DataPort Administrator.
-
Build Automated Workflows with Live Figshare Data in Workato
Use CData Connect AI to connect to live Figshare data and build automated workflows in Workato.
-
How to Connect the Power BI Service to MailerSend: Complete Guide
Connect to the CData Software Power BI Connector for MailerSend from PowerBI.com to provide real-time MailerSend data across the organization.
-
Access Live Active Directory Data in Excel 365 Online (Excel for the web)
Connect to Active Directory data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
A PostgreSQL Interface for ClickUp Data using the CData ODBC Driver
Use the SQL Gateway and ClickUp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Live SQL Analysis Services 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 SQL Analysis Services data directly from the development environment.
-
Create Informatica Mappings From/To a JDBC Data Source for Copper
Create Copper data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Gmail Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Gmail data from your Excel spreadsheets.
-
Connect to Freshdesk Data from Crystal Reports
Use CData Connect AI to connect to and report on live Freshdesk data from Crystal Reports.
-
How to Query Templated Data in MySQL Workbench
Execute MySQL queries against live Templated data from MySQL Workbench.
-
Use Databricks Agent Bricks to Talk to Your Timely Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Timely data for you.
-
Create Data Visualizations Based On Redis Data in Mode
Use CData Connect AI to connect to Redis Data from Mode and build visualizations using live Redis data.
-
Build Pipelines with Live LDAP Objects in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to LDAP from Google Cloud Data Fusion, enabling the integration of live LDAP objects into the building and management of effective data pipelines.
-
How to Connect the Power BI Service to CircleCI: Complete Guide
Connect to the CData Software Power BI Connector for CircleCI from PowerBI.com to provide real-time CircleCI data across the organization.
-
Connect to Reply.io Data in HULFT Integrate
Connect to Reply.io as a JDBC data source in HULFT Integrate
-
Automated Continuous CockroachDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CockroachDB replication to Apache Cassandra.
-
Connect to Mistral AI Data in HULFT Integrate
Connect to Mistral AI as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for Intercom in MicroStrategy
Connect to Intercom data in MicroStrategy Developer using the CData Software JDBC Driver for Intercom.
-
Trigger Amazon DynamoDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Amazon DynamoDB with standard wizards in Logic Apps.
-
Getting Started with the CData Power BI Connector for QuickBooks
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for QuickBooks.
-
Build Automated Avalara AvaTax-Connected Workflows in Zapier
Use CData Connect AI to connect to live Avalara AvaTax data and build automated workflows in Zapier.
-
Visualize Live Pushbullet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pushbullet data.
-
Query, Visualize, and Share live Couchbase Data in Redash
Use CData Connect AI to connect to live Couchbase data in Redash for querying, visualizing, and sharing.
-
Build Stripe Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Stripe data and build visualizations in Tableau Cloud.
-
Query Impala Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Impala entities in PHP by modeling them as objects.
-
Use Azure AI Foundry to Talk to Your ClickUp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ClickUp data for you.
-
Integrate with Live MYOB AccountRight Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MYOB AccountRight from the MuleSoft Anypoint Platform to integrate live MYOB AccountRight data into custom reports and dashboards.
-
Migrating data from SAP HANA to Databricks using CData SSIS Components.
Easily push SAP HANA data to Databricks using the CData SSIS Tasks for SAP HANA and Databricks.
-
Automated Continuous VWO Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable VWO replication to Amazon Redshift.
-
Query Jira Assets Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Jira Assets data from Node.js.
-
A PostgreSQL Interface for Elorus Data (MySQL Remoting via JDBC)
Use the Remoting features of the Elorus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Instantly in SAS for Real-Time Reporting and Analytics
Connect to real-time Instantly data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Instantly.
-
Connect to Rootly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Rootly as an External Source in Dremio.
-
Integrate Cursor with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live QuickBooks Time data from within the editor.
-
Connect to Email Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Email Data and connect to Email data in Akorbi Digital RunMyProcess.
-
Automated Continuous HubDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HubDB replication to IBM DB2.
-
How to Connect the Power BI Service to ConvertAPI: Complete Guide
Connect to the CData Software Power BI Connector for ConvertAPI from PowerBI.com to provide real-time ConvertAPI data across the organization.
-
Configure the CData JDBC Driver for OneNote in a Connection Pool in Tomcat
Connect to OneNote data from a connection pool in Tomcat.
-
Natively Connect to Mixpanel Data in PHP
The CData ODBC driver for Mixpanel enables you to create PHP applications with connectivity to Mixpanel data. Leverage the native support for ODBC in PHP.
-
Integrating LangGraph with BigQuery Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on BigQuery data within automated workflows.
-
Query Live Figshare 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 Figshare data directly from the development environment.
-
Migrating data from Asana to Databricks using CData SSIS Components.
Easily push Asana data to Databricks using the CData SSIS Tasks for Asana and Databricks.
-
Query Vault CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Vault CRM data from Node.js.
-
Bridge MYOB AccountRight Connectivity with Apache NiFi
Access and process MYOB AccountRight data in Apache NiFi using the CData JDBC Driver.
-
Integrating Claude Code with Tally Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Tally data within assisted coding and automated development workflows.
-
Automated Continuous Printify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Printify replication to Snowflake.
-
Deploy the ADO.NET Provider for Excel on an SSRS Report Server
Connect to Excel data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Automated Workflows with Live Jira Assets Data in Workato
Use CData Connect AI to connect to live Jira Assets data and build automated workflows in Workato.
-
How to Work with Google Search Results in ETL Validator JDBC
Connect to Google Search from ETL Validator jobs using the CData Software JDBC Driver.
-
Connecting Agentforce with Raisers Edge NXT Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Raisers Edge NXT data for you.
-
Connect to Unbounce Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Unbounce and work with Unbounce data in your FileMaker applications.
-
How to Connect to Live SageHR Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SageHR data securely in real time.
-
MarkLogic: SQL-NOCOLUMN: Column Not Found Error
In this entry you will find information relating to MarkLogic's "SQL-NOCOLUMN" error.
-
Validate HubSpot Data with QuerySurge
Access and validate HubSpot data in QuerySurge using the CData JDBC Driver.
-
Integrating GitHub Copilot with GraphQL 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.
-
Integrate Theia IDE with Live Microsoft Entra ID 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 Microsoft Entra ID data from within the development environment.
-
Publish Suadeo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Suadeo data.
-
Analyze Webex Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Webex data with the CData JDBC Driver for Webex.
-
A PostgreSQL Interface for Cloudant Data using the CData ODBC Driver
Use the SQL Gateway and Cloudant ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for Jira Data in APOS Live Data Gateway
Use the CData Connector for Jira in APOS Live Data Gateway to build Semantic Layer Views for Jira data.
-
Integrating Claude Code with Presto Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Presto data within assisted coding and automated development workflows.
-
Natively Connect to Rootly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Rootly data. Leverage the native support for ODBC in PHP.
-
Integrate with Amazon DynamoDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon DynamoDB data in SnapLogic.
-
Getting Started with the CData ODBC Driver for Notion
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Notion.
-
Import and Visualize Unbounce Data in Power View
Create data visualizations based on Unbounce data in Excel.
-
Analyze Raisers Edge NXT Data in Cognos Analytics
Use CData Connect AI to connect to Raisers Edge NXT Data from Cognos Analytics and analyze live Raisers Edge NXT data.
-
Getting Started with the CData Tableau Connector for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft Ads.
-
Replicate Salesforce Pardot Data in Heroku for Use in Salesforce Connect
Replicate Salesforce Pardot data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData SSIS Components for Google Sheets
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Sheets.
-
Connect to Paymo Data in NetBeans
Connect to Paymo data in NetBeans with the data source configuration wizard.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for FTP
Provide connectivity to FTP data through an SAP BusinessObjects universe.
-
Create a Data Access Object for Excel Online Data using JDBI
A brief overview of creating a SQL Object API for Excel Online data in JDBI.
-
Create Dashboards and Visualize Live Neo4J Data in Geckoboard
Use CData Connect AI to connect to live Neo4J data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Unbounce Data from PowerShell
Write a quick PowerShell script to query Unbounce data. Use connectivity to the live data to replicate Unbounce data to SQL Server.
-
Establish a Live Connection with ChartMogul Data using Tableau Bridge
The CData ODBC Driver for ChartMogul enables you to integrate live ChartMogul data into Tableau Cloud dashboards using the Tableau Bridge.
-
Query, Visualize, and Share live FHIR Data in Redash
Use CData Connect AI to connect to live FHIR data in Redash for querying, visualizing, and sharing.
-
How to Connect to & Open Parallel Data in Microsoft Excel
This article uses the CData ODBC driver for Parallel to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Automated Workflows with Live Grafana Data in Workato
Use CData Connect AI to connect to live Grafana data and build automated workflows in Workato.
-
Access Aweber Data from MySQL in Amazon QuickSight
Connect to Aweber and build visualizations of Aweber data using a MySQL Connection in Amazon QuickSight.
-
How to Connect to xBase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to xBase data. Leverage the pyodbc module for ODBC in Python.
-
Edit and Search External Zoho Inventory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zoho Inventory data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoho Inventory Data objects that you can access from apps and the dashboard.
-
Integrate with Dynamics 365 Business Central Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics 365 Business Central data to a JSON file on disk.
-
Automated LDAP Objects Replication to Teradata
Use CData Sync to Customize and automate LDAP objects replication to Teradata.
-
Visualize Workday 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 Workday data into TIBCO Spotfire.
-
Build Charts with Attio Data in Clear Analytics
Create dynamic charts and perform analytics based on Attio data in Clear Analytics.
-
Access Smartsheet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Smartsheet data from HeidiSQL.
-
Getting Started with the CData ODBC Driver for FreeAgent
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FreeAgent.
-
Import Real-Time SQL Analysis Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SQL Analysis Services data in ColdFusion.