CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for Presto in PyCharm
Connect to Presto as an ODBC data source in PyCharm using the CData Software ODBC Driver for Presto.
-
Build Excel Online Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Excel Online and build visualizations in Tableau Cloud.
-
Analyze CouchDB in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache CouchDB with the CData JDBC Driver for CouchDB.
-
Validate Azure Data Lake Storage with QuerySurge
Access and validate Azure Data Lake Storage in QuerySurge using the CData JDBC Driver.
-
ETL Neo4J in Oracle Data Integrator
This article shows how to transfer Neo4J into a data warehouse using Oracle Data Integrator.
-
Build OneNote-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for OneNote and create custom apps in Mendix.
-
Integrate Salesforce Data Cloud in Pentaho Data Integration
Build ETL pipelines based on Salesforce Data Cloud in the Pentaho Data Integration tool.
-
How to Connect to & Open Jira in Microsoft Excel
This article uses the CData ODBC driver for Jira to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live SAP HANA Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Import Twitter Ads Using Azure Data Factory
Use CData Connect AI to connect to Twitter Ads from Azure Data Factory and import live Twitter Ads.
-
Write a Simple Go Application to work with eBay on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to eBay.
-
Enable the MongoDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MongoDB.
-
How to Seamlessly Import Impala Data into IBM SPSS Modeler
Integrate Impala data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze YouTube Analytics in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze YouTube Analytics in Microsoft R Open.
-
Getting Started with the CData SSIS Components for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage Cloud Accounting.
-
Connect to and Query Oracle Financials Cloud in QlikView over ODBC
Create data visualizations with Oracle Financials Cloud in QlikView.
-
Consume SAP Fieldglass OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Fieldglass feeds that reflect any changes in SAP Lumira.
-
Integrate MailChimp with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MailChimp with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MailChimp.
-
Publish Acumatica-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Acumatica ERP.
-
HCL Domino Reporting in OBIEE with the HCL Domino JDBC Driver
Deploy the HCL Domino JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live Smartsheet 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 Smartsheet for you.
-
Create Google Cloud Storage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Cloud Storage data access from reports, embedded analytics, and more.
-
Use Azure AI Foundry to Talk to Your GraphQL via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your GraphQL for you.
-
Replicate Blackbaud FE NXT from PowerShell
Write a quick PowerShell script to query Blackbaud FE NXT. Use connectivity to the live data to replicate Blackbaud FE NXT to SQL Server.
-
Query Twilio as a MySQL Database in Node.js
Execute MySQL queries against Twilio from Node.js.
-
Build a PostgreSQL Interface for GraphQL using the CData JDBC Driver
Use the Remoting features of the GraphQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to GraphQL
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 GraphQL Data Provider.
-
Integrating Boomi Agentstudio with WooCommerce via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to WooCommerce, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Calendly in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Calendly from Informatica Cloud.
-
Import and Visualize SharePoint Excel Services in Power View
Create data visualizations based on SharePoint Excel Services in Excel.
-
Integrate with live Databricks in Jitterbit
Use CData Connect AI to connect to and integrate live Databricks in Jitterbit.
-
How to connect to Oracle HCM Cloud from IntelliJ
Integrate connectivity to Oracle HCM Cloud with wizards in IntelliJ.
-
Access Live Google Drive in AWS Lambda
Connect to live Google Drive in AWS Lambda using the CData JDBC Driver.
-
How to Work with Zoho CRM in AWS Glue Jobs Using JDBC
Connect to Zoho CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Bidirectional Access to Amazon S3 from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amazon S3 in Filemaker Pro for Mac or Windows.
-
Use Dash to Build to Web Apps on Xero
Create Python applications that use pandas and Dash to build Xero-connected web apps.
-
Working with HBase in LINQPad
Execute LINQ queries to Apache HBase in LINQPad.
-
Access Live Salesforce in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce & Force.com from your Excel spreadsheets.
-
Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy
Connect to Zoho Projects in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Projects.
-
Automated Continuous MySQL Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MySQL replication to AlloyDB.
-
Build Charts with Adobe Target in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Target in Clear Analytics.
-
Build Act CRM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Act CRM and create custom apps in Bubble.
-
Replicate Invoiced to Multiple Databases
Replicate Invoiced to disparate databases with a point-and-click configuration.
-
Connect to Jira Service Management in HULFT Integrate
Connect to Jira Service Management as a JDBC data source in HULFT Integrate
-
Stream QuickBooks into Apache Kafka Topics
Access and stream QuickBooks Desktop in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Oracle Eloqua-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Eloqua from Zoho Analytics and import live Oracle Eloqua.
-
Create Reports from Azure Data Lake Storage in Looker Studio
Use CData Connect AI to gain access to live Azure Data Lake Storage and create custom reports in Looker Studio.
-
How to Visualize Dynamics CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Dynamics CRM in Python.
-
Connect to and Visualize Live Excel in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel.
-
DataBind Controls to PostgreSQL in Delphi
DataBind to PostgreSQL in Delphi with standard data access components and controls.
-
Analyze Salesforce Marketing in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Marketing Cloud and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Blackbaud FE NXT Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Blackbaud FE NXT facts in real time.
-
Visualize Wave Financial in TIBCO Spotfire through OData
Integrate Wave Financial into dashboards in TIBCO Spotfire.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live DocuSign using the Model Context Protocol.
-
Consume DocuSign OData Feeds in SAP Lumira
Use the API Server to create data visualizations on DocuSign feeds that reflect any changes in SAP Lumira.
-
Visualize Coinbase in Sisense
Create an ElastiCube in Sisense app with access to Coinbase.
-
Replicate Multiple Twilio Accounts
Replicate multiple Twilio accounts to one or many databases.
-
Integrate Live SAS Data Sets into Blue Prism for Intelligent Robotic Process Automation (RPA)
-