CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with SAP Fieldglass in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Fieldglass in Dundas BI.
-
Automated Continuous Greenplum Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Greenplum replication to delimited files (CSV/TSV).
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Informix
Provide connectivity to IBM Informix through an SAP BusinessObjects universe.
-
Access Live FHIR in Excel 365 Online (Excel for the web)
Connect to FHIR from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Invoiced Replication to Teradata
Use CData Sync to Customize and automate Invoiced replication to Teradata.
-
Migrating data from Azure Table to Databricks using CData SSIS Components.
Easily push Azure Table Storage to Databricks using the CData SSIS Tasks for Azure Table and Databricks.
-
Model, Search, and Visualize Live Workday in ThoughtSpot
Use CData Connect AI to connect to live Workday for modeling, searching, and visualizing.
-
Automated Continuous SharePoint Excel Services Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Amazon S3.
-
Access Act CRM from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Act CRM from HeidiSQL.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Data Lake Storage within intelligent workflows.
-
Import Acumatica into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Acumatica ERP. In this article, you will use the OData format to import Acumatica ERP into Microsoft Power Query.
-
Connect to LDAP Objects in RapidMiner
Integrate LDAP with standard components and data source configuration wizards in RapidMiner Studio.
-
Consume Parquet OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Parquet feeds that reflect any changes in SAP Lumira.
-
Connect to Sugar CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sugar CRM to connect to Sugar CRM from Web applications running on WebLogic.
-
Create DocuSign Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time DocuSign data access from reports, embedded analytics, and more.
-
Connect to ClickUp from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ClickUp to connect to ClickUp and execute queries in PowerBuilder.
-
Redshift Reporting in OBIEE with the Redshift JDBC Driver
Deploy the Redshift JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software JDBC Driver for Unbounce in MicroStrategy
Connect to Unbounce in MicroStrategy Developer using the CData Software JDBC Driver for Unbounce.
-
How to integrate Metabase with Databricks
Use CData Connect AI to connect to live Databricks and create an interactive dashboard in Metabase from Databricks.
-
Use the CData ODBC Driver for Google Search from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Search to connect to Google Search from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Search in Excel.
-
Deploy the ADO.NET Provider for Clio on an SSRS Report Server
Connect to Clio 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.
-
PowerShell Scripting to Replicate eBay Analytics to MySQL
Write a simple PowerShell script to replicate eBay Analytics to a MySQL database.
-
Integrate Square with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Square with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Square.
-
View Reports on Real-Time BigQuery in Power BI Report Server
Use the CData ODBC Driver for BigQuery to visualize Google BigQuery in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData ODBC Driver for Oracle
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle.
-
Integrate with AlloyDB using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google AlloyDB to a JSON file on disk.
-
Consume MariaDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MariaDB feeds that reflect any changes in SAP Lumira.
-
Connect to SharePoint in RapidMiner
Integrate Microsoft SharePoint with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for Teradata using the CData ODBC Driver
Use the SQL Gateway and Teradata ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate ConstantContact in Heroku for Use in Salesforce Connect
Replicate ConstantContact to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Drift Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Drift replication to Apache Kafka.
-
Import Real-Time Google Campaign Manager 360 via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Campaign Manager 360 in ColdFusion.
-
Trigger SAP HANA IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Hooking into Google Apps With CData Google Data Provider
Mike Gold reviews the CData Google Data Provider on C# Corner: This is a review of a component called the CData Google Data Provider which allows you to access the Google API through a SQL-like Data Provider interface. This provider opens up the entire Google Application Suite to the .NET developer through familiar ADO.NET tools and classes.
-
Connect to Procore as an External Source in Dremio
Use the CData JDBC Driver to connect to Procore as an External Source in Dremio.
-
Automated Continuous OneNote Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable OneNote replication to Google Cloud SQL.
-
Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy Web
Connect to Google Ad Manager in MicroStrategy Web using the CData Software JDBC Driver for Google Ad Manager.
-
Automated ServiceNow Replication to Teradata
Use CData Sync to Customize and automate ServiceNow replication to Teradata.
-
Connect Spark to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache Spark SQL using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
SuiteCRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SuiteCRM facts in real time.
-
Automated Continuous Excel Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Excel replication to Microsoft Access.
-
Create Dynamic Act-On Grids Using the Infragistics XamDataGrid
Learn how you can connect Act-On to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live Greenplum in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Pivotal GreenPlum into custom reports in Power BI.
-
Automated Continuous Sybase IQ Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Apache Cassandra.
-
Connect to and Query BigCommerce in QlikView over ODBC
Create data visualizations with BigCommerce in QlikView.
-
Analyze Snowflake in Looker
Use CData Connect AI to connect to Snowflake from Looker and build custom apps using live Snowflake.
-
Manage Salesforce Marketing in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce Marketing.
-
Import Real-Time Kintone via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Kintone in ColdFusion.
-
Connect to MailChimp from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MailChimp using standard SQL.
-
Visualize Airtable from Tableau
Use the Tableau Desktop business intelligence tool to connect to Airtable.
-
Edit and Search Google Directory External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Directory to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Directory objects that you can access from apps and the dashboard.
-
Automated Continuous Google Ad Manager Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Amazon S3.
-
How to pipe ShipStation to CSV in PowerShell
Use standard PowerShell cmdlets to access ShipStation tables.
-
Create Data Visualizations Based On Azure Table in Mode
Use CData Connect AI to connect to Azure Table from Mode and build visualizations using live
-
Access Live Outreach.io in TIBCO Data Virtualization
-