CData Software - Knowledge Base
Recent Articles
-
Integrate Cloudant Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live IBM Cloudant from Informatica Cloud.
-
How to connect PolyBase to SendPulse
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SendPulse.
-
Use the CData Software ODBC Driver for Smartsheet in MicroStrategy
Connect to Smartsheet in MicroStrategy Developer using the CData Software ODBC Driver for Smartsheet.
-
Publish Reports with Pingdom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pingdom.
-
Building Dynamic Web Pages with Okta Data Using AngularJS
Create single-page applications with live connectivity to Okta using the CData API Server.
-
Query, Visualize, and Share live Snapchat Ads Data in Redash
Use CData Connect AI to connect to live Snapchat Ads in Redash for querying, visualizing, and sharing.
-
Working with FreshBooks Data in LINQPad
Execute LINQ queries to FreshBooks in LINQPad.
-
How to Connect DBeaver to Pinterest via a JDBC Driver
Manage Pinterest with visual tools in DBeaver like the query browser.
-
Automated Continuous Oracle Sales Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Google BigQuery.
-
Rapidly Develop Google Ads-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 Google Ads.
-
Consume SAP ByDesign OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP ByDesign feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData Python Connector for Pingdom
Learn to install and license the CData Python Connector
-
Import Real-Time SAP Concur Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Concur in ColdFusion.
-
Build Semantic Layer Views for Amazon DynamoDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Amazon DynamoDB.
-
Add Bannerbear Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bannerbear with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Google Directory Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Directory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use Dash to Build Web Apps on Pipedrive Data via CData Connect AI
Build interactive Dash web apps on live Pipedrive using pandas and the CData Connect AI Python SDK.
-
Analyze SharePoint Excel Services Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SharePoint Excel Services with the CData JDBC Driver for SharePoint Excel Services.
-
Visualize Live Mailgun Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mailgun using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Anaplan Data in Power View
Create data visualizations based on Anaplan in Excel.
-
Create Informatica Mappings From/To an ODBC Data Source for Amazon Marketplace
Create an ODBC connection to Amazon Marketplace in Informatica and browse and transfer Amazon Marketplace.
-
Visualize Optimizely Data in Sisense
Create an ElastiCube in Sisense app with access to Optimizely.
-
Connect to Vimeo Data in HULFT Integrate
Connect to Vimeo as a JDBC data source in HULFT Integrate
-
Connect to Salesloft Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesloft.
-
Process & Analyze Clari Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Clari Data.
-
Automated Continuous Mailgun Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mailgun replication to AlloyDB.
-
Build SAP HANA-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP HANA and build web apps with connectivity to live SAP HANA.
-
Query Microsoft Exchange Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Exchange entities in PHP by modeling them as objects.
-
Getting Started with the CData ODBC Driver for Procore
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Procore.
-
Integrating Antigravity CLI with Airtable via CData CLI
Connect Airtable to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to LaunchDarkly Data in Aqua Data Studio
Access LaunchDarkly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Live MySQL Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MySQL from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MySQL.
-
Integrating LlamaIndex with Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Email in real time.
-
Use CData Connect AI to Access IBM Cloud Object Storage Data in Microsoft Power Pivot
Use CData Connect AI to connect to live IBM Cloud Object Storage in the Power Pivot business intelligence tool.
-
How to connect SharePoint with HCL Domino Data through external lists
Provide HCL Domino to SharePoint users as an external list.
-
Connect to Google Search Results in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Search and the SQL Gateway to access Google Search from Google Apps Script.
-
Natively Connect to Avro Data in PHP
The CData ODBC driver for Avro enables you to create PHP applications with connectivity to Apache Avro. Leverage the native support for ODBC in PHP.
-
How to import Microsoft OneDrive Data into Apache Solr
Use the CData Software JDBC Driver for Microsoft OneDrive in Data Import Handler and create an automated import of Microsoft OneDrive to Apache Solr Enterprise Search platform.
-
Visualize Simplesat Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Simplesat.
-
Build EmailOctopus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to EmailOctopus and build web apps with connectivity to live EmailOctopus.
-
How to connect to Guru Data from Spring Boot
Connect to Guru in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Clockify Data in DBArtisan
Use wizards in DBArtisan to configure Clockify as a data source.
-
Use Manus AI to Talk to Your Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Microsoft Dynamics 365.
-
Stream Azure Table Data into Apache Kafka Topics
Access and stream Azure Table Storage in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Excel Spreadsheet Automation on Bannerbear Data with the QUERY Formula
Pull data from Bannerbear, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Tableau Connector for MailChimp
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for MailChimp.
-
Build SFTP-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SFTP to explore live SFTP Data in Gemini Code Assist to assist with building SFTP-powered applications.
-
Bind Live Reckon Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Reckon data
-
Use Biml to Build SSIS Tasks to Replicate Marketo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Marketo to SQL Server.
-
Create Power BI Reports on Real-Time Email Data
Use the CData ODBC Driver for Email to visualize Email in Power BI Desktop.
-
Import Real-Time Certinia Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Certinia in ColdFusion.
-
Import Real-Time Egnyte Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Egnyte in ColdFusion.
-
Provide OData Services of FreshBooks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FreshBooks by developing a WCF Service Application.
-
Connect to IBM Informix Data from a Connection Pool in JBoss
Integrate IBM Informix into Java servlets: Use the Management Console in JBoss to install the IBM Informix JDBC Driver.
-
Integrating Front Data in Talend Cloud Data Management Platform
Connect Front Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to integrate Mouseflow with Apache Airflow
Access and process Mouseflow in Apache Airflow using the CData JDBC Driver.
-
Work with Live Trello Data in Power Query
Use CData Connect AI to connect to Trello and work with live Trello in Microsoft Power Query.
-
Integrate Reckon Accounts Hosted Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Reckon Accounts Hosted from Informatica Cloud.
-
Automate Basecamp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Basecamp from PowerShell? This article demonstrates how to utilize the Basecamp Cmdlets for tasks like connecting to Basecamp, automating operations, downloading data, and more.
-
Build Visualizations of Facebook Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Facebook in Birst.
-
How to connect to SAP Ariba Procurement Data from Spring Boot
Connect to SAP Ariba Procurement in a Spring Boot Application using the CData JDBC Driver for SAP Ariba Procurement
-
Automated Continuous Cloudflare Replication to SQLite
Use CData Sync for automated, continuous, customizable Cloudflare replication to SQLite.
-
Integrate Live YouTube Analytics Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Facebook Ads Data from a Connection Pool in Jetty
The Facebook Ads JDBC Driver supports connection pooling: This article shows how to connect faster to Facebook Ads from Web apps in Jetty.
-
Visualize JSON Services from Tableau
Use the Tableau Desktop business intelligence tool to connect to JSON.
-
Replicate Splunk Data in Heroku for Use in Salesforce Connect
Replicate Splunk to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Perform Batch Operations with Twilio Data in Apache NiFi
Connect to Twilio and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Analyze SAP Fieldglass Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Fieldglass and visualize live SAP Fieldglass in Infragistics Reveal.
-
Automated Continuous OData Replication to Amazon S3
Use CData Sync for automated, continuous, customizable OData replication to Amazon S3.
-
Use the CData Software JDBC Driver for JotForm in MicroStrategy
Connect to JotForm in MicroStrategy Developer using the CData Software JDBC Driver for JotForm.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Dynamics 365 Business Central
Provide connectivity to Dynamics 365 Business Central through an SAP BusinessObjects universe.
-
Stream Basecamp Data into Apache Kafka Topics
Access and stream Basecamp in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Zoho CRM Data from Spring Boot
Connect to Zoho CRM in a Spring Boot Application using the CData JDBC Driver for Zoho CRM
-
Getting Started with the CData ODBC Driver for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PivotalTracker.
-
Work with CSV Data in FoxPro
Load CSV/TSV Files into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy Desktop
Connect to Epicor Kinetic in MicroStrategy Desktop using the CData Software ODBC Driver for Epicor Kinetic.
-
Process & Analyze Oracle Eloqua Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Eloqua Data.
-
Integrate Eventbrite Data in Pentaho Data Integration
Build ETL pipelines based on Eventbrite in the Pentaho Data Integration tool.
-
Analyze Live Google Drive Data in SAS Viya
Use CData Connect AI to connect to Google Drive from SAS Viya and deploy self-service analytics using live Google Drive.
-
DataBind Controls to Google Search Results in Delphi
DataBind to Google Search in Delphi with standard data access components and controls.
-
Getting Started with the CData ODBC Driver for PingOne
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PingOne.
-
Enable the Printful JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Printful.
-
Analyze Quickbase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Quickbase from Power Pivot. You will use the Table Import Wizard to load Quickbase. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SingleStore Data in Jaspersoft Studio
Execute SQL to remote SingleStore in Jaspersoft Studio.
-
Create Reports with Greenhouse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Greenhouse.
-
Integrate Helpscout with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Helpscout with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Helpscout.
-
Work with Webflow Data in FoxPro
Load Webflow into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Multiple SQL Server Accounts via the CData Sync CLI
Replicate multiple SQL Server accounts to one or many databases.
-
Getting Started with the CData Tableau Connector for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP HANA XS Advanced.
-
Integrating OpenCode Terminal with Splunk 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.
-
How to Use a Microsoft Access Database to Update Google Campaign Manager 360 Data in Real Time
Update Google Campaign Manager 360 data by creating a linked table in Microsoft Access with the CData Google Campaign Manager 360 ODBC Driver.
-
Stream Redis Data into Apache Kafka Topics
Access and stream Redis in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Dash to Build Web Apps on Microsoft OneDrive Data via CData Connect AI
Build interactive Dash web apps on live Microsoft OneDrive using pandas and the CData Connect AI Python SDK.
-
Building Dynamic Web Pages with Parquet Data Using AngularJS
Create single-page applications with live connectivity to Parquet using the CData API Server.
-
Use the CData Software JDBC Driver for Azure Table in MicroStrategy Web
Connect to Azure Table Storage in MicroStrategy Web using the CData Software JDBC Driver for Azure Table.
-
Create DocuSign-Connected Business Apps in AppSheet
Connect to DocuSign Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to DocuSign.
-
Moving Data from LinkedIn Ads to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LinkedIn Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to and Visualize Live Salesforce CRM Analytics Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce CRM Analytics.
-
Connect Google Forms to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Forms with IBM WebSphere for seamless data integration and connectivity.
-
Build Data Flows from SQL Server to Dropbox through SSIS
Easily push SQL Server data to Dropbox using the CData SSIS Tasks for Dropbox.