CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors for you.
-
How to integrate ShipStation with Apache Airflow
Access and process ShipStation in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData Python Connector for Short.io
Learn to install and license the CData Python Connector
-
Extract, Transform, and Load ScrapingBee Data in Informatica PowerCenter
Create a simple Workflow for ScrapingBee in Informatica PowerCenter.
-
Build Dashboards with Todoist Data in Dundas BI
Create dynamic dashboards and perform analytics based on Todoist in Dundas BI.
-
How to publish and share Clari Data dashboards with Tableau Server
The CData ODBC driver for Clari enables you integrate Clari into Tableau dashboards.
-
How to update Shopify from Excel
This article explains how to transfer data from Excel to Shopify using the Excel Add-In for Shopify.
-
Create Datasets from Amazon Athena in Domo Workbench and Build Visualizations of Amazon Athena Data in Domo
Use the CData Software ODBC Driver for Amazon Athena to create datasets from Amazon Athena in Domo Workbench and then build visualizations in the Domo service.
-
Build WooCommerce Visualizations in Tableau Cloud
Use CData Connect AI to connect to live WooCommerce and build visualizations in Tableau Cloud.
-
Connect to Oracle HCM Cloud Data in NetBeans
Connect to Oracle HCM Cloud in NetBeans with the data source configuration wizard.
-
Create Dynamic QuickBooks Time Grids Using the Infragistics XamDataGrid
Learn how you can connect QuickBooks Time to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Odoo ERP within intelligent workflows.
-
Access AfterShip Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access AfterShip from your Oracle system.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Entra ID Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Entra ID to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate Webflow Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Webflow to SQL Server.
-
Query Marketo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Marketo from Node.js.
-
Migrating data from Authorize.Net to Snowflake using CData SSIS Components.
Easily push Authorize.Net to Snowflake using the CData SSIS Tasks for Authorize.Net and Snowflake.
-
Extend Google Sheets with Box Data
Make calls to Box from Google Apps Script via the API Server.
-
Import Real-Time Amazon Athena Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon Athena in ColdFusion.
-
Use JayDeBeApi to access Cohere Data in Python
Use standard Python scripting and the development environment of your choice to access live Cohere.
-
Connect Webex to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Webex with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Raisers Edge NXT Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Raisers Edge NXT with the DevExpress Windows Forms and Web controls to provide Raisers Edge NXT to a chart.
-
How to integrate Paddle with Apache Airflow
Access and process Paddle in Apache Airflow using the CData JDBC Driver.
-
How to connect to Productboard Data with Squirrel SQL client
Connect to Productboard and execute queries in the Squirrel SQL Client.
-
Publish Reports with SAP BusinessObjects BI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP BusinessObjects BI.
-
Automated Continuous Humanity Replication to MongoDB
Use CData Sync for automated, continuous, customizable Humanity replication to MongoDB.
-
Access Live Discord Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Discord in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Cohere Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Cohere and work with Cohere in your FileMaker applications.
-
DataBind Charts to ADP Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ADP from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Live Codat Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Codat to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Import Neo4J Data Using Azure Data Factory
Use CData Connect AI to connect to Neo4J Data from Azure Data Factory and import live Neo4J.
-
Automate Greenplum Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Pivotal GreenPlum and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Claude Code CLI 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.
-
Automated Continuous Active Directory Replication to MongoDB
Use CData Sync for automated, continuous, customizable Active Directory replication to MongoDB.
-
Use the CData Software ODBC Driver for Amazon Athena in MicroStrategy
Connect to Amazon Athena in MicroStrategy Developer using the CData Software ODBC Driver for Amazon Athena.
-
Choosing the Best Method to Connect Eventbrite to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Eventbrite from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate DB2 Data Replication to Azure Data Lake
Use CData Sync to customize and automate IBM DB2 replication to Azure Data Lake.
-
Use JayDeBeApi to access Apollo Data in Python
Use standard Python scripting and the development environment of your choice to access live Apollo.
-
Connect to Omnisend Data in DBeaver
Use the CData ODBC Driver to connect to Omnisend in DBeaver.
-
Getting Started with the CData SSIS Components for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Recruit.
-
Connect to Suadeo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Suadeo to connect to Suadeo from Web applications running on WebLogic.
-
Use Dash to Build to Web Apps on Oracle Data
Create Python applications that use pandas and Dash to build Oracle-connected web apps.
-
Provide OData Services of Facebook Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Facebook by developing a WCF Service Application.
-
Build Charts with Google Translate Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Translate in Clear Analytics.
-
Build SendInBlue-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SendInBlue and build web apps with connectivity to live SendInBlue.
-
Create Procore-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Procore Data from Klipfolio and build custom visualizations using live Procore.
-
Integrate OData Services in the Pentaho Report Designer
Publish reports based on OData in the Pentaho BI tool.
-
Use Manus AI to Talk to Your Snapchat Ads 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 Snapchat Ads.
-
Create Power BI Reports on Real-Time Egnyte Data
Use the CData ODBC Driver for Egnyte to visualize Egnyte in Power BI Desktop.
-
How to use SQLAlchemy ORM to access Wave Financial Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Wave Financial.
-
Analyze Insightly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Insightly from Power Pivot. You will use the Table Import Wizard to load Insightly. You can visually build the import query or use any SQL supported by the driver.
-
Integrating LangChain with FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on FHIR within automated workflows.
-
Analyze Live Apollo Data in SAS Viya
Use CData Connect AI to connect to Apollo from SAS Viya and deploy self-service analytics using live Apollo.
-
Connect to MarkLogic Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MarkLogic.
-
How to Visualize Trello Data in Python with pandas
Use pandas and other modules to analyze and visualize live Trello in Python.
-
How to Design Sybase IQ Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Sybase IQ from mobile and tablet Power Apps.
-
Build Apps with Live Azure Synapse Data Using the Low-Code Development Platform of Mendix
Connect Azure Synapse with Mendix to build apps using the CData JDBC Driver for Azure Synapse.
-
Create SAP ByDesign Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP ByDesign data access from reports, embedded analytics, and more.
-
Bidirectional Access to SAP Ariba Procurement Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Ariba Procurement in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData ADO.NET Provider for Recurly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for Vault CRM in MicroStrategy Web
Connect to Veeva Vault & Vault CRM in MicroStrategy Web using the CData Software ODBC Driver for Vault CRM.
-
Viewing Planio Data in RAD Studio Data Explorer
How to view Planio in RAD Studio Data Explorer using the CData ODBC Driver for Planio.
-
Create Salesforce Pardot-Connected Business Apps in AppSheet
Connect to Salesforce Pardot Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Salesforce Pardot.
-
Use Dash to Build Web Apps on BigQuery Data via CData Connect AI
Build interactive Dash web apps on live Google BigQuery using pandas and the CData Connect AI Python SDK.
-
Connect Exa Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Exa using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to integrate Landbot with Apache Airflow
Access and process Landbot in Apache Airflow using the CData JDBC Driver.
-
How to Query Live Unbounce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Unbounce data in natural language using Python.
-
Getting Started with the CData ADO.NET Provider for Apify
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build a Simple VCL Application for PDFMonkey Data
How to build a simple VCL Application to view PDFMonkey in RAD Studio using the CData ODBC Driver for PDFMonkey.
-
How to Connect to & Open Amazon Marketplace Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon Marketplace to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build SAP SuccessFactors LMS Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP SuccessFactors LMS and build visualizations in Tableau.
-
Migrating data from Coinbase to Google BigQuery using CData SSIS Components.
Easily push Coinbase to Google BigQuery using the CData SSIS Tasks for Coinbase and Google BigQuery.
-
Build Data Flows from Okta to SQL Server using SSIS
Easily back up Okta to SQL Server using the SSIS components for Okta.
-
Automated Continuous Odoo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Odoo replication to PostgreSQL.
-
Getting Started with the CData Connect AI Python SDK for SAS xpt
Install the CData Connect AI Python SDK to read and write live SAS XPORT with standard DB-API 2.0 Python code.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Brex
Provide connectivity to Brex through an SAP BusinessObjects universe.
-
Build an OLAP Cube in SSAS from PDFMonkey Data
Establish a connection to PDFMonkey data from SQL Server Analysis Services, and use the PDFMonkey Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Biml to Build SSIS Tasks to Replicate Aircall Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Aircall to SQL Server.
-
How to connect SharePoint with Greenhouse Data through external lists
Provide Greenhouse to SharePoint users as an external list.
-
Build Automated Workflows with Live NetSuite Data in Workato
Use CData Connect AI to connect to live NetSuite CRM & ERP and build automated workflows in Workato.
-
How to create CircleCI federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CircleCI in MySQL .
-
Create Printful Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Printful data access from reports, embedded analytics, and more.
-
Connect to Aircall Data in Jaspersoft Studio
Execute SQL to remote Aircall in Jaspersoft Studio.
-
Automated Continuous Instagram Replication to Oracle
Use CData Sync for automated, continuous, customizable Instagram replication to Oracle.
-
Bridge SharePoint Excel Services Connectivity with Apache NiFi
Access and process SharePoint Excel Services in Apache NiFi using the CData JDBC Driver.
-
How to Use a Microsoft Access Database to Update SAP HANA Data in Real Time
Update SAP HANA data by creating a linked table in Microsoft Access with the CData SAP HANA ODBC Driver.
-
Analyze Live SAP Concur Data in SAS Viya
Use CData Connect AI to connect to SAP Concur from SAS Viya and deploy self-service analytics using live SAP Concur.
-
Replicate Instagram Data in Heroku for Use in Salesforce Connect
Replicate Instagram to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to SAP SuccessFactors from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP SuccessFactors, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create a Data Access Object for Mixpanel Data using JDBI
A brief overview of creating a SQL Object API for Mixpanel in JDBI.
-
How to connect Amazon QuickSight to Xero Data
Create a connection to Xero Accounting in CData Connect AI and insert Xero Accounting into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect to Gong Data with Squirrel SQL client
Connect to Gong and execute queries in the Squirrel SQL Client.
-
Integrate with live Outreach.io Data in Jitterbit
Use CData Connect AI to connect to and integrate live Outreach.io in Jitterbit.
-
Analyze LinkedIn Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LinkedIn with the CData JDBC Driver for LinkedIn.
-
Visualize Basecamp Data in Sisense
Create an ElastiCube in Sisense app with access to Basecamp.
-
Connect to Microsoft Ads Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Ads and the Script function in FileMaker Pro to connect to Microsoft Ads and work with Microsoft Ads in your FileMaker application.
-
Automate Salesforce Pardot Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce Pardot from PowerShell? This article demonstrates how to utilize the Salesforce Pardot Cmdlets for tasks like connecting to Salesforce Pardot, automating operations, downloading data, and more.
-
Build Agents in Relevance AI with Access to Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Apache Avro within intelligent agent workflows.
-
Integrate Open WebUI with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Salesforce & Force.com from within the chat interface.
-
How to connect to IBM Informix Data from Spring Boot
Connect to IBM Informix in a Spring Boot Application using the CData JDBC Driver for IBM Informix