CData Software - Knowledge Base
Recent Articles
-
Access Oracle Eloqua Data from MySQL in PHP
Connect to Oracle Eloqua through the standard MySQL libraries in PHP.
-
Bidirectional Access to Act CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Act CRM data in Filemaker Pro for Mac or Windows.
-
Integrate Live Adobe Target Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Target from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Target data.
-
Replicate Multiple Reckon Accounts Hosted Accounts
Replicate multiple Reckon Accounts Hosted accounts to one or many databases.
-
Build a Singer.io Tap for Close With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Close data using the CData Python Connector.
-
Integrate Cursor with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP SuccessFactors data from within the editor.
-
Automated Continuous Vault CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Vault CRM replication to Amazon S3.
-
Extract, Transform, and Load JSON Services in Informatica PowerCenter
Create a simple Workflow for JSON services in Informatica PowerCenter.
-
Connect to Presto Data in Google Apps Script via Connect AI
Use CData Connect AI to access Presto data in Google Apps Script.
-
Connect to SAP SuccessFactors LMS Data in Ruby
Connect to SAP SuccessFactors LMS data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Recurly Data in CloverDX (formerly CloverETL)
Transfer Recurly data using the visual workflow in the CloverDX data integration tool.
-
Using the CData Software ODBC Driver for Apollo in PyCharm
Connect to Apollo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Apollo.
-
Getting Started with the CData Connect AI Python SDK for Google Directory
Install the CData Connect AI Python SDK to read and write live Google Directory data with standard DB-API 2.0 Python code.
-
Build Apps with Live Neo4J data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Neo4J data into the Adalo platform and build custom mobile and web applications with real-time Neo4J data.
-
Easily Integrate Zoho Recruit Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Recruit data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Twitter Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Twitter Ads data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for eBay Analytics
Provide connectivity to eBay Analytics data through an SAP BusinessObjects universe.
-
Access Live Salesforce Marketing Data in Excel 365 Online (Excel for the web)
Connect to Salesforce Marketing data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Klipfolio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Klipfolio data access from reports, embedded analytics, and more.
-
Build NetSuite-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live NetSuite data and build NetSuite-connected web apps with Axios.
-
How to work with Hive Data in Apache Spark using SQL
Access and process Hive Data in Apache Spark using the CData Software JDBC Driver.
-
Query QuickBooks Data in DataGrip
Create a Data Source for QuickBooks in DataGrip and use SQL to query live QuickBooks data.
-
Access Live BambooHR Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live BambooHR data from your Excel spreadsheets.
-
How to Query Live ConvertAPI Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ConvertAPI data data in natural language using Python.
-
Automated Continuous Discord Replication to Oracle
Use CData Sync for automated, continuous, customizable Discord replication to Oracle.
-
Use Dash to Build Web Apps on Reckon Accounts Hosted Data via CData Connect AI
Build interactive Dash web apps on live Reckon Accounts Hosted data using pandas and the CData Connect AI Python SDK.
-
Connect to SingleStore Data in HULFT Integrate
Connect to SingleStore as a JDBC data source in HULFT Integrate
-
How to connect PolyBase to Apify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apify data.
-
Connect to Unbounce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Unbounce data in the Denodo Virtual DataPort Administrator.
-
Use CData Connect AI to Access Phoenix Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Phoenix data in the Power Pivot business intelligence tool.
-
Build Reply.io-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Reply.io data.
-
Work with Scrapfly Data in FoxPro
Load Scrapfly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Pingdom in MicroStrategy
Connect to Pingdom data in MicroStrategy Developer using the CData Software ODBC Driver for Pingdom.
-
Build MVC Applications with Connectivity to LightSpeedRetail Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LightSpeedRetail from an ASP.NET MVC application.
-
Build Marketo Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Marketo data and build visualizations in Tableau.
-
Getting Started with the CData SSIS Components for Simplesat
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Simplesat.
-
Automated Continuous SAP HANA Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP HANA replication to MongoDB.
-
Create Dashboards and Visualize Live Reckon Accounts Hosted Data in Geckoboard
Use CData Connect AI to connect to live Reckon Accounts Hosted data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to API Data in ACL Analytics
Connect to API data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to API data.
-
Templated Reporting in OBIEE with the Templated JDBC Driver
Deploy the Templated JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Google Directory Data in HULFT Integrate
Connect to Google Directory as a JDBC data source in HULFT Integrate
-
Add Autopilot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Autopilot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous DB2 Replication to Vertica
Use CData Sync for automated, continuous, customizable DB2 replication to Vertica.
-
Automated Continuous Short.io Replication to Databricks
Use CData Sync for automated, continuous, customizable Short.io replication to Databricks.
-
Deploy the ADO.NET Provider for Bannerbear on an SSRS Report Server
Connect to Bannerbear 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 PostgreSQL Data in DBArtisan
Use wizards in DBArtisan to configure PostgreSQL data as a data source.
-
Integrate with iContact Data in JReport Designer
Create charts and reports based on iContact data in JReport Designer.
-
Create Apps from Cosmos DB Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cosmos DB Data and build apps from live Cosmos DB data in Qlik Sense Cloud.
-
Connecting GenSpark with Google Search Results via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Search results without any replication or custom integration required.
-
Create Data Visualizations Based On Oracle Sales Data in Mode
Use CData Connect AI to connect to Oracle Sales Data from Mode and build visualizations using live Oracle Sales data.
-
Automated Continuous Chargebee Replication to MySQL
Use CData Sync for automated, continuous, customizable Chargebee replication to MySQL.
-
How to create Visio diagrams from Access Data
Automatically update Access data with the changes you make to Visio master shapes.
-
How to Connect to Live Vertica 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 Vertica data through natural language.
-
DataBind Controls to Google Translate Data in C++Builder
DataBind to Google Translate data in C++Builder with standard components and controls.
-
How to connect to JobNimbus Data from Spring Boot
Connect to JobNimbus in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Azure Synapse Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Synapse replication to MySQL.
-
Use Claude to Talk to Your Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Phoenix data for you.
-
Bridge Optimizely Connectivity with Apache NiFi
Access and process Optimizely data in Apache NiFi using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with PayPal 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 PayPal data into a Java-based ORM framework, Hibernate.
-
How to Work with Google Tasks Data in ETL Validator JDBC
Connect to Google Tasks from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate OpenCode with Live Adobe Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Adobe Analytics data from within your AI coding agent.
-
How to Work with Accelo Data in ETL Validator JDBC
Connect to Accelo from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to eBay Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for eBay data.
-
Create Data Visualizations in Cognos BI with Front Data
Access Front data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Bugsnag Data in the Pentaho Report Designer
Publish reports based on Bugsnag data in the Pentaho BI tool.
-
Build Pipelines with Live SQL Analysis Services Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SQL Analysis Services from Google Cloud Data Fusion, enabling the integration of live SQL Analysis Services data into the building and management of effective data pipelines.
-
Migrating data from Microsoft Entra ID to Snowflake using CData SSIS Components.
Easily push Microsoft Entra ID data to Snowflake using the CData SSIS Tasks for Microsoft Entra ID and Snowflake.
-
Connect to QuickBooks Data in Google Apps Script via Connect AI
Use CData Connect AI to access QuickBooks data in Google Apps Script.
-
Manage Okta Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Okta.
-
Query MessageBird Data in DataGrip
Create a Data Source for MessageBird in DataGrip and use SQL to query live MessageBird data.
-
How to integrate Asana with Apache Airflow
Access and process Asana data in Apache Airflow using the CData JDBC Driver.
-
Building Dynamic Web Pages with ShipStation Data Using AngularJS
Create single-page applications with live connectivity to ShipStation using the CData API Server.
-
Natively Connect to Jumpseller Data in PHP
The CData ODBC driver for Jumpseller enables you to create PHP applications with connectivity to Jumpseller data. Leverage the native support for ODBC in PHP.
-
Connect to Mailjet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mailjet to connect to Mailjet data from Web applications running on WebLogic.
-
Connecting Mastra with NetSuite SuiteAnalytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time NetSuite SuiteAnalytics data, no replication required.
-
Create Informatica Mappings From/To a JDBC Data Source for PolarTeamPro
Create PolarTeamPro data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Data Visualizations in Cognos BI with FormSite Data
Access FormSite data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Oracle Sales Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Sales data in Dundas BI.
-
Use the CData Software ODBC Driver for Apify in MicroStrategy Desktop
Connect to Apify data in MicroStrategy Desktop using the CData Software ODBC Driver for Apify.
-
Integrate Box Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Box data and integrate live Box data into your Power Automate tasks.
-
Replicate ConvertAPI Data in Heroku for Use in Salesforce Connect
Replicate ConvertAPI data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Seamlessly Import Workday Data into IBM SPSS Modeler
Integrate Workday data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Microsoft Entra ID from Asprova with CData Software ODBC Driver for Microsoft Entra ID
This article shows how to connect faster to Microsoft Entra ID data from Asprova.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce Data 360
Create Salesforce Data 360 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create a Data Access Object for Hugging Face Data using JDBI
A brief overview of creating a SQL Object API for Hugging Face data in JDBI.
-
Use Manus AI to Talk to Your CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on CapsuleCRM data.
-
Work with Tally Data in FoxPro
Load Tally data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate DB2 for i Data in Heroku for Use in Salesforce Connect
Replicate DB2 for i data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Process & Analyze Salesforce Marketing Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Marketing Data.
-
Connect to SAP ByDesign Data in NetBeans
Connect to SAP ByDesign data in NetBeans with the data source configuration wizard.
-
Integrate PabblySubscriptions Data in Pentaho Data Integration
Build ETL pipelines based on PabblySubscriptions data in the Pentaho Data Integration tool.
-
Integrating GitHub Copilot with Simplesat 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 RabbitMQ Replication to SQL Server
Use CData Sync for automated, continuous, customizable RabbitMQ replication to SQL Server.
-
Integrate Real-Time Access to Azure Analysis Services in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Analysis Services data in real time.
-
Connect to Bullhorn CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Bullhorn CRM data in the Denodo Virtual DataPort Administrator.
-
Replicate Multiple ClickUp Accounts
Replicate multiple ClickUp accounts to one or many databases.
-
Integrating LangGraph with Cassandra Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Cassandra data within automated workflows.
-
Connect to Moosend Data in HULFT Integrate
Connect to Moosend as a JDBC data source in HULFT Integrate
-
Query Amazon Athena Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon Athena data from Node.js.
-
Build Microsoft Teams-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Teams data.