CData Software - Knowledge Base
Recent Articles
-
How to import FTP Data into Apache Solr
Use the CData Software JDBC Driver for FTP in Data Import Handler and create an automated import of FTP data to Apache Solr Enterprise Search platform.
-
Automated Oracle Financials Cloud Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Financials Cloud data replication to Teradata.
-
Connect to Zuora Data from PowerBuilder via JDBC
This article demonstrates how to access Zuora data from PowerBuilder using the Zuora JDBC Driver.
-
How to work with Dropbox Data in Apache Spark using SQL
Access and process Dropbox Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous ConvertKit Replication to Vertica
Use CData Sync for automated, continuous, customizable ConvertKit replication to Vertica.
-
Stream ClickUp Data into Apache Kafka Topics
Access and stream ClickUp data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Multiple SAP Netweaver Gateway Accounts
Replicate multiple SAP Netweaver Gateway accounts to one or many databases.
-
Import Real-Time XML Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use XML data in ColdFusion.
-
Connect to Sugar CRM Data in HULFT Integrate
Connect to Sugar CRM as a JDBC data source in HULFT Integrate
-
Import Real-Time Mixpanel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mixpanel data in ColdFusion.
-
How to Connect to Live Facebook Ads 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 Facebook Ads data for you.
-
Create xBase-Connected Applications in Appsmith
Connect to xBase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to xBase data.
-
Replicate CloudConvert Data to Multiple Databases via the CData Sync CLI
Replicate CloudConvert data to disparate databases with a single configuration.
-
How to Connect to & Open PostgreSQL Data in Microsoft Excel
This article uses the CData ODBC driver for PostgreSQL to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Act CRM Data in Talend Cloud Data Management Platform
Connect Act CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Act CRM.
-
Connect to Float Data in DBeaver
Use the CData ODBC Driver to connect to Float data in DBeaver.
-
Build a PostgreSQL Interface for HDFS Data using the CData JDBC Driver
Use the Remoting features of the HDFS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up Cloudant data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cloudant. In this article, we will employ an SSIS workflow to populate a database with Cloudant data data.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams data for you.
-
Integrating Kiro with Mailgun 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.
-
Connect to Typeform Data in Aqua Data Studio
Access Typeform data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Cursor with Azure Data Lake Storage 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.
-
Parallel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Parallel facts in real time.
-
Access Live Gumroad Data in Coginiti Pro
Connect to and query live Gumroad data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect SharePoint with Snapchat Ads Data through external lists
Provide Snapchat Ads data to SharePoint users as an external list.
-
How to Connect to Live SQL Analysis Services Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SQL Analysis Services data securely in real time.
-
Natively Connect to Reply.io Data in PHP
The CData ODBC driver for Reply.io enables you to create PHP applications with connectivity to Reply.io data. Leverage the native support for ODBC in PHP.
-
Manage Dynamics 365 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dynamics 365.
-
Visualize Freshservice Data in TIBCO Spotfire through ADO.NET
Integrate Freshservice data into dashboards in TIBCO Spotfire.
-
Prepare, Blend, and Analyze DB2 Data in Alteryx Designer (Connect AI)
Build workflows to access live DB2 data for self-service data analytics.
-
Enable the ADP JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ADP data.
-
Connect to Live Google Forms Data in MicroStrategy through CData Connect AI
Create a live connection to Google Forms Data in CData Connect AI and connect to your Google Forms data from MicroStrategy.
-
Automate Box Data Replication to Azure Synapse
Use CData Sync to customize and automate Box data replication to Azure Synapse.
-
Build a PostgreSQL Interface for PostgreSQL Data using the CData JDBC Driver
Use the Remoting features of the PostgreSQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access PabblySubscriptions Data from MySQL in Amazon QuickSight
Connect to PabblySubscriptions and build visualizations of PabblySubscriptions data using a MySQL Connection in Amazon QuickSight.
-
Object-Relational Mapping (ORM) with ZarMoney 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 ZarMoney data into a Java-based ORM framework, Hibernate.
-
Migrating data from Superchat to Snowflake using CData SSIS Components.
Easily push Superchat data to Snowflake using the CData SSIS Tasks for Superchat and Snowflake.
-
How to connect to Codat Data from IntelliJ
Integrate connectivity to Codat data with wizards in IntelliJ.
-
How to import ConvertKit Data into Apache Solr
Use the CData Software JDBC Driver for ConvertKit in Data Import Handler and create an automated import of ConvertKit data to Apache Solr Enterprise Search platform.
-
How to Connect to Live Dynamics NAV Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Dynamics NAV data without replication.
-
How to Connect to Live FHIR Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live FHIR data securely in real time.
-
Integrate Goose with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live NetSuite data from within the local AI agent.
-
Connect to IBM Cloud Object Storage Data from a Connection Pool in JBoss
Integrate IBM Cloud Object Storage data into Java servlets: Use the Management Console in JBoss to install the IBM Cloud Object Storage JDBC Driver.
-
Integrate Placid with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Placid with External Services.
-
Connect to Google Calendar Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Calendar data from Filemaker Pro on Mac.
-
Getting Started with the CData Excel Add-In for Timely
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Timely.
-
Create Informatica Mappings From/To an ODBC Data Source for Harvest
Create an ODBC connection to Harvest in Informatica and browse and transfer Harvest data.
-
Create a Data Access Object for Codat Data using JDBI
A brief overview of creating a SQL Object API for Codat data in JDBI.
-
DataBind Controls to SuiteCRM Data in Delphi
DataBind to SuiteCRM data in Delphi with standard data access components and controls.
-
How to Seamlessly Import Hugging Face Data into IBM SPSS Modeler
Integrate Hugging Face data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create SAP HANA XS Advanced-Connected Nintex Workflows
Use CData Connect AI to connect to SAP HANA XS Advanced Data from Nintex Workflow Cloud and build custom workflows using live SAP HANA XS Advanced data.
-
Connect to Amazon DynamoDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon DynamoDB as an External Source in Dremio.
-
Automate Oracle Eloqua Reporting Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle Eloqua Reporting data replication to SAP HANA.
-
LINQ to Printify 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 Printify Data Provider.
-
Access Live Paddle Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Paddle data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Live Zendesk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zendesk in CData Connect AI and connect to your Zendesk data from PostgreSQL.
-
Connect to Exact Online Data from a Connection Pool in Jetty
The Exact Online JDBC Driver supports connection pooling: This article shows how to connect faster to Exact Online data from Web apps in Jetty.
-
Publish Epicor Kinetic-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Epicor Kinetic data.
-
Design BIRT Reports on Redshift Data
Provide current Redshift data to your embedded analytics.
-
How to Easily Query Vimeo Data in OpenOffice Base
Connect to Vimeo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Work with ScrapingBee Data in ETL Validator JDBC
Connect to ScrapingBee from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for Egnyte
Install the CData Connect AI Python SDK to read live Egnyte data with standard DB-API 2.0 Python code.
-
Automated Continuous Todoist Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Todoist data replication to OneLake in Microsoft Fabric.
-
Integrating Office 365 Data in Talend Cloud Data Management Platform
Connect Office 365 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Office 365.
-
How to Connect to Sage 300 Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sage 300 data. Leverage the pyodbc module for ODBC in Python.
-
Replicate Mouseflow Data from PowerShell
Write a quick PowerShell script to query Mouseflow data. Use connectivity to the live data to replicate Mouseflow data to SQL Server.
-
Provide OData Services of Ontraport Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Ontraport data by developing a WCF Service Application.
-
Visualize Live DB2 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live DB2 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from SQL Server to Avalara AvaTax through SSIS
Easily push SQL Server data to Avalara AvaTax using the CData SSIS Tasks for Avalara AvaTax.
-
Build AgileCRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to AgileCRM Data from Zoho Analytics and import live AgileCRM data.
-
Connecting Mastra with SAP Ariba Source Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP Ariba Source data, no replication required.
-
Vimeo Reporting in OBIEE with the Vimeo JDBC Driver
Deploy the Vimeo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Cline with Live Tally Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Tally data from within your IDE.
-
How to Connect to Live Active Directory 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 Active Directory data for you.
-
Choosing the Best Method to Connect AdRoll to SQL Server: 5 Options Explained
Discover multiple ways to connect and use AdRoll data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to QuickBooks Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live QuickBooks data from Filemaker Pro on Mac.
-
Automated Continuous FHIR Replication to SQLite
Use CData Sync for automated, continuous, customizable FHIR replication to SQLite.
-
Build Charts with Zoho Creator Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoho Creator data in Clear Analytics.
-
Analyze Google Cloud Storage Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Cloud Storage data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to SAP SuccessFactors LMS from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS data from Web applications running on WebLogic.
-
Feed Neo4J Data into FineReport
How to set Neo4J data as a JDBC data source in FineReport.
-
Connect to Impala Data in JRuby
Create a simple JRuby app with access to live Impala data.
-
View Reports on Real-Time Google Campaign Manager 360 Data in Power BI Report Server
Use the CData ODBC Driver for Google Campaign Manager 360 to visualize Google Campaign Manager 360 data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Grok to Talk to Your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your FHIR data for you.
-
Analyze Salesforce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce data in Microsoft R Open.
-
Connect to Phoenix Data in HULFT Integrate
Connect to Phoenix as a JDBC data source in HULFT Integrate
-
Visualize Live HelloSign Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HelloSign data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to XML Data in Google Apps Script via Connect AI
Use CData Connect AI to access XML data in Google Apps Script.
-
Use Agno to Talk to Your Google Sheets 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 Google Sheets data for you.
-
How to connect to Oracle Service Cloud Data with Squirrel SQL client
Connect to Oracle Service Cloud data and execute queries in the Squirrel SQL Client.
-
Import Real-Time Sendwithus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sendwithus data in ColdFusion.
-
Use JayDeBeApi to access ZohoSubscriptions Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoSubscriptions data.
-
Build Apps with Live Contentful Data Using the Low-Code Development Platform of Mendix
Connect Contentful data with Mendix to build apps using the CData API Driver for JDBC.
-
Create CapsuleCRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to CapsuleCRM Data from OutSystems and build custom enterprise apps using live CapsuleCRM data.
-
How to load Todoist data into Elasticsearch via Logstash
Introducing a simple method to load Todoist data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate GitHub with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate GitHub with External Services.
-
Build a Simple VCL Application for JobNimbus Data
How to build a simple VCL Application to view JobNimbus data in RAD Studio using the CData ODBC Driver for JobNimbus.
-
Automated Continuous FormSite Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable FormSite replication to Google Cloud SQL.
-
Access Redshift Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Redshift data.
-
Use the CData ODBC Driver for MarkLogic in Microsoft Power Query
You can use the CData MarkLogic ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MarkLogic data into Microsoft Power Query.