CData Software - Knowledge Base
Recent Articles
-
Enable the SendGrid JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SendGrid.
-
Operational Reporting on Foursquare Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Foursquare.
-
Migrating data from ConvertKit to Databricks using CData SSIS Components.
Easily push ConvertKit to Databricks using the CData SSIS Tasks for ConvertKit and Databricks.
-
Easily Integrate Calendly Data in Lazarus Pascal IDE
Learn how to easily integrate live Calendly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create SSAS Tabular Models from PhantomBuster Data
How to build a SQL Server Analysis Service Tabular Model from PhantomBuster using CData drivers.
-
Connect to and Visualize Live Microsoft Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Ads.
-
Integrating Antigravity CLI with Salesforce CRM Analytics via CData CLI
Connect Salesforce CRM Analytics to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SQL Analysis Services
Provide connectivity to SQL Analysis Services through an SAP BusinessObjects universe.
-
Publish Reports with LionDesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LionDesk.
-
Connect to Workable Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Workable as an External Source in Dremio.
-
Analyze Live WordPress Data in SAS Viya
Use CData Connect AI to connect to WordPress from SAS Viya and deploy self-service analytics using live WordPress.
-
Connect to Sybase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sybase from Filemaker Pro on Mac.
-
Automated Continuous Excel Online Replication to Vertica
Use CData Sync for automated, continuous, customizable Excel Online replication to Vertica.
-
How to integrate Zoho CRM with Apache Airflow
Access and process Zoho CRM in Apache Airflow using the CData JDBC Driver.
-
How to Build an ETL App for Microsoft Entra ID Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Entra ID in Python with petl.
-
Migrating data from Tally to Google BigQuery using CData SSIS Components.
Easily push Tally ERP to Google BigQuery using the CData SSIS Tasks for Tally and Google BigQuery.
-
How to Connect to Live Splunk Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Splunk through natural language.
-
Integrate FTP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FTP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FTP Servers.
-
Write a Simple Go Application to work with Campaigner Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Campaigner.
-
Connect to Slack Data from a Connection Pool in JBoss
Integrate Slack into Java servlets: Use the Management Console in JBoss to install the Slack JDBC Driver.
-
Automated Continuous Attio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Attio replication to Apache Kafka.
-
Access Live Zoho CRM Data in TIBCO Data Virtualization
Use the Zoho CRM Tibco DV Adapter to create a Zoho CRM data source in TIBCO Data Virtualization Studio and gain access to live Zoho CRM from your TDV Server.
-
How to Connect to Live SAP Fieldglass Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Fieldglass without replication.
-
Build Snapchat Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Snapchat Ads Data and create custom apps in Mendix.
-
Use JayDeBeApi to access OpenWeatherMap Data in Python
Use standard Python scripting and the development environment of your choice to access live OpenWeatherMap.
-
Perform Batch Operations with MailChimp Data in Apache NiFi
Connect to MailChimp and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to create Cosmos DB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Cosmos DB in MySQL .
-
Connect to OnePageCrm in SpagoBI
Create reports featuring live OnePageCrm in SpagoBI Studio. Host OnePageCrm reports on SpagoBI Server.
-
Establish a Live Connection with Amplitude Data using Tableau Bridge
The CData ODBC Driver for Amplitude enables you to integrate live Amplitude into Tableau Cloud dashboards using the Tableau Bridge.
-
Choosing the Best Method to Connect Insightly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Insightly from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Feed EmailOctopus Data into FineReport
How to set EmailOctopus as a JDBC data source in FineReport.
-
Design BIRT Reports on ShipStation Data
Provide current ShipStation to your embedded analytics.
-
Query Unbounce Data as a MySQL Database in Node.js
Execute MySQL queries against Unbounce from Node.js.
-
Automated Continuous Gorgias Replication to SQLite
Use CData Sync for automated, continuous, customizable Gorgias replication to SQLite.
-
Automate Klaviyo Data Replication to Couchbase
Use CData Sync to Customize and automate Klaviyo replication to Couchbase.
-
Easily Integrate Google Sheets Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Sheets in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData SSIS Components for Highrise
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Highrise.
-
Create a Data Access Object for Typeform Data using JDBI
A brief overview of creating a SQL Object API for Typeform in JDBI.
-
Creating Google Sheets-Connected Applications in Unqork
You can use CData Connect AI to feed Google Sheets to Unqork and build custom business apps.
-
Create BenchmarkEmail Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time BenchmarkEmail data access from reports, embedded analytics, and more.
-
Visualize Cvent Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cvent.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amazon Marketplace
Provide connectivity to Amazon Marketplace through an SAP BusinessObjects universe.
-
Connect to Elasticsearch Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Elasticsearch to connect to Elasticsearch and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Hubstaff in MicroStrategy
Connect to Hubstaff in MicroStrategy Developer using the CData Software JDBC Driver for Hubstaff.
-
Moving Data from Sage Intacct to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sage Intacct data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Dynamic Elasticsearch Grids Using the Infragistics XamDataGrid
Learn how you can connect Elasticsearch to Infragistics XamDataGrid to build dynamic grids.
-
Perform Batch Operations with Excel Online Data in Apache NiFi
Connect to Microsoft Excel Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate Live Avro Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache Avro to Blue Prism using the CData ODBC Driver for Avro to create automated workflows for repetitive business tasks.
-
Getting Started with the CData JDBC Driver for Helpscout
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Helpscout.
-
Automate PolarTeamPro Data Replication to SAP HANA
Use CData Sync to customize and automate PolarTeamPro replication to SAP HANA.
-
Enable the Act-On JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Act-On.
-
Extend Google Sheets with Bitbucket Data
Make calls to Bitbucket from Google Apps Script via the API Server.
-
Create a Data Access Object for Office 365 Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Office 365 in JDBI.
-
Connect to Planio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Planio.
-
Publish Crystal Reports on Cosmos DB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Cosmos DB.
-
Connect to xBase Data in Ruby
Connect to xBase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Google Calendar from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Calendar to connect to Google Calendar from Web applications running on WebLogic.
-
Use the CData Software JDBC Driver for Bright Data in MicroStrategy Web
Connect to Bright Data in MicroStrategy Web using the CData Software JDBC Driver for Bright Data.
-
Import Real-Time Access Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Access in ColdFusion.
-
Design BIRT Reports on NetSuite Data
Provide current NetSuite CRM & ERP to your embedded analytics.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in MicroStrategy Desktop
Connect to SAP SuccessFactors LMS in MicroStrategy Desktop using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
Create Reports with Amazon Athena Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon Athena.
-
Build a Simple VCL Application for Retently Data
How to build a simple VCL Application to view Retently in RAD Studio using the CData ODBC Driver for Retently.
-
Connect to and Query MarkLogic Data in QlikView over ODBC
Create data visualizations with MarkLogic in QlikView.
-
Feed PagerDuty Data into FineReport
How to set PagerDuty as a JDBC data source in FineReport.
-
Connect to SAP Business Warehouse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Business Warehouse.
-
How to publish and share ClickTime Data dashboards with Tableau Server
The CData ODBC driver for ClickTime enables you integrate ClickTime into Tableau dashboards.
-
How to create Visio diagrams from JSON Services
Automatically update JSON with the changes you make to Visio master shapes.
-
Process & Analyze Kafka Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Kafka Data.
-
Connect to Odoo Data in RapidMiner
Integrate Odoo ERP with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Semantic Layer Views for Microsoft OneDrive Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft OneDrive.
-
Adobe Commerce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Adobe Commerce facts in real time.
-
Replicate Zendesk Data to Multiple Databases via the CData Sync CLI
Replicate Zendesk to disparate databases with a single configuration.
-
How to load Coinbase data into Elasticsearch via Logstash
Introducing a simple method to load Coinbase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Edit and Search External Snowflake Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Snowflake to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Snowflake Data objects that you can access from apps and the dashboard.
-
Establish a Live Connection with Perigon Data using Tableau Bridge
The CData ODBC Driver for Perigon enables you to integrate live Perigon into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software ODBC Driver for LinkedIn Ads in MicroStrategy Desktop
Connect to LinkedIn Ads in MicroStrategy Desktop using the CData Software ODBC Driver for LinkedIn Ads.
-
Visualize Live SendGrid Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SendGrid.
-
How to connect to Reckon Data from IntelliJ
Integrate connectivity to Reckon with wizards in IntelliJ.
-
Connect to Presto Data in ACL Analytics
Connect to Presto via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Presto.
-
Query Live Cassandra Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Apache Cassandra directly from the development environment.
-
Connect to Basecamp Data from a Connection Pool in Jetty
The Basecamp JDBC Driver supports connection pooling: This article shows how to connect faster to Basecamp from Web apps in Jetty.
-
Build Visualizations of LinkedIn Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LinkedIn Ads in Birst.
-
Choosing the Best Method to Connect Sentry to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sentry from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate WooCommerce Data in Heroku for Use in Salesforce Connect
Replicate WooCommerce to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to CSV Data in NetBeans
Connect to CSV/TSV Files in NetBeans with the data source configuration wizard.
-
Connect to OnePageCrm from Asprova with CData Software ODBC Driver for OnePageCrm
This article shows how to connect faster to OnePageCrm data from Asprova.
-
Deploy the ADO.NET Provider for Harvest on an SSRS Report Server
Connect to Harvest 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.
-
Automated Continuous GitLab Replication to Oracle
Use CData Sync for automated, continuous, customizable GitLab replication to Oracle.
-
Connect to Auth0 Data from PowerBuilder via JDBC
This article demonstrates how to access Auth0 from PowerBuilder using the Auth0 JDBC Driver.
-
How to Query Live SAP Ariba Procurement Data in Claude Desktop
Connect to and query live SAP Ariba Procurement Data in Claude Desktop using CData MCP Server.
-
Getting Started with the CData ADO.NET Provider for Nuclia
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Clio Replication to Databricks
Use CData Sync for automated, continuous, customizable Clio replication to Databricks.
-
How to Easily Query Flowlu Data in OpenOffice Base
Connect to Flowlu data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Enable the SQL Server JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft SQL Server.
-
Access Live Cvent Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Cvent from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automate Oracle Financials Cloud Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle Financials Cloud replication to Azure Synapse.
-
Operational Reporting on Mistral AI Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mistral AI.
-
Enable the Avro JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Avro.
-
ETL Tally in Oracle Data Integrator
This article shows how to transfer Tally ERP into a data warehouse using Oracle Data Integrator.