CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open Authorize.Net in Microsoft Excel
This article uses the CData ODBC driver for Authorize.Net to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Oracle Sales Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Sales replication to OneLake in Microsoft Fabric.
-
Connecting GenSpark with Redis 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 hundreds of systems without any replication or custom integration required.
-
Prepare, Blend, and Analyze Act-On in Alteryx Designer (ODBC)
Build workflows to access live Act-On for self-service data analytics.
-
Automate Zoho Projects Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Projects replication to Azure Data Lake.
-
How to Access LinkedIn Ads Using Entity Framework
This article shows how to access LinkedIn Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze Sugar CRM in Alteryx Designer (ODBC)
Build workflows to access live Sugar CRM for self-service data analytics.
-
Connect to Confluence in the Denodo Platform
Use CData driver technologies to create a virtual data source for Atlassian Confluence in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Eventbrite Replication to MySQL
Use CData Sync for automated, continuous, customizable Eventbrite replication to MySQL.
-
Use Biml to Build SSIS Tasks to Replicate Freshdesk to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshdesk to SQL Server.
-
Stream Oracle Eloqua into Apache Kafka Topics
Access and stream Oracle Eloqua in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Procore in Sisense
Create an ElastiCube in Sisense app with access to Procore.
-
Create Reports with Google Drive in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Drive.
-
Build Typeform-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Typeform and build web apps with connectivity to live Typeform.
-
Integrating LangChain with Power BI XMLA via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Power BI XMLA within automated workflows.
-
Access Live JDBC-ODBC Bridge in Coginiti Pro
Connect to and query live JDBC-ODBC Bridge from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live SurveyMonkey in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SurveyMonkey into custom reports in Power BI.
-
Analyze Salesforce Data with PowerPivot
This article walks you through the process of using the CData ODBC Driver for Salesforce from PowerPivot. The technique described in this article can be used with any CData ODBC Driver.
-
LINQ to Elasticsearch
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Elasticsearch Data Provider.
-
Query Sage Cloud Accounting in ColdFusion
Write standard ColdFusion data access code to connect to Sage Business Cloud Accounting.
-
Automated Continuous SingleStore Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SingleStore replication to AlloyDB.
-
Working with SAP HANA in LINQPad
Execute LINQ queries to SAP HANA in LINQPad.
-
Analyze Avro in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Avro and visualize live Apache Avro in Infragistics Reveal.
-
Automate Odoo Replication to Azure Data Lake
Use CData Sync to customize and automate Odoo ERP replication to Azure Data Lake.
-
Connect to Microsoft Project through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Project using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Query Live FTP in Claude Desktop
Connect to and query live FTP in Claude Desktop using CData Code Assist MCP.
-
Integrating LangGraph with Amazon Marketplace via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Amazon Marketplace within automated workflows.
-
Work with Clio in FoxPro
Load Clio into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to SAP HANA with Squirrel SQL client
Connect to SAP HANA and execute queries in the Squirrel SQL Client.
-
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.
-
Build Data Flows from SQL Server to Square through SSIS
Easily push SQL Server data to Square using the CData SSIS Tasks for Square.
-
Create Data Visualizations Based On Impala in Mode
Use CData Connect AI to connect to Impala from Mode and build visualizations using live
-
Explore Geographical Relationships in Google Calendar with Power Map
Create data visualizations with Google Calendar in Power Map.
-
Excel Spreadsheet Automation on DB2 with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel Online
Provide connectivity to Microsoft Excel Online through an SAP BusinessObjects universe.
-
Migrating data from Lakebase to Snowflake using CData SSIS Components.
Easily push Lakebase to Snowflake using the CData SSIS Tasks for Lakebase and Snowflake.
-
Perform Batch Operations with SAP Hybris C4C in Apache NiFi
Connect to SAP Hybris C4C and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live JSON Services in Coginiti Pro
Connect to and query live JSON from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate with Printify using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Printify to a JSON file on disk.
-
Use the CData Software JDBC Driver for SAS xpt in MicroStrategy
Connect to SAS XPORT in MicroStrategy Developer using the CData Software JDBC Driver for SAS xpt.
-
Visualize Live Azure DevOps in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Azure DevOps.
-
Integrate with Snapchat Ads in JReport Designer
Create charts and reports based on Snapchat Ads in JReport Designer.
-
Natively Connect to Okta in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Okta. Leverage the native support for ODBC in PHP.
-
Connect to Real-Time Epicor Kinetic Data in Power Apps Using Dataflows to Build Custom Applications
-