CData Software - Knowledge Base
Recent Articles
-
Build Agents in Relevance AI with Access to Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook data within intelligent agent workflows.
-
How to Connect to Kintone Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Kintone data. Leverage the pyodbc module for ODBC in Python.
-
How to work with Avalara AvaTax Data in Apache Spark using SQL
Access and process Avalara AvaTax Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze Live SparkPost Data in SAS Viya
Use CData Connect AI to connect to SparkPost data from SAS Viya and deploy self-service analytics using live SparkPost data.
-
How to Connect to Instantly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Instantly data. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Sage Intacct Data with Squirrel SQL client
Connect to Sage Intacct data and execute queries in the Squirrel SQL Client.
-
How to Connect to Suadeo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Suadeo data. Leverage the pyodbc module for ODBC in Python.
-
Use ChatGPT to Talk to Your Egnyte 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 Egnyte data for you.
-
Migrating data from Smartsheet to Snowflake using CData SSIS Components.
Easily push Smartsheet data to Snowflake using the CData SSIS Tasks for Smartsheet and Snowflake.
-
Integrating Gumloop with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Eloqua data within automated workflows.
-
How to Easily Query Klaviyo Data in OpenOffice Base
Connect to Klaviyo data in OpenOffice Base using the CData ODBC Driver for Klaviyo and generate reports with live data insights.
-
Integrate Blackbaud FE NXT Data into Power Automate Desktop using CData Connect
CData Connect for Blackbaud FE NXT Data enables you to integrate Blackbaud FE NXT data into workflows built using Microsoft Power Automate Desktop.
-
Create Power BI Reports on Real-Time Strava Data
Use the CData ODBC Driver for Strava to visualize Strava data in Power BI Desktop.
-
Bridge Pipeline CRM Connectivity with Apache NiFi
Access and process Pipeline CRM data in Apache NiFi using the CData JDBC Driver.
-
Connect to and Visualize Live HelloSign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HelloSign data.
-
Build Dashboards with Copper Data in Dundas BI
Create dynamic dashboards and perform analytics based on Copper data in Dundas BI.
-
Connecting GenSpark with SAP Business One Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Business One data without any replication or custom integration required.
-
Automated Continuous PabblySubscriptions Replication to SingleStore
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to SingleStore.
-
Process & Analyze Sage 300 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage 300 Data.
-
Getting Started with the CData ODBC Driver for Moosend
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Moosend.
-
Use the CData Software JDBC Driver for Highrise in MicroStrategy
Connect to Highrise data in MicroStrategy Developer using the CData Software JDBC Driver for Highrise.
-
Automated Continuous Moosend Replication to SQLite
Use CData Sync for automated, continuous, customizable Moosend replication to SQLite.
-
Working with Zuora Data in LINQPad
Execute LINQ queries to Zuora data in LINQPad.
-
Query Aweber Data in ColdFusion
Write standard ColdFusion data access code to connect to Aweber data.
-
Enable the Azure Synapse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure Synapse data.
-
Integrating Gumloop with MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MailerLite data within automated workflows.
-
Moving Data from FreshBooks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live FreshBooks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Apps with Live Oracle Eloqua Data Using the Low-Code Development Platform of Mendix
Connect Oracle Eloqua data with Mendix to build apps using the CData JDBC Driver for Oracle Eloqua.
-
Connect to Epicor Kinetic Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Epicor Kinetic and the SQL Gateway to access Epicor Kinetic data from Google Apps Script.
-
Build AI Agents with Procore 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 Procore data through CData Connect AI.
-
Replicate QuickBooks Online Data from PowerShell
Write a quick PowerShell script to query QuickBooks Online data. Use connectivity to the live data to replicate QuickBooks Online data to SQL Server.
-
Object-Relational Mapping (ORM) with ClickTime 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 ClickTime data into a Java-based ORM framework, Hibernate.
-
Create Reports with Zuora Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zuora data.
-
Getting Started with the CData Python Connector for Wrike
Learn to install and license the CData Python Connector and configure a connection to live Wrike data.
-
Analyze Salesforce Marketing Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesforce Marketing data and visualize live Salesforce Marketing data in Infragistics Reveal.
-
Automated Continuous MarkLogic Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MarkLogic replication to Amazon Redshift.
-
Build Visualizations of SAP Hybris C4C Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Hybris C4C data in Birst.
-
Integrate with Pinecone Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pinecone data to a JSON file on disk.
-
Analyze Zuora Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zuora from Power Pivot. You will use the Table Import Wizard to load Zuora data. You can visually build the import query or use any SQL supported by the driver.
-
Create Google Cloud Storage Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Cloud Storage from PowerBI.com to create Power BI Dataflows with real-time data.
-
Design BIRT Reports on SAP SuccessFactors Data
Provide current SAP SuccessFactors data to your embedded analytics.
-
Connect to Mode Data in RapidMiner
Integrate Mode data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Dropbox Data with Squirrel SQL client
Connect to Dropbox data and execute queries in the Squirrel SQL Client.
-
How to Build an ETL App for BenchmarkEmail Data in Python with CData
Create ETL applications and real-time data pipelines for BenchmarkEmail data in Python with petl.
-
Moving Data from Gorgias to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Gorgias data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to and Visualize Live Telegram Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Telegram data.
-
Integrate with Live Shopify Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Shopify from the MuleSoft Anypoint Platform to integrate live Shopify data into custom reports and dashboards.
-
How to Create Power BI Visual Reports with Real-Time PolarTeamPro Data
Use CData Power BI Connectors to visualize PolarTeamPro data in Power BI.
-
Getting Started with the CData Connect AI Python SDK for Perplexity
Install the CData Connect AI Python SDK to read live Perplexity data with standard DB-API 2.0 Python code.
-
Getting Started with the CData Excel Add-In for Teamgate
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Teamgate.
-
Connecting Moonlit Workflow with Jira Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Jira data in real time.
-
Connect to eBay Analytics Data in HULFT Integrate
Connect to eBay Analytics as a JDBC data source in HULFT Integrate
-
Build a PostgreSQL Interface for Nethunt Data using the CData JDBC Driver
Use the Remoting features of the Nethunt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Certinia Data in FoxPro
Load Certinia data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData ODBC Driver for ShipStation from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ShipStation to connect to ShipStation data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ShipStation data in Excel.
-
Create Informatica Mappings From/To an ODBC Data Source for PagerDuty
Create an ODBC connection to PagerDuty in Informatica and browse and transfer PagerDuty data.
-
Publish Google Spanner-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Spanner data.
-
How to Query Live xBase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live xBase data data in natural language using Python.
-
Creating Omnisend-Connected Applications in Unqork
You can use CData Connect AI to feed Omnisend data to Unqork and build custom business apps.
-
Feed Splunk Data into FineReport
How to set Splunk data as a JDBC data source in FineReport.
-
Connect to Kintone Data in JRuby
Create a simple JRuby app with access to live Kintone data.
-
Build a Simple VCL Application for Kintone Data
How to build a simple VCL Application to view Kintone data in RAD Studio using the CData ODBC Driver for Kintone.
-
Stream Oracle HCM Cloud Data into Apache Kafka Topics
Access and stream Oracle HCM Cloud data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jira Assets
Provide connectivity to Jira Assets data through an SAP BusinessObjects universe.
-
Build Salesforce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce data and build web apps with connectivity to live Salesforce data.
-
Connect to Twilio Data in Claris FileMaker Pro
Use the CData ODBC Driver for Twilio in FileMaker Pro to connect to Twilio and work with Twilio data in your FileMaker applications.
-
How to connect to ADP Data with Squirrel SQL client
Connect to ADP data and execute queries in the Squirrel SQL Client.
-
Access Live BigCommerce Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to BigCommerce data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Amazon S3
Provide connectivity to Amazon S3 data through an SAP BusinessObjects universe.
-
Visualize PostgreSQL Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load PostgreSQL data into TIBCO Spotfire.
-
Integrate TaxJar Data in the Pentaho Report Designer
Publish reports based on TaxJar data in the Pentaho BI tool.
-
Build Azure Analysis Services-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 Azure Analysis Services data without replication.
-
Create Reports with CockroachDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CockroachDB data.
-
Connect to Blackbaud FE NXT Data in ACL Analytics
Connect to Blackbaud FE NXT data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Blackbaud FE NXT data.
-
Link Todoist with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Todoist data in Filemaker Pro for Mac or Windows.
-
Use CData Connect AI to Access CockroachDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live CockroachDB data in the Power Pivot business intelligence tool.
-
Automated LeadDesk Data Replication to Teradata
Use CData Sync to Customize and automate LeadDesk data replication to Teradata.
-
Create Power BI Reports on Real-Time PolarTeamPro Data
Use the CData ODBC Driver for PolarTeamPro to visualize PolarTeamPro data in Power BI Desktop.
-
Automated Continuous Azure Blob Storage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to IBM DB2.
-
Use Biml to Build SSIS Tasks to Replicate Email Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Email data to SQL Server.
-
Integrating Boomi Agentstudio with Apollo Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Apollo data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build an OLAP Cube in SSAS from Hugging Face Data
Establish a connection to Hugging Face data data from SQL Server Analysis Services, and use the Hugging Face Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect to Live Impala Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Impala data securely in real time.
-
Build TaxJar-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to TaxJar Data from Zoho Analytics and import live TaxJar data.
-
Integrating LlamaIndex with Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Shopify data in real time.
-
How to Access Freshservice Data Using Entity Framework
This article shows how to access Freshservice data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Build an ETL App for Rootly Data in Python with CData
Create ETL applications and real-time data pipelines for Rootly data in Python with petl.
-
Getting Started with the CData SSIS Components for Eventbrite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Eventbrite.
-
How to create an RPA flow for Strava Data in UiPath Studio
Use the Strava ODBC Driver to create workflows that access real-time Strava data without any coding.
-
Connect to Trello Data in DBeaver
Use the CData ODBC Driver to connect to Trello data in DBeaver.
-
Connect to Todoist Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Todoist and the SQL Gateway to access Todoist data from Google Apps Script.
-
Access Live QuickBooks Time Data in Excel 365 Online (Excel for the web)
Connect to QuickBooks Time data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build AI Agents with MongoDB 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 MongoDB data through CData Connect AI.
-
Build Data Flows from EnterpriseDB to SQL Server using SSIS
Easily back up EnterpriseDB data to SQL Server using the SSIS components for EnterpriseDB.
-
Using the CData Software ODBC Driver for Gorgias in PyCharm
Connect to Gorgias as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gorgias.
-
Integrate with Gmail Data in JReport Designer
Create charts and reports based on Gmail data in JReport Designer.
-
Connect to SAP SuccessFactors LMS Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP SuccessFactors LMS as an External Source in Dremio.
-
DataBind Controls to AlloyDB Data in Delphi
DataBind to AlloyDB data in Delphi with standard data access components and controls.
-
Build AI Agents with Sage Intacct 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 Sage Intacct data through CData Connect AI.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy
Connect to Dynamics 365 Business Central data in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365 Business Central.