CData Software - Knowledge Base

Recent Articles

• «
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• »

• Build Charts with Microsoft Dataverse in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Dataverse (CDS) in Clear Analytics.

• Automated Continuous SingleStore Replication to Snowflake

  Use CData Sync for automated, continuous, customizable SingleStore replication to Snowflake.

• How to Build an ETL App for QuickBooks Time in Python with CData

  Create ETL applications and real-time data pipelines for QuickBooks Time in Python with petl.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for GitHub

  Provide connectivity to GitHub through an SAP BusinessObjects universe.

• Connect to Typeform in Jaspersoft Studio

  Execute SQL to remote Typeform in Jaspersoft Studio.

• Connect to Live Azure Analysis Services in MicroStrategy through CData Connect AI

  Create a live connection to Azure Analysis Services in CData Connect AI and connect to your Azure Analysis Services from MicroStrategy.

• Analyze Shopify with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Shopify from Power Pivot. You will use the Table Import Wizard to load Shopify. You can visually build the import query or use any SQL supported by the driver.

• How to Connect to FHIR in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to FHIR. Leverage the pyodbc module for ODBC in Python.

• Configure the CData JDBC Driver for Cloudant in a Connection Pool in Tomcat

  Connect to IBM Cloudant from a connection pool in Tomcat.

• Using the CData Software ODBC Driver for SAP HANA XS Advanced in PyCharm

  Connect to SAP HANA XS Advanced as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP HANA XS Advanced.

• Create a Data Access Object for Google Spanner using JDBI

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

• Integrate Dynamics 365 with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Dynamics 365 with External Services.

• How to work with Avro in Apache Spark using SQL

  Access and process Avro in Apache Spark using the CData Software JDBC Driver.

• Building Dynamic Web Pages with Marketo Using AngularJS

  Create single-page applications with live connectivity to Marketo using the CData API Server.

• Automated Continuous Microsoft OneLake Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Microsoft Access.

• Integrate MailChimp into Automated Tasks with Power Automate

  Use CData Connect AI to connect to MailChimp and integrate live MailChimp into your Power Automate tasks.

• Operational Reporting on SharePoint Excel Services from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote SharePoint Excel Services.

• Build Semantic Layer Views for Acumatica in APOS Live Data Gateway

  Use the CData Connector for Acumatica in APOS Live Data Gateway to build Semantic Layer Views for Acumatica ERP.

• How to Query Live CouchDB Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Apache CouchDB data in natural language using Python.

• Automated Continuous Google Ads Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Google Ads replication to SingleStore.

• Build a Simple VCL Application for Neo4J

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

• PowerShell Scripting to Replicate QuickBooks Time to MySQL

  Write a simple PowerShell script to replicate QuickBooks Time to a MySQL database.

• How to Seamlessly Import Zoho Books Data into IBM SPSS Modeler

  Integrate Zoho Books data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Object-Relational Mapping (ORM) with Authorize.Net 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 Authorize.Net into a Java-based ORM framework, Hibernate.

• Connect to and Visualize Live Excel in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel.

• Import Databricks into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Databricks and provide access to live Databricks for custom reports in the Power BI Service.

• How to Connect to Live SAP HANA in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAP HANA for you.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed HCL Domino to Power BI dashboards. Simply drag and drop HCL Domino into data visuals on the Power BI canvas.

• Automate Asana Tasks in Power Automate Using CData API Server

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

• How to Work with LinkedIn Ads in ETL Validator JDBC

  Connect to LinkedIn Ads from ETL Validator jobs using the CData Software JDBC Driver.

• Visualize Facebook in TIBCO Spotfire through ADO.NET

  Integrate Facebook into dashboards in TIBCO Spotfire.

• Create SSAS Tabular Models from Oracle Service Cloud

  How to build a SQL Server Analysis Service Tabular Model from Oracle Service Cloud using CData drivers.

• Connecting Mastra with Oracle Financials Cloud 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.

• How to Connect to & Open Bing Ads in Microsoft Excel

  This article uses the CData ODBC driver for Bing Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• How to connect PolyBase to SQL Analysis Services

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SQL Analysis Services.

• Integrate Live IBM Informix into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to IBM Informix and integrate live IBM Informix into apps built in Microsoft Power Apps.

• Configure the CData JDBC Driver for Sage Intacct in a Connection Pool in Tomcat

  Connect to Sage Intacct from a connection pool in Tomcat.

• Integrating Dataiku with Gmail via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Gmail.

• Visualize Live GraphQL in the Power BI Service

  Use CData Connect AI to connect to live GraphQL and create custom reports in the Power BI Service through the On-Premises Gateway.

• Access Live Sugar CRM in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Sugar CRM from your Google Sheets.

• Automated Continuous CData Connect AI Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable CData Connect AI replication to Azure SQL Database.

• Access SAP Ariba Source from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SAP Ariba Source from HeidiSQL.

• Connect to Cvent in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Cvent in the Denodo Virtual DataPort Administrator.

• Create Reports from Amazon Marketplace in Looker Studio

  Use CData Connect AI to gain access to live Amazon Marketplace and create custom reports in Looker Studio.

• How to Connect the Power BI Service to Google Cloud Storage: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Replicate Multiple Splunk Accounts

  Replicate multiple Splunk accounts to one or many databases.

• How to pipe Dropbox to CSV in PowerShell

  Use standard PowerShell cmdlets to access Dropbox tables.

• Query Jira Service Management through ODBC in Node.js

  Use node-odbc to execute SQL queries against Atlassian Jira Service Management from Node.js.

• Connect to Sybase IQ in Ruby

  Connect to Sybase IQ in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• How to use SQLAlchemy ORM to access Spark in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache Spark SQL.

• Build Google Analytics-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Google Analytics and build Google Analytics-connected web apps with Axios.

• Replicate TaxJar to Multiple Databases via the CData Sync CLI

  Replicate TaxJar to disparate databases with a single configuration.

• DataBind Charts to Azure Data Lake Storage

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Azure Data Lake Storage 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.

• Build SendGrid-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SendGrid.

• Build AI Agents with Twilio Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can

• Easily Integrate FTP in Lazarus Pascal IDE

  Learn how to easily integrate live FTP Servers in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated Continuous MarkLogic Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable MarkLogic replication to Apache Cassandra.

• Publish Reports with Salesforce in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Salesforce & Force.com.

• Replicate Azure Active Directory in Heroku for Use in Salesforce Connect

  Replicate Azure Active Directory to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Automated Continuous NetSuite SuiteAnalytics Replication to Databricks

  Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Databricks.

• Automated Continuous RSS Replication to SQLite

  Use CData Sync for automated, continuous, customizable RSS replication to SQLite.

• Create Power BI Reports on Real-Time DocuSign

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

• Automated Continuous Freshdesk Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Freshdesk replication to MongoDB.

• Excel Spreadsheet Automation on CSV with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• DataBind Controls to Excel Online in Delphi

  DataBind to Microsoft Excel Online in Delphi with standard data access components and controls.

• Create SSAS Tabular Models from Confluence

  How to build a SQL Server Analysis Service Tabular Model from Atlassian Confluence using CData drivers.

• Visualize SAP ByDesign in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP Business ByDesign into TIBCO Spotfire.

• Provide OData Services of Okta from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Okta by developing a WCF Service Application.

• Integrating Excel Online in Talend Cloud Data Management Platform

• «
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• »