CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft OneDrive.
-
Access Live Parquet Data in Coginiti Pro
Connect to and query live Apache Parquet from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze SAP HANA Data in Looker
Use CData Connect AI to connect to SAP HANA Data from Looker and build custom apps using live SAP HANA.
-
How to Connect GraphQL 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 GraphQL data in real time using natural language.
-
Integrate with Suadeo Data in JReport Designer
Create charts and reports based on Suadeo in JReport Designer.
-
Rapidly Develop Smartsheet-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Smartsheet.
-
Seamlessly Bring Salesforce Marketing Data into Retool Using CData Connect AI
Integrate Salesforce Marketing data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Enable the Sybase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sybase.
-
How to connect to ZarMoney Data from Spring Boot
Connect to ZarMoney in a Spring Boot Application using the CData API Driver for JDBC
-
How to publish and share Recurly Data dashboards with Tableau Server
The CData ODBC driver for Recurly enables you integrate Recurly into Tableau dashboards.
-
Create Informatica Mappings From/To an ODBC Data Source for Mode
Create an ODBC connection to Mode in Informatica and browse and transfer Mode.
-
Using the CData Software ODBC Driver for Mixpanel in PyCharm
Connect to Mixpanel as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mixpanel.
-
Work with Live Microsoft Teams Data in Power Query
Use CData Connect AI to connect to Microsoft Teams and work with live Microsoft Teams in Microsoft Power Query.
-
How to work with Miro Data in Apache Spark using SQL
Access and process Miro Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to MariaDB Data from a Connection Pool in Jetty
The MariaDB JDBC Driver supports connection pooling: This article shows how to connect faster to MariaDB from Web apps in Jetty.
-
Using the CData Software ODBC Driver for SendPulse in PyCharm
Connect to SendPulse as an ODBC data source in PyCharm using the CData Software ODBC Driver for SendPulse.
-
Rapidly Develop Dotmailer-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Dotmailer.
-
Use the CData ODBC Driver for ZohoMarketingHub from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoMarketingHub to connect to ZohoMarketingHub from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoMarketingHub in Excel.
-
How to connect to Pushbullet Data in DBVisualizer
Integrate Pushbullet with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Dash to Build to Web Apps on Reckon Accounts Hosted Data
Create Python applications that use pandas and Dash to build Reckon Accounts Hosted-connected web apps.
-
How to connect to Workable Data in DBVisualizer
Integrate Workable with visual data analysis tools and data connection wizards in DBVisualizer
-
A PostgreSQL Interface for Gong Data (MySQL Remoting via JDBC)
Use the Remoting features of the Gong JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Aweber in MicroStrategy Web
Connect to Aweber in MicroStrategy Web using the CData Software JDBC Driver for Aweber.
-
How to connect SharePoint with Basecamp Data through external lists
Provide Basecamp to SharePoint users as an external list.
-
ETL Oracle Service Cloud in Oracle Data Integrator
This article shows how to transfer Oracle Service Cloud into a data warehouse using Oracle Data Integrator.
-
Connect to Acumatica Data from PowerBuilder via ADO.NET
This article demonstrates how to access Acumatica ERP from Appeon PowerBuilder using the CData ADO.NET Provider for Acumatica.
-
Analyze Google Sheets Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Sheets from Power Pivot. You will use the Table Import Wizard to load Google Sheets. You can visually build the import query or use any SQL supported by the driver.
-
Process & Analyze Reckon Accounts Hosted Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Reckon Accounts Hosted Data.
-
Visualize Zendesk Data in TIBCO Spotfire through ADO.NET
Integrate Zendesk into dashboards in TIBCO Spotfire.
-
ConvertAPI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ConvertAPI facts in real time.
-
View Reports on Real-Time Eventbrite Data in Power BI Report Server
Use the CData ODBC Driver for Eventbrite to visualize Eventbrite in Power BI Desktop and then publish them to Power BI Report Server.
-
Validate QuickBooks Time Data with QuerySurge
Access and validate QuickBooks Time in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for Google Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Ads.
-
Enable the CSV JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with CSV/TSV Files.
-
Connect to Tickspot from Asprova with CData Software ODBC Driver for Tickspot
This article shows how to connect faster to Tickspot data from Asprova.
-
How to create Visio diagrams from Azure Table Data
Automatically update Azure Table Storage with the changes you make to Visio master shapes.
-
Integrate Cline with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live QuickBooks Time from within your IDE.
-
Process & Analyze Aircall Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Aircall Data.
-
Object-Relational Mapping (ORM) with Square 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 Square into a Java-based ORM framework, Hibernate.
-
Access MarkLogic Data from MySQL in Amazon QuickSight
Connect to MarkLogic and build visualizations of MarkLogic using a MySQL Connection in Amazon QuickSight.
-
How to Seamlessly Import Simplesat Data into IBM SPSS Modeler
Integrate Simplesat data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SAP Data in RazorSQL
Connect to SAP from wizards and query SAP ERP/NetWeaver from the GUI in the RazorSQL database management tool.
-
Integrate Open WebUI with Live Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Contacts from within the chat interface.
-
Connect to Microsoft Dataverse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Dataverse as an External Source in Dremio.
-
Use the CData Software ODBC Driver for Google Analytics in MicroStrategy
Connect to Google Analytics in MicroStrategy Developer using the CData Software ODBC Driver for Google Analytics.
-
Using the CData Software ODBC Driver for Cloudant in PyCharm
Connect to Cloudant as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cloudant.
-
Prepare, Blend, and Analyze Nethunt Data in Alteryx Designer (ODBC)
Build workflows to access live Nethunt for self-service data analytics.
-
Integrate with Cloudant Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy IBM Cloudant to a JSON file on disk.
-
Replicate EnterpriseDB Data to Multiple Databases
Replicate EnterpriseDB to disparate databases with a point-and-click configuration.
-
Migrating data from ZohoExpense to Snowflake using CData SSIS Components.
Easily push ZohoExpense to Snowflake using the CData SSIS Tasks for ZohoExpense and Snowflake.
-
Stream Hive Data into Apache Kafka Topics
Access and stream Apache Hive in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Oracle Financials Cloud Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Financials Cloud from Node.js.
-
Connect to Freshsales Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshsales from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Work with QuickBooks Data in AWS Glue Jobs Using JDBC
Connect to QuickBooks from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect JotForm to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live JotForm using the CData Python MCP Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Hugging Face
Provide connectivity to Hugging Face through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Deel in MicroStrategy Desktop
Connect to Deel in MicroStrategy Desktop using the CData Software ODBC Driver for Deel.
-
Feed Wave Financial Data into FineReport
How to set Wave Financial as a JDBC data source in FineReport.
-
Connect to SingleStore Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SingleStore using standard SQL.
-
Connect Bullhorn CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Bullhorn CRM with IBM WebSphere for seamless data integration and connectivity.
-
Build Freshservice-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Freshservice.
-
Connect to HCL Domino Data in Aqua Data Studio
Access HCL Domino from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Opsgenie Replication to Snowflake
Use CData Sync for automated, continuous, customizable Opsgenie replication to Snowflake.
-
Import and Visualize SharePoint Data in Power View
Create data visualizations based on Microsoft SharePoint in Excel.
-
Visualize SingleStore 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 SingleStore into TIBCO Spotfire.
-
How to Query Live PostgreSQL Data in Perplexity MacOS Desktop
Connect to and query live PostgreSQL Data in Perplexity Desktop using CData MCP Server.
-
Query Strava Data in ColdFusion
Write standard ColdFusion data access code to connect to Strava.
-
Build Redis-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Redis Data from Zoho Analytics and import live Redis.
-
Easily Integrate Gumroad Data in Lazarus Pascal IDE
Learn how to easily integrate live Gumroad in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoExpense
Create an ODBC connection to ZohoExpense in Informatica and browse and transfer ZohoExpense.
-
How to Easily Query Sage Intacct Data in OpenOffice Base
Connect to Sage Intacct data in OpenOffice Base using the CData ODBC Driver for Sage Intacct and generate reports with live data insights.
-
Build Charts with Tally Data in Clear Analytics
Create dynamic charts and perform analytics based on Tally ERP in Clear Analytics.
-
Connect and Visualize Live Cosmos DB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Cosmos DB into the Databricks platform and create visualization dashboards with real-time Azure Cosmos DB.
-
Integrating Antigravity CLI with Highrise CRM via CData CLI
Connect Highrise CRM to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Missive-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Missive.
-
How to integrate Metabase with Microsoft Teams Data
Use CData Connect AI to connect to live Microsoft Teams and create an interactive dashboard in Metabase from Microsoft Teams.
-
How to Connect to & Open Printify Data in Microsoft Excel
This article uses the CData ODBC driver for Printify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Multiple FreeAgent Accounts
Replicate multiple FreeAgent accounts to one or many databases.
-
Visualize Browserless Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Browserless.
-
How to work with HDFS Data in Apache Spark using SQL
Access and process HDFS Data in Apache Spark using the CData Software JDBC Driver.
-
Visualize MessageBird Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MessageBird.
-
Automated QuickBooks Data Replication to Teradata
Use CData Sync to Customize and automate QuickBooks Desktop replication to Teradata.
-
Automated Continuous Planio Replication to Oracle
Use CData Sync for automated, continuous, customizable Planio replication to Oracle.
-
Analyze Airtable Data in Looker
Use CData Connect AI to connect to Airtable Data from Looker and build custom apps using live Airtable.
-
How to connect to Azure Data Catalog Data from Spring Boot
Connect to Azure Data Catalog in a Spring Boot Application using the CData JDBC Driver for Azure Data Catalog
-
Integrate Neo4J with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Neo4J with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Neo4J.
-
Import Real-Time Outreach.io Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Outreach.io in ColdFusion.
-
Build Dashboards with Sage 200 Data in DBxtra
Create dynamic dashboards and perform analytics based on Sage 200 in DBxtra.
-
Integrate SAP SuccessFactors Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP SuccessFactors from Informatica Cloud.
-
A PostgreSQL Interface for SingleStore Data using the CData ODBC Driver
Use the SQL Gateway and SingleStore ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Cohere Data from a Connection Pool in Jetty
The Cohere JDBC Driver supports connection pooling: This article shows how to connect faster to Cohere from Web apps in Jetty.
-
Query Dynamics 365 Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Dynamics 365 and perform CRUD operations on Dynamics 365 from Node.js.
-
Use the CData Software JDBC Driver for Google Ads in MicroStrategy Web
Connect to Google Ads in MicroStrategy Web using the CData Software JDBC Driver for Google Ads.
-
Getting Started with the CData Tableau Connector for Teamgate
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with WooCommerce Data using Tableau Bridge
The CData ODBC Driver for WooCommerce enables you to integrate live WooCommerce into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect Flowise AI Agents to Live Monday.com Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Monday.com without replication.
-
Access Live Basecamp 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 Basecamp through MCP integration.
-
Build Dashboards with Snapchat Ads Data in DBxtra
Create dynamic dashboards and perform analytics based on Snapchat Ads in DBxtra.
-
Deploy the ADO.NET Provider for Smartsheet on an SSRS Report Server
Connect to Smartsheet 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.
-
Getting Started with the CData Python Connector for HCL Domino
Learn to install and license the CData Python Connector