CData Software - Knowledge Base
Recent Articles
-
Integrate Scrapfly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Scrapfly from Informatica Cloud.
-
Publish Crystal Reports on Google Tasks Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Tasks.
-
How to Work with Microsoft Ads Data in ETL Validator JDBC
Connect to Microsoft Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Access PagerDuty Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PagerDuty from your Oracle system.
-
How to use SQLAlchemy ORM to access Timely Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Timely.
-
Migrating data from CouchDB to Google BigQuery using CData SSIS Components.
Easily push Apache CouchDB to Google BigQuery using the CData SSIS Tasks for CouchDB and Google BigQuery.
-
Use the CData ODBC Driver for Lakebase in Microsoft Power Query
You can use the CData Lakebase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Lakebase into Microsoft Power Query.
-
Integrate Real-Time Access to Monday.com in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Monday.com in real time.
-
Connect to Freshsales Data in NetBeans
Connect to Freshsales in NetBeans with the data source configuration wizard.
-
Create Marketo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Marketo Data from Klipfolio and build custom visualizations using live Marketo.
-
Connect to Phoenix Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apache Phoenix from Crystal Reports.
-
Harvest Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Harvest facts in real time.
-
Connect to Close in SpagoBI
Create reports featuring live Close in SpagoBI Studio. Host Close reports on SpagoBI Server.
-
Build Dashboards with Sugar CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sugar CRM in Dundas BI.
-
Creating Databricks-Connected Applications in Unqork
You can use CData Connect AI to feed Databricks to Unqork and build custom business apps.
-
Object-Relational Mapping (ORM) with Accelo 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 Accelo into a Java-based ORM framework, Hibernate.
-
How to Connect to & Open Azure Data Lake Storage Data in Microsoft Excel
This article uses the CData ODBC driver for Azure Data Lake Storage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create QuickBooks Online Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time QuickBooks Online data access from reports, embedded analytics, and more.
-
How to Create Power BI Visual Reports with Real-Time Accelo Data
Use CData Power BI Connectors to visualize Accelo in Power BI.
-
Build Azure DevOps-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure DevOps Data and create custom apps in Bubble.
-
Build Zoho Recruit-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Recruit.
-
Manage SAP Business One Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Business One.
-
Import Sage Cloud Accounting Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sage Cloud Accounting Data and provide access to live Sage Business Cloud Accounting for custom reports in the Power BI Service.
-
Prepare, Blend, and Analyze GraphQL Data in Alteryx Designer (Connect AI)
Build workflows to access live GraphQL for self-service data analytics.
-
Object-Relational Mapping (ORM) with Snowflake 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 Snowflake into a Java-based ORM framework, Hibernate.
-
How to Connect Flowise AI Agents to Live ADP 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 ADP without replication.
-
How to Query Live ActiveCampaign Data in Claude Desktop
Connect to and query live ActiveCampaign Data in Claude Desktop using CData MCP Server.
-
Create Data Visualizations in Cognos BI with SharePoint Data
Access Microsoft SharePoint as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect to Planio Data with Squirrel SQL client
Connect to Planio and execute queries in the Squirrel SQL Client.
-
How to connect to Instagram Data with Squirrel SQL client
Connect to Instagram and execute queries in the Squirrel SQL Client.
-
Publish Apify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apify.
-
Back Up Gong 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 Gong data.
-
How to connect to Scrapfly Data in DBVisualizer
Integrate Scrapfly with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Rootly Data in DBVisualizer
Integrate Rootly with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Zuora Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zuora and integrate live Zuora into your Power Automate tasks.
-
Getting Started with the CData SSIS Components for PayPal
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PayPal.
-
How to create an RPA flow for Oracle SCM Data in UiPath Studio
Use the Oracle SCM ODBC Driver to create workflows that access real-time Oracle SCM without any coding.
-
Analyze Sage Intacct Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage Intacct from Power Pivot. You will use the Table Import Wizard to load Sage Intacct. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Claude Code CLI with Oracle Eloqua 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 PayPal Replication to Snowflake
Use CData Sync for automated, continuous, customizable PayPal replication to Snowflake.
-
Connect to Jira Data in RazorSQL
Connect to Jira from wizards and query Atlassian Jira from the GUI in the RazorSQL database management tool.
-
Connect Zoom to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoom using the CData Python MCP Server.
-
Integrate Oracle Eloqua Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle Eloqua from Informatica Cloud.
-
Build Visualizations of Factorial Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Factorial in Birst.
-
DataBind Charts to Google Tasks Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Tasks 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.
-
Automated Continuous Active Directory Replication to SQL Server
Use CData Sync for automated, continuous, customizable Active Directory replication to SQL Server.
-
Stream Grafana Data into Apache Kafka Topics
Access and stream Grafana in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Mixpanel Data in ColdFusion
Write standard ColdFusion data access code to connect to Mixpanel.
-
How to connect and process Xero Accounting from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Xero Accounting.
-
Build Google Sheets-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Sheets Data and create custom apps in Mendix.
-
Access Live Oracle HCM Cloud Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle HCM Cloud data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous Samanage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Samanage replication to Apache Kafka.
-
Natively Connect to Contentful Data in PHP
The CData ODBC driver for Contentful enables you to create PHP applications with connectivity to Contentful. Leverage the native support for ODBC in PHP.
-
How to connect to Contentful Data from Spring Boot
Connect to Contentful in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Sage Intacct from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sage Intacct to connect to Sage Intacct from Web applications running on WebLogic.
-
Provide OData Services of Gmail Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Gmail by developing a WCF Service Application.
-
Getting Started with the CData Tableau Connector for DB2
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for DB2.
-
Automate SAP Fieldglass Data Replication to SAP HANA
Use CData Sync to customize and automate SAP Fieldglass replication to SAP HANA.
-
Build RabbitMQ-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live RabbitMQ.
-
Analyze Optimizely Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Optimizely in Microsoft R Open.
-
Create Oracle-Connected Applications in Appsmith
Connect to Oracle Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Database.
-
Integrate with WordPress Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy WordPress to a JSON file on disk.
-
Edit and Search ShipStation External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of ShipStation to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create ShipStation objects that you can access from apps and the dashboard.
-
Connect Google Translate to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Translate with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Perplexity Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Perplexity replication to Azure SQL Database.
-
Feed HBase Data into FineReport
How to set Apache HBase as a JDBC data source in FineReport.
-
Replicate Multiple FreshBooks Accounts via the CData Sync CLI
Replicate multiple FreshBooks accounts to one or many databases.
-
Automated Continuous Act-On Replication to Databricks
Use CData Sync for automated, continuous, customizable Act-On replication to Databricks.
-
Extract, Transform, and Load HelloSign Data in Informatica PowerCenter
Create a simple Workflow for HelloSign in Informatica PowerCenter.
-
Integrate Spark Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Spark SQL from Informatica Cloud.
-
Integrate Gmail with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Gmail with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Gmail.
-
Integrate TaxJar with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate TaxJar with External Services.
-
How to Connect to Live SingleStore Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SingleStore for you.
-
Operational Reporting on NetSuite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote NetSuite CRM & ERP.
-
Connect to Onfleet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Onfleet.
-
Connect to Power BI XMLA Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Power BI XMLA as an External Source in Dremio.
-
Automated Continuous Grafana Replication to SQL Server
Use CData Sync for automated, continuous, customizable Grafana replication to SQL Server.
-
Automated Continuous Pipedrive Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Pipedrive replication to Amazon S3.
-
A PostgreSQL Interface for Hubstaff Data (MySQL Remoting via JDBC)
Use the Remoting features of the Hubstaff JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Twilio Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Twilio Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Natively Connect to Snowflake Data in PHP
The CData ODBC driver for Snowflake enables you to create PHP applications with connectivity to Snowflake. Leverage the native support for ODBC in PHP.
-
Connecting Pipedream with Sybase 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 Sybase data in real time.
-
Bidirectional Access to Retently Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Retently in Filemaker Pro for Mac or Windows.
-
Extract, Transform, and Load Power BI XMLA Data in Informatica PowerCenter
Create a simple Workflow for Power BI XMLA in Informatica PowerCenter.
-
Work with Microsoft Ads Data in FoxPro
Load Microsoft Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesforce Pardot using the Model Context Protocol.
-
Create Data Visualizations in Cognos BI with ServiceNow Data
Access ServiceNow as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Back Up Adobe Target to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Adobe Target. In this article, we will employ an SSIS workflow to populate a database with Adobe Target data.
-
How to Connect to Live Apollo 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 Apollo through natural language.
-
Build Odoo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Odoo Data from Zoho Analytics and import live Odoo ERP.
-
Publish Crystal Reports on Lakebase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Lakebase.
-
Use the CData Software JDBC Driver for Email in MicroStrategy
Connect to Email in MicroStrategy Developer using the CData Software JDBC Driver for Email.
-
How to work with PayPal Data in Apache Spark using SQL
Access and process PayPal Data in Apache Spark using the CData Software JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Outlook Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Outlook to SQL Server.
-
Replicate Multiple SAP Ariba Source Accounts
Replicate multiple SAP Ariba Source accounts to one or many databases.
-
Hacker News Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Hacker News facts in real time.
-
Integrate with Mistral AI Data in JReport Designer
Create charts and reports based on Mistral AI in JReport Designer.
-
Use ChatGPT to Talk to Your Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apollo for you.
-
Create Datasets from Sage 200 in Domo Workbench and Build Visualizations of Sage 200 Data in Domo
Use the CData Software ODBC Driver for Sage 200 to create datasets from Sage 200 in Domo Workbench and then build visualizations in the Domo service.
-
Feed FTP Data into FineReport
How to set FTP Servers as a JDBC data source in FineReport.