CData Software - Knowledge Base
Recent Articles
-
Connect to Dropbox in RazorSQL
Connect to Dropbox from wizards and query Dropbox from the GUI in the RazorSQL database management tool.
-
Automated Continuous Smartsheet Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Smartsheet replication to IBM DB2.
-
Replicate SAP SuccessFactors from PowerShell
Write a quick PowerShell script to query SAP SuccessFactors. Use connectivity to the live data to replicate SAP SuccessFactors to SQL Server.
-
How to Connect to Live Square from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Square for you.
-
Connect to Kintone as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Kintone.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for WordPress
Provide connectivity to WordPress through an SAP BusinessObjects universe.
-
Connect to Oracle Financials Cloud from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle Financials Cloud to connect to Oracle Financials Cloud from Web applications running on WebLogic.
-
Query Amazon DynamoDB in ColdFusion
Write standard ColdFusion data access code to connect to Amazon DynamoDB.
-
Analyze Live Google Ads in SAS Viya
Use CData Connect AI to connect to Google Ads from SAS Viya and deploy self-service analytics using live Google Ads.
-
How to connect to Outreach.io from IntelliJ
Integrate connectivity to Outreach.io with wizards in IntelliJ.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Table Storage using the Model Context Protocol.
-
Visualize Live ServiceNow in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ServiceNow.
-
Build ADP-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ADP.
-
Natively Connect to SurveyMonkey in PHP
The CData ODBC driver for SurveyMonkey enables you to create PHP applications with connectivity to SurveyMonkey. Leverage the native support for ODBC in PHP.
-
Visualize Live Twitter in the Power BI Service
Use CData Connect AI to connect to live Twitter and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software JDBC Driver for Gmail in MicroStrategy Desktop
Connect to Gmail in MicroStrategy Desktop using the CData Software JDBC Driver for Gmail.
-
Use the CData Software ODBC Driver for Microsoft Project in MicroStrategy Desktop
Connect to Microsoft Project in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Project.
-
Import Google Campaign Manager 360 into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Campaign Manager 360. In this article, you will use the OData format to import Google Campaign Manager 360 into Microsoft Power Query.
-
How to Connect the Power BI Service to JSON: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Extend Google Sheets with Office 365
Make calls to the API Server from Google Apps Script.
-
Use the CData API Server to Access Shopify in Microsoft PowerPivot
Use the CData API Server to connect to live Shopify in the Power Pivot business intelligence tool.
-
Publish Crystal Reports on YouTube Analytics
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date YouTube Analytics.
-
Access Live Monday.com in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Monday.com from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize Live Printify in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Printify.
-
Connect and Visualize Live Gmail Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Gmail into the Databricks platform and create visualization dashboards with real-time Gmail.
-
Publish Dynamics 365-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics 365.
-
Build Charts with Google Spanner in Clear Analytics
Create dynamic charts and perform analytics based on Google Spanner in Clear Analytics.
-
Bridge Reckon Connectivity with Apache NiFi
Access and process Reckon in Apache NiFi using the CData JDBC Driver.
-
Excel Spreadsheet Automation on SAP Fieldglass with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to SurveyMonkey from PowerBuilder via ADO.NET
This article demonstrates how to access SurveyMonkey from Appeon PowerBuilder using the CData ADO.NET Provider for SurveyMonkey.
-
How to Connect DBeaver to Office 365 via a JDBC Driver
Manage Microsoft Office 365 with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect Jira Service Management to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Atlassian Jira Service Management from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to IBM Cloud Object Storage in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM Cloud Object Storage. Leverage the pyodbc module for ODBC in Python.
-
Connect to and Visualize Live Spark in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Spark SQL.
-
Seamlessly Bring Google Directory into Retool Using CData Connect AI
Integrate Google Directory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Query Live MarkLogic Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MarkLogic data in natural language using Python.
-
How to Visualize Oracle Service Cloud Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Service Cloud in Python.
-
Connect to Outreach.io from a Connection Pool in JBoss
Integrate Outreach.io into Java servlets: Use the Management Console in JBoss to install the Outreach.io JDBC Driver.
-
Create Power BI Reports on Real-Time Zuora
Use the CData ODBC Driver for Zuora to visualize Zuora in Power BI Desktop.
-
Automate Todoist Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Todoist from PowerShell? This article demonstrates how to utilize the Todoist Cmdlets for tasks like connecting to Todoist, automating operations, downloading data, and more.
-
Automated Continuous Salesforce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce replication to delimited files (CSV/TSV).
-
Automated Continuous SQL Server Replication to MongoDB
Use CData Sync for automated, continuous, customizable SQL Server replication to MongoDB.
-
Connect to FHIR as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live FHIR.
-
How to Query Live GraphQL in Claude Desktop
Connect to and query live GraphQL in Claude Desktop using the CData MCP Server.
-
How to Access Google Directory Using Entity Framework
This article shows how to access Google Directory using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Gmail in RazorSQL
Connect to Gmail from wizards and query Gmail from the GUI in the RazorSQL database management tool.
-
How to connect and process Snowflake from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Snowflake.
-
Migrating data from Pinterest to Databricks using CData SSIS Components.
Easily push Pinterest to Databricks using the CData SSIS Tasks for Pinterest and Databricks.
-
Getting Started with the CData Excel Add-In for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bullhorn CRM.
-
Trigger Wave Financial IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Load Google Drive to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Drive to a database.
-
Create Reports with Sybase in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sybase.
-
Build HubDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HubDB.
-
Manage Twitter in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Twitter.
-
Connect to PayPal in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to Snapchat Ads with Squirrel SQL client
Connect to Snapchat Ads and execute queries in the Squirrel SQL Client.
-
LINQ to SAP SuccessFactors
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 SAP SuccessFactors Data Provider.
-
Perform Batch Operations with Quickbase in Apache NiFi
Connect to Quickbase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating Claude Code with Amazon DynamoDB via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon DynamoDB within assisted coding and automated development workflows.
-
Easily Integrate Salesforce Data Cloud in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce Data Cloud in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Kafka Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Kafka replication to Apache Cassandra.
-
Create Reports from Office 365 in Looker Studio
Use CData Connect AI to gain access to live Microsoft Office 365 and create custom reports in Looker Studio.
-
Viewing Pinterest in RAD Studio Data Explorer
How to view Pinterest in RAD Studio Data Explorer using the CData ODBC Driver for Pinterest.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy
Connect to Microsoft Teams in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Teams.
-
How to Import Data from Reckon into Google Sheets
Import Reckon into a Google spreadsheet that is automatically refreshed.
-
How to Seamlessly Import Smartsheet Data into IBM SPSS Modeler
Integrate Smartsheet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Validate Microsoft OneDrive with QuerySurge
Access and validate Microsoft OneDrive in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live AlloyDB 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 Google AlloyDB for you.
-
Operational Reporting on Email from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Email.
-
Automate Oracle Eloqua Reporting Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Eloqua Reporting from PowerShell? This article demonstrates how to utilize the Oracle Eloqua Reporting Cmdlets for tasks like connecting to Oracle Eloqua Reporting, automating operations, downloading data, and more.
-
How to Design SAP Netweaver Gateway Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Automate Sage 300 Replication to SAP HANA
Use CData Sync to customize and automate Sage 300 replication to SAP HANA.
-
PowerShell Scripting to Replicate Vault CRM to MySQL
Write a simple PowerShell script to replicate Veeva Vault & Vault CRM to a MySQL database.
-
Build a Singer.io Tap for LinkedIn With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LinkedIn data using
-
ETL Sage 200 in Oracle Data Integrator
This article shows how to transfer Sage 200 into a data warehouse using Oracle Data Integrator.
-
Query Google Calendar through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Calendar from Node.js.
-
Visualize Live ClickUp in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ClickUp.
-
Automated Continuous HCL Domino Replication to Oracle
Use CData Sync for automated, continuous, customizable HCL Domino replication to Oracle.
-
Create SSAS Tabular Models from Oracle Sales
How to build a SQL Server Analysis Service Tabular Model from Oracle Sales using CData drivers.
-
Create Reports from MYOB AccountRight in Looker Studio
Use CData Connect AI to gain access to live MYOB AccountRight and create custom reports in Looker Studio.
-
Connect to Live Oracle SCM in PostGresSQL Interface through CData Connect AI
Create a live connection to Oracle SCM in CData Connect AI and connect to your Oracle SCM from PostgreSQL.
-
Analyze Twitter in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Twitter and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Analyze Google Drive in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google Drive and visualize Google Drive in SAP Analytics Cloud.
-
Work with Asana in FoxPro
Load Asana into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate FTP in the Pentaho Report Designer
Publish reports based on FTP Servers in the Pentaho BI tool.
-
Automated Continuous SAP Business One Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Business One replication to Databricks.
-
Establish a Live Connection with PayPal using Tableau Bridge
The CData ODBC Driver for PayPal enables you to integrate live PayPal into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Oracle Sales in TIBCO Spotfire through OData
Integrate Oracle Sales into dashboards in TIBCO Spotfire.
-
Visualize Oracle HCM Cloud in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle HCM Cloud into TIBCO Spotfire.
-
A PostgreSQL Interface for Amazon DynamoDB using the CData ODBC Driver
Use the SQL Gateway and Amazon DynamoDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Drift in JReport Designer
Create charts and reports based on Drift in JReport Designer.
-
Create HCL Domino Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Build an ETL App for Google Spanner in Python with CData
Create ETL applications and real-time data pipelines for Google Spanner in Python with petl.
-
Automated Continuous Square Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Square replication to Amazon S3.
-
Integrating Boomi Agentstudio with Google Analytics via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Analytics, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Process & Analyze ActiveCampaign in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ActiveCampaign .
-
Connect to NetSuite from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live NetSuite CRM & ERP from Filemaker Pro on Mac.
-
Connect to Oracle Financials Cloud in ACL Analytics
Connect to Oracle Financials Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Financials Cloud.
-
Getting Started with the CData Excel Add-In for Databricks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Databricks.
-
Getting Started with the CData ADO.NET Provider for Sage 200
-