CData Software - Knowledge Base
Recent Articles
-
Manage Bitly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bitly.
-
Automated Continuous Microsoft Planner Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData ADO.NET Provider for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Bridge Onfleet Connectivity with Apache NiFi
Access and process Onfleet in Apache NiFi using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Mode Data
Use CData Power BI Connectors to visualize Mode in Power BI.
-
How to Seamlessly Import Acumatica Data into IBM SPSS Modeler
Integrate Acumatica data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extract, Transform, and Load Stack Exchange Data in Informatica PowerCenter
Create a simple Workflow for Stack Exchange in Informatica PowerCenter.
-
Consume DocuSign OData Feeds in PowerBuilder
This article demonstrates how to consume DocuSign as OData feeds from PowerBuilder using the API Server.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP ByDesign
Create SAP ByDesign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate with Workday Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Workday to a JSON file on disk.
-
Build Semantic Layer Views for NetSuite Data in APOS Live Data Gateway
Use the CData Connector for NetSuite in APOS Live Data Gateway to build Semantic Layer Views for NetSuite CRM & ERP.
-
Getting Started with the CData SSIS Components for Hive
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Hive.
-
Connecting GenSpark with Google Search Results via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Search without any replication or custom integration required.
-
Create Data Visualizations Based On Oracle Sales Data in Mode
Use CData Connect AI to connect to Oracle Sales Data from Mode and build visualizations using live
-
Connect to Elasticsearch Data in RazorSQL
Connect to Elasticsearch from wizards and query Elasticsearch from the GUI in the RazorSQL database management tool.
-
Query JDBC-ODBC Bridge Data in DataGrip
Create a Data Source for JDBC-ODBC Bridge in DataGrip and use SQL to query live JDBC-ODBC Bridge.
-
Connecting Pipedream with LinkedIn Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on LinkedIn Ads data in real time.
-
Build Cassandra-Connected Apps in Choreo
Use CData Connect AI to connect to Cassandra Data from Choreo and build custom apps using live Apache Cassandra.
-
Build AI Agents with Azure Data Lake Storage Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Azure Data Lake Storage through CData Connect AI.
-
Connect to Microsoft Entra ID Data in CloverDX (formerly CloverETL)
Transfer Microsoft Entra ID using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software ODBC Driver for Act CRM in MicroStrategy Web
Connect to Act CRM in MicroStrategy Web using the CData Software ODBC Driver for Act CRM.
-
Trigger Act-On IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Act-On with standard wizards in Logic Apps.
-
Replicate Multiple Azure DevOps Accounts via the CData Sync CLI
Replicate multiple Azure DevOps accounts to one or many databases.
-
LINQ to DocuSign Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the DocuSign Data Provider.
-
Connect to Ontraport Data in RazorSQL
Connect to Ontraport from wizards and query Ontraport from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Airtable
Provide connectivity to Airtable through an SAP BusinessObjects universe.
-
Query MessageBird Data in DataGrip
Create a Data Source for MessageBird in DataGrip and use SQL to query live MessageBird.
-
Connect to IBM Cloud Object Storage Data in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Cloud Object Storage in FileMaker Pro to connect to IBM Cloud Object Storage and work with IBM Cloud Object Storage in your FileMaker applications.
-
Integrate Vault CRM Data into Power Automate Desktop using CData Connect
CData Connect for Vault CRM Data enables you to integrate Veeva Vault & Vault CRM into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for HelloSign in PyCharm
Connect to HelloSign as an ODBC data source in PyCharm using the CData Software ODBC Driver for HelloSign.
-
Publish Yelp-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Yelp.
-
Use the CData Software JDBC Driver for Printful in MicroStrategy Web
Connect to Printful in MicroStrategy Web using the CData Software JDBC Driver for Printful.
-
Visualize Live Cloudant Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Cloudant.
-
Integrating Antigravity CLI with ConvertKit via CData CLI
Connect ConvertKit to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Automated Workflows with Live API Data in Workato
Use CData Connect AI to connect to live API and build automated workflows in Workato.
-
Build Apps with Live Front Data Using the Low-Code Development Platform of Mendix
Connect Front with Mendix to build apps using the CData API Driver for JDBC.
-
Extract, Transform, and Load Omnisend Data in Informatica PowerCenter
Create a simple Workflow for Omnisend in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for Apify in MicroStrategy Desktop
Connect to Apify in MicroStrategy Desktop using the CData Software ODBC Driver for Apify.
-
Deploy the ADO.NET Provider for Google Drive on an SSRS Report Server
Connect to Google Drive from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Seamlessly Import Workday Data into IBM SPSS Modeler
Integrate Workday data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Gong Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate LibreChat with Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Salesforce CRM Analytics from within the chat interface.
-
Consume GitHub OData Feeds in PowerBuilder
This article demonstrates how to consume GitHub as OData feeds from PowerBuilder using the API Server.
-
How to Visualize Intercom Data in Python with pandas
Use pandas and other modules to analyze and visualize live Intercom in Python.
-
Build Charts with Google Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Analytics in Clear Analytics.
-
How to Query Bitbucket Data in MySQL Workbench
Execute MySQL queries against live Bitbucket from MySQL Workbench.
-
Create Exact Online-Connected Dashboards in Grafana
Connect to Exact Online Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Exact Online.
-
Integrate with live GitLab Data in Jitterbit
Use CData Connect AI to connect to and integrate live GitLab in Jitterbit.
-
Publish Reports with Facebook Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Facebook Ads.
-
Create Dashboards and Visualize Live SAP Concur Data in Geckoboard
Use CData Connect AI to connect to live SAP Concur and create dashboards for real-time monitoring and visualization in Geckoboard.
-
LINQ to AlloyDB Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the AlloyDB Data Provider.
-
Connect to Perplexity Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Analyze AgileCRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for AgileCRM from Power Pivot. You will use the Table Import Wizard to load AgileCRM. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Real-Time Access to Azure Analysis Services in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Analysis Services in real time.
-
Getting Started with the CData ODBC Driver for Neo4J
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Neo4J.
-
Build SQL Server-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SQL Server to explore live SQL Server Data in GitHub Copilot to assist with building SQL Server-powered applications.
-
ETL Hacker News in Oracle Data Integrator
This article shows how to transfer Hacker News into a data warehouse using Oracle Data Integrator.
-
Integrating Claude Code CLI with Zuora 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.
-
Operational Reporting on Acumatica Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Acumatica ERP.
-
Replicate Hive Data to Multiple Databases
Replicate Apache Hive to disparate databases with a point-and-click configuration.
-
Integrate with Azure Analysis Services Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure Analysis Services in SnapLogic.
-
Integrate Real-Time Access to Square in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Square in real time.
-
Create SSAS Tabular Models from Front Data
How to build a SQL Server Analysis Service Tabular Model from Front using CData drivers.
-
Build Dashboards with Outlook Data in Dundas BI
Create dynamic dashboards and perform analytics based on Outlook in Dundas BI.
-
Integrating OpenCode Terminal with Guru 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.
-
How to create Humanity federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Humanity in MySQL .
-
Use the CData ODBC Driver for Twitter Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Twitter Ads to connect to Twitter Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Twitter Ads in Excel.
-
Connecting Agentforce with Salesforce Pardot 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 Salesforce Pardot for you.
-
Connect to Real-Time Anaplan Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Anaplan and Dataflow to import and use Anaplan in Power Apps.
-
Bidirectional Access to Optimizely Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Optimizely in Filemaker Pro for Mac or Windows.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Salesloft actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Analyze Certinia Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Certinia and visualize live Certinia in Infragistics Reveal.
-
Query, Visualize, and Share live Azure Data Lake Storage Data in Redash
Use CData Connect AI to connect to live Azure Data Lake Storage in Redash for querying, visualizing, and sharing.
-
Connect to GitHub Data in NetBeans
Connect to GitHub in NetBeans with the data source configuration wizard.
-
How to Create Power BI Visual Reports with Real-Time Salesforce Marketing Data
Use CData Power BI Connectors to visualize Salesforce Marketing Cloud in Power BI.
-
Explore Geographical Relationships in VWO Data with Power Map
Create data visualizations with VWO in Power Map.
-
Use the CData Software ODBC Driver for Mailjet in SAS for Real-Time Reporting and Analytics
Connect to real-time Mailjet in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mailjet.
-
Connect to Onfleet Data from a Connection Pool in Jetty
The Onfleet JDBC Driver supports connection pooling: This article shows how to connect faster to Onfleet from Web apps in Jetty.
-
Integrate with Live Spark Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Spark from the MuleSoft Anypoint Platform to integrate live Apache Spark SQL into custom reports and dashboards.
-
Validate Dynamics NAV Data with QuerySurge
Access and validate Microsoft Dynamics NAV in QuerySurge using the CData JDBC Driver.
-
Build Apps with Live Zoho Creator Data Using the Low-Code Development Platform of Mendix
Connect Zoho Creator with Mendix to build apps using the CData JDBC Driver for Zoho Creator.
-
Build Semantic Layer Views for Intercom Data in APOS Live Data Gateway
Use the CData Connector for Intercom in APOS Live Data Gateway to build Semantic Layer Views for Intercom.
-
Getting Started with the CData Python Connector for ServiceNow
Learn to install and license the CData Python Connector
-
Integrating Codex CLI with HubDB 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.
-
Access AlloyDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google AlloyDB from HeidiSQL.
-
Build Apps with Live SingleStore in Adalo using CData Connect AI
Use CData Connect AI to integrate live SingleStore into the Adalo platform and build custom mobile and web applications with real-time SingleStore.
-
Object-Relational Mapping (ORM) with Cloudflare 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 Cloudflare into a Java-based ORM framework, Hibernate.
-
Choosing the Best Method to Connect Pushbullet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pushbullet from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Migrating data from Paylocity to Snowflake using CData SSIS Components.
Easily push Paylocity to Snowflake using the CData SSIS Tasks for Paylocity and Snowflake.
-
Build Gmail-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Gmail to explore live Gmail Data in Claude Code to assist with building Gmail-powered applications.
-
Use the CData Software JDBC Driver for Drift in MicroStrategy Web
Connect to Drift in MicroStrategy Web using the CData Software JDBC Driver for Drift.
-
Connect to GitLab Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for GitLab.
-
Getting Started with the CData Power BI Connector for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Reckon Accounts Hosted.
-
Prepare, Blend, and Analyze Avaza Data in Alteryx Designer (ODBC)
Build workflows to access live Avaza for self-service data analytics.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy Web
Connect to Presto in MicroStrategy Web using the CData Software ODBC Driver for Presto.
-
Edit and Search External NetSuite Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of NetSuite CRM & ERP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create NetSuite Data objects that you can access from apps and the dashboard.
-
Automate Browserless Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Browserless from PowerShell? This article demonstrates how to utilize the Browserless Cmdlets for tasks like connecting to Browserless, automating operations, downloading data, and more.
-
Connect to Xero Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Xero and the SQL Gateway to access Xero Accounting from Google Apps Script.
-
Create Data Visualizations in Cognos BI with Bitly Data
Access Bitly as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for RSS in MicroStrategy
Connect to RSS Feeds in MicroStrategy Developer using the CData Software JDBC Driver for RSS.