CData Software - Knowledge Base
Recent Articles
-
Explore Geographical Relationships in Hacker News Data with Power Map
Create data visualizations with Hacker News data in Power Map.
-
Build Active Directory-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Active Directory data.
-
Automate Kintone Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Kintone data from PowerShell? This article demonstrates how to utilize the Kintone Cmdlets for tasks like connecting to Kintone data, automating operations, downloading data, and more.
-
Access Facebook Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Facebook Ads data from your Oracle system.
-
Integrating GitHub Copilot with Intercom 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.
-
Integrating Gumloop with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ServiceNow data within automated workflows.
-
Integrate Theia IDE with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Zoho CRM data from within the development environment.
-
Migrating data from Tanda to Snowflake using CData SSIS Components.
Easily push Tanda data to Snowflake using the CData SSIS Tasks for Tanda and Snowflake.
-
Build Semantic Layer Views for LinkedIn Ads Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for LinkedIn Ads data.
-
Build PayPal-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for PayPal Data and create custom apps in Mendix.
-
Automate Mixpanel Data Replication to Couchbase
Use CData Sync to Customize and automate Mixpanel data replication to Couchbase.
-
Use the CData Software ODBC Driver for BambooHR in MicroStrategy
Connect to BambooHR data in MicroStrategy Developer using the CData Software ODBC Driver for BambooHR.
-
How to Connect the Power BI Service to Authorize.Net: Complete Guide
Connect to the CData Software Power BI Connector for Authorize.Net from PowerBI.com to provide real-time Authorize.Net data across the organization.
-
How to connect to AlloyDB Data with Squirrel SQL client
Connect to AlloyDB data and execute queries in the Squirrel SQL Client.
-
Analyze Figshare Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Figshare data in Microsoft R Open.
-
Connect and Visualize Live Timely Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Timely data into the Databricks platform and create visualization dashboards with real-time Timely data.
-
Use Dash to Build to Web Apps on Pinterest Data
Create Python applications that use pandas and Dash to build Pinterest-connected web apps.
-
Integrating LangChain with MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MongoDB data within automated workflows.
-
Replicate Planio Data from PowerShell
Write a quick PowerShell script to query Planio data. Use connectivity to the live data to replicate Planio data to SQL Server.
-
Deploy the ADO.NET Provider for Accelo on an SSRS Report Server
Connect to Accelo data 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 connect Amazon QuickSight to Office 365 Data
Create a connection to Office 365 data in CData Connect AI and insert Office 365 data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use Microsoft Copilot Studio to talk to your SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Netweaver Gateway data for you.
-
Integrating Codex with ShipStation 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.
-
Bind Live Impala Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Impala data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to JotForm Data in Ruby
Connect to JotForm data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating OpenCode with Salesforce 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.
-
Replicate XML Data in Heroku for Use in Salesforce Connect
Replicate XML data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Semantic Layer Views for REST Data in APOS Live Data Gateway
Use the CData Connector for REST in APOS Live Data Gateway to build Semantic Layer Views for REST data.
-
Automated Continuous Databricks Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Databricks replication to PostgreSQL.
-
Connect to Salesforce Data in RazorSQL
Connect to Salesforce from wizards and query Salesforce data from the GUI in the RazorSQL database management tool.
-
Connect to Spark Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Spark Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build SAP Hybris C4C-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Hybris C4C Data from Choreo and build custom apps using live SAP Hybris C4C data.
-
Integrate Real-Time Access to Certinia in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Certinia data in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics 365
Provide connectivity to Dynamics 365 data through an SAP BusinessObjects universe.
-
Build Dashboards with Square Data in Dundas BI
Create dynamic dashboards and perform analytics based on Square data in Dundas BI.
-
Create a Data Access Object for TaxJar Data using JDBI
A brief overview of creating a SQL Object API for TaxJar data in JDBI.
-
Integrating OpenCode with Webflow 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 LaunchDarkly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live LaunchDarkly data using the CData Python MCP Server.
-
Automated Continuous Salesforce CRM Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Amazon S3.
-
Connect to ZohoDesk Data from AWS Glue
Use CData Connect AI to gain access to live ZohoDesk data from your AWS Glue jobs.
-
Integrate with Live Vault CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Vault CRM from the MuleSoft Anypoint Platform to integrate live Vault CRM data into custom reports and dashboards.
-
How to Connect to Live xBase Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your xBase data for you.
-
Integrate Open WebUI with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Amazon S3 data from within the chat interface.
-
Connect to Stack Exchange Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Stack Exchange and work with Stack Exchange data in your FileMaker applications.
-
Use the CData Software ODBC Driver for Facebook in MicroStrategy Web
Connect to Facebook data in MicroStrategy Web using the CData Software ODBC Driver for Facebook.
-
Connect to and Visualize Live Databricks Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Databricks data.
-
How to Connect Quickbase Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Quickbase data in real time using natural language.
-
Automated Continuous QuickBooks Time Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to PostgreSQL.
-
Visualize Live QuickBooks Online Data in the Power BI Service
Use CData Connect AI to connect to live QuickBooks Online data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Facebook in SAS for Real-Time Reporting and Analytics
Connect to real-time Facebook data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Facebook.
-
Front Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Front facts in real time.
-
Prepare, Blend, and Analyze FreshBooks Data in Alteryx Designer (Connect AI)
Build workflows to access live FreshBooks data for self-service data analytics.
-
Automated Continuous Bannerbear Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bannerbear replication to Apache Cassandra.
-
Build a PostgreSQL Interface for Foursquare Data using the CData JDBC Driver
Use the Remoting features of the Foursquare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate Azure Analysis Services Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Analysis Services data to SQL Server.
-
Integrate SAP Ariba Procurement with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Ariba Procurement with External Services.
-
Integrating Kiro with Rootly 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 Real-Time Keap Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Keap data in Power Apps.
-
Visualize Gumroad Data in TIBCO Spotfire through ADO.NET
Integrate Gumroad data into dashboards in TIBCO Spotfire.
-
Access Live SageHR Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SageHR data into the statistical analysis tools available in SAS JMP. This article shows how to use SageHR data in the Graph Builder and Query Builder.
-
Provide OData Services of Snapchat Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Snapchat Ads data by developing a WCF Service Application.
-
Automated Continuous Zoho Books Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho Books replication to AlloyDB.
-
Build MailChimp-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live MailChimp data without replication.
-
How to Connect to Live Hive Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Hive data for you.
-
How to Create Power BI Visual Reports with Real-Time Front Data
Use CData Power BI Connectors to visualize Front data in Power BI.
-
How to Connect the Power BI Service to Excel Online: Complete Guide
Connect to the CData Software Power BI Connector for Excel Online from PowerBI.com to provide real-time Excel Online data across the organization.
-
Automated Continuous Shortcut Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Shortcut replication to Azure SQL Database.
-
Connecting Mastra with Exact Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Exact Online data, no replication required.
-
Design BIRT Reports on BenchmarkEmail Data
Provide current BenchmarkEmail data to your embedded analytics.
-
Use Biml to Build SSIS Tasks to Replicate Superchat Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Superchat data to SQL Server.
-
Create SSAS Tabular Models from CircleCI Data
How to build a SQL Server Analysis Service Tabular Model from CircleCI data using CData drivers.
-
Explore Geographical Relationships in Bitly Data with Power Map
Create data visualizations with Bitly data in Power Map.
-
Query, Visualize, and Share live LinkedIn Ads Data in Redash
Use CData Connect AI to connect to live LinkedIn Ads data in Redash for querying, visualizing, and sharing.
-
Connect to Dynamics CRM Data from AWS Glue
Use CData Connect AI to gain access to live Dynamics CRM data from your AWS Glue jobs.
-
Create Informatica Mappings From/To an ODBC Data Source for Guru
Create an ODBC connection to Guru in Informatica and browse and transfer Guru data.
-
Working with Twitter Ads Data in LINQPad
Execute LINQ queries to Twitter Ads data in LINQPad.
-
How to Easily Query Slack Data in OpenOffice Base
Connect to Slack data in OpenOffice Base using the CData ODBC Driver for Slack and generate reports with live data insights.
-
Use the CData Software JDBC Driver for SpaceX in MicroStrategy
Connect to SpaceX data in MicroStrategy Developer using the CData Software JDBC Driver for SpaceX.
-
Integrate with Salesloft Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesloft data to a JSON file on disk.
-
Build a Singer.io Tap for Planio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Planio data using the CData Python Connector.
-
Access Live ShipEngine 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 ShipEngine data through MCP integration.
-
Analyze Live Facebook Data in SAS Viya
Use CData Connect AI to connect to Facebook data from SAS Viya and deploy self-service analytics using live Facebook data.
-
Use Manus AI to Talk to Your PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on PostgreSQL data.
-
DataBind Controls to Slack Data in C++Builder
DataBind to Slack data in C++Builder with standard components and controls.
-
Query ConstantContact Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ConstantContact data from Node.js.
-
Access Live Paylocity Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Paylocity data from your Excel spreadsheets.
-
Integrate Theia IDE with Live VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live VWO data from within the development environment.
-
Build AI Agents with Microsoft Ads 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 Microsoft Ads data through CData Connect AI.
-
Getting Started with the CData JDBC Driver for FHIR
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FHIR.
-
Getting Started with the CData Excel Add-In for Parallel
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Parallel.
-
Use the CData Software ODBC Driver for Workday in SAS for Real-Time Reporting and Analytics
Connect to real-time Workday data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Workday.
-
How to Connect DBeaver to Gmail via a JDBC Driver
Manage Gmail data with visual tools in DBeaver like the query browser.
-
Create SSAS Tabular Models from Auth0 Data
How to build a SQL Server Analysis Service Tabular Model from Auth0 data using CData drivers.
-
Use Biml to Build SSIS Tasks to Replicate MYOB AccountRight Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MYOB AccountRight data to SQL Server.
-
Create a Data Access Object for Google Forms Data using JDBI
A brief overview of creating a SQL Object API for Google Forms data in JDBI.
-
Query, Visualize, and Share live xBase Data in Redash
Use CData Connect AI to connect to live xBase data in Redash for querying, visualizing, and sharing.
-
Integrate Live Bannerbear Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Bannerbear from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Bannerbear data.
-
Query Live Paymo Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Paymo data directly from the development environment.
-
Replicate Accelo Data in Heroku for Use in Salesforce Connect
Replicate Accelo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Object-Relational Mapping (ORM) with Greenplum 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 Greenplum data into a Java-based ORM framework, Hibernate.