CData Software - Knowledge Base
Recent Articles
-
How to Query Asana in MySQL Workbench
Execute MySQL queries against live Asana from MySQL Workbench.
-
Connect to Salesloft in Ruby
Connect to Salesloft in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Informatica Mappings From/To a JDBC Data Source for Active Directory
Create Active Directory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Cosmos DB in Looker
Use CData Connect AI to connect to Cosmos DB from Looker and build custom apps using live Azure Cosmos DB.
-
Visualize Oracle Eloqua from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle Eloqua.
-
Automated Continuous Oracle Eloqua Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to IBM DB2.
-
Choosing the Best Method to Connect Invoiced to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Invoiced from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to MongoDB from Asprova with CData Software ODBC Driver for MongoDB
This article shows how to connect faster to MongoDB data from Asprova.
-
Create SSAS Tabular Models from Exact Online
How to build a SQL Server Analysis Service Tabular Model from Exact Online using CData drivers.
-
Build Automated Google Directory-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Directory and build automated workflows in Zapier.
-
Create Data Visualizations Based On Azure Synapse in Mode
Use CData Connect AI to connect to Azure Synapse from Mode and build visualizations using live
-
Automated Continuous Oracle SCM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Apache Kafka.
-
DataBind Controls to xBase in Delphi
DataBind to xBase in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Sage 200 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage 200 to connect to Sage 200 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 200 in Excel.
-
Use the CData ODBC Driver for Cvent from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cvent to connect to Cvent from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Cvent in Excel.
-
Import Real-Time Zoho Creator via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Creator in ColdFusion.
-
Write a Simple Go Application to work with SAP ByDesign on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Business ByDesign.
-
Query Avro in DataGrip
Create a Data Source for Avro in DataGrip and use SQL to query live Apache Avro.
-
Build Charts with eBay Analytics in Clear Analytics
Create dynamic charts and perform analytics based on eBay Analytics in Clear Analytics.
-
How to Query Live QuickBooks Online in Claude Desktop
Connect to and query live QuickBooks Online in Claude Desktop using the CData MCP Server.
-
Integrate SAP Ariba Procurement in the Pentaho Report Designer
Publish reports based on SAP Ariba Procurement in the Pentaho BI tool.
-
Visualize Live Snowflake of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Snowflake using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build LinkedIn Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for LinkedIn Ads and create custom apps in Bubble.
-
Visualize Azure Analysis Services in Tableau
The CData ODBC driver for Azure Analysis Services enables you integrate Azure Analysis Services into Tableau dashboards.
-
Build Trello-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Trello and build Trello-connected web apps with Axios.
-
Analyze Zoho Projects in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zoho Projects and visualize live Zoho Projects in Infragistics Reveal.
-
Visualize Drip in Tableau
The CData ODBC driver for Drip enables you integrate Drip into Tableau dashboards.
-
Automate Sage 300 Replication to Azure Data Lake
Use CData Sync to customize and automate Sage 300 replication to Azure Data Lake.
-
Process & Analyze Google Sheets in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Sheets .
-
Automate Google Campaign Manager 360 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Campaign Manager 360 from PowerShell? This article demonstrates how to utilize the Google Campaign Manager 360 Cmdlets for tasks like connecting to Google Campaign Manager 360, automating operations, downloading data, and more.
-
Build Automated Twilio-Connected Workflows in Zapier
Use CData Connect AI to connect to live Twilio and build automated workflows in Zapier.
-
Automated Continuous Sage 50 UK Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Vertica.
-
Build Visualizations of Twilio in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Twilio in Birst.
-
Import Real-Time Adobe Target via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Adobe Target in ColdFusion.
-
Build Dashboards with Salesforce Marketing in DBxtra
Create dynamic dashboards and perform analytics based on Salesforce Marketing Cloud in DBxtra.
-
Analyze Live Workday in SAS Viya
Use CData Connect AI to connect to Workday from SAS Viya and deploy self-service analytics using live Workday.
-
Automate Oracle Service Cloud Replication to Azure Synapse
Use CData Sync to customize and automate Oracle Service Cloud replication to Azure Synapse.
-
Automated Continuous Couchbase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Couchbase replication to IBM DB2.
-
Access Marketo in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Marketo.
-
Access Acumatica in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Acumatica ERP.
-
Create Oracle SCM-Connected Applications in Appsmith
Connect to Oracle SCM via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle SCM.
-
Build SAP Business One Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Business One and build visualizations in Tableau Cloud.
-
Manage Raisers Edge NXT in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Raisers Edge NXT.
-
Connect to EnterpriseDB from PowerBuilder via ADO.NET
This article demonstrates how to access EnterpriseDB from Appeon PowerBuilder using the CData ADO.NET Provider for EnterpriseDB.
-
Use Dash to Build to Web Apps on Act-On
Create Python applications that use pandas and Dash to build Act-On-connected web apps.
-
Visualize Wave Financial in TIBCO Spotfire through OData
Integrate Wave Financial into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Shippo
Create an ODBC connection to Shippo in Informatica and browse and transfer Shippo.
-
Creating Amazon Marketplace-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon Marketplace to Unqork and build custom business apps.
-
Migrating data from HBase to Google BigQuery using CData SSIS Components.
Easily push Apache HBase to Google BigQuery using the CData SSIS Tasks for HBase and Google BigQuery.
-
Connect to FHIR from a Connection Pool in WebLogic
Use the CData JDBC Driver for FHIR to connect to FHIR from Web applications running on WebLogic.
-
Build Agents in Relevance AI with Access to Live Trello via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Trello within intelligent agent workflows.
-
Analyze Square in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Square and visualize Square in SAP Analytics Cloud.
-
Integrate with HarperDB using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy HarperDB to a JSON file on disk.
-
How to import FHIR into Apache Solr
Use the CData Software JDBC Driver for FHIR in Data Import Handler and create an automated import of FHIR to Apache Solr Enterprise Search platform.
-
Connect to CockroachDB in DBArtisan
Use wizards in DBArtisan to configure CockroachDB as a data source.
-
Connecting Mastra with GitHub via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Connect to OData Services in DBArtisan
Use wizards in DBArtisan to configure OData as a data source.
-
Explore Geographical Relationships in Google Campaign Manager 360 with Power Map
Create data visualizations with Google Campaign Manager 360 in Power Map.
-
Configure the CData JDBC Driver for Dropbox in a Connection Pool in Tomcat
Connect to Dropbox from a connection pool in Tomcat.
-
Integrate with live IBM Informix in Jitterbit
Use CData Connect AI to connect to and integrate live IBM Informix in Jitterbit.
-
Create Jira-Connected Nintex Workflows
Use CData Connect AI to connect to Jira from Nintex Workflow Cloud and build custom workflows using live Atlassian Jira.
-
How to Query Jira Assets in MySQL Workbench
Execute MySQL queries against live Jira Assets from MySQL Workbench.
-
DataBind Controls to Box in Delphi
DataBind to Box in Delphi with standard data access components and controls.
-
Connect to Freshdesk in Google Apps Script via SQL Gateway
Use the ODBC Driver for Freshdesk and the SQL Gateway to access Freshdesk from Google Apps Script.
-
Import AlloyDB into the Power BI Service for Visualizations
Use CData Connect AI to connect to AlloyDB and provide access to live Google AlloyDB for custom reports in the Power BI Service.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy
Connect to TigerGraph in MicroStrategy Developer using the CData Software ODBC Driver for TigerGraph.
-
Consume Amazon Marketplace OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Amazon Marketplace feeds that reflect any changes in SAP Lumira.
-
Build a Singer.io Tap for Spark With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Spark data using
-
Replicate Sage Intacct to Multiple Databases via the CData Sync CLI
Replicate Sage Intacct to disparate databases with a single configuration.
-
Connect to SuiteCRM in JRuby
Create a simple JRuby app with access to live SuiteCRM.
-
Publish Reports with NetSuite in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date NetSuite CRM & ERP.
-
Access Greenplum from MySQL in PHP
Connect to Greenplum through the standard MySQL libraries in PHP.
-
Rapidly Develop Drip-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Getting Started with the CData ADO.NET Provider for HBase
-