CData Software - Knowledge Base
Recent Articles
-
Integrate Oracle Data in the Pentaho Report Designer
Publish reports based on Oracle Database in the Pentaho BI tool.
-
Access Live Pinterest Data in Coginiti Pro
Connect to and query live Pinterest from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Instagram Data from a Connection Pool in Jetty
The Instagram JDBC Driver supports connection pooling: This article shows how to connect faster to Instagram from Web apps in Jetty.
-
Feed Float Data into FineReport
How to set Float as a JDBC data source in FineReport.
-
Create Power BI Reports on Real-Time Optimizely Data
Use the CData ODBC Driver for Optimizely to visualize Optimizely in Power BI Desktop.
-
Use the CData API Server to Access Zoho CRM Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zoho CRM in the Power Pivot business intelligence tool.
-
How to Access Instagram Data Using Entity Framework
This article shows how to access Instagram using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate Cvent Data Replication to Azure Synapse
Use CData Sync to customize and automate Cvent replication to Azure Synapse.
-
Build Apps with Live MailerLite Data Using the Low-Code Development Platform of Mendix
Connect MailerLite with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Theia IDE with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Stream Mocean Data into Apache Kafka Topics
Access and stream Mocean in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to JSON Services from IntelliJ
Integrate connectivity to JSON with wizards in IntelliJ.
-
DataBind Controls to Outlook Data in Delphi
DataBind to Outlook in Delphi with standard data access components and controls.
-
Perform Batch Operations with AlloyDB Data in Apache NiFi
Connect to Google AlloyDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Building Dynamic Web Pages with SAP ByDesign Data Using AngularJS
Create single-page applications with live connectivity to SAP ByDesign using the CData API Server.
-
Object-Relational Mapping (ORM) with ZendeskSell 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 ZendeskSell into a Java-based ORM framework, Hibernate.
-
Connect to Sybase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sybase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Semantic Layer Views for Bitbucket Data in APOS Live Data Gateway
Use the CData Connector for Bitbucket in APOS Live Data Gateway to build Semantic Layer Views for Bitbucket.
-
Bind Live YouTube Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live YouTube Analytics data
-
Migrating data from IBM Cloud Object Storage to Snowflake using CData SSIS Components.
Easily push IBM Cloud Object Storage to Snowflake using the CData SSIS Tasks for IBM Cloud Object Storage and Snowflake.
-
Access Epicor Kinetic Data from MySQL in PHP
Connect to Epicor Kinetic through the standard MySQL libraries in PHP.
-
View Reports on Real-Time Oracle Eloqua Data in Power BI Report Server
Use the CData ODBC Driver for Oracle Eloqua to visualize Oracle Eloqua in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect DBeaver to Couchbase via a JDBC Driver
Manage Couchbase with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect ServiceDesk Plus to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ServiceDesk Plus from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous PolarTeamPro Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to PostgreSQL.
-
LINQ to Google Campaign Manager 360 Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Google Campaign Manager 360 Data Provider.
-
Integrating Dataiku with Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Analysis Services.
-
Connect to LionDesk Data in DBArtisan
Use wizards in DBArtisan to configure LionDesk as a data source.
-
Validate Basecamp Data with QuerySurge
Access and validate Basecamp in QuerySurge using the CData JDBC Driver.
-
Create ShipEngine Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ShipEngine data access from reports, embedded analytics, and more.
-
Connect to Splunk 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 Splunk.
-
Using the CData Software ODBC Driver for MYOB AccountRight in PyCharm
Connect to MYOB AccountRight as an ODBC data source in PyCharm using the CData Software ODBC Driver for MYOB AccountRight.
-
Integrating Kiro CLI with ConvertAPI 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.
-
Integrate with Procore Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Procore in SnapLogic.
-
Easily Integrate Oracle Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Database in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Working with Smartsheet Data in LINQPad
Execute LINQ queries to Smartsheet in LINQPad.
-
Back Up Jira Assets to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Jira Assets. In this article, we will employ an SSIS workflow to populate a database with Jira Assets data.
-
Operational Reporting on Facebook Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Facebook.
-
How to Query Live FTP Data in Claude Desktop
Connect to and query live FTP Data in Claude Desktop using CData MCP Server.
-
Validate Trello Data with QuerySurge
Access and validate Trello in QuerySurge using the CData JDBC Driver.
-
Query Authorize.Net Data as a MySQL Database in Node.js
Execute MySQL queries against Authorize.Net from Node.js.
-
Integrating Kiro CLI with Facebook Ads 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.
-
Choosing the Best Method to Connect Oracle SCM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle SCM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Easily Query MarkLogic Data in OpenOffice Base
Connect to MarkLogic data in OpenOffice Base using the CData ODBC Driver for MarkLogic and generate reports with live data insights.
-
Build SAP SuccessFactors LMS-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Zoho Analytics and import live SAP SuccessFactors LMS.
-
How to Visualize Invoiced Data in Python with pandas
Use pandas and other modules to analyze and visualize live Invoiced in Python.
-
Build Dashboards with SAP Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP ERP/NetWeaver in Dundas BI.
-
Establish a Live Connection with Mailgun Data using Tableau Bridge
The CData ODBC Driver for Mailgun enables you to integrate live Mailgun into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Exa Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Exa replication to OneLake in Microsoft Fabric.
-
Automate Todoist Data Replication to Couchbase
Use CData Sync to Customize and automate Todoist replication to Couchbase.
-
Getting Started with the CData Python Connector for ConvertAPI
Learn to install and license the CData Python Connector
-
How to Connect DBeaver to Workday via a JDBC Driver
Manage Workday with visual tools in DBeaver like the query browser.
-
Create Informatica Mappings From/To an ODBC Data Source for CircleCI
Create an ODBC connection to CircleCI in Informatica and browse and transfer CircleCI.
-
Create Datasets from Microsoft Exchange in Domo Workbench and Build Visualizations of Microsoft Exchange Data in Domo
Use the CData Software ODBC Driver for Microsoft Exchange to create datasets from Microsoft Exchange in Domo Workbench and then build visualizations in the Domo service.
-
Use Dash to Build to Web Apps on Pushbullet Data
Create Python applications that use pandas and Dash to build Pushbullet-connected web apps.
-
Automated Continuous WooCommerce Replication to Databricks
Use CData Sync for automated, continuous, customizable WooCommerce replication to Databricks.
-
Import Real-Time Amazon DynamoDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon DynamoDB in ColdFusion.
-
Operational Reporting on Dynamics NAV Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Dynamics NAV.
-
Integrating Kiro CLI with Sage Cloud Accounting 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.
-
Query Sage Intacct Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage Intacct entities in PHP by modeling them as objects.
-
Process & Analyze Deel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Deel Data.
-
Visualize Yelp Data in Sisense
Create an ElastiCube in Sisense app with access to Yelp.
-
Automate Reckon Data Replication to Couchbase
Use CData Sync to Customize and automate Reckon replication to Couchbase.
-
Connect to MySQL Data from HeidiSQL
Use CData Connect AI to connect to and query live MySQL from HeidiSQL.
-
How to Easily Query Salesforce Marketing Data in OpenOffice Base
Connect to Salesforce Marketing data in OpenOffice Base using the CData ODBC Driver for Salesforce Marketing and generate reports with live data insights.
-
Edit and Search External Lakebase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Lakebase to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Lakebase Data objects that you can access from apps and the dashboard.
-
Choosing the Best Method to Connect Parallel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Parallel from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to integrate Metabase with HubSpot Data
Use CData Connect AI to connect to live HubSpot and create an interactive dashboard in Metabase from HubSpot.
-
Automated Continuous Airtable Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Airtable replication to PostgreSQL.
-
Consume PingOne OData Feeds in SAP Lumira
Use the API Server to create data visualizations on PingOne feeds that reflect any changes in SAP Lumira.
-
Connecting GenSpark with Amazon Athena Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon Athena without any replication or custom integration required.
-
How to Connect to Nuclia Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Nuclia. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Oracle Financials Cloud Data from IntelliJ
Integrate connectivity to Oracle Financials Cloud with wizards in IntelliJ.
-
DataBind Controls to Odoo Data in Delphi
DataBind to Odoo ERP in Delphi with standard data access components and controls.
-
Replicate ConstantContact Data to Multiple Databases via the CData Sync CLI
Replicate ConstantContact to disparate databases with a single configuration.
-
Explore Geographical Relationships in Gorgias Data with Power Map
Create data visualizations with Gorgias in Power Map.
-
ETL Strava in Oracle Data Integrator
This article shows how to transfer Strava into a data warehouse using Oracle Data Integrator.
-
Build Google Search-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Google Search Results and create custom apps in Bubble.
-
How to Query Live DB2 Data in Perplexity MacOS Desktop
Connect to and query live DB2 Data in Perplexity Desktop using CData MCP Server.
-
Visualize Sendwithus Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Sendwithus into TIBCO Spotfire.
-
Integrate Live Accelo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Accelo to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Demio Data in AWS Lambda
Connect to live Demio in AWS Lambda using the CData JDBC Driver.
-
Integrate SAP HANA Data into Power Automate Desktop using CData Connect
CData Connect for SAP HANA Data enables you to integrate SAP HANA into workflows built using Microsoft Power Automate Desktop.
-
Connect to PhantomBuster Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PhantomBuster in the Denodo Virtual DataPort Administrator.
-
How to Work with Postmark Data in AWS Glue Jobs Using JDBC
Connect to Postmark from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Raisers Edge NXT Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google BigQuery.
-
Connect to Sage Cloud Accounting Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sage Cloud Accounting in FileMaker Pro to connect to Sage Cloud Accounting and work with Sage Business Cloud Accounting in your FileMaker applications.
-
How to integrate Google Drive with Apache Airflow
Access and process Google Drive in Apache Airflow using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for PagerDuty in MicroStrategy
Connect to PagerDuty in MicroStrategy Developer using the CData Software JDBC Driver for PagerDuty.
-
Automated IBM Cloud Object Storage Data Replication to Teradata
Use CData Sync to Customize and automate IBM Cloud Object Storage replication to Teradata.
-
Build Apps with Live Cvent in Adalo using CData Connect AI
Use CData Connect AI to integrate live Cvent into the Adalo platform and build custom mobile and web applications with real-time Cvent.
-
Automated Continuous Microsoft Dataverse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Amazon Redshift.
-
Working with ZarMoney Data in LINQPad
Execute LINQ queries to ZarMoney in LINQPad.
-
Build Dashboards with Salesforce Pardot Data in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce Pardot in Dundas BI.
-
Build MVC Applications with Connectivity to Factorial Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Factorial from an ASP.NET MVC application.
-
Build ShipStation-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for ShipStation to explore live ShipStation Data in Claude Code to assist with building ShipStation-powered applications.
-
How to Easily Query Discourse Data in OpenOffice Base
Connect to Discourse data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Front Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Front and the SQL Gateway to access Front from Google Apps Script.
-
Build Typeform-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Typeform and build web apps with connectivity to live Typeform.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesforce Marketing Cloud using the Model Context Protocol.