CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on SAP Ariba Source Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Ariba Source.
-
Manage Vimeo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Vimeo.
-
Visualize Quaderno Data in TIBCO Spotfire through ADO.NET
Integrate Quaderno into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access Paylocity Data in Python
Use standard Python scripting and the development environment of your choice to access live Paylocity.
-
Build Dashboards with FormSite Data in Dundas BI
Create dynamic dashboards and perform analytics based on FormSite in Dundas BI.
-
How to use SQLAlchemy ORM to access ServiceDesk Plus Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ServiceDesk Plus.
-
How to Access CloudConvert Data Using Entity Framework
This article shows how to access CloudConvert using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Semantic Layer Views for Calendly Data in APOS Live Data Gateway
Use the CData Connector for Calendly in APOS Live Data Gateway to build Semantic Layer Views for Calendly.
-
How to use SQLAlchemy ORM to access Greenhouse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Greenhouse.
-
Connect to Real-Time Mode Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mode in Power Apps.
-
How to connect to Oracle Eloqua Reporting Data from IntelliJ
Integrate connectivity to Oracle Eloqua Reporting with wizards in IntelliJ.
-
Build Apps with Live OData in Adalo using CData Connect AI
Use CData Connect AI to integrate live OData into the Adalo platform and build custom mobile and web applications with real-time OData.
-
Create Dashboards and Visualize Live Paylocity Data in Geckoboard
Use CData Connect AI to connect to live Paylocity and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Query Supabase Data in DataGrip
Create a Data Source for Supabase in DataGrip and use SQL to query live Supabase.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sybase using the Model Context Protocol.
-
Automated Continuous ZohoExpense Replication to Oracle
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Oracle.
-
Import Real-Time HubSpot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HubSpot in ColdFusion.
-
Stream Shopify Data into Apache Kafka Topics
Access and stream Shopify in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Real-Time Zoho Creator Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Creator and Dataflow to import and use Zoho Creator in Power Apps.
-
Analyze Bullhorn CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bullhorn CRM in Microsoft R Open.
-
Manage Quaderno Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Quaderno.
-
How to Build an ETL App for Foursquare Data in Python with CData
Create ETL applications and real-time data pipelines for Foursquare in Python with petl.
-
DataBind Controls to Perplexity Data in Delphi
DataBind to Perplexity in Delphi with standard data access components and controls.
-
How to connect to Salesforce Marketing Data from IntelliJ
Integrate connectivity to Salesforce Marketing Cloud with wizards in IntelliJ.
-
Automate Close Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Close from PowerShell? This article demonstrates how to utilize the Close Cmdlets for tasks like connecting to Close, automating operations, downloading data, and more.
-
Work with Live AlloyDB Data in Power Query
Use CData Connect AI to connect to Google AlloyDB and work with live Google AlloyDB in Microsoft Power Query.
-
Publish Crystal Reports on NASA Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date NASA.
-
Build Charts with Act CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Act CRM in Clear Analytics.
-
Automate FTP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access FTP Servers from PowerShell? This article demonstrates how to utilize the FTP Cmdlets for tasks like connecting to FTP Servers, automating operations, downloading data, and more.
-
Create Power BI Reports on Real-Time PivotalTracker Data
Use the CData ODBC Driver for PivotalTracker to visualize PivotalTracker in Power BI Desktop.
-
Automated Continuous Certinia Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Certinia replication to Google BigQuery.
-
Access Live OneNote Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft OneNote into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft OneNote in the Graph Builder and Query Builder.
-
Access Live Microsoft Planner Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Planner from your Excel spreadsheets.
-
Process & Analyze Jira Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Jira Data.
-
Access Neo4J Data from MySQL in Amazon QuickSight
Connect to Neo4J and build visualizations of Neo4J using a MySQL Connection in Amazon QuickSight.
-
Integrate Theia IDE with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to MailChimp Data from Crystal Reports
Use CData Connect AI to connect to and report on live MailChimp from Crystal Reports.
-
Import Real-Time Anaplan Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Anaplan in ColdFusion.
-
How to connect and process CapsuleCRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CapsuleCRM.
-
Excel Spreadsheet Automation on Pushbullet Data with the QUERY Formula
Pull data from Pushbullet, automate spreadsheets, and more with the QUERY formula.
-
Connect to Live ShipStation Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ShipStation in CData Connect AI and connect to your ShipStation from PostgreSQL.
-
Connect and Visualize Live Epicor Kinetic Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Epicor Kinetic into the Databricks platform and create visualization dashboards with real-time Epicor Kinetic.
-
Connect to Access Data in Jaspersoft Studio
Execute SQL to remote Microsoft Access in Jaspersoft Studio.
-
Process & Analyze Codat Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Codat Data.
-
A PostgreSQL Interface for Mailgun Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mailgun JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with ShipStation Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ShipStation.
-
Connect to PingOne Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PingOne using standard SQL.
-
Create CSV-Connected Business Apps in AppSheet
Connect to CSV Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to CSV/TSV Files.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Gmail using the Model Context Protocol.
-
Integrating Claude Code with Exact Online Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Exact Online within assisted coding and automated development workflows.
-
How to Easily Query Blackbaud FE NXT Data in OpenOffice Base
Connect to Blackbaud FE NXT data in OpenOffice Base using the CData ODBC Driver for Blackbaud FE NXT and generate reports with live data insights.
-
Automated Continuous Todoist Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Todoist replication to IBM DB2.
-
Model Google Ad Manager Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Ad Manager, enabling the direct import of real-time Google Ad Manager.
-
Connecting Pipedream with Raisers Edge NXT 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 Raisers Edge NXT data in real time.
-
Migrating data from Certinia to Google BigQuery using CData SSIS Components.
Easily push Certinia to Google BigQuery using the CData SSIS Tasks for Certinia and Google BigQuery.
-
Design BIRT Reports on CircleCI Data
Provide current CircleCI to your embedded analytics.
-
Import Real-Time ChartMogul Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ChartMogul in ColdFusion.
-
Automated Continuous Humanity Replication to Vertica
Use CData Sync for automated, continuous, customizable Humanity replication to Vertica.
-
Connect to Moosend from a Connection Pool in WebLogic
Use the CData JDBC Driver for Moosend to connect to Moosend from Web applications running on WebLogic.
-
Feed Smartsheet Data into FineReport
How to set Smartsheet as a JDBC data source in FineReport.
-
Connect to Real-Time Google Contacts Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Contacts and Dataflow to import and use Google Contacts in Power Apps.
-
Connect to OneNote Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft OneNote.
-
Use the CData SSIS Components to Insert New or Update Existing WooCommerce Records from SQL Server
Easily push SQL Server data to WooCommerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into WooCommerce or update existing records with data from a SQL Server database.
-
How to Create Power BI Visual Reports with Real-Time Intercom Data
Use CData Power BI Connectors to visualize Intercom in Power BI.
-
Integrating Boomi Agentstudio with SAP Fieldglass Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Fieldglass, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Semantic Layer Views for Datadog Data in APOS Live Data Gateway
Use the CData Connector for Datadog in APOS Live Data Gateway to build Semantic Layer Views for Datadog.
-
Access Live Clockify Data in Coginiti Pro
Connect to and query live Clockify from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Oracle Eloqua Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Oracle Eloqua for you.
-
Import Real-Time Paylocity Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Paylocity in ColdFusion.
-
Automated Continuous Box Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Box replication to Apache Cassandra.
-
Use the CData API Server to Access Freshdesk Data in Microsoft PowerPivot
Use the CData API Server to connect to live Freshdesk in the Power Pivot business intelligence tool.
-
Getting Started with the CData Power BI Connector for Google Calendar
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Calendar.
-
How to connect SharePoint with Authorize.Net Data through external lists
Provide Authorize.Net to SharePoint users as an external list.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apache Phoenix using the Model Context Protocol.
-
Connect to Dynamics CRM Data in HULFT Integrate
Connect to Dynamics CRM as a JDBC data source in HULFT Integrate
-
Create SSAS Tabular Models from Parquet Data
How to build a SQL Server Analysis Service Tabular Model from Apache Parquet using CData drivers.
-
How to create Visio diagrams from YouTube Analytics Data
Automatically update YouTube Analytics with the changes you make to Visio master shapes.
-
Edit and Search External Act-On Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Act-On to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Act-On Data objects that you can access from apps and the dashboard.
-
How to connect to Instagram Data from IntelliJ
Integrate connectivity to Instagram with wizards in IntelliJ.
-
Getting Started with the CData JDBC Driver for Apollo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Apollo.
-
Use the CData Software ODBC Driver for Salesloft in MicroStrategy
Connect to Salesloft in MicroStrategy Developer using the CData Software ODBC Driver for Salesloft.
-
Integrate Cursor with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live FreshBooks from within the editor.
-
Build Voice Agents in ElevenLabs with access to Live SendGrid Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SendGrid.
-
Feed Front Data into FineReport
How to set Front as a JDBC data source in FineReport.
-
Create Reports with Mailgun Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mailgun.
-
Write a Simple Go Application to work with Okta Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Okta.
-
Integrate SAP Hybris C4C Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Hybris C4C from Informatica Cloud.
-
Getting Started with the CData ODBC Driver for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Data Catalog.
-
Visualize SAP SuccessFactors LMS Data in Tableau
The CData ODBC driver for SAP SuccessFactors LMS enables you integrate SAP SuccessFactors LMS into Tableau dashboards.
-
Access Live MessageBird Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MessageBird in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Epicor Kinetic
Provide connectivity to Epicor Kinetic through an SAP BusinessObjects universe.
-
Connecting Agentforce with SendGrid Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your SendGrid for you.
-
Analyze HelloSign Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HelloSign with the CData JDBC Driver for HelloSign.
-
Integrating Codex CLI with Placid 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.
-
Integrating Cursor CLI with Drift 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.
-
Replicate Multiple WooCommerce Accounts via the CData Sync CLI
Replicate multiple WooCommerce accounts to one or many databases.
-
Connect to and Query Twilio Data in QlikView over ODBC
Create data visualizations with Twilio in QlikView.
-
Integrating Codex CLI with Azure Table Storage 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.
-
Access Apollo 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 Apollo.
-
Automated Continuous Google Tasks Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Tasks replication to SQL Server.