CData Software - Knowledge Base

Recent Articles

---

• «
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• »

• Teradata Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Teradata facts in real time.

• Access SAP Netweaver Gateway 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 SAP Netweaver Gateway.

• Stream Google Ads into Apache Kafka Topics

  Access and stream Google Ads in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Integrate Cline with Live Confluence Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Atlassian Confluence from within your IDE.

• Connecting Moonlit Workflow with Reckon Accounts Hosted via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Reckon Accounts Hosted in real time.

• Create Oracle Sales-Connected Dashboards in Grafana

  Connect to Oracle Sales via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Sales.

• Use Microsoft Copilot Studio to talk to your Oracle Eloqua via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Oracle Eloqua for you.

• How to use SQLAlchemy ORM to access Google Campaign Manager 360 in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Campaign Manager 360.

• Automated Continuous Exact Online Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Exact Online replication to delimited files (CSV/TSV).

• Connect to Paylocity in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Paylocity and the SQL Gateway to access Paylocity from Google Apps Script.

• How to connect to Xero from Spring Boot

  Connect to Xero in a Spring Boot Application using CData JDBC Xero Driver

• Object-Relational Mapping (ORM) with Amazon DynamoDB Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Amazon DynamoDB into a Java-based ORM framework, Hibernate.

• Automate Teradata Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Teradata and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Import Real-Time Google Data Catalog via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Google Data Catalog in ColdFusion.

• Build SAP HANA Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live SAP HANA and build visualizations in Tableau.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Acumatica ERP using the Model Context Protocol.

• How to pipe ClickUp to CSV in PowerShell

  Use standard PowerShell cmdlets to access ClickUp tables.

• How to Connect Adobe Commerce to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Adobe Commerce data in real time using natural language.

• Create Power BI Reports on Real-Time Xero

  Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop.

• Access Reckon Accounts Hosted from MySQL in PHP

  Connect to Reckon Accounts Hosted through the standard MySQL libraries in PHP.

• Integrating Boomi Agentstudio with Vault CRM via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Veeva Vault & Vault CRM, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• Build Data Flows from Databricks to SQL Server using SSIS

  Easily back up Databricks to SQL Server using the SSIS components for Databricks.

• Access Live NetSuite in Coginiti Pro

  Connect to and query live NetSuite CRM & ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Access Azure Table from MySQL in Amazon QuickSight

  Connect to Azure Table and build visualizations of Azure Table Storage using a MySQL Connection in Amazon QuickSight.

• Build MVC Applications with Connectivity to ClickUp

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ClickUp from an ASP.NET MVC application.

• PowerShell Scripting to Replicate SharePoint Excel Services to MySQL

  Write a simple PowerShell script to replicate SharePoint Excel Services to a MySQL database.

• Connecting Agentforce with Zoho Inventory via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zoho Inventory for you.

• Extract, Transform, and Load SAP Concur in Informatica PowerCenter

  Create a simple Workflow for SAP Concur in Informatica PowerCenter.

• SAP HANA XS Advanced Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SAP HANA XS Advanced facts in real time.

• Automate Facebook Replication to Azure Synapse

  Use CData Sync to customize and automate Facebook replication to Azure Synapse.

• How to Access Twilio Using Entity Framework

  This article shows how to access Twilio using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Create YouTube Analytics Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Connect to Bitbucket from a Connection Pool in Jetty

  The Bitbucket JDBC Driver supports connection pooling: This article shows how to connect faster to Bitbucket from Web apps in Jetty.

• How to Query Live WordPress in Perplexity MacOS Desktop

  Connect to and query live WordPress in Perplexity Desktop using CData Code Assist MCP.

• Integrate Okta in Pentaho Data Integration

  Build ETL pipelines based on Okta in the Pentaho Data Integration tool.

• Model Marketo Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Marketo, enabling the direct import of real-time Marketo.

• Build a PostgreSQL Interface for BigCommerce using the CData JDBC Driver

  Use the Remoting features of the BigCommerce JDBC Driver to create a PostgreSQL entry-point for data access.

• Build MVC Applications with Connectivity to Typeform

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Typeform from an ASP.NET MVC application.

• Operational Reporting on Greenplum from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Pivotal GreenPlum.

• Create a Data Access Object for Todoist using JDBI

  A brief overview of creating a SQL Object API for Todoist in JDBI.

