CData Software - Knowledge Base
Recent Articles
-
Connect to Redshift Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon Redshift from Crystal Reports.
-
Automated Continuous Azure Data Lake Storage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to IBM DB2.
-
Rebilly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Rebilly facts in real time.
-
Build eBay-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for eBay to explore live eBay Data in Gemini Code Assist to assist with building eBay-powered applications.
-
Rapidly Develop WooCommerce-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 WooCommerce.
-
Build an OLAP Cube in SSAS from Pipeliner CRM Data
Establish a connection to Pipeliner CRM data from SQL Server Analysis Services, and use the Pipeliner CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create a Data Access Object for Microsoft Planner Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Planner in JDBI.
-
Automate Salesloft Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesloft replication to Azure Synapse.
-
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.
-
Connect to FHIR Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live FHIR from Filemaker Pro on Mac.
-
Access Live Dynamics CRM Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Dynamics CRM from Excel 365 Online (Excel for the web) with CData Connect AI.
-
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.
-
How to connect to Cassandra Data from Spring Boot
Connect to Cassandra in a Spring Boot Application using the CData JDBC Driver for Cassandra
-
Use the CData ODBC Driver for Drift from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Drift to connect to Drift from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Drift in Excel.
-
Connect to Amazon Marketplace Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Amazon Marketplace using standard SQL.
-
Integrate Hive Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apache Hive and integrate live Apache Hive into your Power Automate tasks.
-
Explore Geographical Relationships in Zoho Recruit Data with Power Map
Create data visualizations with Zoho Recruit in Power Map.
-
Integrating GitHub Copilot CLI with Tally ERP 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.
-
Moving Data from LionDesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LionDesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Crystal Reports on Samanage Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Samanage.
-
Working with Parallel Data in LINQPad
Execute LINQ queries to Parallel in LINQPad.
-
How to create an RPA flow for Browserless Data in UiPath Studio
Use the Browserless ODBC Driver to create workflows that access real-time Browserless without any coding.
-
Create Datasets from Oracle Eloqua in Domo Workbench and Build Visualizations of Oracle Eloqua Data in Domo
Use the CData Software ODBC Driver for Oracle Eloqua to create datasets from Oracle Eloqua in Domo Workbench and then build visualizations in the Domo service.
-
Automate FormSite Data Replication to Azure Synapse
Use CData Sync to customize and automate FormSite replication to Azure Synapse.
-
DataBind Controls to IBM Informix Data in Delphi
DataBind to IBM Informix in Delphi with standard data access components and controls.
-
DataBind Charts to JSON Services
Use the standard ADO.NET procedures for databinding to provide bidirectional access to JSON from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use the CData Software ODBC Driver for GraphQL in SAS for Real-Time Reporting and Analytics
Connect to real-time GraphQL in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for GraphQL.
-
Query QuickBooks Data from Node.js
Use the OData endpoint of the CData API Server to connect to your QuickBooks Desktop and perform CRUD operations on QuickBooks from Node.js.
-
How to create Templated federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Templated in MySQL .
-
Explore Geographical Relationships in Drift Data with Power Map
Create data visualizations with Drift in Power Map.
-
Integrate with PingOne Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PingOne to a JSON file on disk.
-
Create Dotmailer Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dotmailer data access from reports, embedded analytics, and more.
-
Analyze EnterpriseDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of EnterpriseDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
ETL Opsgenie in Oracle Data Integrator
This article shows how to transfer Opsgenie into a data warehouse using Oracle Data Integrator.
-
Create Dashboards and Visualize Live HubSpot Data in Geckoboard
Use CData Connect AI to connect to live HubSpot and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Stream Blackbaud FE NXT Data into Apache Kafka Topics
Access and stream Blackbaud FE NXT in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build SAP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP ERP/NetWeaver.
-
How to publish and share Facebook Data dashboards with Tableau Server
The CData ODBC driver for Facebook enables you integrate Facebook into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for DB2
Create an ODBC connection to DB2 in Informatica and browse and transfer IBM DB2.
-
Spark Reporting in OBIEE with the Spark JDBC Driver
Deploy the Spark JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to SAP Hybris C4C Data with Squirrel SQL client
Connect to SAP Hybris C4C and execute queries in the Squirrel SQL Client.
-
Connect and Query Live NetSuite SuiteAnalytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live NetSuite SuiteAnalytics into Databricks
-
How to Connect the Power BI Service to Supabase: Complete Guide
Connect to the CData Software Power BI Connector for Supabase from PowerBI.com to provide real-time Supabase across the organization.
-
Viewing Rootly Data in RAD Studio Data Explorer
How to view Rootly in RAD Studio Data Explorer using the CData ODBC Driver for Rootly.
-
Use Manus AI to Talk to Your ServiceNow 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 ServiceNow.
-
Access Live Sage Cloud Accounting Data in TIBCO Data Virtualization
Use the Sage Cloud Accounting Tibco DV Adapter to create a Sage Business Cloud Accounting data source in TIBCO Data Virtualization Studio and gain access to live Sage Business Cloud Accounting from your TDV Server.
-
Automated Continuous Clio Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Clio replication to delimited files (CSV/TSV).
-
Import Real-Time Hubstaff Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Hubstaff in ColdFusion.
-
Connect to Freshservice Data in DBArtisan
Use wizards in DBArtisan to configure Freshservice as a data source.
-
Automated Continuous Timely Replication to Vertica
Use CData Sync for automated, continuous, customizable Timely replication to Vertica.
-
Access Freshservice Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshservice from HeidiSQL.
-
Building Dynamic Web Pages with Salesloft Data Using AngularJS
Create single-page applications with live connectivity to Salesloft using the CData API Server.
-
Connect BigCommerce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect BigCommerce with IBM WebSphere for seamless data integration and connectivity.
-
Connect to MariaDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MariaDB in Airbyte.
-
Getting Started with the CData JDBC Driver for Cloudflare
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cloudflare.
-
How to Seamlessly Import WooCommerce Data into IBM SPSS Modeler
Integrate WooCommerce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SendGrid Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SendGrid from Filemaker Pro on Mac.
-
Integrate Delighted Data in Pentaho Data Integration
Build ETL pipelines based on Delighted in the Pentaho Data Integration tool.
-
Analyze Live API Data in SAS Viya
Use CData Connect AI to connect to API from SAS Viya and deploy self-service analytics using live API.
-
How to Connect to Live Google Ad Manager Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Ad Manager for you.
-
Use the CData Software ODBC Driver for Sendwithus in MicroStrategy
Connect to Sendwithus in MicroStrategy Developer using the CData Software ODBC Driver for Sendwithus.
-
Automated Continuous SAP Concur Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Concur replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Power BI Connector for Square
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Square.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SharePoint
Provide connectivity to Microsoft SharePoint through an SAP BusinessObjects universe.
-
How to connect to Printify Data from IntelliJ
Integrate connectivity to Printify with wizards in IntelliJ.
-
How to Visualize Discourse Data in Python with pandas
Use pandas and other modules to analyze and visualize live Discourse in Python.
-
Getting Started with the CData Tableau Connector for HubDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HubDB.
-
How to Connect SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data in real time using natural language.
-
Connect to Live QuickBooks Time Data in MicroStrategy through CData Connect AI
Create a live connection to QuickBooks Time Data in CData Connect AI and connect to your QuickBooks Time from MicroStrategy.
-
Create a Data Access Object for SAP Data using JDBI
A brief overview of creating a SQL Object API for SAP ERP/NetWeaver in JDBI.
-
Automated Continuous Azure Data Lake Storage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Apache Kafka.
-
How to integrate Greenplum with Apache Airflow
Access and process Pivotal GreenPlum in Apache Airflow using the CData JDBC Driver.
-
Connect to Cohere Data in Aqua Data Studio
Access Cohere from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Kintone-Connected Dashboards in Grafana
Connect to Kintone Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Kintone.
-
Access Live Tavily Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Tavily in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Semantic Layer Views for Workday Data in APOS Live Data Gateway
Use the CData Connector for Workday in APOS Live Data Gateway to build Semantic Layer Views for Workday.
-
Use the CData Software ODBC Driver for Exa in MicroStrategy
Connect to Exa in MicroStrategy Developer using the CData Software ODBC Driver for Exa.
-
Automated Continuous Google Search Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Search replication to Google BigQuery.
-
Use Databricks Agent Bricks to Talk to Your Zoom Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zoom for you.
-
How to Design Paylocity Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Paylocity from mobile and tablet Power Apps.
-
Automated Continuous Marketo Replication to Databricks
Use CData Sync for automated, continuous, customizable Marketo replication to Databricks.
-
Create Power BI Reports on Real-Time Dynamics NAV Data
Use the CData ODBC Driver for Dynamics NAV to visualize Microsoft Dynamics NAV in Power BI Desktop.
-
Create Hubstaff Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Hubstaff from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate Microsoft Entra ID Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Entra ID and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Ontraport Replication to SQL Server
Use CData Sync for automated, continuous, customizable Ontraport replication to SQL Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage Cloud Accounting
Create an ODBC connection to Sage Cloud Accounting in Informatica and browse and transfer Sage Business Cloud Accounting.
-
DataBind CSV Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for CSV with the DevExpress Windows Forms and Web controls to provide CSV/TSV Files to a chart.
-
Automated Continuous Oracle Financials Cloud Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to PostgreSQL.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live BigCommerce within intelligent workflows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Okta
Provide connectivity to Okta through an SAP BusinessObjects universe.
-
Automated Continuous Cvent Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Cvent replication to Amazon Redshift.
-
How to Work with Marketo Data in AWS Glue Jobs Using JDBC
Connect to Marketo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Perigon Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Perigon as an External Source in Dremio.
-
Zoho Projects Reporting in OBIEE with the Zoho Projects JDBC Driver
Deploy the Zoho Projects JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Salesforce Data to SAP Datasphere with CData Sync
Use CData Sync to replicate Salesforce data into SAP Datasphere via SAP HANA.
-
Build Visualizations of Vercel Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Vercel in Birst.
-
Build a PostgreSQL Interface for MarkLogic Data using the CData JDBC Driver
Use the Remoting features of the MarkLogic JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Create Power BI Visual Reports with Real-Time LightSpeedRetail Data
Use CData Power BI Connectors to visualize LightSpeedRetail in Power BI.
-
Automated Continuous Acumatica Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Cassandra.
-
Integrate SAP Concur with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Concur with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Concur.