CData Software - Knowledge Base
Recent Articles
-
Use Azure AI Foundry to Talk to Your Freshservice 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 Freshservice for you.
-
Model Basecamp Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Basecamp, enabling the direct import of real-time Basecamp.
-
Connect to LionDesk from Asprova with CData Software ODBC Driver for LionDesk
This article shows how to connect faster to LionDesk data from Asprova.
-
Connect to Amazon DynamoDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon DynamoDB in FileMaker Pro to connect to Amazon DynamoDB and work with Amazon DynamoDB in your FileMaker applications.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Dynamics 365 Business Central actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Live Google Spanner Data in MicroStrategy through CData Connect AI
Create a live connection to Google Spanner Data in CData Connect AI and connect to your Google Spanner from MicroStrategy.
-
Integrating LangGraph with Vault CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Veeva Vault & Vault CRM within automated workflows.
-
Create Reports from Salesforce Marketing Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce Marketing Cloud and create custom reports in Looker Studio.
-
Query CircleCI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CircleCI from Node.js.
-
Automated Continuous Phoenix Replication to SingleStore
Use CData Sync for automated, continuous, customizable Phoenix replication to SingleStore.
-
Automated Continuous Asana Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Asana replication to Google Cloud SQL.
-
View Reports on Real-Time MySQL Data in Power BI Report Server
Use the CData ODBC Driver for MySQL to visualize MySQL in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to HCL Domino in SpagoBI
Create reports featuring live HCL Domino in SpagoBI Studio. Host HCL Domino reports on SpagoBI Server.
-
FTP Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to FTP Servers through CData Connect AI using different applications and tools.
-
Use ChatGPT to Talk to Your GitHub 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 GitHub for you.
-
Connect to Act-On Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Act-On from Filemaker Pro on Mac.
-
Create Reports with Tickspot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tickspot.
-
Connect to LeadDesk from Asprova with CData Software ODBC Driver for LeadDesk
This article shows how to connect faster to LeadDesk data from Asprova.
-
Create a Data Access Object for Cloudflare Data using JDBI
A brief overview of creating a SQL Object API for Cloudflare in JDBI.
-
How to Design Salesforce Pardot Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Salesforce Pardot from mobile and tablet Power Apps.
-
Import Facebook Ads Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Facebook Ads. In this article, you will use the OData format to import Facebook Ads into Microsoft Power Query.
-
Model, Search, and Visualize Live Splunk Data in ThoughtSpot
Use CData Connect AI to connect to live Splunk for modeling, searching, and visualizing.
-
Connect to Salesloft in SpagoBI
Create reports featuring live Salesloft in SpagoBI Studio. Host Salesloft reports on SpagoBI Server.
-
Provide OData Services of MailerLite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MailerLite by developing a WCF Service Application.
-
Integrating Bright Data Data in Talend Cloud Data Management Platform
Connect Bright Data Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Connect the Power BI Service to Act-On: Complete Guide
Connect to the CData Software Power BI Connector for Act-On from PowerBI.com to provide real-time Act-On across the organization.
-
Use Biml to Build SSIS Tasks to Replicate Airtable Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Airtable to SQL Server.
-
Choosing the Best Method to Connect Oracle to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Database from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous PivotalTracker Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PivotalTracker replication to OneLake in Microsoft Fabric.
-
Integrating Boomi Agentstudio with MailChimp Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MailChimp, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to and Query Placid Data in QlikView over ODBC
Create data visualizations with Placid in QlikView.
-
Access Live Pinecone Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pinecone in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Pipelines with Live Impala Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Impala from Google Cloud Data Fusion, enabling the integration of live Apache Impala into the building and management of effective data pipelines.
-
Connect to Act CRM Data in ACL Analytics
Connect to Act CRM via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Act CRM.
-
Integrating Claude Code with Zoho Creator Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zoho Creator within assisted coding and automated development workflows.
-
Getting Started with the CData Connect AI Python SDK for BambooHR
Install the CData Connect AI Python SDK to read and write live BambooHR with standard DB-API 2.0 Python code.
-
Object-Relational Mapping (ORM) with MongoDB 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 MongoDB into a Java-based ORM framework, Hibernate.
-
Replicate ZendeskSell Data to Multiple Databases
Replicate ZendeskSell to disparate databases with a point-and-click configuration.
-
How to Connect to Live Elasticsearch 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 Elasticsearch through natural language.
-
Choosing the Best Method to Connect Google Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Analytics from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build a PostgreSQL Interface for Kafka Data using the CData JDBC Driver
Use the Remoting features of the Kafka JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Oracle Sales Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle Sales and integrate live Oracle Sales into apps built in Microsoft Power Apps.
-
Replicate Authorize.Net Data in Heroku for Use in Salesforce Connect
Replicate Authorize.Net to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Real-Time Pinecone Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pinecone in Power Apps.
-
Connect to ElevenLabs Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ElevenLabs as an External Source in Dremio.
-
Connect to ShipStation Data from a Connection Pool in JBoss
Integrate ShipStation into Java servlets: Use the Management Console in JBoss to install the ShipStation JDBC Driver.
-
Automated Continuous Dynamics 365 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to AlloyDB.
-
Design BIRT Reports on Snowflake Data
Provide current Snowflake to your embedded analytics.
-
Enable the Zoho CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho CRM.
-
Integrating Cursor CLI with Superchat 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.
-
Getting Started with the CData ADO.NET Provider for Office 365
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Office 365.
-
Manage Microsoft Planner Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Planner.
-
Connect to Oracle Sales Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Sales from Crystal Reports.
-
Back Up Billsby 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 Billsby data.
-
How to Access Live Bannerbear Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bannerbear enables you to integrate Bannerbear into workflows built using Microsoft Power Automate Desktop.
-
Extend Google Sheets with Google Cloud Storage Data
Make calls to Google Cloud Storage from Google Apps Script via the API Server.
-
Create Power BI Reports on Real-Time Kintone Data
Use the CData ODBC Driver for Kintone to visualize Kintone in Power BI Desktop.
-
Replicate Multiple Clari Accounts via the CData Sync CLI
Replicate multiple Clari accounts to one or many databases.
-
Connect to SAP Fieldglass in SpagoBI
Create reports featuring live SAP Fieldglass in SpagoBI Studio. Host SAP Fieldglass reports on SpagoBI Server.
-
How to Query Live DocuSign Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live DocuSign data in natural language using Python.
-
Visualize Tanda 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 Tanda into TIBCO Spotfire.
-
Connect to and Visualize Live Retently Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Retently.
-
Automated Continuous VWO Replication to Amazon S3
Use CData Sync for automated, continuous, customizable VWO replication to Amazon S3.
-
Access Live Square Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Square data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Visualize Google Campaign Manager 360 Data in Tableau
The CData ODBC driver for Google Campaign Manager 360 enables you integrate Google Campaign Manager 360 into Tableau dashboards.
-
Connect to and Visualize Live Drip Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Drip.
-
Integrate Kintone Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Kintone and integrate live Kintone into your Power Automate tasks.
-
Work with WordPress Data in FoxPro
Load WordPress into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData ODBC Driver for Nethunt
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Nethunt.
-
Automated Continuous Coinbase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Coinbase replication to OneLake in Microsoft Fabric.
-
How to Connect to & Open LightSpeedRetail Data in Microsoft Excel
This article uses the CData ODBC driver for LightSpeedRetail to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind Controls to Jumpseller Data in C++Builder
DataBind to Jumpseller in C++Builder with standard components and controls.
-
Create Informatica Mappings From/To an ODBC Data Source for Close
Create an ODBC connection to Close in Informatica and browse and transfer Close.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live PostgreSQL within intelligent workflows.
-
Visualize Live ConvertKit Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ConvertKit using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Outreach.io Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Outreach.io. Leverage the native support for ODBC in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Ads Records from SQL Server
Easily push SQL Server data to Microsoft Ads using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Ads or update existing records with data from a SQL Server database.
-
Integrating GitHub Copilot CLI with Slack 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 SAP Ariba Procurement-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Ariba Procurement and build SAP Ariba Procurement-connected web apps with Axios.
-
Automate PivotalTracker Data Replication to SAP HANA
Use CData Sync to customize and automate PivotalTracker replication to SAP HANA.
-
Connect to Monday.com Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Monday.com.
-
Access Active Directory Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Active Directory from your Oracle system.
-
Process & Analyze SingleStore Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SingleStore Data.
-
Getting Started with the CData Tableau Connector for SharePoint
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SharePoint.
-
Automated xBase Data Replication to Teradata
Use CData Sync to Customize and automate xBase replication to Teradata.
-
How to connect to CampaignMonitor Data in DBVisualizer
Integrate CampaignMonitor with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData ODBC Driver for Excel Online
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Excel Online.
-
How to create an RPA flow for PivotalTracker Data in UiPath Studio
Use the PivotalTracker ODBC Driver to create workflows that access real-time PivotalTracker without any coding.
-
Getting Started with the CData Excel Add-In for Mixpanel
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mixpanel.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LDAP
Provide connectivity to LDAP through an SAP BusinessObjects universe.
-
Import Real-Time BambooHR Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use BambooHR in ColdFusion.
-
Create Informatica Mappings From/To an ODBC Data Source for Opsgenie
Create an ODBC connection to Opsgenie in Informatica and browse and transfer Opsgenie.
-
Connect to Zoho Creator Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Validate Jumpseller Data with QuerySurge
Access and validate Jumpseller in QuerySurge using the CData JDBC Driver.
-
Build Dashboards with LionDesk Data in Dundas BI
Create dynamic dashboards and perform analytics based on LionDesk in Dundas BI.
-
How to Connect DBeaver to Zuora via a JDBC Driver
Manage Zuora with visual tools in DBeaver like the query browser.
-
Integrate Google Ad Manager Data into Power Automate Desktop using CData Connect
CData Connect for Google Ad Manager Data enables you to integrate Google Ad Manager into workflows built using Microsoft Power Automate Desktop.
-
Choosing the Best Method to Connect Jodoo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Jodoo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Crystal Reports on GraphQL Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date GraphQL.
-
Getting Started with the CData Excel Add-In for Paddle
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Paddle.