• Add LinkedIn to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for LinkedIn with the Informatica Enterprise Data Catalog to classify and organize data.

• Connect to Klipfolio in NetBeans

  Connect to Klipfolio in NetBeans with the data source configuration wizard.

• Splunk Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Splunk through CData Connect AI using different applications and tools.

• Choosing the Best Method to Connect QuickBooks Time to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use QuickBooks Time from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Connect to SendGrid from PowerBuilder via JDBC

  This article demonstrates how to access SendGrid from PowerBuilder using the SendGrid JDBC Driver.

• Analyze Google Sheets in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Google Sheets and visualize Google Sheets in SAP Analytics Cloud.

• Build Semantic Layer Views for Google Sheets in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Sheets.

• Automated Continuous Marketo Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Marketo replication to OneLake in Microsoft Fabric.

• Getting Started with the CData Excel Add-In for SAP Netweaver Gateway

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Netweaver Gateway.

• View Reports on Real-Time WordPress in Power BI Report Server

  Use the CData ODBC Driver for WordPress to visualize WordPress in Power BI Desktop and then publish them to Power BI Report Server.

• Connect to Adobe Analytics in RapidMiner

  Integrate Adobe Analytics with standard components and data source configuration wizards in RapidMiner Studio.

• Import Real-Time SAP SuccessFactors via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use SAP SuccessFactors in ColdFusion.

• Build Microsoft Dataverse Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build visualizations in Tableau Cloud.

• Query Authorize.Net through ODBC in Node.js

  Use node-odbc to execute SQL queries against Authorize.Net from Node.js.

• Analyze Bing Ads in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Bing Ads and visualize Bing Ads in SAP Analytics Cloud.

• Build a Simple VCL Application for Google Search Results

  How to build a simple VCL Application to view Google Search in RAD Studio using the CData ODBC Driver for Google Search.

• Automated Continuous Procore Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Procore replication to IBM DB2.

• Connect to Quickbase from AWS Glue

  Use CData Connect AI to gain access to live Quickbase from your AWS Glue jobs.

• Access Live Reckon Accounts Hosted in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Reckon Accounts Hosted from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Access Live SFTP in Coginiti Pro

  Connect to and query live SFTP from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Build MVC Applications with Connectivity to Adobe Commerce

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Commerce from an ASP.NET MVC application.

• DataBind Charts to Adobe Target

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Adobe Target 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.

• Connect to Google Ads in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Google Ads and the SQL Gateway to access Google Ads from Google Apps Script.

• Integrate with Active Directory in JReport Designer

  Create charts and reports based on Active Directory in JReport Designer.

• How to connect to Google Data Catalog from Spring Boot

  Connect to Google Data Catalog in a Spring Boot Application using CData JDBC Google Data Catalog Driver

• Getting Started with the CData ODBC Driver for Workday

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Workday.

• Use Grok to Talk to Your Zoho Creator via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Zoho Creator for you.

• How to Connect to Live Sage Intacct in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sage Intacct without replication.

• Replicate Multiple Kafka Accounts

  Replicate multiple Kafka accounts to one or many databases.

• Build an OLAP Cube in SSAS from Microsoft Dataverse

  Establish a connection to Microsoft Dataverse (CDS) data from SQL Server Analysis Services, and use the Microsoft Dataverse Data Provider to build OLAP cubes for use in analytics and reporting.

• Automated Odoo Replication to Teradata

  Use CData Sync to Customize and automate Odoo ERP replication to Teradata.

• Automated PayPal Replication to Teradata

  Use CData Sync to Customize and automate PayPal replication to Teradata.

• Integrate with Live Oracle Eloqua in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Oracle Eloqua from the MuleSoft Anypoint Platform to integrate live Oracle Eloqua into custom reports and dashboards.

• Viewing Google Search Results in RAD Studio Data Explorer

  How to view Google Search in RAD Studio Data Explorer using the CData ODBC Driver for Google Search.

• Publish Reports with Snapchat Ads in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Snapchat Ads.

• SAS Data Sets Reporting in OBIEE with the SAS Data Sets JDBC Driver

  Deploy the SAS Data Sets JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• 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.

• Use Dash to Build to Web Apps on SAP HANA XS Advanced

  Create Python applications that use pandas and Dash to build SAP HANA XS Advanced-connected web apps.

• Build Certinia-Powered Applications in Gemini Code Assist with CData Code Assist MCP

• «
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• »