CData Software - Knowledge Base
Recent Articles
-
Connect to LinkedIn Ads from PowerBuilder via JDBC
This article demonstrates how to access LinkedIn Ads from PowerBuilder using the LinkedIn Ads JDBC Driver.
-
Consume Workday OData Feeds in PowerBuilder
This article demonstrates how to consume Workday as OData feeds from PowerBuilder using the API Server.
-
Office 365 Reporting in OBIEE with the Office 365 JDBC Driver
Deploy the Office 365 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Presto Replication to Vertica
Use CData Sync for automated, continuous, customizable Presto replication to Vertica.
-
Process & Analyze Gmail in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gmail .
-
A PostgreSQL Interface for Splunk using the CData ODBC Driver
Use the SQL Gateway and Splunk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from CouchDB to SQL Server using SSIS
Easily back up Apache CouchDB to SQL Server using the SSIS components for CouchDB.
-
Use the CData API Server to Access LinkedIn in Microsoft PowerPivot
Use the CData API Server to connect to live LinkedIn in the Power Pivot business intelligence tool.
-
Connect and Visualize Live SAP Business One Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Business One into the Databricks platform and create visualization dashboards with real-time SAP Business One.
-
Query Salesloft as a MySQL Database in Node.js
Execute MySQL queries against Salesloft from Node.js.
-
Provide OData Services of WordPress from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for WordPress by developing a WCF Service Application.
-
Configure the CData JDBC Driver for JotForm in a Connection Pool in Tomcat
Connect to JotForm from a connection pool in Tomcat.
-
Create ActiveCampaign Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ActiveCampaign data access from reports, embedded analytics, and more.
-
Connect to Redshift in Google Apps Script via Connect AI
Use CData Connect AI to access Amazon Redshift in Google Apps Script.
-
Connect to Impala from Asprova with CData Software ODBC Driver for Impala
This article shows how to connect faster to Impala data from Asprova.
-
DataBind Controls to SFTP in Delphi
DataBind to SFTP in Delphi with standard data access components and controls.
-
Automated Continuous Airtable Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Airtable replication to Azure SQL Database.
-
Build Dashboards with Redis in DBxtra
Create dynamic dashboards and perform analytics based on Redis in DBxtra.
-
Integrate with Live Facebook Ads in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Facebook Ads from the MuleSoft Anypoint Platform to integrate live Facebook Ads into custom reports and dashboards.
-
Automated Continuous Exact Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Exact Online replication to delimited files (CSV/TSV).
-
Provide OData Services of Klaviyo from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Klaviyo by developing a WCF Service Application.
-
Analyze Live FHIR in SAS Viya
Use CData Connect AI to connect to FHIR from SAS Viya and deploy self-service analytics using live FHIR.
-
Visualize Authorize.Net from Tableau
Use the Tableau Desktop business intelligence tool to connect to Authorize.Net.
-
Bind Live Microsoft Planner Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Planner data
-
DataBind Controls to EnterpriseDB in Delphi
DataBind to EnterpriseDB in Delphi with standard data access components and controls.
-
Connect to Reckon Accounts Hosted in Google Apps Script via Connect AI
Use CData Connect AI to access Reckon Accounts Hosted in Google Apps Script.
-
Query Azure DevOps using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure DevOps entities in PHP by modeling them as objects.
-
Connect to Zoho CRM in RazorSQL
Connect to Zoho CRM from wizards and query Zoho CRM from the GUI in the RazorSQL database management tool.
-
Connect to Excel in NetBeans
Connect to Microsoft Excel in NetBeans with the data source configuration wizard.
-
Connect to Bing Ads in Aqua Data Studio
Access Bing Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating LangChain with Presto via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Presto within automated workflows.
-
Automated Continuous SAP HANA XS Advanced Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Vertica.
-
Import and Visualize Twilio in Power View
Create data visualizations based on Twilio in Excel.
-
Automated Continuous Printful Replication to Databricks
Use CData Sync for automated, continuous, customizable Printful replication to Databricks.
-
How to create Google Cloud Storage federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Cloud Storage in MySQL .
-
Connect to Amazon Athena from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Amazon Athena to connect to Amazon Athena and execute queries in PowerBuilder.
-
Build Semantic Layer Views for MySQL in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MySQL.
-
Migrating data from Quickbase to Databricks using CData SSIS Components.
Easily push Quickbase to Databricks using the CData SSIS Tasks for Quickbase and Databricks.
-
Replicate Salesforce Pardot from PowerShell
Write a quick PowerShell script to query Salesforce Pardot. Use connectivity to the live data to replicate Salesforce Pardot to SQL Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Business One using the Model Context Protocol.
-
How to Connect to ServiceNow in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ServiceNow. Leverage the pyodbc module for ODBC in Python.
-
Integrate with live Office 365 in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Office 365 in Jitterbit.
-
Integrating Boomi Agentstudio with HubSpot via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to HubSpot, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build SurveyMonkey Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SurveyMonkey and build visualizations in Tableau Cloud.
-
Build Dashboards with Snowflake in Dundas BI
Create dynamic dashboards and perform analytics based on Snowflake in Dundas BI.
-
Configure the CData Connect AI Connector for Looker Studio
Use the CData Connect AI Connector to connect to your CData Connect AI instance from Looker Studio.
-
Connect to SuiteCRM as an External Source in Dremio
Use the CData JDBC Driver to connect to SuiteCRM as an External Source in Dremio.
-
Integrate with Stripe using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Stripe to a JSON file on disk.
-
Use the CData Software ODBC Driver for Sage 200 in MicroStrategy Desktop
Connect to Sage 200 in MicroStrategy Desktop using the CData Software ODBC Driver for Sage 200.
-
Automated Continuous Google Contacts Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Contacts replication to Google Cloud SQL.
-
PowerShell Scripting to Replicate Office 365 to MySQL
Write a simple PowerShell script to replicate Microsoft Office 365 to a MySQL database.
-
How to import Azure Synapse into Apache Solr
Use the CData Software JDBC Driver for Azure Synapse in Data Import Handler and create an automated import of Azure Synapse to Apache Solr Enterprise Search platform.
-
Build Data Flows from SAP HANA XS Advanced to SQL Server using SSIS
Easily back up SAP HANA XS Advanced to SQL Server using the SSIS components for SAP HANA XS Advanced.
-
Connect to Unbounce in Google Apps Script via SQL Gateway
Use the ODBC Driver for Unbounce and the SQL Gateway to access Unbounce from Google Apps Script.
-
Replicate BigQuery to Multiple Databases
Replicate Google BigQuery to disparate databases with a point-and-click configuration.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Create Square Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Square data access from reports, embedded analytics, and more.
-
How to Work with Harvest in ETL Validator JDBC
Connect to Harvest from ETL Validator jobs using the CData Software JDBC Driver.
-
Back Up Gmail to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Gmail. In this article, we will employ an SSIS workflow to populate a database with Gmail data.
-
Create Data Visualizations in Cognos BI with SAP SuccessFactors
Access SAP SuccessFactors as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Act-On as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Act-On.
-
Replicate Multiple AlloyDB Accounts
Replicate multiple AlloyDB accounts to one or many databases.
-
Analyze FHIR in Cognos Analytics
Use CData Connect AI to connect to FHIR from Cognos Analytics and analyze live FHIR.
-
Replicate Multiple Reckon Accounts
Replicate multiple Reckon accounts to one or many databases.
-
How to Work with DocuSign in AWS Glue Jobs Using JDBC
Connect to DocuSign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze GraphQL in Infragistics Reveal
Use the CData API Server to create an OData API on top of GraphQL and visualize live GraphQL in Infragistics Reveal.
-
How to Connect the Power BI Service to Hive: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Natively Connect to Sybase IQ in PHP
The CData ODBC driver for Sybase IQ enables you to create PHP applications with connectivity to Sybase IQ. Leverage the native support for ODBC in PHP.
-
Use CData Connect AI to Access Sage Intacct in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage Intacct in the Power Pivot business intelligence tool.
-
Build Apps with Live Salesforce & Force.com in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesforce & Force.com into the Adalo platform and build custom mobile and web applications with real-time Salesforce & Force.com.
-
Connect to and Visualize Live Google Drive in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Drive.
-
Microsoft Dataverse Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Dataverse (CDS) through CData Connect AI using different applications and tools.
-
Build Cassandra-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Cassandra.
-
Model, Search, and Visualize Live QuickBooks Online in ThoughtSpot
Use CData Connect AI to connect to live QuickBooks Online for modeling, searching, and visualizing.
-
Automate MongoDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live MongoDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Harvest
Provide connectivity to Harvest through an SAP BusinessObjects universe.
-
Connect to SAP Ariba Procurement in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Ariba Procurement in Airbyte.
-
Build MailChimp-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MailChimp and build MailChimp-connected web apps with Axios.
-
DataBind Charts to AlloyDB
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google AlloyDB from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Viewing Databricks in RAD Studio Data Explorer
How to view Databricks in RAD Studio Data Explorer using the CData ODBC Driver for Databricks.
-
Connect to Adobe Commerce in RazorSQL
Connect to Adobe Commerce from wizards and query Adobe Commerce from the GUI in the RazorSQL database management tool.
-
Connect to Oracle Eloqua from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Eloqua using standard SQL.
-
How to Connect to Live MongoDB 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 MongoDB for you.
-
Build MVC Applications with Connectivity to Zoho Books
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Books from an ASP.NET MVC application.
-
Natively Connect to Square in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Square. Leverage the native support for ODBC in PHP.
-
Visualize SAP ByDesign in Tableau
The CData ODBC driver for SAP ByDesign enables you integrate SAP Business ByDesign into Tableau dashboards.
-
Connect to Access from Asprova with CData Software ODBC Driver for Access
This article shows how to connect faster to Access data from Asprova.
-
Getting Started with the CData Power BI Connector for Bitbucket
-