CData Software - Knowledge Base
Recent Articles
-
Create Customer.io Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Customer.io from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze SAP Business One Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Business One with the CData JDBC Driver for SAP Business One.
-
How to Access Contentful Data Using Entity Framework
This article shows how to access Contentful using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Provide OData Services of Lakebase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Lakebase by developing a WCF Service Application.
-
Publish Reports with Instagram Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Instagram.
-
Integrate Live Vault CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Replicate ConvertKit Data in Heroku for Use in Salesforce Connect
Replicate ConvertKit to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize LDAP Objects from Tableau
Use the Tableau Desktop business intelligence tool to connect to LDAP.
-
Build Google Spanner-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Spanner Data and create custom apps in Mendix.
-
Easily Integrate OpenWeatherMap Data in Lazarus Pascal IDE
Learn how to easily integrate live OpenWeatherMap in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Sentry Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sentry to a JSON file on disk.
-
Build Charts with eBay Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on eBay Analytics in Clear Analytics.
-
Working with Exa Data in LINQPad
Execute LINQ queries to Exa in LINQPad.
-
Access Live GetResponse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GetResponse in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Live Microsoft Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Ads and integrate live Microsoft Ads into apps built in Microsoft Power Apps.
-
Connect to Azure Data Catalog Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to integrate Paymo with Apache Airflow
Access and process Paymo in Apache Airflow using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Stripe
Create an ODBC connection to Stripe in Informatica and browse and transfer Stripe.
-
Access Exa Data from MySQL in Amazon QuickSight
Connect to Exa and build visualizations of Exa using a MySQL Connection in Amazon QuickSight.
-
How to Visualize Spark Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache Spark SQL in Python.
-
How to connect Amazon QuickSight to EnterpriseDB Data
Create a connection to EnterpriseDB in CData Connect AI and insert EnterpriseDB into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Calendly Data from a Connection Pool in JBoss
Integrate Calendly into Java servlets: Use the Management Console in JBoss to install the Calendly JDBC Driver.
-
Configure the CData JDBC Driver for SAP SuccessFactors LMS in a Connection Pool in Tomcat
Connect to SAP SuccessFactors LMS from a connection pool in Tomcat.
-
Connect to Azure DevOps Data from HeidiSQL
Use CData Connect AI to connect to and query live Azure DevOps from HeidiSQL.
-
Access Live Exact Online Data in TIBCO Data Virtualization
Use the Exact Online Tibco DV Adapter to create a Exact Online data source in TIBCO Data Virtualization Studio and gain access to live Exact Online from your TDV Server.
-
A PostgreSQL Interface for Vimeo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Vimeo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor CLI with ZohoDesk 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.
-
Connect to Cvent Data from a Connection Pool in JBoss
Integrate Cvent into Java servlets: Use the Management Console in JBoss to install the Cvent JDBC Driver.
-
DataBind Charts to Access Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Access 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.
-
Connect to Keap Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Keap.
-
Integrate with Todoist Data in JReport Designer
Create charts and reports based on Todoist in JReport Designer.
-
Analyze Box Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Box and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Charts with QuickBooks Time Data in Clear Analytics
Create dynamic charts and perform analytics based on QuickBooks Time in Clear Analytics.
-
Automate Tasks in Power Automate Using the CData API Server
Automate DB2 actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Natively Connect to SAP SuccessFactors Data in PHP
The CData ODBC driver for SAP SuccessFactors enables you to create PHP applications with connectivity to SAP SuccessFactors. Leverage the native support for ODBC in PHP.
-
Access FreshBooks Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FreshBooks from HeidiSQL.
-
How to Connect Apollo Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Apollo data in real time using natural language.
-
How to Seamlessly Import Printify Data into IBM SPSS Modeler
Integrate Printify data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Enable the Pipeline CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pipeline CRM.
-
Automated Continuous Google Ad Manager Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to OneLake in Microsoft Fabric.
-
Integrating Cursor CLI with EnterpriseDB 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.
-
Visualize Google Drive Data in Tableau
The CData ODBC driver for Google Drive enables you integrate Google Drive into Tableau dashboards.
-
How to connect PolyBase to Coda
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Coda.
-
Automated Continuous Avaza Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Avaza replication to Azure SQL Database.
-
Integrating Claude Code CLI with Exact Online 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.
-
View Reports on Real-Time Paylocity Data in Power BI Report Server
Use the CData ODBC Driver for Paylocity to visualize Paylocity in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Confluence Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Atlassian Confluence from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrating MarkLogic Data in Talend Cloud Data Management Platform
Connect MarkLogic Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MarkLogic.
-
Access Live Zoho Inventory Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho Inventory in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Informatica Mappings From/To a JDBC Data Source for Teamgate
Create Teamgate data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Datasets from Mixpanel in Domo Workbench and Build Visualizations of Mixpanel Data in Domo
Use the CData Software ODBC Driver for Mixpanel to create datasets from Mixpanel in Domo Workbench and then build visualizations in the Domo service.
-
Access Live BigCommerce Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live BigCommerce from your Excel spreadsheets.
-
Create Front Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Front data access from reports, embedded analytics, and more.
-
Build a Singer.io Tap for Google Calendar With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Calendar data using
-
How to Connect to & Open LeadDesk Data in Microsoft Excel
This article uses the CData ODBC driver for LeadDesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to iContact Data in NetBeans
Connect to iContact in NetBeans with the data source configuration wizard.
-
Replicate ZohoExpense Data in Heroku for Use in Salesforce Connect
Replicate ZohoExpense to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Work with Figshare Data in AWS Glue Jobs Using JDBC
Connect to Figshare from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Seamlessly Bring Google Sheets Data into Retool Using CData Connect AI
Integrate Google Sheets data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to MarkLogic Data in Aqua Data Studio
Access MarkLogic from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Live Jira Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Atlassian Jira to Blue Prism using the CData ODBC Driver for Jira to create automated workflows for repetitive business tasks.
-
Replicate BigCommerce Data to Multiple Databases via the CData Sync CLI
Replicate BigCommerce to disparate databases with a single configuration.
-
Access Live Postmark Data in Coginiti Pro
Connect to and query live Postmark from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect Microsoft Teams to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Teams with IBM WebSphere for seamless data integration and connectivity.
-
How to publish and share Perigon Data dashboards with Tableau Server
The CData ODBC driver for Perigon enables you integrate Perigon into Tableau dashboards.
-
How to connect to Adobe Analytics Data in DBVisualizer
Integrate Adobe Analytics with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Automated Impala-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Impala and build automated workflows in Zapier.
-
How to connect to Sage Cloud Accounting Data in DBVisualizer
Integrate Sage Business Cloud Accounting with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to & Open ScrapingBee Data in Microsoft Excel
This article uses the CData ODBC driver for ScrapingBee to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query ScrapingBee Data in ColdFusion
Write standard ColdFusion data access code to connect to ScrapingBee.
-
How to Use a Microsoft Access Database to Update Sybase IQ Data in Real Time
Update Sybase IQ data by creating a linked table in Microsoft Access with the CData Sybase IQ ODBC Driver.
-
Create Dashboards and Visualize Live NetSuite SuiteAnalytics Data in Geckoboard
Use CData Connect AI to connect to live NetSuite SuiteAnalytics and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Oracle Service Cloud with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Service Cloud with External Services.
-
Migrating data from Brex to Google BigQuery using CData SSIS Components.
Easily push Brex to Google BigQuery using the CData SSIS Tasks for Brex and Google BigQuery.
-
How to connect PolyBase to Pipeliner CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pipeliner CRM.
-
Operational Reporting on Snapchat Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Snapchat Ads.
-
Design BIRT Reports on Oracle SCM Data
Provide current Oracle SCM to your embedded analytics.
-
Analyze Dynamics 365 Business Central Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Dynamics 365 Business Central and visualize live Dynamics 365 Business Central in Infragistics Reveal.
-
Create Excel Online-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Excel Online Data from OutSystems and build custom enterprise apps using live Microsoft Excel Online.
-
How to Query ChargeOver Data in MySQL Workbench
Execute MySQL queries against live ChargeOver from MySQL Workbench.
-
Connect to CSV Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for CSV Data and connect to CSV/TSV Files in Akorbi Digital RunMyProcess.
-
Bridge FTP Connectivity with Apache NiFi
Access and process FTP Servers in Apache NiFi using the CData JDBC Driver.
-
Create Reports with SAP Netweaver Gateway Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Netweaver Gateway.
-
Access Greenhouse Data from MySQL in PHP
Connect to Greenhouse through the standard MySQL libraries in PHP.
-
Access Opsgenie Data from MySQL in PHP
Connect to Opsgenie through the standard MySQL libraries in PHP.
-
Analyze Reckon Accounts Hosted Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Reckon Accounts Hosted from Power Pivot. You will use the Table Import Wizard to load Reckon Accounts Hosted. You can visually build the import query or use any SQL supported by the driver.
-
Using the CData Software ODBC Driver for Brex in PyCharm
Connect to Brex as an ODBC data source in PyCharm using the CData Software ODBC Driver for Brex.
-
Validate Bitbucket Data with QuerySurge
Access and validate Bitbucket in QuerySurge using the CData JDBC Driver.
-
A PostgreSQL Interface for Highrise Data (MySQL Remoting via JDBC)
Use the Remoting features of the Highrise JDBC Driver to create a PostgreSQL entry-point for data access.
-
Process & Analyze ZohoMarketingHub Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoMarketingHub Data.
-
Connect to Teradata Data from PowerBuilder via JDBC
This article demonstrates how to access Teradata from PowerBuilder using the Teradata JDBC Driver.
-
Connect to Acumatica Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Acumatica ERP.
-
Use the CData API Server to Access xBase Data in Microsoft PowerPivot
Use the CData API Server to connect to live xBase in the Power Pivot business intelligence tool.
-
Establish a Live Connection with PivotalTracker Data using Tableau Bridge
The CData ODBC Driver for PivotalTracker enables you to integrate live PivotalTracker into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Samanage Data in Sisense
Create an ElastiCube in Sisense app with access to Samanage.
-
Use the CData Software JDBC Driver for Float in MicroStrategy Web
Connect to Float in MicroStrategy Web using the CData Software JDBC Driver for Float.
-
Access Live Twilio Data in Excel 365 Online (Excel for the web)
Connect to Twilio from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData ADO.NET Provider for Vimeo
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build an OLAP Cube in SSAS from Highrise Data
Establish a connection to Highrise CRM data from SQL Server Analysis Services, and use the Highrise Data Provider to build OLAP cubes for use in analytics and reporting.
-
View Reports on Real-Time MarkLogic Data in Power BI Report Server
Use the CData ODBC Driver for MarkLogic to visualize MarkLogic in Power BI Desktop and then publish them to Power BI Report Server.