CData Software - Knowledge Base
Recent Articles
-
Use Grok to Talk to Your AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your AlloyDB data for you.
-
Integrate with Airtable Data in JReport Designer
Create charts and reports based on Airtable data in JReport Designer.
-
Integrate with Live SAP ByDesign Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP ByDesign from the MuleSoft Anypoint Platform to integrate live SAP ByDesign data into custom reports and dashboards.
-
Build Square-Connected Apps in Choreo
Use CData Connect AI to connect to Square Data from Choreo and build custom apps using live Square data.
-
Process & Analyze Productboard Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Productboard Data.
-
Connect to Pushbullet Data in DBArtisan
Use wizards in DBArtisan to configure Pushbullet data as a data source.
-
How to Work with Salesforce CRM Analytics Data in AWS Glue Jobs Using JDBC
Connect to Salesforce CRM Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Build an ETL App for Google Drive Data in Python with CData
Create ETL applications and real-time data pipelines for Google Drive data in Python with petl.
-
Integrating Gumloop with TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on TaxJar data within automated workflows.
-
Use Grok to Talk to Your Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Certinia data for you.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM data for you.
-
Connect to Omnisend from a Connection Pool in WebLogic
Use the CData JDBC Driver for Omnisend to connect to Omnisend data from Web applications running on WebLogic.
-
Visualize Live LaunchDarkly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LaunchDarkly data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize XML Data in TIBCO Spotfire through OData
Integrate XML data into dashboards in TIBCO Spotfire.
-
Automated Continuous Bullhorn CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to MongoDB.
-
A PostgreSQL Interface for Pipeliner CRM Data using the CData ODBC Driver
Use the SQL Gateway and Pipeliner CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to ZohoPeople
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoPeople data.
-
Visualize QuickBooks Time Data in TIBCO Spotfire through ADO.NET
Integrate QuickBooks Time data into dashboards in TIBCO Spotfire.
-
Integrate Live BigQuery Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live BigQuery data from within the IDE.
-
Integrate Google's Antigravity Agent with Live Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Omnisend data using the Model Context Protocol.
-
Build Discord-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Discord Data from Zoho Analytics and import live Discord data.
-
A PostgreSQL Interface for Invoiced Data (MySQL Remoting via JDBC)
Use the Remoting features of the Invoiced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Jira Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jira data into the statistical analysis tools available in SAS JMP. This article shows how to use Jira data in the Graph Builder and Query Builder.
-
Build an OLAP Cube in SSAS from Float Data
Establish a connection to Float data data from SQL Server Analysis Services, and use the Float Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Live BigCommerce Data in SAS Viya
Use CData Connect AI to connect to BigCommerce data from SAS Viya and deploy self-service analytics using live BigCommerce data.
-
Integrating Antigravity CLI with Microsoft Dataverse data via CData CLI
Connect Microsoft Dataverse data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live Oracle Financials Cloud Data in Coginiti Pro
Connect to and query live Oracle Financials Cloud data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Shippo Data in Cognos Analytics
Use CData Connect AI to connect to Shippo Data from Cognos Analytics and analyze live Shippo data.
-
How to connect and process Google Calendar data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Calendar data.
-
Integrate with Smartsheet Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Smartsheet data in SnapLogic.
-
Connect Tally to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Tally with IBM WebSphere for seamless data integration and connectivity.
-
Feed ScrapingBee Data into FineReport
How to set ScrapingBee data as a JDBC data source in FineReport.
-
Query LinkedIn Data as a SQL Server Database in Node.js
Execute SQL Server queries against LinkedIn data from Node.js.
-
Rapidly Develop Zoho Creator-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 Zoho Creator.
-
Extract, Transform, and Load Dynamics NAV Data in Informatica PowerCenter
Create a simple Workflow for Dynamics NAV data in Informatica PowerCenter.
-
Access Twilio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Twilio data from HeidiSQL.
-
Build a Simple VCL Application for Microsoft Exchange Data
How to build a simple VCL Application to view Microsoft Exchange data in RAD Studio using the CData ODBC Driver for Microsoft Exchange.
-
How to work with Exa Data in Apache Spark using SQL
Access and process Exa Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize Live Browserless Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Browserless data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Microsoft Copilot Studio to talk to your Google Sheets 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 Google Sheets data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Samanage
Provide connectivity to Samanage data through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live NetSuite SuiteAnalytics Data in ThoughtSpot
Use CData Connect AI to connect to live NetSuite SuiteAnalytics data for modeling, searching, and visualizing.
-
Query Tanda Data in DataGrip
Create a Data Source for Tanda in DataGrip and use SQL to query live Tanda data.
-
Connect to Cassandra Data in HULFT Integrate
Connect to Cassandra as a JDBC data source in HULFT Integrate
-
How to Access Coda Data Using Entity Framework
This article shows how to access Coda data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Drip Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Drip as an External Source in Dremio.
-
How to Create Power BI Visual Reports with Real-Time Aircall Data
Use CData Power BI Connectors to visualize Aircall data in Power BI.
-
Integrate Omnisend with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Omnisend with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Omnisend data.
-
Connect to TaxJar Data in ACL Analytics
Connect to TaxJar data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to TaxJar data.
-
Connect to Pipedrive Data from a Connection Pool in JBoss
Integrate Pipedrive data into Java servlets: Use the Management Console in JBoss to install the Pipedrive JDBC Driver.
-
DataBind Controls to Gorgias Data in Delphi
DataBind to Gorgias data in Delphi with standard data access components and controls.
-
How to use SQLAlchemy ORM to access Dynamics NAV Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Dynamics NAV data.
-
A PostgreSQL Interface for Discourse Data using the CData ODBC Driver
Use the SQL Gateway and Discourse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To an ODBC Data Source for MySQL
Create an ODBC connection to MySQL in Informatica and browse and transfer MySQL data.
-
Connect to Epicor Kinetic Data from Crystal Reports
Use CData Connect AI to connect to and report on live Epicor Kinetic data from Crystal Reports.
-
Connect to LaunchDarkly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to LaunchDarkly as an External Source in Dremio.
-
Visualize Keap Data in Tableau
The CData ODBC driver for Keap enables you integrate Keap data into Tableau dashboards.
-
Connecting Mastra with eBay 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 eBay data, no replication required.
-
Integrate Contentful Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Contentful data from Informatica Cloud.
-
Analyze MailerLite Data in Cognos Analytics
Use CData Connect AI to connect to MailerLite Data from Cognos Analytics and analyze live MailerLite data.
-
How to Work with Salesforce CRM Analytics Data in ETL Validator JDBC
Connect to Salesforce CRM Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to SageHR Data in Aqua Data Studio
Access SageHR data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Oracle Sales Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Sales data from HeidiSQL.
-
Integrating GitHub Copilot with Oracle Sales 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.
-
Integrate Live Timely Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Timely data from within the IDE.
-
Explore Geographical Relationships in SparkPost Data with Power Map
Create data visualizations with SparkPost data in Power Map.
-
Import and Visualize Sugar CRM Data in Power View
Create data visualizations based on Sugar CRM data in Excel.
-
Connect and Visualize Live VWO Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live VWO data into the Databricks platform and create visualization dashboards with real-time VWO data.
-
Migrating data from Optimizely to Snowflake using CData SSIS Components.
Easily push Optimizely data to Snowflake using the CData SSIS Tasks for Optimizely and Snowflake.
-
Use Azure AI Foundry to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Salesforce Marketing data for you.
-
Use CData Connect AI to Access Kintone Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Kintone data in the Power Pivot business intelligence tool.
-
Publish Wistia-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Wistia data.
-
How to Connect Flowise AI Agents to Live PostgreSQL Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live PostgreSQL data without replication.
-
Connecting Pipedream with Exact Online 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 Exact Online data in real time.
-
Using the CData Software ODBC Driver for CockroachDB in PyCharm
Connect to CockroachDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for CockroachDB.
-
Connecting Mastra with PolarTeamPro 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 PolarTeamPro data, no replication required.
-
Build Semantic Layer Views for Azure DevOps Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure DevOps data.
-
How to Access Phoenix Data Using Entity Framework
This article shows how to access Phoenix data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live YouTube Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live YouTube Analytics data from your Excel spreadsheets.
-
How to Connect to Live Office 365 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 Office 365 data through natural language.
-
Import Real-Time Dropbox Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dropbox data in ColdFusion.
-
Integrate Google's Vertex AI Agent with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Sendwithus data within intelligent workflows.
-
Automated Continuous AlloyDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable AlloyDB replication to Google BigQuery.
-
Connect to Workday Data in HULFT Integrate
Connect to Workday as a JDBC data source in HULFT Integrate
-
Use Dash to Build to Web Apps on VWO Data
Create Python applications that use pandas and Dash to build VWO-connected web apps.
-
Object-Relational Mapping (ORM) with Scrapfly 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 Scrapfly data into a Java-based ORM framework, Hibernate.
-
Use Biml to Build SSIS Tasks to Replicate Jira Assets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jira Assets data to SQL Server.
-
Connect to Oracle SCM 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 Oracle SCM data.
-
Automated Continuous Microsoft OneLake Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Snowflake.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Gong
Provide connectivity to Gong data through an SAP BusinessObjects universe.
-
Analyze Epicor Kinetic Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Epicor Kinetic data and visualize live Epicor Kinetic data in Infragistics Reveal.
-
Integrating Microsoft Dataverse Data in Talend Cloud Data Management Platform
Connect Microsoft Dataverse Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Microsoft Dataverse.
-
Connecting Moonlit Workflow with xBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your xBase data in real time.
-
Build Semantic Layer Views for Marketo Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Marketo data.
-
Choosing the Best Method to Connect ServiceNow to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ServiceNow data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Typeform Replication to SingleStore
Use CData Sync for automated, continuous, customizable Typeform replication to SingleStore.
-
Build Paylocity-Connected Apps in Choreo
Use CData Connect AI to connect to Paylocity Data from Choreo and build custom apps using live Paylocity data.
-
Integrate Suadeo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Suadeo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Suadeo data.
-
Automated Continuous Billsby Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Billsby replication to IBM DB2.
-
Work with Shortcut Data in FoxPro
Load Shortcut data into a FoxPro database. This article includes full code and a walk-through of the process.