CData Software - Knowledge Base
Recent Articles
-
Connect to and Query SAP Fieldglass in QlikView over ODBC
Create data visualizations with SAP Fieldglass in QlikView.
-
Query SharePoint in DataGrip
Create a Data Source for SharePoint in DataGrip and use SQL to query live Microsoft SharePoint.
-
Automated Continuous PayPal Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable PayPal replication to Google BigQuery.
-
Connect Todoist to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Todoist with IBM WebSphere for seamless data integration and connectivity.
-
Consume Procore OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Procore feeds that reflect any changes in SAP Lumira.
-
Automate CData Connect AI Replication to Azure Data Lake
Use CData Sync to customize and automate CData Connect AI replication to Azure Data Lake.
-
Access Live Salesforce Marketing in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Salesforce Marketing Cloud from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Deploy the ADO.NET Provider for HDFS on an SSRS Report Server
Connect to Apache HDFS from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
DataBind Charts to SAP HANA XS Advanced
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP HANA XS Advanced 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.
-
Bind Live SQL Analysis Services Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SQL Analysis Services data
-
Provide OData Services of Elasticsearch from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Elasticsearch by developing a WCF Service Application.
-
Connect to HCL Domino in Ruby
Connect to HCL Domino in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Snowflake to Multiple Databases via the CData Sync CLI
Replicate Snowflake to disparate databases with a single configuration.
-
DataBind Charts to IBM Cloud Object Storage
Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM Cloud Object 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.
-
Bind Live DocuSign Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live DocuSign data
-
Integrating Gumloop with Microsoft Teams via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Teams within automated workflows.
-
Automated Continuous GraphQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable GraphQL replication to SingleStore.
-
Build Dashboards with Redshift in DBxtra
Create dynamic dashboards and perform analytics based on Amazon Redshift in DBxtra.
-
Connect to Sybase IQ from a Connection Pool in JBoss
Integrate Sybase IQ into Java servlets: Use the Management Console in JBoss to install the Sybase IQ JDBC Driver.
-
Build Dashboards with SAP Netweaver Gateway in DBxtra
Create dynamic dashboards and perform analytics based on SAP Netweaver Gateway in DBxtra.
-
Automate eBay Analytics Replication to Couchbase
Use CData Sync to Customize and automate eBay Analytics replication to Couchbase.
-
Edit and Search SQL Server External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft SQL Server to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SQL Server objects that you can access from apps and the dashboard.
-
Access Live Okta in Coginiti Pro
Connect to and query live Okta from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData JDBC Driver for CSV
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CSV.
-
Using the CData Software ODBC Driver for Xero in PyCharm
Connect to Xero as an ODBC data source in PyCharm using the CData Software ODBC Driver for Xero.
-
Bidirectional Access to Bing Ads from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bing Ads in Filemaker Pro for Mac or Windows.
-
Integrate with XML using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy XML Files to a JSON file on disk.
-
Edit and Search Spark External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Spark SQL to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Spark objects that you can access from apps and the dashboard.
-
Migrating data from SAP BusinessObjects BI to Snowflake using CData SSIS Components.
Easily push SAP BusinessObjects BI to Snowflake using the CData SSIS Tasks for SAP BusinessObjects BI and Snowflake.
-
Visualize Live Salesforce Pardot in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Salesforce Pardot into custom reports in Power BI.
-
Getting Started with the CData JDBC Driver for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Ariba Source.
-
How to Create Power BI Visual Reports with Real-Time Shippo
Use CData Power BI Connectors to visualize Shippo in Power BI.
-
Access Live Impala in Coginiti Pro
Connect to and query live Apache Impala from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Create Power BI Visual Reports with Real-Time Adobe Commerce
Use CData Power BI Connectors to visualize Adobe Commerce in Power BI.
-
Automated Continuous Confluence Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Confluence replication to Apache Kafka.
-
Migrating data from Google Analytics to Snowflake using CData SSIS Components.
Easily push Google Analytics to Snowflake using the CData SSIS Tasks for Google Analytics and Snowflake.
-
Connect to Live Act-On in PostGresSQL Interface through CData Connect AI
Create a live connection to Act-On in CData Connect AI and connect to your Act-On from PostgreSQL.
-
Getting Started with the CData ODBC Driver for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP BusinessObjects BI.
-
View Reports on Real-Time Avalara AvaTax in Power BI Report Server
Use the CData ODBC Driver for Avalara AvaTax to visualize Avalara AvaTax in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Google Calendar from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Calendar using standard SQL.
-
Create a Data Access Object for HubDB using JDBI
A brief overview of creating a SQL Object API for HubDB in JDBI.
-
Provide OData Services of AlloyDB from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google AlloyDB by developing a WCF Service Application.
-
Getting Started with the CData SSIS Components for PayPal
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PayPal.
-
Automate Raisers Edge NXT Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Raisers Edge NXT and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to SQL Analysis Services from a Connection Pool in WebLogic
Use the CData JDBC Driver for SQL Analysis Services to connect to SQL Analysis Services from Web applications running on WebLogic.
-
Build Data Flows from Zoho Books to SQL Server using SSIS
Easily back up Zoho Books to SQL Server using the SSIS components for Zoho Books.
-
Integrate SAP HANA with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP HANA with External Services.
-
Connect and Visualize Live Vault CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Veeva Vault & Vault CRM into the Databricks platform and create visualization dashboards with real-time Veeva Vault & Vault CRM.
-
How to Query Live Zendesk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zendesk data in natural language using Python.
-
Automated Continuous Procore Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Procore replication to PostgreSQL.
-
Automated Continuous Spark Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Spark replication to Azure SQL Database.
-
Analyze SAP Business One in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Business One in Microsoft R Open.
-
Automate Procore Replication to Azure Synapse
Use CData Sync to customize and automate Procore replication to Azure Synapse.
-
Visualize Procore in TIBCO Spotfire through ADO.NET
Integrate Procore into dashboards in TIBCO Spotfire.
-
Replicate Square to Multiple Databases
Replicate Square to disparate databases with a point-and-click configuration.
-
How to Connect to Live Avalara AvaTax from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Avalara AvaTax for you.
-
Integrate Oracle Sales in Pentaho Data Integration
Build ETL pipelines based on Oracle Sales in the Pentaho Data Integration tool.
-
Connect and Visualize Live Adobe Commerce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce into the Databricks platform and create visualization dashboards with real-time Adobe Commerce.
-
Validate Google Search Results with QuerySurge
Access and validate Google Search in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData ODBC Driver for SAP Concur
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Concur.
-
Rapidly Develop Spark-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.
-
How to Connect the Power BI Service to Access: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed GraphQL to Power BI dashboards. Simply drag and drop GraphQL into data visuals on the Power BI canvas.
-
Integrating LangGraph with Twitter Ads via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Twitter Ads within automated workflows.
-
Migrating data from JotForm to Snowflake using CData SSIS Components.
Easily push JotForm to Snowflake using the CData SSIS Tasks for JotForm and Snowflake.
-
Replicate Klaviyo to Multiple Databases via the CData Sync CLI
Replicate Klaviyo to disparate databases with a single configuration.
-
Build Apps with Live OData in Adalo using CData Connect AI
Use CData Connect AI to integrate live OData into the Adalo platform and build custom mobile and web applications with real-time OData.
-
Consume QuickBooks Online OData Feeds in SAP Lumira
Use the API Server to create data visualizations on QuickBooks Online feeds that reflect any changes in SAP Lumira.
-
Working with Bing Ads in LINQPad
Execute LINQ queries to Bing Ads in LINQPad.
-
Automated Continuous PayPal Replication to Databricks
Use CData Sync for automated, continuous, customizable PayPal replication to Databricks.
-
How to import Redshift into Apache Solr
Use the CData Software JDBC Driver for Redshift in Data Import Handler and create an automated import of Amazon Redshift to Apache Solr Enterprise Search platform.
-
Provide OData Services of Instagram from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Instagram by developing a WCF Service Application.
-
Connect to Real-Time HDFS Data in Power Apps Using Dataflows to Build Custom Applications
-