CData Software - Knowledge Base
Recent Articles
-
Excel Online Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Excel Online facts in real time.
-
Use Agno to Talk to Your Pipedrive 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 Pipedrive data for you.
-
How to Work with MariaDB Data in AWS Glue Jobs Using JDBC
Connect to MariaDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Suadeo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Suadeo data in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for Adobe Analytics Data using the CData ODBC Driver
Use the SQL Gateway and Adobe Analytics ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to import SAP HANA Data into Apache Solr
Use the CData Software JDBC Driver for SAP HANA in Data Import Handler and create an automated import of SAP HANA data to Apache Solr Enterprise Search platform.
-
Design BIRT Reports on Everhour Data
Provide current Everhour data to your embedded analytics.
-
Query Supabase Data in ColdFusion
Write standard ColdFusion data access code to connect to Supabase data.
-
How to Connect to Live Amazon Marketplace Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Amazon Marketplace data securely in real time.
-
Automated Continuous Microsoft Dataverse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to PostgreSQL.
-
Create Google Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Analytics data access from reports, embedded analytics, and more.
-
Connect to SparkPost Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SparkPost Data and connect to SparkPost data in Akorbi Digital RunMyProcess.
-
Connect to Sage 300 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sage 300 and the Script function in FileMaker Pro to connect to Sage 300 and work with Sage 300 data in your FileMaker application.
-
Connect to Elorus Data in HULFT Integrate
Connect to Elorus as a JDBC data source in HULFT Integrate
-
Integrating Antigravity CLI with Printful data via CData CLI
Connect Printful data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build SurveyMonkey-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SurveyMonkey Data from Zoho Analytics and import live SurveyMonkey data.
-
LINQ to Gong 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 Gong Data Provider.
-
Connect to Hugging Face Data in RapidMiner
Integrate Hugging Face data with standard components and data source configuration wizards in RapidMiner Studio.
-
Import and Visualize ZohoDesk Data in Power View
Create data visualizations based on ZohoDesk data in Excel.
-
Connect to and Query Perplexity Data in QlikView over ODBC
Create data visualizations with Perplexity data in QlikView.
-
Connect to Customer.io Data in JRuby
Create a simple JRuby app with access to live Customer.io data.
-
Connect to Dynamics 365 from Asprova with CData Software ODBC Driver for Dynamics 365
This article shows how to connect faster to Dynamics 365 data from Asprova.
-
Getting Started with the CData SSIS Components for Google Ad Manager
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Ad Manager.
-
Automated Continuous Auth0 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Auth0 replication to Azure SQL Database.
-
LINQ to Close 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 Close Data Provider.
-
Use CData Sync to Replicate Data to Amazon S3
Use CData Sync to replicate enterprise data from more than 100 data sources to Amazon S3
-
Object-Relational Mapping (ORM) with Recurly 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 Recurly data into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Email 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 Email data for you.
-
Automated Continuous Avro Replication to SQL Server
Use CData Sync for automated, continuous, customizable Avro replication to SQL Server.
-
View Reports on Real-Time Redis Data in Power BI Report Server
Use the CData ODBC Driver for Redis to visualize Redis data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Coda Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Coda data from Informatica Cloud.
-
Build Visualizations of Quaderno Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Quaderno data in Birst.
-
How to publish and share Sybase IQ Data dashboards with Tableau Server
The CData ODBC driver for Sybase IQ enables you integrate Sybase IQ data into Tableau dashboards.
-
Use the CData Software ODBC Driver for Quaderno in SAS for Real-Time Reporting and Analytics
Connect to real-time Quaderno data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Quaderno.
-
Query, Visualize, and Share live Vault CRM Data in Redash
Use CData Connect AI to connect to live Vault CRM data in Redash for querying, visualizing, and sharing.
-
Use Agno to Talk to Your Salesloft 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 Salesloft data for you.
-
How to Connect Facebook Ads 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 Facebook Ads data in real time using natural language.
-
How to Visualize Email Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Email data in Python.
-
Create Coda-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Coda Data from Klipfolio and build custom visualizations using live Coda data.
-
Create Shopify-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Shopify Data from Klipfolio and build custom visualizations using live Shopify data.
-
Connect to Demio Data in DBeaver
Use the CData ODBC Driver to connect to Demio data in DBeaver.
-
How to integrate JotForm with Apache Airflow
Access and process JotForm data in Apache Airflow using the CData JDBC Driver.
-
Migrating data from Microsoft Planner to Snowflake using CData SSIS Components.
Easily push Microsoft Planner data to Snowflake using the CData SSIS Tasks for Microsoft Planner and Snowflake.
-
Create Informatica Mappings From/To a JDBC Data Source for Power BI XMLA
Create Power BI XMLA data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Amazon Athena Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Amazon Athena data and visualize Amazon Athena data in SAP Analytics Cloud.
-
Use Microsoft Copilot Studio to talk to your ConstantContact 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 ConstantContact data for you.
-
Integrate HubDB Data into Power Automate Desktop using CData Connect
CData Connect for HubDB Data enables you to integrate HubDB data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Trae with Live ZohoSubscriptions Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoSubscriptions data from within the AI-powered IDE.
-
Create Bitbucket Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Bitbucket data access from reports, embedded analytics, and more.
-
Build a PostgreSQL Interface for ChargeOver Data using the CData JDBC Driver
Use the Remoting features of the ChargeOver JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Reporting in OBIEE with the Excel JDBC Driver
Deploy the Excel JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Gong Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Gong replication to Apache Cassandra.
-
Getting Started with the CData ADO.NET Provider for Hive
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Hive.
-
How to connect to Odoo Data in DBVisualizer
Integrate Odoo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Trigger Dynamics 365 Business Central IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dynamics 365 Business Central with standard wizards in Logic Apps.
-
Use Agno to Talk to Your Avalara AvaTax 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 Avalara AvaTax data for you.
-
Build Automated Workflows with Live Dropbox Data in Workato
Use CData Connect AI to connect to live Dropbox data and build automated workflows in Workato.
-
Getting Started with the CData ODBC Driver for SageHR
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SageHR.
-
Build MVC Applications with Connectivity to Auth0 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Auth0 from an ASP.NET MVC application.
-
Integrating LlamaIndex with ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ServiceNow data in real time.
-
Connect to and Visualize Live Short.io Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Short.io data.
-
Integrate Live Google Ad Manager 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 Google Ad Manager data from within the IDE.
-
How to connect to Google Analytics Data from IntelliJ
Integrate connectivity to Google Analytics data with wizards in IntelliJ.
-
Migrating data from WordPress to Databricks using CData SSIS Components.
Easily push WordPress data to Databricks using the CData SSIS Tasks for WordPress and Databricks.
-
Use the CData Software ODBC Driver for Dropbox in MicroStrategy
Connect to Dropbox data in MicroStrategy Developer using the CData Software ODBC Driver for Dropbox.
-
Connect to Yelp Data in CloverDX (formerly CloverETL)
Transfer Yelp data using the visual workflow in the CloverDX data integration tool.
-
How to Connect to ScrapingBee Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ScrapingBee data. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Brex Data from Spring Boot
Connect to Brex in a Spring Boot Application using the CData API Driver for JDBC
-
Connect Timely to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Timely with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Claude Code CLI with Tavily 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.
-
Automated Continuous Parallel Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Parallel replication to Apache Kafka.
-
Connect to Pinecone Data in HULFT Integrate
Connect to Pinecone as a JDBC data source in HULFT Integrate
-
How to Easily Query Wrike Data in OpenOffice Base
Connect to Wrike data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Campaign Manager 360
Provide connectivity to Google Campaign Manager 360 data through an SAP BusinessObjects universe.
-
Automated Continuous Ontraport Replication to Databricks
Use CData Sync for automated, continuous, customizable Ontraport replication to Databricks.
-
How to Query Couchbase Data in MySQL Workbench
Execute MySQL queries against live Couchbase data from MySQL Workbench.
-
Build Semantic Layer Views for Marketo Data in APOS Live Data Gateway
Use the CData Connector for Marketo in APOS Live Data Gateway to build Semantic Layer Views for Marketo data.
-
Automated Continuous SurveyMonkey Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to IBM DB2.
-
Create Vercel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Vercel data access from reports, embedded analytics, and more.
-
How to Access Mistral AI Data Using Entity Framework
This article shows how to access Mistral AI data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Model Microsoft Dataverse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Dataverse, enabling the direct import of real-time Microsoft Dataverse data.
-
Build Oracle Eloqua-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Eloqua data.
-
Automated Continuous ConstantContact Replication to Oracle
Use CData Sync for automated, continuous, customizable ConstantContact replication to Oracle.
-
Design BIRT Reports on Telegram Data
Provide current Telegram data to your embedded analytics.
-
Write a Simple Go Application to work with Cassandra Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cassandra data.
-
Build BigCommerce-Connected Apps in Choreo
Use CData Connect AI to connect to BigCommerce Data from Choreo and build custom apps using live BigCommerce data.
-
Access Live Pipedrive Data in Excel 365 Online (Excel for the web)
Connect to Pipedrive data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Feed LinkedIn Ads Data into FineReport
How to set LinkedIn Ads data as a JDBC data source in FineReport.
-
Use Databricks Agent Bricks to Talk to Your Act CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Act CRM data for you.
-
Connect to Stripe Data in JRuby
Create a simple JRuby app with access to live Stripe data.
-
How to Connect to Wistia Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wistia data. Leverage the pyodbc module for ODBC in Python.
-
Create Exact Online Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Exact Online from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Microsoft OneDrive Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft OneDrive data from your Excel spreadsheets.
-
Use Dash to Build Web Apps on Mailjet Data via CData Connect AI
Build interactive Dash web apps on live Mailjet data using pandas and the CData Connect AI Python SDK.
-
Build Semantic Layer Views for Instagram Data in APOS Live Data Gateway
Use the CData Connector for Instagram in APOS Live Data Gateway to build Semantic Layer Views for Instagram data.
-
How to Build an ETL App for Gong Data in Python with CData
Create ETL applications and real-time data pipelines for Gong data in Python with petl.
-
Use the CData Software ODBC Driver for RSS in SAS for Real-Time Reporting and Analytics
Connect to real-time RSS feeds in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for RSS.
-
Build Apps with Live ServiceDesk Plus Data Using the Low-Code Development Platform of Mendix
Connect ServiceDesk Plus data with Mendix to build apps using the CData API Driver for JDBC.
-
Work with Amazon Athena Data in FoxPro
Load Amazon Athena data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build an OLAP Cube in SSAS from HDFS Data
Establish a connection to HDFS data data from SQL Server Analysis Services, and use the HDFS Data Provider to build OLAP cubes for use in analytics and reporting.