CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Procore in Domo Workbench and Build Visualizations of Procore Data in Domo
Use the CData Software ODBC Driver for Procore to create datasets from Procore data in Domo Workbench and then build visualizations in the Domo service.
-
Create ZohoDesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoDesk data access from reports, embedded analytics, and more.
-
Automated Continuous LaunchDarkly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Google BigQuery.
-
Write a Simple Go Application to work with Insightly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Insightly data.
-
Automated Continuous Sage Cloud Accounting Replication to MySQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MySQL.
-
Getting Started with the CData Power BI Connector for Qualaroo
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Bugsnag Replication to MySQL
Use CData Sync for automated, continuous, customizable Bugsnag replication to MySQL.
-
Automated Continuous Salesloft Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesloft replication to Databricks.
-
View Reports on Real-Time Rebilly Data in Power BI Report Server
Use the CData ODBC Driver for Rebilly to visualize Rebilly data in Power BI Desktop and then publish them to Power BI Report Server.
-
Model Instagram Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Instagram, enabling the direct import of real-time Instagram data.
-
Work with Dynamics CRM Data in FoxPro
Load Dynamics CRM data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Oracle SCM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle SCM as an External Source in Dremio.
-
Automated Continuous Outreach.io Replication to SQLite
Use CData Sync for automated, continuous, customizable Outreach.io replication to SQLite.
-
Getting Started with the CData SSIS Components for HBase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HBase.
-
Visualize Live Twitter Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Twitter Ads data into custom reports in Power BI.
-
Analyze Google Sheets Data in Cognos Analytics
Use CData Connect AI to connect to Google Sheets Data from Cognos Analytics and analyze live Google Sheets data.
-
Connect to Real-Time HelloSign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use HelloSign data in Power Apps.
-
Connect to Zoho Inventory Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zoho Inventory data in Airbyte.
-
Create SSAS Tabular Models from Nethunt Data
How to build a SQL Server Analysis Service Tabular Model from Nethunt data using CData drivers.
-
Use JayDeBeApi to access SAP Hybris C4C Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP Hybris C4C data.
-
Connect to SAS xpt from Asprova with CData Software ODBC Driver for SAS xpt
This article shows how to connect faster to SAS xpt data from Asprova.
-
DataBind Printify Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Printify data to a chart.
-
How to Connect to Live GetResponse 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 GetResponse data for you.
-
Integrate Supabase Data in the Pentaho Report Designer
Publish reports based on Supabase data in the Pentaho BI tool.
-
Publish Sage 300-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sage 300 data.
-
Connecting Moonlit Workflow with Asana 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 Asana data in real time.
-
Prepare, Blend, and Analyze Anaplan Data in Alteryx Designer (ODBC)
Build workflows to access live Anaplan data for self-service data analytics.
-
Access Google Ad Manager Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Ad Manager data from HeidiSQL.
-
Deploy the ADO.NET Provider for Spotify on an SSRS Report Server
Connect to Spotify 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.
-
Edit and Search External EnterpriseDB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of EnterpriseDB data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create EnterpriseDB Data objects that you can access from apps and the dashboard.
-
Connect to Instantly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Instantly data in the Denodo Virtual DataPort Administrator.
-
How to integrate LDAP with Apache Airflow
Access and process LDAP objects in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for Redshift Data (MySQL Remoting via JDBC)
Use the Remoting features of the Redshift JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Adobe Commerce Data from Crystal Reports
Use CData Connect AI to connect to and report on live Adobe Commerce data from Crystal Reports.
-
Analyze ScrapingBee Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ScrapingBee from Power Pivot. You will use the Table Import Wizard to load ScrapingBee data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData ODBC Driver for Superchat
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Superchat.
-
Integrate Google's Vertex AI Agent with Live Mailgun 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 Mailgun data within intelligent workflows.
-
Use Dash to Build to Web Apps on Elasticsearch Data
Create Python applications that use pandas and Dash to build Elasticsearch-connected web apps.
-
Connect to DB2 Data in DBeaver
Use the CData ODBC Driver to connect to DB2 data in DBeaver.
-
Automated Continuous Google Contacts Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Contacts replication to Amazon S3.
-
Automated Continuous Cohere Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Cohere replication to Apache Cassandra.
-
Bidirectional Access to MongoDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MongoDB data in Filemaker Pro for Mac or Windows.
-
Object-Relational Mapping (ORM) with GitLab 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 GitLab data into a Java-based ORM framework, Hibernate.
-
Integrate Cline with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Monday.com data from within your IDE.
-
Visualize Live Box Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Box data.
-
Automate Float Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Float data from PowerShell? This article demonstrates how to utilize the Float Cmdlets for tasks like connecting to Float data, automating operations, downloading data, and more.
-
Connect to Google Drive Data from AWS Glue
Use CData Connect AI to gain access to live Google Drive data from your AWS Glue jobs.
-
Build Dashboards with Superchat Data in DBxtra
Create dynamic dashboards and perform analytics based on Superchat data in DBxtra.
-
DataBind ZendeskSell Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZendeskSell data to a chart.
-
Create JobNimbus Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time JobNimbus data access from reports, embedded analytics, and more.
-
Build Automated Workflows with Live ZohoInvoice Data in Workato
Use CData Connect AI to connect to live ZohoInvoice data and build automated workflows in Workato.
-
Use the CData ODBC Driver for ZeroBounce in Microsoft Power Query
You can use the CData ZeroBounce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZeroBounce data into Microsoft Power Query.
-
Connect to RSS Feeds as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live RSS feeds.
-
How to Create Power BI Visual Reports with Real-Time Couchbase Data
Use CData Power BI Connectors to visualize Couchbase data in Power BI.
-
Build AI Agents with Freshdesk 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 Freshdesk data through CData Connect AI.
-
How to Easily Query SageHR Data in OpenOffice Base
Connect to SageHR data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software JDBC Driver for TaxJar in MicroStrategy Desktop
Connect to TaxJar data in MicroStrategy Desktop using the CData Software JDBC Driver for TaxJar.
-
Build Zuora-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 Zuora data without replication.
-
Feed Zoho CRM Data into FineReport
How to set Zoho CRM data as a JDBC data source in FineReport.
-
Integrate Redis Data into Power Automate Desktop using CData Connect
CData Connect for Redis Data enables you to integrate Redis data into workflows built using Microsoft Power Automate Desktop.
-
How to connect Amazon QuickSight to ServiceNow Data
Create a connection to ServiceNow data in CData Connect AI and insert ServiceNow data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Cloudflare Data in RazorSQL
Connect to Cloudflare from wizards and query Cloudflare data from the GUI in the RazorSQL database management tool.
-
Prepare, Blend, and Analyze QuickBooks Data in Alteryx Designer (ODBC)
Build workflows to access live QuickBooks data for self-service data analytics.
-
Moving Data from Quaderno to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Quaderno data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Search External SageHR Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SageHR data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SageHR Data objects that you can access from apps and the dashboard.
-
Connect Power BI XMLA to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Power BI XMLA data using the CData Python MCP Server.
-
Migrating data from IBM Informix to Databricks using CData SSIS Components.
Easily push IBM Informix data to Databricks using the CData SSIS Tasks for IBM Informix and Databricks.
-
Create Webex Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Webex data access from reports, embedded analytics, and more.
-
Create Data Visualizations in Cognos BI with Airtable Data
Access Airtable data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Query ConstantContact Data in QlikView over ODBC
Create data visualizations with ConstantContact data in QlikView.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Dataverse
Create an ODBC connection to Microsoft Dataverse in Informatica and browse and transfer Microsoft Dataverse data.
-
Connect Spotify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Spotify data using the CData Python MCP Server.
-
Connect and Visualize Live Reckon Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Reckon data into the Databricks platform and create visualization dashboards with real-time Reckon data.
-
Build a Simple VCL Application for Elasticsearch Data
How to build a simple VCL Application to view Elasticsearch data in RAD Studio using the CData ODBC Driver for Elasticsearch.
-
How to Query Live Facebook Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Facebook Ads data data in natural language using Python.
-
Build Semantic Layer Views for Sage 200 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sage 200 data.
-
Query Slack Data in DataGrip
Create a Data Source for Slack in DataGrip and use SQL to query live Slack data.
-
Build Apps with Live QuickBooks data in Adalo using CData Connect AI
Use CData Connect AI to integrate live QuickBooks data into the Adalo platform and build custom mobile and web applications with real-time QuickBooks data.
-
How to integrate Metabase with Freshdesk Data
Use CData Connect AI to connect to live Freshdesk data and create an interactive dashboard in Metabase from Freshdesk data.
-
View Reports on Real-Time Grafana Data in Power BI Report Server
Use the CData ODBC Driver for Grafana to visualize Grafana data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot with HelloSign 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 GraphQL 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 GraphQL data through MCP integration.
-
Build Semantic Layer Views for Sage Intacct Data in APOS Live Data Gateway
Use the CData Connector for Sage Intacct in APOS Live Data Gateway to build Semantic Layer Views for Sage Intacct data.
-
Create Dynamic Front Grids Using the Infragistics XamDataGrid
Learn how you can connect Front to Infragistics XamDataGrid to build dynamic grids.
-
Rapidly Develop Sage Cloud Accounting-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 Sage Cloud Accounting.
-
Automate Exa Data Replication to SAP HANA
Use CData Sync to customize and automate Exa data replication to SAP HANA.
-
Access Live GraphQL Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GraphQL data into the statistical analysis tools available in SAS JMP. This article shows how to use GraphQL data in the Graph Builder and Query Builder.
-
Replicate Multiple Phoenix Accounts
Replicate multiple Phoenix accounts to one or many databases.
-
Visualize Freshsales Data in Sisense
Create an ElastiCube in Sisense app with access to Freshsales data.
-
How to create Visio diagrams from MYOB AccountRight Data
Automatically update MYOB AccountRight data with the changes you make to Visio master shapes.
-
How to create an RPA flow for Pipeline CRM Data in UiPath Studio
Use the Pipeline CRM ODBC Driver to create workflows that access real-time Pipeline CRM data without any coding.
-
How to Access Live Attio Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Attio enables you to integrate Attio data into workflows built using Microsoft Power Automate Desktop.
-
A PostgreSQL Interface for JSON Services using the CData ODBC Driver
Use the SQL Gateway and JSON ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Google Sheets Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Sheets data in SnapLogic.
-
Create SingleStore-Connected Nintex Workflows
Use CData Connect AI to connect to SingleStore Data from Nintex Workflow Cloud and build custom workflows using live SingleStore data.
-
Rapidly Develop Zendesk-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 Zendesk.
-
Getting Started with the CData ODBC Driver for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Commerce.
-
How to use SQLAlchemy ORM to access Adobe Commerce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Adobe Commerce data.
-
Build Agents in Relevance AI with Access to Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Redis data within intelligent agent workflows.
-
Automated Continuous Postmark Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Postmark replication to AlloyDB.