CData Software - Knowledge Base
Recent Articles
-
Analyze Live SAP BusinessObjects BI Data in SAS Viya
Use CData Connect AI to connect to SAP BusinessObjects BI from SAS Viya and deploy self-service analytics using live SAP BusinessObjects BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sybase
Provide connectivity to Sybase through an SAP BusinessObjects universe.
-
Establish a Live Connection with Amazon DynamoDB Data using Tableau Bridge
The CData ODBC Driver for Amazon DynamoDB enables you to integrate live Amazon DynamoDB into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Semantic Layer Views for Instagram Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Instagram.
-
Use the CData Software ODBC Driver for GetResponse in MicroStrategy
Connect to GetResponse in MicroStrategy Developer using the CData Software ODBC Driver for GetResponse.
-
Publish Microsoft Teams-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Teams.
-
Build Visualizations of Freshsales Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Freshsales in Birst.
-
Connect to Google Campaign Manager 360 in SpagoBI
Create reports featuring live Google Campaign Manager 360 in SpagoBI Studio. Host Google Campaign Manager 360 reports on SpagoBI Server.
-
Connect to Real-Time Instantly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Instantly in Power Apps.
-
Visualize Live Email Data in the Power BI Service
Use CData Connect AI to connect to live Email and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Spotify Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Spotify. Leverage the native support for ODBC in PHP.
-
Integrating Antigravity CLI with LDAP via CData CLI
Connect LDAP to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Create Power BI Visual Reports with Real-Time Nuclia Data
Use CData Power BI Connectors to visualize Nuclia in Power BI.
-
Connect to Airtable Data in DBeaver
Use the CData ODBC Driver to connect to Airtable in DBeaver.
-
Integrating Freshservice Data in Talend Cloud Data Management Platform
Connect Freshservice Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Snowflake-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Snowflake to explore live Snowflake Data in Gemini Code Assist to assist with building Snowflake-powered applications.
-
Natively Connect to Google Directory Data in PHP
The CData ODBC driver for Google Directory enables you to create PHP applications with connectivity to Google Directory. Leverage the native support for ODBC in PHP.
-
Build Dashboards with BigCommerce Data in DBxtra
Create dynamic dashboards and perform analytics based on BigCommerce in DBxtra.
-
Connect to MariaDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Excel Spreadsheet Automation on Bullhorn CRM Data with the QUERY Formula
Pull data from Bullhorn CRM, automate spreadsheets, and more with the QUERY formula.
-
ADP Reporting in OBIEE with the ADP JDBC Driver
Deploy the ADP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Xero Data in Looker
Use CData Connect AI to connect to Xero Data from Looker and build custom apps using live Xero Accounting.
-
Integrating GitHub Copilot CLI with Klaviyo 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.
-
Replicate CloudConvert Data from PowerShell
Write a quick PowerShell script to query CloudConvert. Use connectivity to the live data to replicate CloudConvert to SQL Server.
-
How to connect to ZohoDesk Data with Squirrel SQL client
Connect to ZohoDesk and execute queries in the Squirrel SQL Client.
-
Integrate Live Trello Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Trello and integrate live Trello into apps built in Microsoft Power Apps.
-
Integrate Open WebUI with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoom from within the chat interface.
-
Provide OData Services of ServiceNow Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ServiceNow by developing a WCF Service Application.
-
How to connect to Oracle HCM Cloud Data from IntelliJ
Integrate connectivity to Oracle HCM Cloud with wizards in IntelliJ.
-
Stream Google Search Results into Apache Kafka Topics
Access and stream Google Search in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Autopilot Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Autopilot replication to Amazon Redshift.
-
Use the CData Software ODBC Driver for CockroachDB in MicroStrategy
Connect to CockroachDB in MicroStrategy Developer using the CData Software ODBC Driver for CockroachDB.
-
Design BIRT Reports on Freshservice Data
Provide current Freshservice to your embedded analytics.
-
Connect to Sage Intacct Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage Intacct.
-
How to Connect to & Open Wistia Data in Microsoft Excel
This article uses the CData ODBC driver for Wistia to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Drift Data in ColdFusion
Write standard ColdFusion data access code to connect to Drift.
-
Getting Started with the CData SSIS Components for MariaDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MariaDB.
-
Design BIRT Reports on GitHub Data
Provide current GitHub to your embedded analytics.
-
Connect to Wave Financial Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Wave Financial and the Script function in FileMaker Pro to connect to Wave Financial and work with Wave Financial in your FileMaker application.
-
Create Datasets from Microsoft OneDrive in Domo Workbench and Build Visualizations of Microsoft OneDrive Data in Domo
Use the CData Software ODBC Driver for Microsoft OneDrive to create datasets from Microsoft OneDrive in Domo Workbench and then build visualizations in the Domo service.
-
Create Informatica Mappings From/To an ODBC Data Source for Hugging Face
Create an ODBC connection to Hugging Face in Informatica and browse and transfer Hugging Face.
-
Automated SAP Ariba Procurement Data Replication to Teradata
Use CData Sync to Customize and automate SAP Ariba Procurement replication to Teradata.
-
Choosing the Best Method to Connect Bitly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bitly from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build an OLAP Cube in SSAS from Cloudant Data
Establish a connection to IBM Cloudant data from SQL Server Analysis Services, and use the Cloudant Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating LlamaIndex with Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure DevOps in real time.
-
Automated Continuous Sage Intacct Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Apache Kafka.
-
Build MVC Applications with Connectivity to Dynamics 365 Business Central Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics 365 Business Central from an ASP.NET MVC application.
-
Query Greenhouse Data as a SQL Server Database in Node.js
Execute SQL Server queries against Greenhouse from Node.js.
-
Create Data Visualizations in Cognos BI with Avaza Data
Access Avaza as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate with Live Dynamics CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics CRM from the MuleSoft Anypoint Platform to integrate live Microsoft Dynamics CRM into custom reports and dashboards.
-
How to Connect to Live Amazon S3 Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Amazon S3 for you.
-
Use the CData ODBC Driver for SAP SuccessFactors LMS from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP SuccessFactors LMS in Excel.
-
Integrate Jira Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Atlassian Jira from Informatica Cloud.
-
Access TigerGraph Data from MySQL in PHP
Connect to TigerGraph through the standard MySQL libraries in PHP.
-
Connect to and Visualize Live SAP Business One Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Business One.
-
How to Connect the Power BI Service to Outreach.io: Complete Guide
Connect to the CData Software Power BI Connector for Outreach.io from PowerBI.com to provide real-time Outreach.io across the organization.
-
Build Okta-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Okta and build web apps with connectivity to live Okta.
-
Bidirectional Access to Dynamics 365 Business Central Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Dynamics 365 Business Central in Filemaker Pro for Mac or Windows.
-
How to Build an ETL App for Neo4J Data in Python with CData Connect AI
Build ETL pipelines that read and write live Neo4J in Python with petl and the CData Connect AI Python SDK.
-
Feed Mistral AI Data into FineReport
How to set Mistral AI as a JDBC data source in FineReport.
-
Getting Started with the CData Power BI Connector for SageHR
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Design BIRT Reports on Facebook Data
Provide current Facebook to your embedded analytics.
-
Connect to Neo4J Data in HULFT Integrate
Connect to Neo4J as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Facebook
Provide connectivity to Facebook through an SAP BusinessObjects universe.
-
Create Greenplum Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenplum data access from reports, embedded analytics, and more.
-
Build Semantic Layer Views for Templated Data in APOS Live Data Gateway
Use the CData Connector for Templated in APOS Live Data Gateway to build Semantic Layer Views for Templated.
-
Automated Continuous Unbounce Replication to Snowflake
Use CData Sync for automated, continuous, customizable Unbounce replication to Snowflake.
-
Create Informatica Mappings From/To an ODBC Data Source for PostgreSQL
Create an ODBC connection to PostgreSQL in Informatica and browse and transfer PostgreSQL.
-
Automated Continuous Copper Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Copper replication to AlloyDB.
-
ETL Sage Cloud Accounting in Oracle Data Integrator
This article shows how to transfer Sage Business Cloud Accounting into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Synapse
Provide connectivity to Azure Synapse through an SAP BusinessObjects universe.
-
Publish Jira Assets-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Jira Assets.
-
How to Access Live Workable Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Workable enables you to integrate Workable into workflows built using Microsoft Power Automate Desktop.
-
Query, Visualize, and Share live Google Calendar Data in Redash
Use CData Connect AI to connect to live Google Calendar in Redash for querying, visualizing, and sharing.
-
How to connect and process DocuSign from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live DocuSign.
-
Access Live Facebook Data in TIBCO Data Virtualization
Use the Facebook Tibco DV Adapter to create a Facebook data source in TIBCO Data Virtualization Studio and gain access to live Facebook from your TDV Server.
-
Provide OData Services of Salesforce Marketing Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce Marketing Cloud by developing a WCF Service Application.
-
Build Adobe Commerce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Adobe Commerce and build web apps with connectivity to live Adobe Commerce.
-
ETL Outlook in Oracle Data Integrator
This article shows how to transfer Outlook into a data warehouse using Oracle Data Integrator.
-
Choosing the Best Method to Connect Lakebase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Lakebase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Databricks Agent Bricks to Talk to Your GraphQL Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your GraphQL for you.
-
Automated Campaigner Data Replication to Teradata
Use CData Sync to Customize and automate Campaigner replication to Teradata.
-
Add Figshare Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Figshare with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Live Microsoft Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Ads enables you to integrate Microsoft Ads into workflows built using Microsoft Power Automate Desktop.
-
Integrating Boomi Agentstudio with LinkedIn Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to LinkedIn, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData ODBC Driver for Retently in Microsoft Power Query
You can use the CData Retently ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Retently into Microsoft Power Query.
-
Connecting Agentforce with GraphQL 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 GraphQL for you.
-
Visualize Google Drive Data in TIBCO Spotfire through ADO.NET
Integrate Google Drive into dashboards in TIBCO Spotfire.
-
How to connect to SharePoint Excel Services Data with Squirrel SQL client
Connect to SharePoint Excel Services and execute queries in the Squirrel SQL Client.
-
How to create an RPA flow for Pushbullet Data in UiPath Studio
Use the Pushbullet ODBC Driver to create workflows that access real-time Pushbullet without any coding.
-
Connect to Printify Data in Aqua Data Studio
Access Printify from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Teradata Data in CloverDX (formerly CloverETL)
Transfer Teradata using the visual workflow in the CloverDX data integration tool.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP Business Warehouse to Power BI dashboards. Simply drag and drop SAP Business Warehouse into data visuals on the Power BI canvas.
-
Integrating Claude Code with Elasticsearch Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Elasticsearch within assisted coding and automated development workflows.
-
Automated Continuous BigCommerce Replication to SQLite
Use CData Sync for automated, continuous, customizable BigCommerce replication to SQLite.
-
Using the CData Software ODBC Driver for Microsoft OneDrive in PyCharm
Connect to Microsoft OneDrive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft OneDrive.
-
Load Google Cloud Storage Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Cloud Storage to a database.
-
Automate Lakebase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Lakebase replication to Azure Data Lake.
-
Bidirectional Access to Raisers Edge NXT Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Raisers Edge NXT in Filemaker Pro for Mac or Windows.
-
How to Query PagerDuty Data in MySQL Workbench
Execute MySQL queries against live PagerDuty from MySQL Workbench.