CData Software - Knowledge Base
Recent Articles
-
Create 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.
-
Choosing the Best Method to Connect Excel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Excel from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Azure Blob Storage Replication to Teradata
Use CData Sync to Customize and automate Azure Blob Storage replication to Teradata.
-
How to Work with Splunk in ETL Validator JDBC
Connect to Splunk from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with Databricks in ETL Validator JDBC
Connect to Databricks from ETL Validator jobs using the CData Software JDBC Driver.
-
Viewing QuickBooks Time in RAD Studio Data Explorer
How to view QuickBooks Time in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks Time.
-
Replicate SuiteCRM to Multiple Databases
Replicate SuiteCRM to disparate databases with a point-and-click configuration.
-
Operational Reporting on Calendly from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Calendly.
-
Access Live Zoho Creator in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho Creator in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to OneNote in Jaspersoft Studio
Execute SQL to remote Microsoft OneNote in Jaspersoft Studio.
-
Consume Google Spanner OData Feeds in PowerBuilder
This article demonstrates how to consume Google Spanner as OData feeds from PowerBuilder using the API Server.
-
How to Use a Microsoft Access Database to Update IBM Informix in Real Time
Update IBM Informix data by creating a linked table in Microsoft Access with the CData IBM Informix ODBC Driver.
-
Getting Started with the CData Excel Add-In for ServiceNow
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ServiceNow.
-
How to Connect to Live Square Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Square securely in real time.
-
Use Grok to Talk to Your Cassandra via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache Cassandra for you.
-
Connect to Highrise in the Denodo Platform
Use CData driver technologies to create a virtual data source for Highrise CRM in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Airtable Replication to Snowflake
Use CData Sync for automated, continuous, customizable Airtable replication to Snowflake.
-
Connect to OData Services from a Connection Pool in JBoss
Integrate OData into Java servlets: Use the Management Console in JBoss to install the OData JDBC Driver.
-
Build Data Flows from ConstantContact to SQL Server using SSIS
Easily back up ConstantContact to SQL Server using the SSIS components for ConstantContact.
-
Analyze Shopify with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Shopify from Power Pivot. You will use the Table Import Wizard to load Shopify. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Google Sheets Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Sheets replication to Apache Kafka.
-
How to Access Google Spanner Using Entity Framework
This article shows how to access Google Spanner using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect and process Atlassian Jira from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Atlassian Jira.
-
Connect to Salesforce Pardot through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce Pardot using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Monday.com in RazorSQL
Connect to Monday.com from wizards and query Monday.com from the GUI in the RazorSQL database management tool.
-
How to Connect to Spark in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Spark SQL. Leverage the pyodbc module for ODBC in Python.
-
How to use SQLAlchemy ORM to access Email in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Email.
-
How to Connect to Live Twilio from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Twilio for you.
-
Connect to HCL Domino from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HCL Domino from Filemaker Pro on Mac.
-
Build MailChimp-Powered Applications in Cursor with CData Code Assist MCP
-