CData Software - Knowledge Base
Recent Articles
-
Visualize Live Certinia Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Certinia into custom reports in Power BI.
-
Integrating Gumloop with SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Business ByDesign within automated workflows.
-
Connect to SFTP Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SFTP to connect to SFTP and execute queries in PowerBuilder.
-
Automated Continuous Harvest Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Harvest replication to Apache Kafka.
-
How to Connect to Live Google Campaign Manager 360 Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Campaign Manager 360 for you.
-
Query Google Translate Data in DataGrip
Create a Data Source for Google Translate in DataGrip and use SQL to query live Google Translate.
-
Connect to Egnyte Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Egnyte and work with Egnyte in your FileMaker application.
-
Build Voice Agents in ElevenLabs with access to Live FreshBooks Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live FreshBooks.
-
Connect to Pipedrive Data in Claris FileMaker Pro
Use the CData ODBC Driver for Pipedrive in FileMaker Pro to connect to Pipedrive and work with Pipedrive in your FileMaker applications.
-
Visualize Beeminder Data in Tableau
The CData ODBC driver for Beeminder enables you integrate Beeminder into Tableau dashboards.
-
Build a PostgreSQL Interface for Aweber Data using the CData JDBC Driver
Use the Remoting features of the Aweber JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ConstantContact Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ConstantContact replication to delimited files (CSV/TSV).
-
Build a Singer.io Tap for Google Search With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Search data using
-
Integrate Parallel Data in the Pentaho Report Designer
Publish reports based on Parallel in the Pentaho BI tool.
-
Connect to SAP Hybris C4C Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Hybris C4C.
-
Use the CData Software ODBC Driver for Amplitude in MicroStrategy
Connect to Amplitude in MicroStrategy Developer using the CData Software ODBC Driver for Amplitude.
-
Automated Continuous Cassandra Replication to MongoDB
Use CData Sync for automated, continuous, customizable Cassandra replication to MongoDB.
-
Connect Productboard to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Productboard using the CData Python MCP Server.
-
Import Real-Time Perigon Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Perigon in ColdFusion.
-
Replicate SAP ByDesign Data to Multiple Databases via the CData Sync CLI
Replicate SAP Business ByDesign to disparate databases with a single configuration.
-
Connect to Smartsheet Data in Aqua Data Studio
Access Smartsheet from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to publish and share Exa Data dashboards with Tableau Server
The CData ODBC driver for Exa enables you integrate Exa into Tableau dashboards.
-
Analyze Oracle Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle from Power Pivot. You will use the Table Import Wizard to load Oracle Database. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Dropbox Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Dropbox. Leverage the pyodbc module for ODBC in Python.
-
Build Access-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Access.
-
Visualize Live VWO Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live VWO.
-
Create SSAS Tabular Models from Square Data
How to build a SQL Server Analysis Service Tabular Model from Square using CData drivers.
-
Use Microsoft Copilot Studio to talk to your SQL Analysis Services 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 SQL Analysis Services for you.
-
Connect to Vimeo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Vimeo to connect to Vimeo from Web applications running on WebLogic.
-
ETL Freshservice in Oracle Data Integrator
This article shows how to transfer Freshservice into a data warehouse using Oracle Data Integrator.
-
Connect to Sage 300 Data in DBArtisan
Use wizards in DBArtisan to configure Sage 300 as a data source.
-
Creating SAP HANA-Connected Applications in Unqork
You can use CData Connect AI to feed SAP HANA to Unqork and build custom business apps.
-
Moving Data from IBM Informix to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live IBM Informix data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Live Sybase Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sybase from the MuleSoft Anypoint Platform to integrate live Sybase into custom reports and dashboards.
-
Connect to and Visualize Live Parallel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Parallel.
-
Getting Started with the CData SSIS Components for Auth0
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Auth0.
-
Connect and Query Live Snowflake Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Snowflake into Databricks
-
Integrate Google Sheets with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Sheets with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Sheets.
-
Visualize Live CSV Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CSV/TSV Files.
-
How to use SQLAlchemy ORM to access Pingdom Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pingdom.
-
Model, Search, and Visualize Live Airtable Data in ThoughtSpot
Use CData Connect AI to connect to live Airtable for modeling, searching, and visualizing.
-
Getting Started with the CData SSIS Components for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics 365 Business Central.
-
Publish Reports with Cloudant Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM Cloudant.
-
Integrate with Mouseflow Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mouseflow to a JSON file on disk.
-
A PostgreSQL Interface for Asana Data using the CData ODBC Driver
Use the SQL Gateway and Asana ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use Dash to Build to Web Apps on Instantly Data
Create Python applications that use pandas and Dash to build Instantly-connected web apps.
-
Build Sybase IQ Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sybase IQ and build visualizations in Tableau Cloud.
-
Access Recurly Data from MySQL in PHP
Connect to Recurly through the standard MySQL libraries in PHP.
-
How to connect Amazon QuickSight to Avalara AvaTax Data
Create a connection to Avalara AvaTax in CData Connect AI and insert Avalara AvaTax into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate ConstantContact Data in the Pentaho Report Designer
Publish reports based on ConstantContact in the Pentaho BI tool.
-
Moving Data from Amazon Athena to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Amazon Athena data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Process & Analyze PhantomBuster Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PhantomBuster Data.
-
Import Real-Time Drip Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Drip in ColdFusion.
-
Create SSAS Tabular Models from IBM Cloud Object Storage Data
How to build a SQL Server Analysis Service Tabular Model from IBM Cloud Object Storage using CData drivers.
-
How to create Dynamics 365 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics 365 in MySQL .
-
Automate Salesforce Marketing Data Replication to SAP HANA
Use CData Sync to customize and automate Salesforce Marketing Cloud replication to SAP HANA.
-
Connect to DocuSign Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for DocuSign Data and connect to DocuSign in Akorbi Digital RunMyProcess.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP SuccessFactors LMS
Provide connectivity to SAP SuccessFactors LMS through an SAP BusinessObjects universe.
-
Connect to Confluence Data in RazorSQL
Connect to Confluence from wizards and query Atlassian Confluence from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData SSIS Components for Google Forms
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Forms.
-
Integrating GitHub Copilot CLI with Google Spanner 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 Real-Time Access to Microsoft Entra ID in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Entra ID in real time.
-
Use Dash to Build Web Apps on DocuSign Data via CData Connect AI
Build interactive Dash web apps on live DocuSign using pandas and the CData Connect AI Python SDK.
-
How to connect to MailerSend Data from Spring Boot
Connect to MailerSend in a Spring Boot Application using the CData API Driver for JDBC
-
Extract, Transform, and Load Instagram Data in Informatica PowerCenter
Create a simple Workflow for Instagram in Informatica PowerCenter.
-
ETL MongoDB in Oracle Data Integrator
This article shows how to transfer MongoDB into a data warehouse using Oracle Data Integrator.
-
Publish Crystal Reports on Salesforce CRM Analytics Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce CRM Analytics.
-
How to Access Bitbucket Data Using Entity Framework
This article shows how to access Bitbucket using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Excel Spreadsheet Automation on JotForm Data with the QUERY Formula
Pull data from JotForm, automate spreadsheets, and more with the QUERY formula.
-
How to Connect DBeaver to Keap via a JDBC Driver
Manage Keap with visual tools in DBeaver like the query browser.
-
How to work with Instantly Data in Apache Spark using SQL
Access and process Instantly Data in Apache Spark using the CData Software JDBC Driver.
-
Create a Data Access Object for Pushbullet Data using JDBI
A brief overview of creating a SQL Object API for Pushbullet in JDBI.
-
How to Connect to Live Zoho Creator Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zoho Creator through natural language.
-
Integrate with Google Cloud Storage Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Cloud Storage in SnapLogic.
-
Access Live ZarMoney Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZarMoney in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
SAP Hybris C4C Reporting in OBIEE with the SAP Hybris C4C JDBC Driver
Deploy the SAP Hybris C4C JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze SFTP Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SFTP and visualize live SFTP in Infragistics Reveal.
-
How to connect SharePoint with ADP Data through external lists
Provide ADP to SharePoint users as an external list.
-
DataBind Onfleet Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Onfleet to a chart.
-
Build an OLAP Cube in SSAS from Sugar CRM Data
Establish a connection to Sugar CRM data from SQL Server Analysis Services, and use the Sugar CRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build SendGrid-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SendGrid to explore live SendGrid Data in GitHub Copilot to assist with building SendGrid-powered applications.
-
Create ZeroBounce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZeroBounce data access from reports, embedded analytics, and more.
-
How to Visualize Basecamp 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 Basecamp in Python.
-
Build AI/ML Models with Live Zoho Inventory Data using Dataiku
Connect Zoho Inventory Data with Dataiku using the CData JDBC Driver for Zoho Inventory.
-
Integrating AlloyDB Data in Talend Cloud Data Management Platform
Connect AlloyDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for AlloyDB.
-
Build Dashboards with Close Data in Dundas BI
Create dynamic dashboards and perform analytics based on Close in Dundas BI.
-
Build Automated Workflows with Live Reckon Accounts Hosted Data in Workato
Use CData Connect AI to connect to live Reckon Accounts Hosted and build automated workflows in Workato.
-
Explore Geographical Relationships in Mailgun Data with Power Map
Create data visualizations with Mailgun in Power Map.
-
How to connect to Greenplum Data with Squirrel SQL client
Connect to Pivotal GreenPlum and execute queries in the Squirrel SQL Client.
-
Automated Continuous Authorize.Net Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Amazon Redshift.
-
Connect to Samanage Data in DBeaver
Use the CData ODBC Driver to connect to Samanage in DBeaver.
-
DataBind Controls to Todoist Data in C++Builder
DataBind to Todoist in C++Builder with standard components and controls.
-
How to Create Power BI Visual Reports with Real-Time Calendly Data
Use CData Power BI Connectors to visualize Calendly in Power BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Aweber
Provide connectivity to Aweber through an SAP BusinessObjects universe.
-
Automated Continuous SAP Business One Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Business One replication to MongoDB.
-
Consume Elasticsearch OData Feeds in PowerBuilder
This article demonstrates how to consume Elasticsearch as OData feeds from PowerBuilder using the API Server.
-
Build Raisers Edge NXT-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Raisers Edge NXT to explore live Raisers Edge NXT Data in Cursor to assist with building Raisers Edge NXT-powered applications.
-
Connect to Shortcut Data in RazorSQL
Connect to Shortcut from wizards and query Shortcut from the GUI in the RazorSQL database management tool.
-
How to Import Data from Google Ads into Google Sheets
Import Google Ads into a Google spreadsheet that is automatically refreshed.
-
eBay Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on eBay facts in real time.