CData Software - Knowledge Base
Recent Articles
-
Viewing Zoom Data in RAD Studio Data Explorer
How to view Zoom data in RAD Studio Data Explorer using the CData ODBC Driver for Zoom.
-
Build MVC Applications with Connectivity to Auth0 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Auth0 from an ASP.NET MVC application.
-
Getting Started with the CData JDBC Driver for Stripe
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Stripe.
-
Build Dashboards with GitHub Data in Dundas BI
Create dynamic dashboards and perform analytics based on GitHub data in Dundas BI.
-
Connect to Qualaroo Data in Jaspersoft Studio
Execute SQL to remote Qualaroo data in Jaspersoft Studio.
-
Integrate ChargeOver with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ChargeOver with External Services.
-
Integrate Yelp with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Yelp with External Services.
-
Automated Continuous Clio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Clio replication to PostgreSQL.
-
Connect to Okta Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Okta.
-
Build Apps with Live SendPulse Data Using the Low-Code Development Platform of Mendix
Connect SendPulse data with Mendix to build apps using the CData API Driver for JDBC.
-
How to connect to Brex Data from Spring Boot
Connect to Brex in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Salesforce Pardot Data in NetBeans
Connect to Salesforce Pardot data in NetBeans with the data source configuration wizard.
-
Build Typeform Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Typeform data and build visualizations in Tableau.
-
How to Easily Query Wrike Data in OpenOffice Base
Connect to Wrike data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Campaign Manager 360
Provide connectivity to Google Campaign Manager 360 data through an SAP BusinessObjects universe.
-
Automated Continuous Ontraport Replication to Databricks
Use CData Sync for automated, continuous, customizable Ontraport replication to Databricks.
-
Prepare, Blend, and Analyze Sybase Data in Alteryx Designer (Connect AI)
Build workflows to access live Sybase data for self-service data analytics.
-
Connecting Mastra with SAP Netweaver Gateway 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 SAP Netweaver Gateway data, no replication required.
-
Integrate Adobe Analytics Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Analytics data from Informatica Cloud.
-
Create Vercel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Vercel data access from reports, embedded analytics, and more.
-
How to Connect to Google Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Ads data. Leverage the pyodbc module for ODBC in Python.
-
Deploy the ADO.NET Provider for Autopilot on an SSRS Report Server
Connect to Autopilot 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.
-
Build SAS Data Sets-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAS Data Sets data.
-
Create Informatica Mappings From/To an ODBC Data Source for Apify
Create an ODBC connection to Apify in Informatica and browse and transfer Apify data.
-
Automated Continuous Reckon Replication to SQL Server
Use CData Sync for automated, continuous, customizable Reckon replication to SQL Server.
-
Build Oracle Eloqua-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Eloqua data.
-
Write a Simple Go Application to work with Calendly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Calendly data.
-
Use the CData Software ODBC Driver for AfterShip in MicroStrategy Desktop
Connect to AfterShip data in MicroStrategy Desktop using the CData Software ODBC Driver for AfterShip.
-
Replicate Multiple Grafana Accounts via the CData Sync CLI
Replicate multiple Grafana accounts to one or many databases.
-
Natively Connect to Adobe Target Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Target data. Leverage the native support for ODBC in PHP.
-
Integrate OpenCode with Live Gmail Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Gmail data from within your AI coding agent.
-
Create a Data Access Object for Amazon DynamoDB Data using JDBI
A brief overview of creating a SQL Object API for Amazon DynamoDB data in JDBI.
-
Integrate MongoDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MongoDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MongoDB data.
-
Connect to Zoho Books Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Zoho Books.
-
Access Live ZohoInvoice Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ZohoInvoice data from your Excel spreadsheets.
-
Connect to Sendwithus Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sendwithus Data and connect to Sendwithus data in Akorbi Digital RunMyProcess.
-
Automated Continuous Shopify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Shopify replication to Amazon Redshift.
-
Integrate Reckon with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Reckon with External Services.
-
Automate Vimeo Data Replication to Couchbase
Use CData Sync to Customize and automate Vimeo data replication to Couchbase.
-
Create MySQL-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MySQL Data from OutSystems and build custom enterprise apps using live MySQL data.
-
Use Microsoft Copilot Studio to talk to your AgileCRM 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 AgileCRM data for you.
-
How to connect to SAP Netweaver Gateway Data from IntelliJ
Integrate connectivity to SAP Netweaver Gateway data with wizards in IntelliJ.
-
Feed Xero Data into FineReport
How to set Xero data as a JDBC data source in FineReport.
-
Automated Continuous Teamwork Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Teamwork data replication to OneLake in Microsoft Fabric.
-
Automated Continuous SAP Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP replication to Apache Kafka.
-
How to Seamlessly Import Mouseflow Data into IBM SPSS Modeler
Integrate Mouseflow data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connecting GenSpark with Oracle HCM Cloud Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Oracle HCM Cloud data without any replication or custom integration required.
-
Connect to Paylocity from a Connection Pool in WebLogic
Use the CData JDBC Driver for Paylocity to connect to Paylocity data from Web applications running on WebLogic.
-
Query, Visualize, and Share live Pipedrive Data in Redash
Use CData Connect AI to connect to live Pipedrive data in Redash for querying, visualizing, and sharing.
-
Visualize GitLab Data in Tableau
The CData ODBC driver for GitLab enables you integrate GitLab data into Tableau dashboards.
-
How to integrate Metabase with Airtable Data
Use CData Connect AI to connect to live Airtable data and create an interactive dashboard in Metabase from Airtable data.
-
Access SparkPost Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SparkPost data.
-
Integrate Real-Time Access to Google Drive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Drive data in real time.
-
Integrate Amazon DynamoDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon DynamoDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon DynamoDB data.
-
Integrate Live PhantomBuster Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PhantomBuster data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Zoho Books Data from a Connection Pool in JBoss
Integrate Zoho Books data into Java servlets: Use the Management Console in JBoss to install the Zoho Books JDBC Driver.
-
Visualize Sentry Data in Sisense
Create an ElastiCube in Sisense app with access to Sentry data.
-
Replicate Clockify Data to Multiple Databases
Replicate Clockify data to disparate databases with a point-and-click configuration.
-
Use JayDeBeApi to access MailerLite Data in Python
Use standard Python scripting and the development environment of your choice to access live MailerLite data.
-
Publish Reports with Placid Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Placid data.
-
Import Okta Data Using Azure Data Factory
Use CData Connect AI to connect to Okta Data from Azure Data Factory and import live Okta data.
-
Analyze Pipeline CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pipeline CRM from Power Pivot. You will use the Table Import Wizard to load Pipeline CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Extract, Transform, and Load Lakebase Data in Informatica PowerCenter
Create a simple Workflow for Lakebase data in Informatica PowerCenter.
-
Use the CData SSIS Components to Insert New or Update Existing MySQL Records from SQL Server
Easily push SQL Server data to MySQL using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MySQL or update existing records with data from a SQL Server database.
-
Operational Reporting on SAP Business One Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business One data.
-
Integrate with Dynamics 365 Business Central Data in JReport Designer
Create charts and reports based on Dynamics 365 Business Central data in JReport Designer.
-
How to Connect to Live Google Calendar Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Calendar data for you.
-
Migrating data from LightSpeedRetail to Google BigQuery using CData SSIS Components.
Easily push LightSpeedRetail data to Google BigQuery using the CData SSIS Tasks for LightSpeedRetail and Google BigQuery.
-
Replicate Multiple Google Calendar Accounts
Replicate multiple Google Calendar accounts to one or many databases.
-
Visualize Live AgileCRM Data in the Power BI Service
Use CData Connect AI to connect to live AgileCRM data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with live Marketo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Marketo data in Jitterbit.
-
Integrating Codex with ScrapingBee 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 Amazon QuickSight to QuickBooks Data
Create a connection to QuickBooks data in CData Connect AI and insert QuickBooks data into Amazon QuickSight SPICE to build interactive dashboards.
-
Query ServiceDesk Plus Data as a MySQL Database in Node.js
Execute MySQL queries against ServiceDesk Plus data from Node.js.
-
Automate Cassandra Data Replication to Couchbase
Use CData Sync to Customize and automate Cassandra data replication to Couchbase.
-
Getting Started with the CData Connect AI Python SDK for Impala
Install the CData Connect AI Python SDK to read and write live Impala data with standard DB-API 2.0 Python code.
-
Automate Mocean Data Replication to Couchbase
Use CData Sync to Customize and automate Mocean data replication to Couchbase.
-
Working with Yelp Data in LINQPad
Execute LINQ queries to Yelp data in LINQPad.
-
Build Dashboards with Oracle Service Cloud Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Service Cloud data in Dundas BI.
-
How to integrate Metabase with Zoom Data
Use CData Connect AI to connect to live Zoom data and create an interactive dashboard in Metabase from Zoom data.
-
Use Azure AI Foundry to Talk to Your Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Pipedrive data for you.
-
Integrating Antigravity CLI with YouTube Analytics data via CData CLI
Connect YouTube Analytics data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live Excel Data in Coginiti Pro
Connect to and query live Excel data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build AI/ML Models with Live Azure Table Data using Dataiku
Connect Azure Table Data with Dataiku using the CData JDBC Driver for Azure Table.
-
Integrating Cursor with Attio 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 Browserless Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Browserless replication to Google Cloud SQL.
-
Connect Azure Synapse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Synapse data using the CData Python MCP Server.
-
Integrate with Live Outreach.io Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Outreach.io from the MuleSoft Anypoint Platform to integrate live Outreach.io data into custom reports and dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage 300
Create an ODBC connection to Sage 300 in Informatica and browse and transfer Sage 300 data.
-
Easily Integrate Bullhorn CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Bullhorn CRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Claude Code with Oracle Service Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Service Cloud data within assisted coding and automated development workflows.
-
Process & Analyze Box Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Box Data.
-
Build Agents in Relevance AI with Access to Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MarkLogic data within intelligent agent workflows.
-
Replicate Parquet Data in Heroku for Use in Salesforce Connect
Replicate Parquet data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automate SAP Netweaver Gateway Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Netweaver Gateway data from PowerShell? This article demonstrates how to utilize the SAP Netweaver Gateway Cmdlets for tasks like connecting to SAP Netweaver Gateway data, automating operations, downloading data, and more.
-
Automated Continuous Short.io Replication to SQLite
Use CData Sync for automated, continuous, customizable Short.io replication to SQLite.
-
Access Live QuickBooks Data in Coginiti Pro
Connect to and query live QuickBooks data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Grafana Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Grafana data through MCP integration.
-
Integrating Claude Code CLI with Adobe Target 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Snowflake
Create Snowflake data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.