CData Software - Knowledge Base
Recent Articles
-
Connect to Raisers Edge NXT Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Raisers Edge NXT and the Script function in FileMaker Pro to connect to Raisers Edge NXT and work with Raisers Edge NXT data in your FileMaker application.
-
Connect to Jira Assets Data from HeidiSQL
Use CData Connect AI to connect to and query live Jira Assets data from HeidiSQL.
-
Replicate MariaDB Data in Heroku for Use in Salesforce Connect
Replicate MariaDB data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for SparkPost from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SparkPost to connect to SparkPost data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SparkPost data in Excel.
-
Visualize Live WooCommerce Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live WooCommerce data into custom reports in Power BI.
-
Automated Continuous Excel Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Excel Online replication to delimited files (CSV/TSV).
-
Build a Simple VCL Application for Active Directory Data
How to build a simple VCL Application to view Active Directory data in RAD Studio using the CData ODBC Driver for Active Directory.
-
DataBind Controls to Asana Data in Delphi
DataBind to Asana data in Delphi with standard data access components and controls.
-
Visualize Live SuiteCRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SuiteCRM data into custom reports in Power BI.
-
Access Live Oracle SCM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle SCM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Connect AI Python SDK for Zoho Creator
Install the CData Connect AI Python SDK to read and write live Zoho Creator data with standard DB-API 2.0 Python code.
-
Build Pipelines with Live IBM Cloud Object Storage Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to IBM Cloud Object Storage from Google Cloud Data Fusion, enabling the integration of live IBM Cloud Object Storage data into the building and management of effective data pipelines.
-
Integrate Live Zoho CRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho CRM data to Blue Prism using the CData ODBC Driver for Zoho CRM to create automated workflows for repetitive business tasks.
-
Replicate Multiple Freshdesk Accounts via the CData Sync CLI
Replicate multiple Freshdesk accounts to one or many databases.
-
How to Connect to Live YouTube Analytics 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 YouTube Analytics data for you.
-
Integrate with Outlook Data in JReport Designer
Create charts and reports based on Outlook data in JReport Designer.
-
Connect to Teradata Data in Jaspersoft Studio
Execute SQL to remote Teradata data in Jaspersoft Studio.
-
Visualize SAP Ariba Source Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Ariba Source data.
-
Easily Integrate Amazon S3 Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon S3 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build MariaDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MariaDB Data and create custom apps in Mendix.
-
Replicate Multiple Pinterest Accounts via the CData Sync CLI
Replicate multiple Pinterest accounts to one or many databases.
-
Build PostgreSQL-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to PostgreSQL Data from Zoho Analytics and import live PostgreSQL data.
-
Prepare, Blend, and Analyze PostgreSQL Data in Alteryx Designer (Connect AI)
Build workflows to access live PostgreSQL data for self-service data analytics.
-
Connect to Harvest Data from a Connection Pool in Jetty
The Harvest JDBC Driver supports connection pooling: This article shows how to connect faster to Harvest data from Web apps in Jetty.
-
Getting Started with the CData Excel Add-In for Greenplum
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Greenplum.
-
Migrating data from Cassandra to Google BigQuery using CData SSIS Components.
Easily push Cassandra data to Google BigQuery using the CData SSIS Tasks for Cassandra and Google BigQuery.
-
Connect to Cvent Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cvent in FileMaker Pro to connect to Cvent and work with Cvent data in your FileMaker applications.
-
Visualize Clio Data in Sisense
Create an ElastiCube in Sisense app with access to Clio data.
-
Integrate Goose with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Sheets data from within the local AI agent.
-
Build AI Agents with Bitly 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 Bitly data through CData Connect AI.
-
Object-Relational Mapping (ORM) with Demio 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 Demio data into a Java-based ORM framework, Hibernate.
-
Integrate Gorgias with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Gorgias with External Services.
-
Automated Continuous Power BI XMLA Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Power BI XMLA data replication to OneLake in Microsoft Fabric.
-
How to Query WordPress Data in MySQL Workbench
Execute MySQL queries against live WordPress data from MySQL Workbench.
-
Use Dash to Build Web Apps on Databricks Data via CData Connect AI
Build interactive Dash web apps on live Databricks data using pandas and the CData Connect AI Python SDK.
-
How to Access Brex Data Using Entity Framework
This article shows how to access Brex data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Excel Online Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Excel Online replication to Google BigQuery.
-
Automated Continuous Impala Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Impala replication to Apache Cassandra.
-
Connect to Moosend in SpagoBI
Create reports featuring live Moosend data in SpagoBI Studio. Host Moosend reports on SpagoBI Server.
-
How to Connect to Live SAP Ariba Source Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Ariba Source data securely in real time.
-
Consume Tally OData Feeds in PowerBuilder
This article demonstrates how to consume Tally data as OData feeds from PowerBuilder using the API Server.
-
Easily Integrate Sage 200 Data in Lazarus Pascal IDE
Learn how to easily integrate live Sage 200 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Search External ServiceNow Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ServiceNow data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ServiceNow Data objects that you can access from apps and the dashboard.
-
Access Live Twitter Ads Data in TIBCO Data Virtualization
Use the Twitter Ads Tibco DV Adapter to create a Twitter Ads data data source in TIBCO Data Virtualization Studio and gain access to live Twitter Ads data from your TDV Server.
-
Build Data Flows from SQL Server to Google Directory through SSIS
Easily push SQL Server data to Google Directory using the CData SSIS Tasks for Google Directory.
-
Automated Continuous Paymo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Paymo replication to MongoDB.
-
Use the CData Software JDBC Driver for Hacker News in MicroStrategy Desktop
Connect to Hacker News data in MicroStrategy Desktop using the CData Software JDBC Driver for Hacker News.
-
Analyze Printful Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Printful data in Microsoft R Open.
-
Visualize Live Salesforce Marketing Data in the Power BI Service
Use CData Connect AI to connect to live Salesforce Marketing data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData ODBC Driver for Square
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Square.
-
View Reports on Real-Time CloudConvert Data in Power BI Report Server
Use the CData ODBC Driver for CloudConvert to visualize CloudConvert data in Power BI Desktop and then publish them to Power BI Report Server.
-
Moving Data from Placid to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Placid data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build MailChimp-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MailChimp Data and create custom apps in Mendix.
-
Build Semantic Layer Views for ZohoDesk Data in APOS Live Data Gateway
Use the CData Connector for ZohoDesk in APOS Live Data Gateway to build Semantic Layer Views for ZohoDesk data.
-
How to Connect to Toggl Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Toggl data. Leverage the pyodbc module for ODBC in Python.
-
Integrating Webex Data in Talend Cloud Data Management Platform
Connect Webex Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Snowflake Data from a Connection Pool in Jetty
The Snowflake JDBC Driver supports connection pooling: This article shows how to connect faster to Snowflake data from Web apps in Jetty.
-
Connect to CircleCI Data from a Connection Pool in JBoss
Integrate CircleCI data into Java servlets: Use the Management Console in JBoss to install the CircleCI JDBC Driver.
-
Integrating Kiro with Sentry 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.
-
Search External Zoom Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zoom data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zoom Data objects that you can access from apps and the dashboard.
-
Automated Continuous Access Replication to Snowflake
Use CData Sync for automated, continuous, customizable Access replication to Snowflake.
-
Analyze LinkedIn Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of LinkedIn data and visualize LinkedIn data in SAP Analytics Cloud.
-
Automated Continuous Amplitude Replication to Snowflake
Use CData Sync for automated, continuous, customizable Amplitude replication to Snowflake.
-
Automated Continuous Oracle Eloqua Reporting Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Azure SQL Database.
-
Build Semantic Layer Views for Asana Data in APOS Live Data Gateway
Use the CData Connector for Asana in APOS Live Data Gateway to build Semantic Layer Views for Asana data.
-
Build a Singer.io Tap for FTP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FTP data using the CData Python Connector.
-
Connect to Foursquare Data in NetBeans
Connect to Foursquare data in NetBeans with the data source configuration wizard.
-
Access SendInBlue Data from MySQL in PHP
Connect to SendInBlue through the standard MySQL libraries in PHP.
-
Automated Continuous RabbitMQ Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Amazon Redshift.
-
Migrating data from Elasticsearch to Snowflake using CData SSIS Components.
Easily push Elasticsearch data to Snowflake using the CData SSIS Tasks for Elasticsearch and Snowflake.
-
Use the CData Software ODBC Driver for Aircall in SAS for Real-Time Reporting and Analytics
Connect to real-time Aircall data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Aircall.
-
Automated Continuous Gorgias Replication to Databricks
Use CData Sync for automated, continuous, customizable Gorgias replication to Databricks.
-
Connect IBM Informix Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your IBM Informix data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build an OLAP Cube in SSAS from Pipeline CRM Data
Establish a connection to Pipeline CRM data data from SQL Server Analysis Services, and use the Pipeline CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Dashboards and Visualize Live Azure DevOps Data in Geckoboard
Use CData Connect AI to connect to live Azure DevOps data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Moving Data from Paymo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Paymo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Live Azure Synapse Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Synapse from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Synapse data.
-
Create SAP Hybris C4C-Connected Business Apps in AppSheet
Connect to SAP Hybris C4C Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Hybris C4C data.
-
Integrate Timely Data into Power Automate Desktop using CData Connect
CData Connect for Timely Data enables you to integrate Timely data into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for Zendesk
Create Zendesk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create a Data Access Object for Zoho Creator Data using JDBI
A brief overview of creating a SQL Object API for Zoho Creator data in JDBI.
-
Getting Started with the CData Excel Add-In for PayPal
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PayPal.
-
Analyze HCL Domino Data in Looker
Use CData Connect AI to connect to HCL Domino Data from Looker and build custom apps using live HCL Domino data.
-
Automated Continuous Azure Blob Storage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Apache Cassandra.
-
Access Live Paymo Data in Excel 365 Online (Excel for the web)
Connect to Paymo data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Microsoft Teams-Connected Applications in Appsmith
Connect to Microsoft Teams Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Teams data.
-
SharePoint Excel Services Reporting in OBIEE with the SharePoint Excel Services JDBC Driver
Deploy the SharePoint Excel Services JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Pipedrive-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 Pipedrive data without replication.
-
Connect to AfterShip Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live AfterShip data.
-
How to connect to Apollo Data in DBVisualizer
Integrate Apollo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Live Oracle SCM 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 Oracle SCM data through a conversational interface.
-
How to Connect the Power BI Service to SAP: Complete Guide
Connect to the CData Software Power BI Connector for SAP from PowerBI.com to provide real-time SAP data across the organization.
-
Query SharePoint Excel Services Data as a MySQL Database in Node.js
Execute MySQL queries against SharePoint Excel Services data from Node.js.
-
Deploy the ADO.NET Provider for ADP on an SSRS Report Server
Connect to ADP 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.
-
Connect to Oracle Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Oracle.
-
Access Aircall Data from MySQL in Amazon QuickSight
Connect to Aircall and build visualizations of Aircall data using a MySQL Connection in Amazon QuickSight.
-
Build Apps with Live Exact Online data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Exact Online data into the Adalo platform and build custom mobile and web applications with real-time Exact Online data.
-
Bidirectional Access to Google Campaign Manager 360 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Campaign Manager 360 data in Filemaker Pro for Mac or Windows.
-
Automated Continuous HubSpot Replication to Vertica
Use CData Sync for automated, continuous, customizable HubSpot replication to Vertica.
-
Integrate with HubDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live HubDB data in SnapLogic.