CData Software - Knowledge Base
Recent Articles
-
Integrate Google Tasks with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Tasks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Tasks data.
-
Use ChatGPT to Talk to Your Exact Online 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 Exact Online data for you.
-
Integrating Rebilly Data in Talend Cloud Data Management Platform
Connect Rebilly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Migrating data from Drip to Snowflake using CData SSIS Components.
Easily push Drip data to Snowflake using the CData SSIS Tasks for Drip and Snowflake.
-
Explore Geographical Relationships in Microsoft Entra ID Data with Power Map
Create data visualizations with Microsoft Entra ID data in Power Map.
-
Connect to AlloyDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for AlloyDB and the Script function in FileMaker Pro to connect to AlloyDB and work with AlloyDB data in your FileMaker application.
-
Automated Continuous Cassandra Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Cassandra replication to Google BigQuery.
-
Publish MariaDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MariaDB data.
-
Create Google Forms-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Forms Data from OutSystems and build custom enterprise apps using live Google Forms data.
-
Provide OData Services of AgileCRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for AgileCRM data by developing a WCF Service Application.
-
Integrating GitHub Copilot with Zoho Projects 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.
-
Integrate Lakebase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Lakebase data from Informatica Cloud.
-
Getting Started with the CData JDBC Driver for Act-On
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Act-On.
-
Connect to Reckon Accounts Hosted Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon Accounts Hosted data.
-
Import Reckon Accounts Hosted Data Using Azure Data Factory
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Azure Data Factory and import live Reckon Accounts Hosted data.
-
Create Microsoft Planner Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Planner from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Certinia Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Certinia data and integrate live Certinia data into your Power Automate tasks.
-
Connect to eBay Data in Aqua Data Studio
Access eBay data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Oracle Sales Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Sales replication to SQLite.
-
Create SSAS Tabular Models from HDFS Data
How to build a SQL Server Analysis Service Tabular Model from HDFS data using CData drivers.
-
Build Dashboards with Zoho Recruit Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Recruit data in Dundas BI.
-
Automated Continuous Greenhouse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Greenhouse replication to Apache Kafka.
-
Build AI/ML Models with Live Google Contacts Data using Dataiku
Connect Google Contacts Data with Dataiku using the CData JDBC Driver for Google Contacts.
-
Analyze SingleStore Data in Cognos Analytics
Use CData Connect AI to connect to SingleStore Data from Cognos Analytics and analyze live SingleStore data.
-
Use Databricks Agent Bricks to Talk to Your Instagram Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Instagram data for you.
-
Connect to Salesforce Marketing Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce Marketing data from Crystal Reports.
-
Build Zoho Projects-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Projects Data and create custom apps in Mendix.
-
Build a Simple VCL Application for SQL Server Data
How to build a simple VCL Application to view SQL Server data in RAD Studio using the CData ODBC Driver for SQL Server.
-
View Reports on Real-Time Pinterest Data in Power BI Report Server
Use the CData ODBC Driver for Pinterest to visualize Pinterest data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Avro-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Avro Data from Zoho Analytics and import live Avro data.
-
Connect and Query Live Amazon Athena Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon Athena data into Databricks and enable direct, live querying and analysis without replication.
-
Automate Zoho Projects Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Projects data replication to Azure Data Lake.
-
Integrating OpenCode with YouTube Analytics 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 Blackbaud FE NXT to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Blackbaud FE NXT with IBM WebSphere for seamless data integration and connectivity.
-
Prepare, Blend, and Analyze Rebilly Data in Alteryx Designer (ODBC)
Build workflows to access live Rebilly data for self-service data analytics.
-
Create Power BI Reports on Real-Time Okta Data
Use the CData ODBC Driver for Okta to visualize Okta data in Power BI Desktop.
-
Connect Front to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Front with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous ZohoInvoice Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Amazon S3.
-
Automated Continuous Eventbrite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Eventbrite replication to Amazon Redshift.
-
Automated Continuous Mailgun Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mailgun replication to Google BigQuery.
-
Import Bullhorn CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Bullhorn CRM Data from Azure Data Factory and import live Bullhorn CRM data.
-
Getting Started with the CData ADO.NET Provider for IBM Informix
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for IBM Informix.
-
Automated Continuous Azure Synapse Replication to SQL Server
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SQL Server.
-
A PostgreSQL Interface for Jira Assets Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jira Assets JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Zoho Projects Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Projects data securely in real time.
-
View Reports on Real-Time SAS Data Sets Data in Power BI Report Server
Use the CData ODBC Driver for SAS Data Sets to visualize SAS Data Sets data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with Contentful Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Contentful data to a JSON file on disk.
-
Create Reports from Confluence Data in Looker Studio
Use CData Connect AI to gain access to live Confluence data and create custom reports in Looker Studio.
-
Build Dashboards with Azure Data Catalog Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Data Catalog data in Dundas BI.
-
Publish Office 365-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Office 365 data.
-
Object-Relational Mapping (ORM) with Oracle Eloqua 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 Oracle Eloqua data into a Java-based ORM framework, Hibernate.
-
How to update Bitbucket from Excel
This article explains how to transfer data from Excel to Bitbucket using the Excel Add-In for Bitbucket.
-
A PostgreSQL Interface for Microsoft Exchange Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Exchange JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access Float Data in Python
Use standard Python scripting and the development environment of your choice to access live Float data.
-
Integrating Dataiku with HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live HDFS data.
-
Query Zoho Recruit Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Recruit data from Node.js.
-
Integrate SAP Business Warehouse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Business Warehouse with External Services.
-
Integrate Live SAP Ariba Procurement Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Ariba Procurement data and integrate live SAP Ariba Procurement data into apps built in Microsoft Power Apps.
-
Build Dashboards with Short.io Data in Dundas BI
Create dynamic dashboards and perform analytics based on Short.io data in Dundas BI.
-
How to use SQLAlchemy ORM to access Vimeo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Vimeo data.
-
Replicate Microsoft Ads Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Ads data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Devin with Live Jira Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Jira data.
-
Drip Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Drip facts in real time.
-
View Reports on Real-Time BigCommerce Data in Power BI Report Server
Use the CData ODBC Driver for BigCommerce to visualize BigCommerce data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot with Webflow 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 HBase Data in RapidMiner
Integrate HBase data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live Basecamp Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Basecamp data from your Excel spreadsheets.
-
Connect AfterShip Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AfterShip data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous SAP SuccessFactors Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to MongoDB.
-
Publish Microsoft Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Ads data.
-
Enable the SAS xpt JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAS xpt data.
-
Choosing the Best Method to Connect ConvertAPI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ConvertAPI data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Query Live Dotmailer Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Dotmailer data data in natural language using Python.
-
Feed ConvertKit Data into FineReport
How to set ConvertKit data as a JDBC data source in FineReport.
-
Query Live Adobe Target Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Adobe Target data through a conversational interface.
-
Use the CData ODBC Driver for Amazon DynamoDB in Microsoft Power Query
You can use the CData Amazon DynamoDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon DynamoDB data into Microsoft Power Query.
-
Replicate CouchDB Data in Heroku for Use in Salesforce Connect
Replicate CouchDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Scrapfly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Scrapfly replication to Amazon Redshift.
-
Excel Spreadsheet Automation on CockroachDB Data with the QUERY Formula
Pull data from CockroachDB, automate spreadsheets, and more with the QUERY formula.
-
Build Quaderno-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Quaderno data.
-
DataBind Auth0 Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Auth0 data to a chart.
-
Use Azure AI Foundry to Talk to Your CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your CapsuleCRM data for you.
-
Build Blackbaud FE NXT-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Blackbaud FE NXT data.
-
Getting Started with the CData Connect AI Python SDK for Xero
Install the CData Connect AI Python SDK to read and write live Xero data with standard DB-API 2.0 Python code.
-
Establish a Live Connection with Cvent Data using Tableau Bridge
The CData ODBC Driver for Cvent enables you to integrate live Cvent data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Perplexity Data in Looker
Use CData Connect AI to connect to Perplexity Data from Looker and build custom apps using live Perplexity data.
-
How to import Amazon Marketplace Data into Apache Solr
Use the CData Software JDBC Driver for Amazon Marketplace in Data Import Handler and create an automated import of Amazon Marketplace data to Apache Solr Enterprise Search platform.
-
Automate ClickTime Data Replication to Couchbase
Use CData Sync to Customize and automate ClickTime data replication to Couchbase.
-
Integrate Theia IDE with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SAP Business One data from within the development environment.
-
Getting Started with the CData Power BI Connector for Invoiced
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Raisers Edge NXT Data in JRuby
Create a simple JRuby app with access to live Raisers Edge NXT data.
-
Create Apps from Email Data in Qlik Sense Cloud
Use CData Connect AI to connect to Email Data and build apps from live Email data in Qlik Sense Cloud.
-
Connecting Agentforce with Outreach.io Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Outreach.io data for you.
-
Visualize Microsoft OneDrive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft OneDrive data.
-
Use the CData ODBC Driver for LeadDesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LeadDesk to connect to LeadDesk data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LeadDesk data in Excel.
-
Integrating Gumloop with eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on eBay data within automated workflows.
-
Configure the CData JDBC Driver for Exa in a Connection Pool in Tomcat
Connect to Exa data from a connection pool in Tomcat.
-
Integrate Sugar CRM Data in the Pentaho Report Designer
Publish reports based on Sugar CRM data in the Pentaho BI tool.
-
How to Build an ETL App for Retently Data in Python with CData
Create ETL applications and real-time data pipelines for Retently data in Python with petl.
-
Analyze Live Google Cloud Storage Data in SAS Viya
Use CData Connect AI to connect to Google Cloud Storage data from SAS Viya and deploy self-service analytics using live Google Cloud Storage data.