CData Software - Knowledge Base
Recent Articles
-
Automate Cosmos DB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Cosmos DB from PowerShell? This article demonstrates how to utilize the Cosmos DB Cmdlets for tasks like connecting to Azure Cosmos DB, automating operations, downloading data, and more.
-
Automate Procore Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Procore and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrate with Blackbaud FE NXT in SnapLogic
Use CData Connect AI to connect to and integrate with live Blackbaud FE NXT in SnapLogic.
-
Connect to Reckon Accounts Hosted in NetBeans
Connect to Reckon Accounts Hosted in NetBeans with the data source configuration wizard.
-
Connect Smartsheet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Smartsheet using the CData Python MCP Server.
-
Build Splunk-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Splunk from Zoho Analytics and import live Splunk.
-
Create Informatica Mappings From/To a JDBC Data Source for MySQL
Create MySQL data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Sage 200 from HeidiSQL
Use CData Connect AI to connect to and query live Sage 200 from HeidiSQL.
-
Visualize Coinbase in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Coinbase into TIBCO Spotfire.
-
Analyze Google Calendar in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Calendar in Microsoft R Open.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Marketo using the Model Context Protocol.
-
Integrate Azure Synapse in Pentaho Data Integration
Build ETL pipelines based on Azure Synapse in the Pentaho Data Integration tool.
-
How to import Vault CRM into Apache Solr
Use the CData Software JDBC Driver for Vault CRM in Data Import Handler and create an automated import of Veeva Vault & Vault CRM to Apache Solr Enterprise Search platform.
-
Building Dynamic Web Pages with Confluence Using AngularJS
Create single-page applications with live connectivity to Confluence using the CData API Server.
-
Build Apps with Live BigCommerce in Adalo using CData Connect AI
Use CData Connect AI to integrate live BigCommerce into the Adalo platform and build custom mobile and web applications with real-time BigCommerce.
-
Operational Reporting on EnterpriseDB from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote EnterpriseDB.
-
Bidirectional Access to Printify from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Printify in Filemaker Pro for Mac or Windows.
-
Automated Continuous BambooHR Replication to SQLite
Use CData Sync for automated, continuous, customizable BambooHR replication to SQLite.
-
Connect to Microsoft Project in Aqua Data Studio
Access Microsoft Project from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Excel Online-Connected Nintex Workflows
Use CData Connect AI to connect to Excel Online from Nintex Workflow Cloud and build custom workflows using live Microsoft Excel Online.
-
Build Visualizations of JSON Services in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JSON in Birst.
-
Use Claude to Talk to Your Confluence via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Atlassian Confluence for you.
-
Explore Geographical Relationships in Zoho Projects with Power Map
Create data visualizations with Zoho Projects in Power Map.
-
Automated Continuous Printify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Printify replication to Snowflake.
-
Build Agents in Relevance AI with Access to Live Reckon via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Reckon within intelligent agent workflows.
-
Perform Batch Operations with Slack in Apache NiFi
Connect to Slack and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to and Query Neo4J in QlikView over ODBC
Create data visualizations with Neo4J in QlikView.
-
Automated Continuous Microsoft Teams Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SingleStore.
-
Snapchat Ads Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Snapchat Ads through CData Connect AI using different applications and tools.
-
Connect to MySQL from Asprova with CData Software ODBC Driver for MySQL
This article shows how to connect faster to MySQL data from Asprova.
-
Model Twitter Ads Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Twitter Ads, enabling the direct import of real-time Twitter Ads.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Project to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Project to SQL Server.
-
Query Google Campaign Manager 360 through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Campaign Manager 360 from Node.js.
-
How to Create Power BI Visual Reports with Real-Time Calendly
Use CData Power BI Connectors to visualize Calendly in Power BI.
-
Use the CData Software JDBC Driver for Todoist in MicroStrategy Web
Connect to Todoist in MicroStrategy Web using the CData Software JDBC Driver for Todoist.
-
Configure the CData JDBC Driver for QuickBooks in a Connection Pool in Tomcat
Connect to QuickBooks Desktop from a connection pool in Tomcat.
-
How to integrate CSV with Apache Airflow
Access and process CSV/TSV Files in Apache Airflow using the CData JDBC Driver.
-
Connect to CSV in DBeaver
Use the CData ODBC Driver to connect to CSV/TSV Files in DBeaver.
-
Connect to BigCommerce in DBArtisan
Use wizards in DBArtisan to configure BigCommerce as a data source.
-
Snowflake Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Snowflake facts in real time.
-
Replicate Amazon Marketplace from PowerShell
Write a quick PowerShell script to query Amazon Marketplace. Use connectivity to the live data to replicate Amazon Marketplace to SQL Server.
-
Invoiced Reporting in OBIEE with the Invoiced JDBC Driver
Deploy the Invoiced JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Perform Batch Operations with ActiveCampaign in Apache NiFi
Connect to ActiveCampaign and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connecting GenSpark with Dynamics 365 Business Central via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Extract, Transform, and Load Salesforce Data Cloud in Informatica PowerCenter
Create a simple Workflow for Salesforce Data Cloud in Informatica PowerCenter.
-
Using the CData Software ODBC Driver for Impala in PyCharm
Connect to Impala as an ODBC data source in PyCharm using the CData Software ODBC Driver for Impala.
-
Connect to Power BI XMLA in JRuby
Create a simple JRuby app with access to live Power BI XMLA.
-
Connect to Hive as an External Source in Dremio
Use the CData JDBC Driver to connect to Hive as an External Source in Dremio.
-
Getting Started with the CData Python Connector for Trello
Learn to install and license the CData Python Connector
-
Migrating data from SAP to Databricks using CData SSIS Components.
Easily push SAP ERP/NetWeaver to Databricks using the CData SSIS Tasks for SAP and Databricks.
-
Stream Oracle Sales into Apache Kafka Topics
Access and stream Oracle Sales in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Informatica Mappings From/To a JDBC Data Source for Redshift
Create Redshift data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Sugar CRM from Crystal Reports
Use CData Connect AI to connect to and report on live Sugar CRM from Crystal Reports.
-
Use the CData Software ODBC Driver for Zoom in MicroStrategy Desktop
Connect to Zoom in MicroStrategy Desktop using the CData Software ODBC Driver for Zoom.
-
Connect to Oracle from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Database using standard SQL.
-
Connect to Shippo Using the Script Function in Claris FileMaker Pro
-