CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Guru Data in OpenOffice Base
Connect to Guru data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to Live Google Contacts Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Contacts data for you.
-
Design BIRT Reports on ActiveCampaign Data
Provide current ActiveCampaign data to your embedded analytics.
-
Customer.io Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Customer.io facts in real time.
-
Integrate SAP Hybris C4C with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Hybris C4C with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Hybris C4C data.
-
Publish Crystal Reports on MarkLogic Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MarkLogic data.
-
Getting Started with the CData ADO.NET Provider for Email
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Email.
-
Access Live Azure DevOps Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure DevOps data from your Google Sheets.
-
Query Yelp Data as a SQL Server Database in Node.js
Execute SQL Server queries against Yelp data from Node.js.
-
Easily Integrate Typeform Data in Lazarus Pascal IDE
Learn how to easily integrate live Typeform data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Email Data in NetBeans
Connect to Email data in NetBeans with the data source configuration wizard.
-
Use Agno to Talk to Your Amazon Marketplace 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 Amazon Marketplace data for you.
-
Getting Started with the CData JDBC Driver for Klipfolio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Klipfolio.
-
Use the CData Software ODBC Driver for Accelo in SAS for Real-Time Reporting and Analytics
Connect to real-time Accelo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Accelo.
-
Automated Continuous Trello Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Trello data replication to OneLake in Microsoft Fabric.
-
Connect to Live LinkedIn Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to LinkedIn Ads in CData Connect AI and connect to your LinkedIn Ads data from PostgreSQL.
-
Configure the CData JDBC Driver for SingleStore in a Connection Pool in Tomcat
Connect to SingleStore data from a connection pool in Tomcat.
-
Build Voice Agents in ElevenLabs with access to Live Paymo Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Paymo data.
-
Use Biml to Build SSIS Tasks to Replicate Shopify Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Shopify data to SQL Server.
-
Query Live Procore 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 Procore data directly from the development environment.
-
How to connect to Gorgias Data with Squirrel SQL client
Connect to Gorgias data and execute queries in the Squirrel SQL Client.
-
Build Apps with Live Testmonitor data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Testmonitor data into the Adalo platform and build custom mobile and web applications with real-time Testmonitor data.
-
Automate Tanda Data Replication to Azure Synapse
Use CData Sync to customize and automate Tanda data replication to Azure Synapse.
-
Migrating data from ConvertAPI to Databricks using CData SSIS Components.
Easily push ConvertAPI data to Databricks using the CData SSIS Tasks for ConvertAPI and Databricks.
-
Object-Relational Mapping (ORM) with Google Forms 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 Google Forms data into a Java-based ORM framework, Hibernate.
-
Design BIRT Reports on Float Data
Provide current Float data to your embedded analytics.
-
Use the CData Software ODBC Driver for Reply.io in SAS for Real-Time Reporting and Analytics
Connect to real-time Reply.io data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Reply.io.
-
How to create Visio diagrams from Shopify Data
Automatically update Shopify data with the changes you make to Visio master shapes.
-
Automate Google Analytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Analytics data replication to Azure Data Lake.
-
How to connect to Acumatica Data with Squirrel SQL client
Connect to Acumatica data and execute queries in the Squirrel SQL Client.
-
Integrating Dataiku with Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Guru data.
-
Connect to PagerDuty in SpagoBI
Create reports featuring live PagerDuty data in SpagoBI Studio. Host PagerDuty reports on SpagoBI Server.
-
Access Live Blackbaud FE NXT Data in AWS Lambda
Connect to live Blackbaud FE NXT data in AWS Lambda using the CData JDBC Driver.
-
Work with Live NetSuite SuiteAnalytics Data in Power Query
Use CData Connect AI to connect to NetSuite SuiteAnalytics data and work with live NetSuite SuiteAnalytics data in Microsoft Power Query.
-
How to Connect Sybase IQ 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 Sybase IQ data in real time using natural language.
-
How to connect PolyBase to Power BI XMLA
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Power BI XMLA data.
-
Back Up CloudConvert data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with CloudConvert data data.
-
Integrating Kiro with Printful 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.
-
Access Live Salesforce CRM Analytics Data in Coginiti Pro
Connect to and query live Salesforce CRM Analytics data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Visualize Telegram Data in Python with pandas
Use pandas and other modules to analyze and visualize live Telegram data in Python.
-
Connect to Grafana Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Grafana Data and connect to Grafana data in Akorbi Digital RunMyProcess.
-
Import JSON Services Using Azure Data Factory
Use CData Connect AI to connect to JSON Services from Azure Data Factory and import live JSON services.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Service Cloud
Provide connectivity to Oracle Service Cloud data through an SAP BusinessObjects universe.
-
Getting Started with the CData JDBC Driver for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Data Catalog.
-
Automated Continuous Retently Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Retently replication to IBM DB2.
-
Consume Zoho Creator OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Creator data as OData feeds from PowerBuilder using the API Server.
-
Extract, Transform, and Load Hugging Face Data in Informatica PowerCenter
Create a simple Workflow for Hugging Face data in Informatica PowerCenter.
-
Connect to ElevenLabs Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ElevenLabs.
-
Connect to Landbot in SpagoBI
Create reports featuring live Landbot data in SpagoBI Studio. Host Landbot reports on SpagoBI Server.
-
Replicate Couchbase Data to Multiple Databases via the CData Sync CLI
Replicate Couchbase data to disparate databases with a single configuration.
-
Query Live Cassandra Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Cassandra data through a conversational interface.
-
Getting Started with the CData ODBC Driver for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesforce Marketing.
-
Connect to REST Data in Ruby
Connect to REST data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate SQL Analysis Services Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SQL Analysis Services data from Informatica Cloud.
-
Connect and Visualize Live BigQuery Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live BigQuery data into the Databricks platform and create visualization dashboards with real-time BigQuery data.
-
Explore Geographical Relationships in Avaza Data with Power Map
Create data visualizations with Avaza data in Power Map.
-
Connect to Zoho Inventory Data in CloverDX (formerly CloverETL)
Transfer Zoho Inventory data using the visual workflow in the CloverDX data integration tool.
-
Choosing the Best Method to Connect eBay Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use eBay Analytics data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Boomi Agentstudio with MarkLogic Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MarkLogic data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData ADO.NET Provider for Google Sheets
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Sheets.
-
Integrate Missive Data in the Pentaho Report Designer
Publish reports based on Missive data in the Pentaho BI tool.
-
Model, Search, and Visualize Live Quickbase Data in ThoughtSpot
Use CData Connect AI to connect to live Quickbase data for modeling, searching, and visualizing.
-
Build a Singer.io Tap for iContact With the CData Python Connector
Learn how to easily build a Singer.io Tap for live iContact data using the CData Python Connector.
-
Excel Spreadsheet Automation on Asana Data with the QUERY Formula
Pull data from Asana, automate spreadsheets, and more with the QUERY formula.
-
Replicate CockroachDB Data to Multiple Databases via the CData Sync CLI
Replicate CockroachDB data to disparate databases with a single configuration.
-
Access Live SAP HANA XS Advanced Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA XS Advanced data into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA XS Advanced data in the Graph Builder and Query Builder.
-
Connect Tickspot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Tickspot data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to eBay Analytics Data in Ruby
Connect to eBay Analytics data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Microsoft Dataverse Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to MongoDB.
-
Integrating Cursor with SFTP 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.
-
Build Charts with Stack Exchange Data in Clear Analytics
Create dynamic charts and perform analytics based on Stack Exchange data in Clear Analytics.
-
How to create an RPA flow for Dropbox Data in UiPath Studio
Use the Dropbox ODBC Driver to create workflows that access real-time Dropbox data without any coding.
-
Use the CData Software ODBC Driver for Salesloft in MicroStrategy Desktop
Connect to Salesloft data in MicroStrategy Desktop using the CData Software ODBC Driver for Salesloft.
-
Build a Singer.io Tap for Teradata With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Teradata data using the CData Python Connector.
-
Integrate ZeroBounce Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZeroBounce data from Informatica Cloud.
-
Extract, Transform, and Load Authorize.Net Data in Informatica PowerCenter
Create a simple Workflow for Authorize.Net data in Informatica PowerCenter.
-
Authorize.Net Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Authorize.Net data through CData Connect AI using different applications and tools.
-
Connect to Jira Assets Data in Claris FileMaker Pro
Use the CData ODBC Driver for Jira Assets in FileMaker Pro to connect to Jira Assets and work with Jira Assets data in your FileMaker applications.
-
How to Connect to Live MailChimp Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your MailChimp data for you.
-
Getting Started with the CData Power BI Connector for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP BusinessObjects BI.
-
Bind Live Google Sheets Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Sheets data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Seamlessly Bring Couchbase Data into Retool Using CData Connect AI
Integrate Couchbase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Work with SAP HANA XS Advanced Data in ETL Validator JDBC
Connect to SAP HANA XS Advanced from ETL Validator jobs using the CData Software JDBC Driver.
-
Build an OLAP Cube in SSAS from Lakebase Data
Establish a connection to Lakebase data data from SQL Server Analysis Services, and use the Lakebase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Toggl in MicroStrategy Web
Connect to Toggl data in MicroStrategy Web using the CData Software ODBC Driver for Toggl.
-
Create PolarTeamPro-Connected Dashboards in Grafana
Connect to PolarTeamPro Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to PolarTeamPro data.
-
Bind Live Twitter Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Twitter Ads data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create SSAS Tabular Models from Zendesk Data
How to build a SQL Server Analysis Service Tabular Model from Zendesk data using CData drivers.
-
Migrating data from Phoenix to Snowflake using CData SSIS Components.
Easily push Phoenix data to Snowflake using the CData SSIS Tasks for Phoenix and Snowflake.
-
Integrate Oracle Service Cloud with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Service Cloud with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Service Cloud data.
-
Extract, Transform, and Load SendPulse Data in Informatica PowerCenter
Create a simple Workflow for SendPulse data in Informatica PowerCenter.
-
Automated Continuous CampaignMonitor Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Apache Cassandra.
-
Connect to Wave Financial Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Wave Financial data from Filemaker Pro on Mac.
-
Easily Integrate Bitly Data in Lazarus Pascal IDE
Learn how to easily integrate live Bitly data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Object-Relational Mapping (ORM) with Pipedrive 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 Pipedrive data into a Java-based ORM framework, Hibernate.
-
Integrating Google Drive Data in Talend Cloud Data Management Platform
Connect Google Drive Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Drive.
-
Build a Singer.io Tap for Freshdesk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Freshdesk data using the CData Python Connector.
-
Connecting GenSpark with xBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to xBase data without any replication or custom integration required.
-
Create SAP SuccessFactors-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP SuccessFactors Data from OutSystems and build custom enterprise apps using live SAP SuccessFactors data.
-
Excel Spreadsheet Automation on LinkedIn Data with the QUERY Formula
Pull data from LinkedIn, automate spreadsheets, and more with the QUERY formula.