CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Factorial Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Factorial data.
-
Integrate with SAS Data Sets Data in JReport Designer
Create charts and reports based on SAS Data Sets data in JReport Designer.
-
Connect to Live Dynamics 365 Data in MicroStrategy through CData Connect AI
Create a live connection to Dynamics 365 Data in CData Connect AI and connect to your Dynamics 365 data from MicroStrategy.
-
Connect to SAP Netweaver Gateway Data from a Connection Pool in Jetty
The SAP Netweaver Gateway JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Netweaver Gateway data from Web apps in Jetty.
-
Automate OData Integration Tasks from PowerShell
Are you in search of a quick and easy way to access OData services from PowerShell? This article demonstrates how to utilize the OData Cmdlets for tasks like connecting to OData services, automating operations, downloading data, and more.
-
Build Data Flows from ServiceDesk Plus to SQL Server using SSIS
Easily back up ServiceDesk Plus data to SQL Server using the SSIS components for ServiceDesk Plus.
-
Integrating OpenCode with Excel 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.
-
Migrating data from FTP to Snowflake using CData SSIS Components.
Easily push FTP data to Snowflake using the CData SSIS Tasks for FTP and Snowflake.
-
Access Live Amazon S3 Data in Excel 365 Online (Excel for the web)
Connect to Amazon S3 data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Explore Geographical Relationships in ConstantContact Data with Power Map
Create data visualizations with ConstantContact data in Power Map.
-
Connect Elasticsearch to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Elasticsearch data using the CData Python MCP Server.
-
Visualize Live Google Campaign Manager 360 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Campaign Manager 360 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Okta Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Okta facts in real time.
-
Create Power BI Reports on Real-Time IBM Informix Data
Use the CData ODBC Driver for IBM Informix to visualize IBM Informix data in Power BI Desktop.
-
Integrating LangGraph with Supabase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Supabase data within automated workflows.
-
Enable the Salesforce Marketing JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce Marketing data.
-
Publish Keap-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Keap data.
-
Create Dashboards and Visualize Live PolarTeamPro Data in Geckoboard
Use CData Connect AI to connect to live PolarTeamPro data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Easily Integrate MailChimp Data in Lazarus Pascal IDE
Learn how to easily integrate live MailChimp data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to SAP Concur Data in RazorSQL
Connect to SAP Concur from wizards and query SAP Concur data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Couchbase Replication to SQLite
Use CData Sync for automated, continuous, customizable Couchbase replication to SQLite.
-
Automated Continuous Microsoft Entra ID Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to SingleStore.
-
Automate SAP Ariba Source Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Ariba Source data replication to Couchbase.
-
Integrate Live Salesforce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce data and integrate live Salesforce data into apps built in Microsoft Power Apps.
-
Automated Continuous PagerDuty Replication to Oracle
Use CData Sync for automated, continuous, customizable PagerDuty replication to Oracle.
-
Consume SharePoint Excel Services OData Feeds in PowerBuilder
This article demonstrates how to consume SharePoint Excel Services data as OData feeds from PowerBuilder using the API Server.
-
Connect to Kafka Data in NetBeans
Connect to Kafka data in NetBeans with the data source configuration wizard.
-
Stream Contentful Data into Apache Kafka Topics
Access and stream Contentful data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create a Data Access Object for Scrapfly Data using JDBI
A brief overview of creating a SQL Object API for Scrapfly data in JDBI.
-
Connect to OnePageCrm Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for OnePageCrm data in the Denodo Virtual DataPort Administrator.
-
Integrate Cline with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live PostgreSQL data from within your IDE.
-
Working with Grafana Data in LINQPad
Execute LINQ queries to Grafana data in LINQPad.
-
Using the CData Software ODBC Driver for Paylocity in PyCharm
Connect to Paylocity as an ODBC data source in PyCharm using the CData Software ODBC Driver for Paylocity.
-
Configure the CData JDBC Driver for Outreach.io in a Connection Pool in Tomcat
Connect to Outreach.io data from a connection pool in Tomcat.
-
Access Live Epicor Kinetic Data in Excel 365 Online (Excel for the web)
Connect to Epicor Kinetic data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Adobe Target Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Adobe Target data from your Google Sheets.
-
Connect to Simplesat Data in Ruby
Connect to Simplesat data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Excel Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Excel data.
-
Getting Started with the CData Tableau Connector for Azure Table
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Azure Table.
-
How to Build an ETL App for Sybase Data in Python with CData
Create ETL applications and real-time data pipelines for Sybase data in Python with petl.
-
Visualize Sybase IQ Data in TIBCO Spotfire through ADO.NET
Integrate Sybase IQ data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Connect AI Python SDK for GraphQL
Install the CData Connect AI Python SDK to read live GraphQL data with standard DB-API 2.0 Python code.
-
Connect to CloudConvert Data in Aqua Data Studio
Access CloudConvert data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
View Reports on Real-Time Moosend Data in Power BI Report Server
Use the CData ODBC Driver for Moosend to visualize Moosend data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create SAP SuccessFactors Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP SuccessFactors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Datadog Data with Squirrel SQL client
Connect to Datadog data and execute queries in the Squirrel SQL Client.
-
Build Automated ServiceDesk Plus-Connected Workflows in Zapier
Use CData Connect AI to connect to live ServiceDesk Plus data and build automated workflows in Zapier.
-
Replicate Paylocity Data from PowerShell
Write a quick PowerShell script to query Paylocity data. Use connectivity to the live data to replicate Paylocity data to SQL Server.
-
Import Real-Time Salesforce CRM Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce CRM Analytics data in ColdFusion.
-
Getting Started with the CData ODBC Driver for Timely
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Timely.
-
Replicate ZohoMarketingHub Data to Multiple Databases via the CData Sync CLI
Replicate ZohoMarketingHub data to disparate databases with a single configuration.
-
Integrating Antigravity CLI with Gong data via CData CLI
Connect Gong data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
View Reports on Real-Time Discourse Data in Power BI Report Server
Use the CData ODBC Driver for Discourse to visualize Discourse data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Samanage Data in Jaspersoft Studio
Execute SQL to remote Samanage data in Jaspersoft Studio.
-
Stream HelloSign Data into Apache Kafka Topics
Access and stream HelloSign data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Live Microsoft Entra ID Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft Entra ID from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Entra ID data.
-
Access Live Databricks Data in Coginiti Pro
Connect to and query live Databricks data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Access Live ServiceNow Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ServiceNow enables you to integrate ServiceNow data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live Customer.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Customer.io data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create MYOB AccountRight-Connected Applications in Appsmith
Connect to MYOB AccountRight Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MYOB AccountRight data.
-
Connect to Anaplan 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 Anaplan data.
-
Access Live Confluence Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Confluence data through MCP integration.
-
Integrate Live Zoho Inventory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho Inventory data and integrate live Zoho Inventory data into apps built in Microsoft Power Apps.
-
Publish Crystal Reports on CouchDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CouchDB data.
-
Connect to Jira Data in NetBeans
Connect to Jira data in NetBeans with the data source configuration wizard.
-
Build MVC Applications with Connectivity to LDAP Objects
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LDAP from an ASP.NET MVC application.
-
Operational Reporting on Grafana Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Grafana data.
-
Integrate Devin with Live Zoho CRM Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Zoho CRM data.
-
Migrating data from Amazon Athena to Databricks using CData SSIS Components.
Easily push Amazon Athena data to Databricks using the CData SSIS Tasks for Amazon Athena and Databricks.
-
Use Agno to Talk to Your Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Sybase IQ data for you.
-
How to work with Outlook Data in Apache Spark using SQL
Access and process Outlook Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Kiro with AlloyDB 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.
-
Connect to Live HDFS Data in MicroStrategy through CData Connect AI
Create a live connection to HDFS Data in CData Connect AI and connect to your HDFS data from MicroStrategy.
-
Copper Reporting in OBIEE with the Copper JDBC Driver
Deploy the Copper JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect Tavily to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Tavily with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous ZeroBounce Replication to MySQL
Use CData Sync for automated, continuous, customizable ZeroBounce replication to MySQL.
-
Visualize Office 365 Data in TIBCO Spotfire through OData
Integrate Office 365 data into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load QuickBooks Data in Informatica PowerCenter
Create a simple Workflow for QuickBooks data in Informatica PowerCenter.
-
Automated Continuous Front Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Front replication to Amazon S3.
-
How to connect to Redis Data from IntelliJ
Integrate connectivity to Redis data with wizards in IntelliJ.
-
Integrating Dataiku with Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Timely data.
-
Build Automated Workflows with Live Discord Data in Workato
Use CData Connect AI to connect to live Discord data and build automated workflows in Workato.
-
Use the CData Software ODBC Driver for MessageBird in MicroStrategy
Connect to MessageBird data in MicroStrategy Developer using the CData Software ODBC Driver for MessageBird.
-
Build an OLAP Cube in SSAS from Google Ads Data
Establish a connection to Google Ads data data from SQL Server Analysis Services, and use the Google Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Yelp Replication to Snowflake
Use CData Sync for automated, continuous, customizable Yelp replication to Snowflake.
-
Work with Miro Data in FoxPro
Load Miro data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Configure the CData JDBC Driver for Webflow in a Connection Pool in Tomcat
Connect to Webflow data from a connection pool in Tomcat.
-
Build Apps with Live Hugging Face Data Using the Low-Code Development Platform of Mendix
Connect Hugging Face data with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live Oracle Data in Coginiti Pro
Connect to and query live Oracle data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Excel Add-In for Suadeo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Suadeo.
-
Publish MarkLogic-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MarkLogic data.
-
Integrating Boomi Agentstudio with BenchmarkEmail Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to BenchmarkEmail data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Natively Connect to SAP BusinessObjects BI Data in PHP
The CData ODBC driver for SAP BusinessObjects BI enables you to create PHP applications with connectivity to SAP BusinessObjects BI data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Klaviyo Replication to SQLite
Use CData Sync for automated, continuous, customizable Klaviyo replication to SQLite.
-
Use the CData Software JDBC Driver for SendInBlue in MicroStrategy Desktop
Connect to SendInBlue data in MicroStrategy Desktop using the CData Software JDBC Driver for SendInBlue.
-
Analyze MailChimp Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MailChimp data and visualize MailChimp data in SAP Analytics Cloud.
-
Connect to Ontraport Data in RapidMiner
Integrate Ontraport data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live Guru Data in Excel 365 Online (Excel for the web)
Connect to Guru data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Bullhorn CRM Data from MySQL in Amazon QuickSight
Connect to Bullhorn CRM and build visualizations of Bullhorn CRM data using a MySQL Connection in Amazon QuickSight.
-
Easily Integrate Harvest Data in Lazarus Pascal IDE
Learn how to easily integrate live Harvest data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.