CData Software - Knowledge Base
Recent Articles
-
Import Sage 300 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sage 300. In this article, you will use the OData format to import Sage 300 into Microsoft Power Query.
-
Automated Continuous Recurly Replication to SQLite
Use CData Sync for automated, continuous, customizable Recurly replication to SQLite.
-
Prepare, Blend, and Analyze Wave Financial Data in Alteryx Designer (ODBC)
Build workflows to access live Wave Financial for self-service data analytics.
-
Work with Live Greenplum Data in Power Query
Use CData Connect AI to connect to Pivotal GreenPlum and work with live Pivotal GreenPlum in Microsoft Power Query.
-
How to Connect to Live Cassandra Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Apache Cassandra securely in real time.
-
Extend Google Sheets with Office 365 Data
Make calls to Office 365 from Google Apps Script via the API Server.
-
Connect to Flowlu Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to integrate Optimizely with Apache Airflow
Access and process Optimizely in Apache Airflow using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Close on an SSRS Report Server
Connect to Close 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.
-
How to connect to Instantly Data in DBVisualizer
Integrate Instantly with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Outlook Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Outlook from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Gumroad Data in Tableau
The CData ODBC driver for Gumroad enables you integrate Gumroad into Tableau dashboards.
-
Visualize ShipStation 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 ShipStation into TIBCO Spotfire.
-
Integrating PayPal Data in Talend Cloud Data Management Platform
Connect PayPal Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PayPal.
-
How to work with Authorize.Net Data in Apache Spark using SQL
Access and process Authorize.Net Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Google Cloud Storage Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Cloud Storage in Google Apps Script.
-
Build Dashboards with Missive Data in Dundas BI
Create dynamic dashboards and perform analytics based on Missive in Dundas BI.
-
Automated Continuous Teradata Replication to MySQL
Use CData Sync for automated, continuous, customizable Teradata replication to MySQL.
-
Automated Continuous Google Campaign Manager 360 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Apache Cassandra.
-
Connect to Office 365 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Office 365 and the SQL Gateway to access Microsoft Office 365 from Google Apps Script.
-
Create Informatica Mappings From/To an ODBC Data Source for Zendesk
Create an ODBC connection to Zendesk in Informatica and browse and transfer Zendesk.
-
Build SAP ByDesign-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP ByDesign Data and create custom apps in Mendix.
-
Connect to Float in SpagoBI
Create reports featuring live Float in SpagoBI Studio. Host Float reports on SpagoBI Server.
-
Connecting Pipedream with Phoenix 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 Phoenix data in real time.
-
Object-Relational Mapping (ORM) with Invoiced 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 Invoiced into a Java-based ORM framework, Hibernate.
-
Integrate JDBC-ODBC Bridge with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate JDBC-ODBC Bridge with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to JDBC-ODBC Bridge.
-
Build Data Flows from Sage Intacct to SQL Server using SSIS
Easily back up Sage Intacct to SQL Server using the SSIS components for Sage Intacct.
-
ETL HCL Domino in Oracle Data Integrator
This article shows how to transfer HCL Domino into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live Smartsheet 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 Smartsheet for you.
-
Edit and Search Bullhorn CRM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Bullhorn CRM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Bullhorn CRM objects that you can access from apps and the dashboard.
-
Connect to Unbounce in SpagoBI
Create reports featuring live Unbounce in SpagoBI Studio. Host Unbounce reports on SpagoBI Server.
-
Query Salesforce CRM Analytics Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce CRM Analytics.
-
Connect to Elorus Data in DBArtisan
Use wizards in DBArtisan to configure Elorus as a data source.
-
Connect to Microsoft OneDrive Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft OneDrive.
-
Object-Relational Mapping (ORM) with Freshteam 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 Freshteam into a Java-based ORM framework, Hibernate.
-
Connect to XML Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for XML Files in the Denodo Virtual DataPort Administrator.
-
Automated Continuous ZarMoney Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZarMoney replication to PostgreSQL.
-
Access Live Asana Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Asana from your Google Sheets.
-
How to Visualize Bullhorn CRM Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Bullhorn CRM in Python.
-
Use the CData SSIS Components to Insert New or Update Existing FTP Records from SQL Server
Easily push SQL Server data to FTP using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into FTP or update existing records with data from a SQL Server database.
-
Create Data Visualizations Based On Microsoft Exchange Data in Mode
Use CData Connect AI to connect to Microsoft Exchange Data from Mode and build visualizations using live
-
Create Reports with Zoho Recruit Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Recruit.
-
Automate Azure Synapse Data Replication to SAP HANA
Use CData Sync to customize and automate Azure Synapse replication to SAP HANA.
-
Automate AfterShip Data Replication to Couchbase
Use CData Sync to Customize and automate AfterShip replication to Couchbase.
-
How to Visualize Stack Exchange Data in Python with pandas
Use pandas and other modules to analyze and visualize live Stack Exchange in Python.
-
Connect to PabblySubscriptions Data from PowerBuilder via JDBC
This article demonstrates how to access PabblySubscriptions from PowerBuilder using the PabblySubscriptions JDBC Driver.
-
Automated Continuous BigCommerce Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable BigCommerce replication to OneLake in Microsoft Fabric.
-
Build Data Flows from SQL Server to Zendesk through SSIS
Easily push SQL Server data to Zendesk using the CData SSIS Tasks for Zendesk.
-
Connect to Anaplan from Asprova with CData Software ODBC Driver for Anaplan
This article shows how to connect faster to Anaplan data from Asprova.
-
Publish Reports with Codat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Codat.
-
How to create Perigon federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Perigon in MySQL .
-
Create Freshservice Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshservice data access from reports, embedded analytics, and more.
-
How to publish and share Tanda Data dashboards with Tableau Server
The CData ODBC driver for Tanda enables you integrate Tanda into Tableau dashboards.
-
How to Connect to Miro Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Miro. Leverage the pyodbc module for ODBC in Python.
-
Connect to FHIR Data in DBeaver
Use the CData ODBC Driver to connect to FHIR in DBeaver.
-
Getting Started with the CData Connect AI Python SDK for Databricks
Install the CData Connect AI Python SDK to read and write live Databricks with standard DB-API 2.0 Python code.
-
Build SAP ByDesign-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP ByDesign to explore live SAP ByDesign Data in Gemini Code Assist to assist with building SAP ByDesign-powered applications.
-
Access Live CapsuleCRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CapsuleCRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to create an RPA flow for Redshift Data in UiPath Studio
Use the Redshift ODBC Driver to create workflows that access real-time Amazon Redshift without any coding.
-
How to connect to Microsoft Ads Data in DBVisualizer
Integrate Microsoft Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Hubstaff Data in DBVisualizer
Integrate Hubstaff with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Notion Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Notion replication to PostgreSQL.
-
Automated Continuous eBay Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Oracle.
-
Use Agno to Talk to Your Gmail 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 Gmail for you.
-
Access Live Oracle Data in Excel 365 Online (Excel for the web)
Connect to Oracle Database from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous YouTube Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Oracle.
-
Connect to SAP HANA XS Advanced Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP HANA XS Advanced and the Script function in FileMaker Pro to connect to SAP HANA XS Advanced and work with SAP HANA XS Advanced in your FileMaker application.
-
Analyze Insightly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Insightly with the CData JDBC Driver for Insightly.
-
Integrating Cursor CLI with Quickbase 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 LaunchDarkly Replication to SQL Server
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to SQL Server.
-
Connect to Tally Data in Claris FileMaker Pro
Use the CData ODBC Driver for Tally in FileMaker Pro to connect to Tally and work with Tally ERP in your FileMaker applications.
-
Connect to Jira Assets Data in Google Apps Script via Connect AI
Use CData Connect AI to access Jira Assets in Google Apps Script.
-
Replicate IBM Informix Data to Multiple Databases via the CData Sync CLI
Replicate IBM Informix to disparate databases with a single configuration.
-
Use Microsoft Copilot Studio to talk to your Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Azure Cosmos DB for you.
-
Automated Continuous Email Replication to Snowflake
Use CData Sync for automated, continuous, customizable Email replication to Snowflake.
-
Import and Visualize Landbot Data in Power View
Create data visualizations based on Landbot in Excel.
-
Excel Spreadsheet Automation on Epicor Kinetic Data with the QUERY Formula
Pull data from Epicor Kinetic, automate spreadsheets, and more with the QUERY formula.
-
How to Design Microsoft Teams Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Microsoft Teams from mobile and tablet Power Apps.
-
Create Informatica Mappings From/To a JDBC Data Source for Timely
Create Timely data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Easily Query SFTP Data in OpenOffice Base
Connect to SFTP data in OpenOffice Base using the CData ODBC Driver for SFTP and generate reports with live data insights.
-
ETL Mailjet in Oracle Data Integrator
This article shows how to transfer Mailjet into a data warehouse using Oracle Data Integrator.
-
Import Real-Time Sentry Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sentry in ColdFusion.
-
Build a PostgreSQL Interface for ConvertKit Data using the CData JDBC Driver
Use the Remoting features of the ConvertKit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dashboards and Visualize Live Act CRM Data in Geckoboard
Use CData Connect AI to connect to live Act CRM and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate with Gmail Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Gmail in SnapLogic.
-
Build Automated Workflows with Live Cloudant Data in Workato
Use CData Connect AI to connect to live IBM Cloudant and build automated workflows in Workato.
-
Access Live Azure Analysis Services Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Analysis Services from your Excel spreadsheets.
-
Build Dynamics 365-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Dynamics 365.
-
Stream Nuclia Data into Apache Kafka Topics
Access and stream Nuclia in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use ChatGPT to Talk to Your Blackbaud FE NXT 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 Blackbaud FE NXT for you.
-
Use Dash to Build to Web Apps on Auth0 Data
Create Python applications that use pandas and Dash to build Auth0-connected web apps.
-
Connect to SAP Ariba Procurement Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Query Simplesat Data in ColdFusion
Write standard ColdFusion data access code to connect to Simplesat.
-
Connect Google Campaign Manager 360 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Campaign Manager 360 using the CData Python MCP Server.
-
Integrating OpenCode Terminal with Dynamics CRM 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.
-
How to Connect Xero Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Xero data in real time using natural language.
-
How to publish and share Brex Data dashboards with Tableau Server
The CData ODBC driver for Brex enables you integrate Brex into Tableau dashboards.
-
Getting Started with the CData ODBC Driver for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Reckon Accounts Hosted.
-
Bridge ADP Connectivity with Apache NiFi
Access and process ADP in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Basecamp
Provide connectivity to Basecamp through an SAP BusinessObjects universe.