CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access Redis in Python
Use standard Python scripting and the development environment of your choice to access live Redis.
-
Use the CData Software JDBC Driver for Stripe in MicroStrategy Web
Connect to Stripe in MicroStrategy Web using the CData Software JDBC Driver for Stripe.
-
Integrating Claude Code with SAP ByDesign via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Business ByDesign within assisted coding and automated development workflows.
-
Visualize Monday.com in TIBCO Spotfire through OData
Integrate Monday.com into dashboards in TIBCO Spotfire.
-
How to Connect DBeaver to Square via a JDBC Driver
Manage Square with visual tools in DBeaver like the query browser.
-
Extend Google Sheets with Pipedrive
Make calls to the API Server from Google Apps Script.
-
Connect to Google Drive as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Drive as an External Source in Dremio.
-
Build SQL Server-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft SQL Server and build web apps with connectivity to live Microsoft SQL Server.
-
Prepare, Blend, and Analyze Lakebase in Alteryx Designer (Connect AI)
Build workflows to access live Lakebase for self-service data analytics.
-
Automated Continuous ADP Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ADP replication to delimited files (CSV/TSV).
-
Connect to Marketo in Google Apps Script via SQL Gateway
Use the ODBC Driver for Marketo and the SQL Gateway to access Marketo from Google Apps Script.
-
Back Up Sybase IQ to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase IQ. In this article, we will employ an SSIS workflow to populate a database with Sybase IQ data.
-
Connect to and Visualize Live Google Spanner in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Spanner.
-
Build an OLAP Cube in SSAS from Stripe
Establish a connection to Stripe data from SQL Server Analysis Services, and use the Stripe Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Google Contacts from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Contacts.
-
Edit and Search External Snapchat Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Snapchat Ads to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Snapchat Ads objects that you can access from apps and the dashboard.
-
Access Live NetSuite in AWS Lambda (with IntelliJ IDEA)
Connect to live NetSuite CRM & ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Hive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Hive from PowerShell? This article demonstrates how to utilize the Hive Cmdlets for tasks like connecting to Apache Hive, automating operations, downloading data, and more.
-
Integrate with live Bing Ads in Jitterbit
Use CData Connect AI to connect to and integrate live Bing Ads in Jitterbit.
-
How to Connect to Live Snapchat Ads 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 Snapchat Ads for you.
-
Replicate Google Drive from PowerShell
Write a quick PowerShell script to query Google Drive. Use connectivity to the live data to replicate Google Drive to SQL Server.
-
Visualize Live HDFS in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache HDFS.
-
Publish Crystal Reports on Printful
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Printful.
-
Create Apps from SAP BusinessObjects BI in Qlik Sense Cloud
Use CData Connect AI to connect to SAP BusinessObjects BI and build apps from live SAP BusinessObjects BI in Qlik Sense Cloud.
-
Connect to Airtable from HeidiSQL
Use CData Connect AI to connect to and query live Airtable from HeidiSQL.
-
Integrate with Office 365 in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Office 365 in SnapLogic.
-
LINQ to Google Campaign Manager 360
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 Google Campaign Manager 360 Data Provider.
-
Create Zendesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zendesk data access from reports, embedded analytics, and more.
-
Automated Continuous Salesforce Marketing Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Apache Kafka.
-
Use JayDeBeApi to access Airtable in Python
Use standard Python scripting and the development environment of your choice to access live Airtable.
-
Getting Started with the CData Excel Add-In for Shippo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Shippo.
-
Create SAP Concur-Connected Applications in Appsmith
Connect to SAP Concur via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Concur.
-
How to Import Data from Greenplum into Google Sheets
Import Pivotal GreenPlum into a Google spreadsheet that is automatically refreshed.
-
View Reports on Real-Time Zuora in Power BI Report Server
Use the CData ODBC Driver for Zuora to visualize Zuora in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy Desktop
Connect to IBM Informix in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Informix.
-
Build Dashboards with Office 365 in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Office 365 in Dundas BI.
-
Getting Started with the CData Power BI Connector for Dynamics NAV
-