CData Software - Knowledge Base
Recent Articles
-
Migrating data from SharePoint Excel Services to Databricks using CData SSIS Components.
Easily push SharePoint Excel Services data to Databricks using the CData SSIS Tasks for SharePoint Excel Services and Databricks.
-
Integrating LangGraph with Blackbaud FE NXT Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Blackbaud FE NXT data within automated workflows.
-
Visualize Tickspot 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 Tickspot data into TIBCO Spotfire.
-
Automated Continuous SAP HANA XS Advanced Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to PostgreSQL.
-
Integrate Trae with Live PolarTeamPro Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live PolarTeamPro data from within the AI-powered IDE.
-
Access Live Campaigner Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Campaigner data from your Excel spreadsheets.
-
Connecting Agentforce with Quickbase 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 Quickbase data for you.
-
How to Visualize Epicor Kinetic 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 Epicor Kinetic data in Python.
-
Build Dashboards with Excel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Excel data in Dundas BI.
-
Edit and Search External ActiveCampaign Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ActiveCampaign data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ActiveCampaign Data objects that you can access from apps and the dashboard.
-
Create Reports from Bullhorn CRM Data in Looker Studio
Use CData Connect AI to gain access to live Bullhorn CRM data and create custom reports in Looker Studio.
-
DataBind Controls to Opsgenie Data in C++Builder
DataBind to Opsgenie data in C++Builder with standard components and controls.
-
Query Ontraport Data as a MySQL Database in Node.js
Execute MySQL queries against Ontraport data from Node.js.
-
Integrate with live Authorize.Net Data in Jitterbit
Use CData Connect AI to connect to and integrate live Authorize.Net data in Jitterbit.
-
Access Live Office 365 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Office 365 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access PagerDuty 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 PagerDuty data.
-
Use the CData Software ODBC Driver for PDFMonkey in MicroStrategy Web
Connect to PDFMonkey data in MicroStrategy Web using the CData Software ODBC Driver for PDFMonkey.
-
Choosing the Best Method to Connect Oracle Service Cloud to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Service Cloud data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Crystal Reports on SAP Fieldglass Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Fieldglass data.
-
Use ChatGPT to Talk to Your Databricks 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 Databricks data for you.
-
A PostgreSQL Interface for Adobe Target Data using the CData ODBC Driver
Use the SQL Gateway and Adobe Target ODBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Active Directory Data in Power BI Report Server
Use the CData ODBC Driver for Active Directory to visualize Active Directory data in Power BI Desktop and then publish them to Power BI Report Server.
-
DataBind Cosmos DB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Cosmos DB with the DevExpress Windows Forms and Web controls to provide Cosmos DB data to a chart.
-
Visualize Live CockroachDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CockroachDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query, Visualize, and Share live Vertica Data in Redash
Use CData Connect AI to connect to live Vertica data in Redash for querying, visualizing, and sharing.
-
Integrate Google's Vertex AI Agent with Live iContact 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 iContact data within intelligent workflows.
-
Use the CData ODBC Driver for Reckon Accounts Hosted in Microsoft Power Query
You can use the CData Reckon Accounts Hosted ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Reckon Accounts Hosted data into Microsoft Power Query.
-
Query Kintone Data in ColdFusion
Write standard ColdFusion data access code to connect to Kintone data.
-
Connect to Google Translate Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Translate to connect to Google Translate data and execute queries in PowerBuilder.
-
A PostgreSQL Interface for ScrapingBee Data (MySQL Remoting via JDBC)
Use the Remoting features of the ScrapingBee JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Data Lake Storage.
-
Query, Visualize, and Share live Databricks Data in Redash
Use CData Connect AI to connect to live Databricks data in Redash for querying, visualizing, and sharing.
-
Connect to Jodoo Data in DBArtisan
Use wizards in DBArtisan to configure Jodoo data as a data source.
-
Query Freshteam Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Freshteam data from Node.js.
-
Model, Search, and Visualize Live Presto Data in ThoughtSpot
Use CData Connect AI to connect to live Presto data for modeling, searching, and visualizing.
-
Getting Started with the CData ADO.NET Provider for HBase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for HBase.
-
Automated Continuous Mouseflow Replication to Oracle
Use CData Sync for automated, continuous, customizable Mouseflow replication to Oracle.
-
Getting Started with the CData Excel Add-In for GraphQL
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GraphQL.
-
Getting Started with the CData Power BI Connector for Google Contacts
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Contacts.
-
Automated Continuous MailerSend Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MailerSend replication to Google BigQuery.
-
Query Odoo Data in DataGrip
Create a Data Source for Odoo in DataGrip and use SQL to query live Odoo data.
-
Connect to Notion Data in DBeaver
Use the CData ODBC Driver to connect to Notion data in DBeaver.
-
Replicate Vault CRM Data from PowerShell
Write a quick PowerShell script to query Vault CRM data. Use connectivity to the live data to replicate Vault CRM data to SQL Server.
-
Integrate LibreChat with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Redis data from within the chat interface.
-
Automated Continuous MailerLite Replication to MongoDB
Use CData Sync for automated, continuous, customizable MailerLite replication to MongoDB.
-
Moving Data from Datadog to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Datadog data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Oracle SCM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Google BigQuery.
-
Access Live HCL Domino Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live HCL Domino data through MCP integration.
-
Create Datasets from Raisers Edge NXT in Domo Workbench and Build Visualizations of Raisers Edge NXT Data in Domo
Use the CData Software ODBC Driver for Raisers Edge NXT to create datasets from Raisers Edge NXT data in Domo Workbench and then build visualizations in the Domo service.
-
Create Perigon Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Perigon from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze IBM Cloud Object Storage Data in Looker
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Looker and build custom apps using live IBM Cloud Object Storage data.
-
Visualize Spotify 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 Spotify data into TIBCO Spotfire.
-
Create Amazon Marketplace-Connected Business Apps in AppSheet
Connect to Amazon Marketplace Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Amazon Marketplace data.
-
Visualize Active Directory Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Active Directory data.
-
Connecting GenSpark with HDFS Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to HDFS data without any replication or custom integration required.
-
Connect to GitLab Data from PowerBuilder via ADO.NET
This article demonstrates how to access GitLab data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Attio-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Attio Data from OutSystems and build custom enterprise apps using live Attio data.
-
Replicate Adobe Experience Manager Data from PowerShell
Write a quick PowerShell script to query Adobe Experience Manager data. Use connectivity to the live data to replicate Adobe Experience Manager data to SQL Server.
-
How to Connect Grafana 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 Grafana data in real time using natural language.
-
How to Connect to Live Timely Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Timely data through natural language.
-
Import and Visualize SuiteCRM Data in Power View
Create data visualizations based on SuiteCRM data in Excel.
-
Process & Analyze Aha! Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Aha! Data.
-
Use Dash to Build Web Apps on RSS Feeds via CData Connect AI
Build interactive Dash web apps on live RSS feeds using pandas and the CData Connect AI Python SDK.
-
Replicate Box Data in Heroku for Use in Salesforce Connect
Replicate Box data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData SSIS Components to Insert New or Update Existing Amazon Athena Records from SQL Server
Easily push SQL Server data to Amazon Athena using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Amazon Athena or update existing records with data from a SQL Server database.
-
Build Visualizations of Rebilly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Rebilly data in Birst.
-
Query ConstantContact Data in DataGrip
Create a Data Source for ConstantContact in DataGrip and use SQL to query live ConstantContact data.
-
Connect to HubDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for HubDB and the Script function in FileMaker Pro to connect to HubDB and work with HubDB data in your FileMaker application.
-
Migrating data from Zuora to Snowflake using CData SSIS Components.
Easily push Zuora data to Snowflake using the CData SSIS Tasks for Zuora and Snowflake.
-
Automated Continuous Pinecone Replication to Databricks
Use CData Sync for automated, continuous, customizable Pinecone replication to Databricks.
-
How to Query Snapchat Ads Data in MySQL Workbench
Execute MySQL queries against live Snapchat Ads data from MySQL Workbench.
-
Visualize Omnisend Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Omnisend data.
-
Back Up Outlook 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 Outlook data data.
-
Consume Xero OData Feeds in PowerBuilder
This article demonstrates how to consume Xero data as OData feeds from PowerBuilder using the API Server.
-
Creating SurveyMonkey-Connected Applications in Unqork
You can use CData Connect AI to feed SurveyMonkey data to Unqork and build custom business apps.
-
How to Connect to Square Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Square data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Eventbrite Data from a Connection Pool in JBoss
Integrate Eventbrite data into Java servlets: Use the Management Console in JBoss to install the Eventbrite JDBC Driver.
-
Automated SAP SuccessFactors Data Replication to Teradata
Use CData Sync to Customize and automate SAP SuccessFactors data replication to Teradata.
-
Using the CData Software ODBC Driver for Oracle Eloqua Reporting in PyCharm
Connect to Oracle Eloqua Reporting as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Eloqua Reporting.
-
Connect to Gumroad Data in Ruby
Connect to Gumroad data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Establish a Live Connection with Excel Data using Tableau Bridge
The CData ODBC Driver for Excel enables you to integrate live Excel data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Zoho Books Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Books data from your AWS Glue jobs.
-
Integrate Teamgate Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Teamgate data from Informatica Cloud.
-
Connect to Dynamics NAV Data in DBeaver
Use the CData ODBC Driver to connect to Dynamics NAV data in DBeaver.
-
Use the CData Software ODBC Driver for ConvertAPI in SAS for Real-Time Reporting and Analytics
Connect to real-time ConvertAPI data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ConvertAPI.
-
How to connect SharePoint with SAP Ariba Procurement Data through external lists
Provide SAP Ariba Procurement data to SharePoint users as an external list.
-
DataBind Controls to FormSite Data in C++Builder
DataBind to FormSite data in C++Builder with standard components and controls.
-
Visualize Live Omnisend Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Omnisend data into custom reports in Power BI.
-
Prepare, Blend, and Analyze Todoist Data in Alteryx Designer (ODBC)
Build workflows to access live Todoist data for self-service data analytics.
-
Connect to Hubstaff from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hubstaff to connect to Hubstaff data from Web applications running on WebLogic.
-
Explore Geographical Relationships in Pinterest Data with Power Map
Create data visualizations with Pinterest data in Power Map.
-
Getting Started with the CData SSIS Components for Twilio
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Twilio.
-
Miro Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Miro facts in real time.
-
Automated Continuous Oracle Eloqua Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to SQL Server.
-
Use Claude to Talk to Your SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP Concur data for you.
-
How to connect to MariaDB Data from IntelliJ
Integrate connectivity to MariaDB data with wizards in IntelliJ.
-
How to Work with Dropbox Data in AWS Glue Jobs Using JDBC
Connect to Dropbox from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect SAP BusinessObjects BI Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP BusinessObjects BI data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to ChargeOver Data from PowerBuilder via ADO.NET
This article demonstrates how to access ChargeOver data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Add AdRoll Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AdRoll with the Informatica Enterprise Data Catalog to classify and organize data.