CData Software - Knowledge Base
Recent Articles
-
Connect to Snowflake from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snowflake from Filemaker Pro on Mac.
-
A PostgreSQL Interface for DocuSign (MySQL Remoting via JDBC)
Use the Remoting features of the DocuSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Establish a Live Connection with CockroachDB using Tableau Bridge
The CData ODBC Driver for CockroachDB enables you to integrate live CockroachDB into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Reckon Accounts Hosted Replication to Databricks
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Databricks.
-
Getting Started with the CData Python Connector for Salesforce Marketing
Learn to install and license the CData Python Connector
-
Create Tableau CRM Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate Adobe Analytics Replication to Couchbase
Use CData Sync to Customize and automate Adobe Analytics replication to Couchbase.
-
Visualize Live Dynamics 365 in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics 365.
-
Automated Continuous Pinterest Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Pinterest replication to Microsoft Access.
-
Connect to Typeform in DBArtisan
Use wizards in DBArtisan to configure Typeform as a data source.
-
Analyze Stripe in Cognos Analytics
Use CData Connect AI to connect to Stripe from Cognos Analytics and analyze live Stripe.
-
How to load Access data into Elasticsearch via Logstash
Introducing a simple method to load Access data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
PowerShell Scripting to Replicate SharePoint Excel Services to MySQL
Write a simple PowerShell script to replicate SharePoint Excel Services to a MySQL database.
-
Deploy the ADO.NET Provider for Pinterest on an SSRS Report Server
Connect to Pinterest 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.
-
Validate Microsoft Exchange with QuerySurge
Access and validate Microsoft Exchange in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for MYOB AccountRight in MicroStrategy
Connect to MYOB AccountRight in MicroStrategy Developer using the CData Software JDBC Driver for MYOB AccountRight.
-
Build Data Flows from Clio to SQL Server using SSIS
Easily back up Clio to SQL Server using the SSIS components for Clio.
-
Create Sage Intacct-Connected Nintex Workflows
Use CData Connect AI to connect to Sage Intacct from Nintex Workflow Cloud and build custom workflows using live Sage Intacct.
-
Analyze Live Sage Intacct in SAS Viya
Use CData Connect AI to connect to Sage Intacct from SAS Viya and deploy self-service analytics using live Sage Intacct.
-
How to Work with Oracle Eloqua in ETL Validator JDBC
Connect to Oracle Eloqua from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Azure Blob Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to MongoDB.
-
Access Microsoft Exchange in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Exchange.
-
How to connect to Access from Spring Boot
Connect to Access in a Spring Boot Application using CData JDBC Access Driver
-
Build a Singer.io Tap for Google Data Catalog With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Data Catalog data using
-
Access Live Square in AWS Lambda (with IntelliJ IDEA)
Connect to live Square in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Edit and Search Trello External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Trello to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Trello objects that you can access from apps and the dashboard.
-
Build Oracle Service Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Service Cloud and build web apps with connectivity to live Oracle Service Cloud.
-
How to Visualize EventBrite Data in Python with pandas
Use pandas and other modules to analyze and visualize live Eventbrite in Python.
-
Integrate with Instagram using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Instagram to a JSON file on disk.
-
How to Connect to Stripe in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Stripe. Leverage the pyodbc module for ODBC in Python.
-
How to connect and process Reckon from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Reckon.
-
Integrating Claude Code with Splunk via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Splunk within assisted coding and automated development workflows.
-
How to Query Live Calendly Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Calendly data in natural language using Python.
-
Build Apps with Live Snapchat Ads in Adalo using CData Connect AI
Use CData Connect AI to integrate live Snapchat Ads into the Adalo platform and build custom mobile and web applications with real-time Snapchat Ads.
-
Build Visualizations of Hive in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Hive in Birst.
-
Creating ActiveCampaign-Connected Applications in Unqork
You can use CData Connect AI to feed ActiveCampaign to Unqork and build custom business apps.
-
Create Dynamic Google Calendar Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Calendar to Infragistics XamDataGrid to build dynamic grids.
-
Consume Microsoft Exchange OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Exchange feeds that reflect any changes in SAP Lumira.
-
Create SSAS Tabular Models from Zoho Creator
How to build a SQL Server Analysis Service Tabular Model from Zoho Creator using CData drivers.
-
Connect and Query Live NetSuite Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live NetSuite CRM & ERP into Databricks
-
Automated Continuous Square Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Square replication to PostgreSQL.
-
Stream Greenhouse into Apache Kafka Topics
Access and stream Greenhouse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData ODBC Driver for ShipStation from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ShipStation to connect to ShipStation from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ShipStation in Excel.
-
How to connect to Pipedrive from IntelliJ
Integrate connectivity to Pipedrive with wizards in IntelliJ.
-
Use the CData ODBC Driver for HBase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HBase to connect to Apache HBase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache HBase in Excel.
-
Connect to Twilio in DBArtisan
Use wizards in DBArtisan to configure Twilio as a data source.
-
Automated Continuous Exact Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable Exact Online replication to SQL Server.
-
Build a PostgreSQL Interface for Cassandra using the CData JDBC Driver
Use the Remoting features of the Cassandra JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with Azure Data Catalog in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Data Catalog.
-
Query Google Analytics through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Analytics from Node.js.
-
How to Connect DBeaver to IBM Informix via a JDBC Driver
Manage IBM Informix with visual tools in DBeaver like the query browser.
-
Use Claude to Talk to Your SharePoint via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft SharePoint for you.
-
Model Salesforce Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce, enabling the direct import of real-time Salesforce & Force.com.
-
Rapidly Develop Workday-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create SSAS Tabular Models from Microsoft Project
How to build a SQL Server Analysis Service Tabular Model from Microsoft Project using CData drivers.
-
Spark Reporting in OBIEE with the Spark JDBC Driver
Deploy the Spark JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import Real-Time SharePoint Excel Services via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SharePoint Excel Services in ColdFusion.
-
Build an OLAP Cube in SSAS from Kintone
Establish a connection to Kintone data from SQL Server Analysis Services, and use the Kintone Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Visualizations of Highrise in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Highrise CRM in Birst.
-
Object-Relational Mapping (ORM) with SFTP 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 SFTP into a Java-based ORM framework, Hibernate.
-
How to Seamlessly Import Xero Data into IBM SPSS Modeler
Integrate Xero data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connecting Moonlit Workflow with Exact Online via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Exact Online in real time.
-
How to Connect to Live Airtable from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Airtable for you.
-
How to connect Amazon QuickSight to Tableau CRM Analytics
Create a connection to Tableau CRM Analytics in CData Connect AI and insert Tableau CRM Analytics into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Access Facebook Using Entity Framework
This article shows how to access Facebook using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Adobe Commerce from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Adobe Commerce from Filemaker Pro on Mac.
-
Automated Continuous xBase Replication to MongoDB
Use CData Sync for automated, continuous, customizable xBase replication to MongoDB.
-
Build Dashboards with Quickbase in Dundas BI
Create dynamic dashboards and perform analytics based on Quickbase in Dundas BI.
-
Connect to Basecamp from Asprova with CData Software ODBC Driver for Basecamp
This article shows how to connect faster to Basecamp data from Asprova.
-
Automated Continuous Confluence Replication to MongoDB
Use CData Sync for automated, continuous, customizable Confluence replication to MongoDB.
-
Analyze Live Square in SAS Viya
Use CData Connect AI to connect to Square from SAS Viya and deploy self-service analytics using live Square.
-
Extend Google Sheets with SAP HANA
Make calls to the API Server from Google Apps Script.
-
Replicate Jira to Multiple Databases
Replicate Atlassian Jira to disparate databases with a point-and-click configuration.
-
How to Query Live SAP in Perplexity MacOS Desktop
Connect to and query live SAP in Perplexity Desktop using the CData MCP Server.
-
Connect to and Query WordPress in QlikView over ODBC
Create data visualizations with WordPress in QlikView.
-
Automated Continuous Printful Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Printful replication to PostgreSQL.
-
How to work with Wave Financial in Apache Spark using SQL
Access and process Wave Financial in Apache Spark using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics CRM
Provide connectivity to Microsoft Dynamics CRM through an SAP BusinessObjects universe.
-
Query Bullhorn CRM in DataGrip
Create a Data Source for Bullhorn CRM in DataGrip and use SQL to query live Bullhorn CRM.
-
How to Query Live Microsoft Dataverse in Perplexity MacOS Desktop
Connect to and query live Microsoft Dataverse in Perplexity Desktop using the CData MCP Server.
-
Getting Started with the CData Power BI Connector for CouchDB
-