CData Software - Knowledge Base
Recent Articles
-
Integrating Boomi Agentstudio with IBM Informix via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to IBM Informix, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Consume FHIR OData Feeds in PowerBuilder
This article demonstrates how to consume FHIR as OData feeds from PowerBuilder using the API Server.
-
Configure the CData JDBC Driver for Google Campaign Manager 360 in a Connection Pool in Tomcat
Connect to Google Campaign Manager 360 from a connection pool in Tomcat.
-
Create FHIR-Connected Dashboards in Grafana
Connect to FHIR via CData Connect AI in Grafana and create custom business dashboards with real-time access to FHIR.
-
Salesforce Pardot Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce Pardot through CData Connect AI using different applications and tools.
-
Use the CData ODBC Driver for Oracle SCM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle SCM to connect to Oracle SCM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle SCM in Excel.
-
How to Build an ETL App for SendGrid in Python with CData
Create ETL applications and real-time data pipelines for SendGrid in Python with petl.
-
DataBind Controls to Salesforce Pardot in Delphi
DataBind to Salesforce Pardot in Delphi with standard data access components and controls.
-
How to connect to Google Data Catalog in DBVisualizer
Integrate Google Data Catalog with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Drip in Ruby
Connect to Drip in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Stream NetSuite into Apache Kafka Topics
Access and stream NetSuite CRM & ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to QuickBooks Online in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Online in the Denodo Virtual DataPort Administrator.
-
Connect to Azure DevOps in Jaspersoft Studio
Execute SQL to remote Azure DevOps in Jaspersoft Studio.
-
Use Biml to Build SSIS Tasks to Replicate Impala to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Impala to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Impala
Provide connectivity to Apache Impala through an SAP BusinessObjects universe.
-
Connect to FHIR in DBeaver
Use the CData ODBC Driver to connect to FHIR in DBeaver.
-
Work with XML in FoxPro
Load XML Files into a FoxPro database. This article includes full code and a walk-through of the process.
-
Viewing Splunk in RAD Studio Data Explorer
How to view Splunk in RAD Studio Data Explorer using the CData ODBC Driver for Splunk.
-
How to Connect to Live Oracle SCM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle SCM securely in real time.
-
Connect to Google Ads in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Ads and connect to Google Ads in Akorbi Digital RunMyProcess.
-
Automated Continuous Printful Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Printful replication to AlloyDB.
-
Build Agents in Relevance AI with Access to Live Office 365 via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Office 365 within intelligent agent workflows.
-
Connect to Zoho Creator in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Creator and the SQL Gateway to access Zoho Creator from Google Apps Script.
-
Migrating data from Google Sheets to Google BigQuery using CData SSIS Components.
Easily push Google Sheets to Google BigQuery using the CData SSIS Tasks for Google Sheets and Google BigQuery.
-
Edit and Search External Adobe Analytics Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Adobe Analytics to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Adobe Analytics objects that you can access from apps and the dashboard.
-
Build Data Flows from SQL Server to Kintone through SSIS
Easily push SQL Server data to Kintone using the CData SSIS Tasks for Kintone.
-
Build Semantic Layer Views for Facebook Ads in APOS Live Data Gateway
Use the CData Connector for Facebook Ads in APOS Live Data Gateway to build Semantic Layer Views for Facebook Ads.
-
Publish Act CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Act CRM.
-
Replicate Twitter from PowerShell
Write a quick PowerShell script to query Twitter. Use connectivity to the live data to replicate Twitter to SQL Server.
-
Build AI Agents with HubSpot Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Automated Continuous Google Calendar Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Calendar replication to Vertica.
-
Connect to Epicor Kinetic in Jaspersoft Studio
Execute SQL to remote Epicor Kinetic in Jaspersoft Studio.
-
Create SQL Server-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SQL Server from OutSystems and build custom enterprise apps using live Microsoft SQL Server.
-
Query eBay from Node.js
Use the OData endpoint of the CData API Server to connect to your eBay and perform CRUD operations on eBay from Node.js.
-
Access Live Excel Online in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Excel Online from your Google Sheets.
-
Use ChatGPT to Talk to Your SQL Server via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft SQL Server for you.
-
Use the CData Software ODBC Driver for Marketo in SAS for Real-Time Reporting and Analytics
Connect to real-time Marketo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Marketo.
-
How to Connect to TigerGraph in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to TigerGraph. Leverage the pyodbc module for ODBC in Python.
-
Work with Klaviyo in FoxPro
Load Klaviyo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Printify from Tableau
Use the Tableau Desktop business intelligence tool to connect to Printify.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for eBay Analytics
Provide connectivity to eBay Analytics through an SAP BusinessObjects universe.
-
Analyze Zendesk in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zendesk and visualize Zendesk in SAP Analytics Cloud.
-
Automated Continuous Google Campaign Manager 360 Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MySQL.
-
Build Semantic Layer Views for Microsoft Project in APOS Live Data Gateway
Use the CData Connector for Microsoft Project in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Project.
-
Build AI Agents with ADP Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Use the CData Software ODBC Driver for Google Calendar in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Calendar in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Calendar.
-
Integrate with Twitter using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Twitter to a JSON file on disk.
-
How to connect and process SharePoint Excel Services from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SharePoint Excel Services.
-
Prepare, Blend, and Analyze Bing Ads in Alteryx Designer (ODBC)
Build workflows to access live Bing Ads for self-service data analytics.
-
Publish Crystal Reports on SAP Netweaver Gateway
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Netweaver Gateway.
-
Analyze Live Google Sheets in SAS Viya
Use CData Connect AI to connect to Google Sheets from SAS Viya and deploy self-service analytics using live Google Sheets.
-
How to use SQLAlchemy ORM to access Printify in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Printify.
-
Build Semantic Layer Views for Sage Cloud Accounting in APOS Live Data Gateway
Use the CData Connector for Sage Cloud Accounting in APOS Live Data Gateway to build Semantic Layer Views for Sage Business Cloud Accounting.
-
Visualize Databricks in TIBCO Spotfire through ADO.NET
Integrate Databricks into dashboards in TIBCO Spotfire.
-
Build Apps with Live Airtable in Adalo using CData Connect AI
Use CData Connect AI to integrate live Airtable into the Adalo platform and build custom mobile and web applications with real-time Airtable.
-
Use the CData Software ODBC Driver for Sage 50 UK in MicroStrategy Desktop
Connect to Sage 50 UK in MicroStrategy Desktop using the CData Software ODBC Driver for Sage 50 UK.
-
How to Connect the Power BI Service to FHIR: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to integrate PingOne with Apache Airflow
Access and process PingOne in Apache Airflow using the CData JDBC Driver.
-
Analyze Live Salesforce Pardot in SAS Viya
Use CData Connect AI to connect to Salesforce Pardot from SAS Viya and deploy self-service analytics using live Salesforce Pardot.
-
Publish Google Data Catalog-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Data Catalog.
-
Automated Continuous Oracle Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle replication to MySQL.
-
Getting Started with the CData Excel Add-In for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Target.
-
Automate Facebook Replication to SAP HANA
Use CData Sync to customize and automate Facebook replication to SAP HANA.
-
Connect to Jira Assets in DBeaver
Use the CData ODBC Driver to connect to Jira Assets in DBeaver.
-
How to Import Data from Salesforce Marketing into Google Sheets
Import Salesforce Marketing Cloud into a Google spreadsheet that is automatically refreshed.
-
Integrating Parquet in Talend Cloud Data Management Platform
-