CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode Terminal with SAP Concur 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.
-
Connecting GenSpark with LinkedIn Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to LinkedIn Ads without any replication or custom integration required.
-
Access Live Amazon Athena Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon Athena from your Google Sheets.
-
Create Data Visualizations Based On Lakebase Data in Mode
Use CData Connect AI to connect to Lakebase Data from Mode and build visualizations using live
-
Connect to Cohere Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Cohere using standard SQL.
-
Connect to PabblySubscriptions from a Connection Pool in WebLogic
Use the CData JDBC Driver for PabblySubscriptions to connect to PabblySubscriptions from Web applications running on WebLogic.
-
Access Todoist Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Todoist from your Oracle system.
-
How to Connect to Live Microsoft Dataverse 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 Microsoft Dataverse (CDS) through natural language.
-
Working with Google Spanner Data in LINQPad
Execute LINQ queries to Google Spanner in LINQPad.
-
Write a Simple Go Application to work with PostgreSQL Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PostgreSQL.
-
Integrate Intercom Data in the Pentaho Report Designer
Publish reports based on Intercom in the Pentaho BI tool.
-
Manage PostgreSQL Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PostgreSQL.
-
Build Semantic Layer Views for HCL Domino Data in APOS Live Data Gateway
Use the CData Connector for HCL Domino in APOS Live Data Gateway to build Semantic Layer Views for HCL Domino.
-
Integrate Live Google Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Analytics.
-
Connect to Procore Data from a Connection Pool in JBoss
Integrate Procore into Java servlets: Use the Management Console in JBoss to install the Procore JDBC Driver.
-
Use the CData ODBC Driver for Vault CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Vault CRM to connect to Veeva Vault & Vault CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Veeva Vault & Vault CRM in Excel.
-
Choosing the Best Method to Connect ConvertKit to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ConvertKit from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Avalara AvaTax-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Avalara AvaTax to explore live Avalara AvaTax Data in Cursor to assist with building Avalara AvaTax-powered applications.
-
Getting Started with the CData Tableau Connector for Outreach.io
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Outreach.io.
-
Import TaxJar Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access TaxJar. In this article, you will use the OData format to import TaxJar into Microsoft Power Query.
-
Create Data Visualizations in Cognos BI with Workday Data
Access Workday as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Microsoft Ads Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Ads from your AWS Glue jobs.
-
Getting Started with the CData Excel Add-In for Databricks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Databricks.
-
Getting Started with the CData Python Connector for FormSite
Learn to install and license the CData Python Connector
-
Automated Continuous XML Replication to AlloyDB
Use CData Sync for automated, continuous, customizable XML replication to AlloyDB.
-
Integrate Invoiced with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Invoiced with External Services.
-
Build Dashboards with BambooHR Data in DBxtra
Create dynamic dashboards and perform analytics based on BambooHR in DBxtra.
-
Viewing Asana Data in RAD Studio Data Explorer
How to view Asana in RAD Studio Data Explorer using the CData ODBC Driver for Asana.
-
How to Connect to Foursquare Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Foursquare. Leverage the pyodbc module for ODBC in Python.
-
DataBind Charts to Excel Online Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Excel Online 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.
-
Access Acumatica Data from MySQL in PHP
Connect to Acumatica through the standard MySQL libraries in PHP.
-
Automated Continuous Testmonitor Replication to MongoDB
Use CData Sync for automated, continuous, customizable Testmonitor replication to MongoDB.
-
Integrate Intercom with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Intercom with External Services.
-
Connect to Google Ads Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Ads using standard SQL.
-
Use Dash to Build Web Apps on Dynamics CRM Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Dynamics CRM using pandas and the CData Connect AI Python SDK.
-
Connect to XML Data in Jaspersoft Studio
Execute SQL to remote XML Files in Jaspersoft Studio.
-
How to create an RPA flow for Perigon Data in UiPath Studio
Use the Perigon ODBC Driver to create workflows that access real-time Perigon without any coding.
-
Natively Connect to Salesforce CRM Analytics Data in PHP
The CData ODBC driver for Salesforce CRM Analytics enables you to create PHP applications with connectivity to Salesforce CRM Analytics. Leverage the native support for ODBC in PHP.
-
How to Access Live PagerDuty Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PagerDuty enables you to integrate PagerDuty into workflows built using Microsoft Power Automate Desktop.
-
How to connect to Cassandra Data with Squirrel SQL client
Connect to Apache Cassandra and execute queries in the Squirrel SQL Client.
-
Automate Moosend Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Moosend from PowerShell? This article demonstrates how to utilize the Moosend Cmdlets for tasks like connecting to Moosend, automating operations, downloading data, and more.
-
Viewing Epicor Kinetic Data in RAD Studio Data Explorer
How to view Epicor Kinetic in RAD Studio Data Explorer using the CData ODBC Driver for Epicor Kinetic.
-
Cloudant Reporting in OBIEE with the Cloudant JDBC Driver
Deploy the Cloudant JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for AlloyDB in Microsoft Power Query
You can use the CData AlloyDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google AlloyDB into Microsoft Power Query.
-
Design BIRT Reports on Foursquare Data
Provide current Foursquare to your embedded analytics.
-
Getting Started with the CData Tableau Connector for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Oracle Sales actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect Paddle to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Paddle with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData ODBC Driver for Salesforce Pardot in Microsoft Power Query
You can use the CData Salesforce Pardot ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce Pardot into Microsoft Power Query.
-
Work with Live Snowflake Data in Power Query
Use CData Connect AI to connect to Snowflake and work with live Snowflake in Microsoft Power Query.
-
Access Live QuickBooks Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData Software ODBC Driver for Raisers Edge NXT in SAS for Real-Time Reporting and Analytics
Connect to real-time Raisers Edge NXT in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Raisers Edge NXT.
-
Integrate with Live BambooHR Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BambooHR from the MuleSoft Anypoint Platform to integrate live BambooHR into custom reports and dashboards.
-
Connect to WordPress Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for WordPress and the SQL Gateway to access WordPress from Google Apps Script.
-
Stream LeadDesk Data into Apache Kafka Topics
Access and stream LeadDesk in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Delighted Data in Coginiti Pro
Connect to and query live Delighted from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze FHIR Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of FHIR and visualize FHIR in SAP Analytics Cloud.
-
Integrating GitHub Copilot CLI with Oracle Eloqua Reporting 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 Avro Replication to MongoDB
Use CData Sync for automated, continuous, customizable Avro replication to MongoDB.
-
Choosing the Best Method to Connect Sage Intacct to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage Intacct from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Azure Synapse Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure Synapse securely in real time.
-
Connect to and Query Gorgias Data in QlikView over ODBC
Create data visualizations with Gorgias in QlikView.
-
Validate AgileCRM Data with QuerySurge
Access and validate AgileCRM in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for GitHub in Microsoft Power Query
You can use the CData GitHub ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import GitHub into Microsoft Power Query.
-
How to Query Live Azure Data Lake Storage Data in Claude Desktop
Connect to and query live Azure Data Lake Storage Data in Claude Desktop using CData MCP Server.
-
Build a PostgreSQL Interface for Figshare Data using the CData JDBC Driver
Use the Remoting features of the Figshare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Microsoft Planner in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Planner in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Planner.
-
How to Connect to Live SAP Fieldglass Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SAP Fieldglass for you.
-
Explore Geographical Relationships in Amplitude Data with Power Map
Create data visualizations with Amplitude in Power Map.
-
Visualize Live Copper Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Copper.
-
Analyze Live Freshservice Data in SAS Viya
Use CData Connect AI to connect to Freshservice from SAS Viya and deploy self-service analytics using live Freshservice.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Oracle actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect Codat Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Codat using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CloudConvert
Provide connectivity to CloudConvert through an SAP BusinessObjects universe.
-
SQL Server Reporting in OBIEE with the SQL Server JDBC Driver
Deploy the SQL Server JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Jira Assets-Connected Applications in Appsmith
Connect to Jira Assets Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Jira Assets.
-
Automated Continuous Campaigner Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Campaigner replication to Google BigQuery.
-
Strava Reporting in OBIEE with the Strava JDBC Driver
Deploy the Strava JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating GitHub Copilot CLI with Google Ads 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.
-
Rapidly Develop REST-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by REST.
-
Automated Continuous Moosend Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Moosend replication to Amazon S3.
-
Create Informatica Mappings From/To an ODBC Data Source for WordPress
Create an ODBC connection to WordPress in Informatica and browse and transfer WordPress.
-
Viewing Twitter Ads Data in RAD Studio Data Explorer
How to view Twitter Ads in RAD Studio Data Explorer using the CData ODBC Driver for Twitter Ads.
-
Use the CData ODBC Driver for SAP Concur in Microsoft Power Query
You can use the CData SAP Concur ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Concur into Microsoft Power Query.
-
Connect to Redis Data in DBArtisan
Use wizards in DBArtisan to configure Redis as a data source.
-
Access Live Pipeliner CRM Data in AWS Lambda
Connect to live Pipeliner CRM in AWS Lambda using the CData JDBC Driver.
-
Configure the CData JDBC Driver for MailChimp in a Connection Pool in Tomcat
Connect to MailChimp from a connection pool in Tomcat.
-
Build Google Contacts-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Contacts Data and create custom apps in Mendix.
-
Automated Continuous Nethunt Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Nethunt replication to Apache Kafka.
-
Connect to Mode Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mode and the SQL Gateway to access Mode from Google Apps Script.
-
Provide OData Services of NetSuite Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for NetSuite CRM & ERP by developing a WCF Service Application.
-
Build a Simple VCL Application for Sybase IQ Data
How to build a simple VCL Application to view Sybase IQ in RAD Studio using the CData ODBC Driver for Sybase IQ.
-
How to Query Zoho CRM Data in MySQL Workbench
Execute MySQL queries against live Zoho CRM from MySQL Workbench.
-
Add SAP ByDesign Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP ByDesign with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Seamlessly Import Parquet Data into IBM SPSS Modeler
Integrate Parquet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Apollo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apollo. Leverage the pyodbc module for ODBC in Python.
-
Use ChatGPT to Talk to Your Outreach.io 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 Outreach.io for you.
-
Connect to Email Data in Google Apps Script via Connect AI
Use CData Connect AI to access Email in Google Apps Script.
-
Build Semantic Layer Views for Exact Online Data in APOS Live Data Gateway
Use the CData Connector for Exact Online in APOS Live Data Gateway to build Semantic Layer Views for Exact Online.
-
Connect to Copper Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Copper as an External Source in Dremio.