CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Raisers Edge NXT in PHP
The CData ODBC driver for Raisers Edge NXT enables you to create PHP applications with connectivity to Raisers Edge NXT. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Databricks in Alteryx Designer (ODBC)
Build workflows to access live Databricks for self-service data analytics.
-
Use JayDeBeApi to access Amazon DynamoDB in Python
Use standard Python scripting and the development environment of your choice to access live Amazon DynamoDB.
-
Connect to Sugar CRM from a Connection Pool in JBoss
Integrate Sugar CRM into Java servlets: Use the Management Console in JBoss to install the Sugar CRM JDBC Driver.
-
Connect to Google Drive in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Drive in Airbyte.
-
Design BIRT Reports on SharePoint
Provide current Microsoft SharePoint to your embedded analytics.
-
Connect JotForm to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JotForm using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to pipe Jira Assets to CSV in PowerShell
Use standard PowerShell cmdlets to access Jira Assets tables.
-
How to use SQLAlchemy ORM to access Google Calendar in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Calendar.
-
Build Automated SAP Business One-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Business One and build automated workflows in Zapier.
-
How to connect SharePoint with Kintone through external lists
Provide Kintone to SharePoint users as an external list.
-
Connect to Office 365 in HULFT Integrate
Connect to Office 365 as a JDBC data source in HULFT Integrate
-
Connect to Cloudant through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Cloudant using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Replicate Dynamics NAV to Multiple Databases via the CData Sync CLI
Replicate Microsoft Dynamics NAV to disparate databases with a single configuration.
-
Connect to GitHub in NetBeans
Connect to GitHub in NetBeans with the data source configuration wizard.
-
Use the CData API Server to Access ServiceNow in Microsoft PowerPivot
Use the CData API Server to connect to live ServiceNow in the Power Pivot business intelligence tool.
-
Prepare, Blend, and Analyze Invoiced in Alteryx Designer (ODBC)
Build workflows to access live Invoiced for self-service data analytics.
-
Build Dashboards with SAP Business One in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business One in DBxtra.
-
Connect Redshift to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Amazon Redshift using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect and process Google BigQuery from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google BigQuery.
-
Connect to EventBrite in Aqua Data Studio
Access Eventbrite from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous SendGrid Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SendGrid replication to Google BigQuery.
-
How to Work with JDBC-ODBC Bridge in ETL Validator JDBC
Connect to JDBC-ODBC Bridge from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Couchbase
Use CData Power BI Connectors to visualize Couchbase in Power BI.
-
Connect and Visualize Live Microsoft Teams Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Teams into the Databricks platform and create visualization dashboards with real-time Microsoft Teams.
-
Work with SAP Ariba Procurement in FoxPro
Load SAP Ariba Procurement into a FoxPro database. This article includes full code and a walk-through of the process.
-
Publish Amazon Athena-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Amazon Athena.
-
How to Access Live Zuora in Power Automate Desktop via ODBC
The CData ODBC Driver for Zuora enables you to integrate Zuora into workflows built using Microsoft Power Automate Desktop.
-
Connect to Oracle Service Cloud in RapidMiner
Integrate Oracle Service Cloud with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time DocuSign via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use DocuSign in ColdFusion.
-
Automate Todoist Replication to Azure Synapse
Use CData Sync to customize and automate Todoist replication to Azure Synapse.
-
How to Work with MySQL in ETL Validator JDBC
Connect to MySQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Build API-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for API and create custom apps in Mendix.
-
Analyze Sage 200 in Cognos Analytics
Use CData Connect AI to connect to Sage 200 from Cognos Analytics and analyze live Sage 200.
-
Import and Visualize Couchbase in Power View
Create data visualizations based on Couchbase in Excel.
-
Access Facebook Ads from MySQL in Amazon QuickSight
Connect to Facebook Ads and build visualizations of Facebook Ads using a MySQL Connection in Amazon QuickSight.
-
Connect to and Query Zendesk in QlikView over ODBC
Create data visualizations with Zendesk in QlikView.
-
Build a Singer.io Tap for Epicor Kinetic With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Epicor Kinetic data using
-
Access Live Confluence Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Confluence data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Twilio in ColdFusion
Write standard ColdFusion data access code to connect to Twilio.
-
Access Live MongoDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live MongoDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
DataBind Controls to Google Sheets in C++Builder
DataBind to Google Sheets in C++Builder with standard components and controls.
-
Use Dash to Build to Web Apps on ServiceNow
Create Python applications that use pandas and Dash to build ServiceNow-connected web apps.
-
Create Data Visualizations in Cognos BI with Impala
Access Apache Impala as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query Dynamics 365 Business Central as a SQL Server Database in Node.js
Execute SQL Server queries against Dynamics 365 Business Central from Node.js.
-
Build Semantic Layer Views for SAP BusinessObjects BI in APOS Live Data Gateway
Use the CData Connector for SAP BusinessObjects BI in APOS Live Data Gateway to build Semantic Layer Views for SAP BusinessObjects BI.
-
Integrating Boomi Agentstudio with Google Calendar via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Calendar, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect and Visualize Live Shopify Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Shopify into the Databricks platform and create visualization dashboards with real-time Shopify.
-
Migrating data from Aha to Google BigQuery using CData SSIS Components.
Easily push Aha! to Google BigQuery using the CData SSIS Tasks for Aha and Google BigQuery.
-
Provide OData Services of Amazon Marketplace from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon Marketplace by developing a WCF Service Application.
-
Analyze Zoho Inventory in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Inventory with the CData JDBC Driver for Zoho Inventory.
-
Build Agents in Relevance AI with Access to Live Splunk via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Splunk within intelligent agent workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce
Create an ODBC connection to Salesforce in Informatica and browse and transfer Salesforce & Force.com.
-
Analyze Acumatica in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Acumatica ERP and visualize live Acumatica ERP in Infragistics Reveal.
-
Manage JSON Services in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JSON.
-
DataBind Controls to Neo4J in Delphi
DataBind to Neo4J in Delphi with standard data access components and controls.
-
Build Cloudant-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cloudant and create custom apps in Mendix.
-
Automate SAP SuccessFactors Replication to Azure Data Lake
Use CData Sync to customize and automate SAP SuccessFactors replication to Azure Data Lake.
-
Use the CData Software ODBC Driver for Certinia in MicroStrategy
Connect to Certinia in MicroStrategy Developer using the CData Software ODBC Driver for Certinia.
-
Automated Continuous Marketo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Marketo replication to Snowflake.
-
Create Reports from Amazon S3 in Looker Studio
Use CData Connect AI to gain access to live Amazon S3 and create custom reports in Looker Studio.
-
How to connect Amazon QuickSight to Databricks
Create a connection to Databricks in CData Connect AI and insert Databricks into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Multiple SAP Business One Accounts via the CData Sync CLI
Replicate multiple SAP Business One accounts to one or many databases.
-
Process & Analyze Okta in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Okta .
-
Access Live ServiceNow in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ServiceNow from your Excel spreadsheets.
-
Analyze IBM Informix with Power Pivot
This article walks you through the process of using the CData ODBC Driver for IBM Informix from Power Pivot. You will use the Table Import Wizard to load IBM Informix. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Marketo from PowerBuilder via ADO.NET
This article demonstrates how to access Marketo from Appeon PowerBuilder using the CData ADO.NET Provider for Marketo.
-
Use JayDeBeApi to access Adobe Analytics in Python
Use standard Python scripting and the development environment of your choice to access live Adobe Analytics.
-
Visualize Live Google Sheets in the Power BI Service
Use CData Connect AI to connect to live Google Sheets and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze MongoDB with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MongoDB from Power Pivot. You will use the Table Import Wizard to load MongoDB. You can visually build the import query or use any SQL supported by the driver.
-
Bidirectional Access to Adobe Analytics from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Adobe Analytics in Filemaker Pro for Mac or Windows.
-
How to Create Power BI Visual Reports with Real-Time Exact Online
Use CData Power BI Connectors to visualize Exact Online in Power BI.
-
Query Excel in DataGrip
Create a Data Source for Excel in DataGrip and use SQL to query live Microsoft Excel.
-
Build SAP ByDesign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Business ByDesign and build web apps with connectivity to live SAP Business ByDesign.
-
Use Claude to Talk to Your PayPal via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your PayPal for you.
-
Automated Continuous EventBrite Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable EventBrite replication to delimited files (CSV/TSV).
-
Connect to REST in RazorSQL
Connect to REST from wizards and query REST from the GUI in the RazorSQL database management tool.
-
Access Live Power BI XMLA in TIBCO Data Virtualization
-