CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Bitbucket Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bitbucket replication to Apache Cassandra.
-
Manage Pushbullet Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pushbullet.
-
Process & Analyze IBM Informix Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live IBM Informix Data.
-
Provide OData Services of Clockify Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Clockify by developing a WCF Service Application.
-
Analyze Salesforce Data 360 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Data 360 from Power Pivot. You will use the Table Import Wizard to load Salesforce Data 360. You can visually build the import query or use any SQL supported by the driver.
-
How to Seamlessly Import EmailOctopus Data into IBM SPSS Modeler
Integrate EmailOctopus data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live Amazon Marketplace Data in Perplexity MacOS Desktop
Connect to and query live Amazon Marketplace Data in Perplexity Desktop using CData MCP Server.
-
Connect to BambooHR Data in DBeaver
Use the CData ODBC Driver to connect to BambooHR in DBeaver.
-
Automated Continuous LinkedIn Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Oracle.
-
Integrating Antigravity CLI with Microsoft Excel via CData CLI
Connect Microsoft Excel to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate Nethunt Data Replication to SAP HANA
Use CData Sync to customize and automate Nethunt replication to SAP HANA.
-
Use Dash to Build Web Apps on Zoho Inventory Data via CData Connect AI
Build interactive Dash web apps on live Zoho Inventory using pandas and the CData Connect AI Python SDK.
-
Connect to AlloyDB from Asprova with CData Software ODBC Driver for AlloyDB
This article shows how to connect faster to AlloyDB data from Asprova.
-
Extend Google Sheets with Jira Data
Make calls to Jira from Google Apps Script via the API Server.
-
How to connect to Spark Data from IntelliJ
Integrate connectivity to Apache Spark SQL with wizards in IntelliJ.
-
Object-Relational Mapping (ORM) with Odoo 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 Odoo ERP into a Java-based ORM framework, Hibernate.
-
Visualize Live SharePoint Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft SharePoint.
-
Extract, Transform, and Load RabbitMQ Data in Informatica PowerCenter
Create a simple Workflow for RabbitMQ in Informatica PowerCenter.
-
Getting Started with the CData ADO.NET Provider for CockroachDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for CockroachDB.
-
Access Live Suadeo Data in Coginiti Pro
Connect to and query live Suadeo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Dash to Build to Web Apps on Zendesk Data
Create Python applications that use pandas and Dash to build Zendesk-connected web apps.
-
Build Visualizations of Microsoft Entra ID Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Entra ID in Birst.
-
Visualize Testmonitor Data in Sisense
Create an ElastiCube in Sisense app with access to Testmonitor.
-
Create SSAS Tabular Models from Autopilot Data
How to build a SQL Server Analysis Service Tabular Model from Autopilot using CData drivers.
-
Connect to Avaza Data in Aqua Data Studio
Access Avaza from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query YouTube Analytics Data in ColdFusion
Write standard ColdFusion data access code to connect to YouTube Analytics.
-
Access Live SAP Concur Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Concur through MCP integration.
-
How to Connect to Live Office 365 Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Microsoft Office 365 for you.
-
Use the CData Software JDBC Driver for Copper in MicroStrategy Web
Connect to Copper in MicroStrategy Web using the CData Software JDBC Driver for Copper.
-
Access Live MailerSend Data in Coginiti Pro
Connect to and query live MailerSend from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to DocuSign Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live DocuSign from Filemaker Pro on Mac.
-
Build Adobe Commerce-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Adobe Commerce to explore live Adobe Commerce Data in GitHub Copilot to assist with building Adobe Commerce-powered applications.
-
How to Seamlessly Import ChargeOver Data into IBM SPSS Modeler
Integrate ChargeOver data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for Amazon Athena in MicroStrategy Desktop
Connect to Amazon Athena in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon Athena.
-
Integrating LangChain with Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Highrise CRM within automated workflows.
-
Integrate Bullhorn CRM Data in the Pentaho Report Designer
Publish reports based on Bullhorn CRM in the Pentaho BI tool.
-
How to Create Power BI Visual Reports with Real-Time Postmark Data
Use CData Power BI Connectors to visualize Postmark in Power BI.
-
Automate DB2 Data Replication to Couchbase
Use CData Sync to Customize and automate IBM DB2 replication to Couchbase.
-
How to work with Jumpseller Data in Apache Spark using SQL
Access and process Jumpseller Data in Apache Spark using the CData Software JDBC Driver.
-
Working with Intercom Data in LINQPad
Execute LINQ queries to Intercom in LINQPad.
-
Build Visualizations of Google Directory Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Directory in Birst.
-
How to Connect to & Open Google Spanner Data in Microsoft Excel
This article uses the CData ODBC driver for Google Spanner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Informatica Mappings From/To a JDBC Data Source for Epicor Kinetic
Create Epicor Kinetic data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Apify Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apify from Informatica Cloud.
-
Replicate Vertica Data in Heroku for Use in Salesforce Connect
Replicate Vertica to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect Gmail Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Gmail using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with Certinia Data in JReport Designer
Create charts and reports based on Certinia in JReport Designer.
-
Connect to Paylocity Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Paylocity and the Script function in FileMaker Pro to connect to Paylocity and work with Paylocity in your FileMaker application.
-
Query XML Data from Node.js
Use the OData endpoint of the CData API Server to connect to your XML Files and perform CRUD operations on XML from Node.js.
-
Viewing SingleStore Data in RAD Studio Data Explorer
How to view SingleStore in RAD Studio Data Explorer using the CData ODBC Driver for SingleStore.
-
Create Apps from Sage Cloud Accounting Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sage Cloud Accounting Data and build apps from live Sage Business Cloud Accounting in Qlik Sense Cloud.
-
Use ChatGPT to Talk to Your SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP SuccessFactors for you.
-
DataBind Controls to Grafana Data in C++Builder
DataBind to Grafana in C++Builder with standard components and controls.
-
Integrate Wistia with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Wistia with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Wistia.
-
Connect to HBase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apache HBase in Airbyte.
-
Explore Geographical Relationships in LionDesk Data with Power Map
Create data visualizations with LionDesk in Power Map.
-
Integrating GitHub Copilot CLI with Pipeline CRM 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.
-
Access Jodoo Data from MySQL in Amazon QuickSight
Connect to Jodoo and build visualizations of Jodoo using a MySQL Connection in Amazon QuickSight.
-
Automate Apify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apify from PowerShell? This article demonstrates how to utilize the Apify Cmdlets for tasks like connecting to Apify, automating operations, downloading data, and more.
-
Integrate with Neo4J Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Neo4J in SnapLogic.
-
Explore Geographical Relationships in Datadog Data with Power Map
Create data visualizations with Datadog in Power Map.
-
Seamlessly Bring Dynamics 365 Data into Retool Using CData Connect AI
Integrate Dynamics 365 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to ServiceNow from Asprova with CData Software ODBC Driver for ServiceNow
This article shows how to connect faster to ServiceNow data from Asprova.
-
Automated Continuous SAP Ariba Procurement Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Vertica.
-
Create Sage 200-Connected Nintex Workflows
Use CData Connect AI to connect to Sage 200 Data from Nintex Workflow Cloud and build custom workflows using live Sage 200.
-
Integrating Claude Code with Azure Table Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Azure Table Storage within assisted coding and automated development workflows.
-
Use the CData Software JDBC Driver for EnterpriseDB in MicroStrategy Web
Connect to EnterpriseDB in MicroStrategy Web using the CData Software JDBC Driver for EnterpriseDB.
-
Connect to Google Campaign Manager 360 Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Campaign Manager 360 in Google Apps Script.
-
Access Google Search Results from MySQL in PHP
Connect to Google Search through the standard MySQL libraries in PHP.
-
Establish a Live Connection with TaxJar Data using Tableau Bridge
The CData ODBC Driver for TaxJar enables you to integrate live TaxJar into Tableau Cloud dashboards using the Tableau Bridge.
-
Working with Avalara AvaTax Data in LINQPad
Execute LINQ queries to Avalara AvaTax in LINQPad.
-
Working with Google Search Results in LINQPad
Execute LINQ queries to Google Search in LINQPad.
-
Connect to Greenplum Data in NetBeans
Connect to Pivotal GreenPlum in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for FreshBooks in MicroStrategy Web
Connect to FreshBooks in MicroStrategy Web using the CData Software JDBC Driver for FreshBooks.
-
Automate Active Directory Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Active Directory from PowerShell? This article demonstrates how to utilize the Active Directory Cmdlets for tasks like connecting to Active Directory, automating operations, downloading data, and more.
-
How to Connect to Live Twilio Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Twilio for you.
-
Connect to Deel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Deel and the SQL Gateway to access Deel from Google Apps Script.
-
Analyze Twitter Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Twitter Ads in Microsoft R Open.
-
Establish a Live Connection with Bullhorn CRM Data using Tableau Bridge
The CData ODBC Driver for Bullhorn CRM enables you to integrate live Bullhorn CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to GetResponse Data in DBVisualizer
Integrate GetResponse with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect Simplesat to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Simplesat with IBM WebSphere for seamless data integration and connectivity.
-
Create Informatica Mappings From/To a JDBC Data Source for Impala
Create Impala data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect PolyBase to Google Contacts
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Contacts.
-
Use the CData Software JDBC Driver for MailerSend in MicroStrategy
Connect to MailerSend in MicroStrategy Developer using the CData Software JDBC Driver for MailerSend.
-
Build NetSuite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to NetSuite CRM & ERP and build web apps with connectivity to live NetSuite CRM & ERP.
-
Replicate Instagram Data from PowerShell
Write a quick PowerShell script to query Instagram. Use connectivity to the live data to replicate Instagram to SQL Server.
-
Build Pipelines with Live ShipStation Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ShipStation from Google Cloud Data Fusion, enabling the integration of live ShipStation into the building and management of effective data pipelines.
-
Automated Continuous Bitbucket Replication to SQLite
Use CData Sync for automated, continuous, customizable Bitbucket replication to SQLite.
-
Build Amazon Athena-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amazon Athena and build web apps with connectivity to live Amazon Athena.
-
Build MVC Applications with Connectivity to GraphQL Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access GraphQL from an ASP.NET MVC application.
-
Feed Pingdom Data into FineReport
How to set Pingdom as a JDBC data source in FineReport.
-
How to Connect to Live Basecamp 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 Basecamp without replication.
-
Automated Continuous Google Forms Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Forms replication to PostgreSQL.
-
Automate Testmonitor Data Replication to Azure Synapse
Use CData Sync to customize and automate Testmonitor replication to Azure Synapse.
-
DataBind Controls to Microsoft Dataverse Data in C++Builder
DataBind to Microsoft Dataverse (CDS) in C++Builder with standard components and controls.
-
Connect to QuickBooks Online Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with QuickBooks Online Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Miro Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Miro in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Write a Simple Go Application to work with Telegram Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Telegram.
-
Use the CData Software ODBC Driver for Shopify in MicroStrategy Web
Connect to Shopify in MicroStrategy Web using the CData Software ODBC Driver for Shopify.
-
Access Paymo Data from MySQL in Amazon QuickSight
Connect to Paymo and build visualizations of Paymo using a MySQL Connection in Amazon QuickSight.