CData Software - Knowledge Base
Recent Articles
-
Query SAP Fieldglass in DataGrip
Create a Data Source for SAP Fieldglass in DataGrip and use SQL to query live SAP Fieldglass.
-
Visualize BambooHR in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load BambooHR into TIBCO Spotfire.
-
Automated Twilio Replication to Teradata
Use CData Sync to Customize and automate Twilio replication to Teradata.
-
Connect to Zoho Inventory in DBArtisan
Use wizards in DBArtisan to configure Zoho Inventory as a data source.
-
Visualize Live Jira Assets of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Jira Assets using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Aha! to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Aha! with the DevExpress Windows Forms and Web controls to provide Aha! to a chart.
-
Connect to SAP Ariba Procurement from HeidiSQL
Use CData Connect AI to connect to and query live SAP Ariba Procurement from HeidiSQL.
-
Automated Continuous Twitter Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Amazon Redshift.
-
Connect to Instagram in Jaspersoft Studio
Execute SQL to remote Instagram in Jaspersoft Studio.
-
Process & Analyze Hive in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Hive .
-
Access Live Quickbase in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Quickbase from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Object-Relational Mapping (ORM) with WooCommerce 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 WooCommerce into a Java-based ORM framework, Hibernate.
-
Visualize MarkLogic from Tableau
Use the Tableau Desktop business intelligence tool to connect to MarkLogic.
-
Integrate Live Amazon DynamoDB into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Amazon DynamoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon DynamoDB.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel
Provide connectivity to Microsoft Excel through an SAP BusinessObjects universe.
-
How to Connect to Live Sage Intacct from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Sage Intacct through natural language.
-
How to import PostgreSQL into Apache Solr
Use the CData Software JDBC Driver for PostgreSQL in Data Import Handler and create an automated import of PostgreSQL to Apache Solr Enterprise Search platform.
-
Publish Crystal Reports on TaxJar
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date TaxJar.
-
Automated Continuous Google Calendar Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Calendar replication to PostgreSQL.
-
Building Dynamic Web Pages with Oracle Using AngularJS
Create single-page applications with live connectivity to Oracle using the CData API Server.
-
Integrate Real-Time Access to Blackbaud FE NXT in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Blackbaud FE NXT in real time.
-
Bidirectional Access to eBay Analytics from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate eBay Analytics in Filemaker Pro for Mac or Windows.
-
Connect to SAP BusinessObjects BI from a Connection Pool in JBoss
Integrate SAP BusinessObjects BI into Java servlets: Use the Management Console in JBoss to install the SAP BusinessObjects BI JDBC Driver.
-
How to connect PolyBase to Spark
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Spark SQL.
-
Use the CData Software ODBC Driver for Paylocity in SAS for Real-Time Reporting and Analytics
Connect to real-time Paylocity in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Paylocity.
-
How to Access Slack Using Entity Framework
This article shows how to access Slack using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect the Power BI Service to OData: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Use the CData Software JDBC Driver for LDAP in MicroStrategy Web
Connect to LDAP in MicroStrategy Web using the CData Software JDBC Driver for LDAP.
-
Connecting GenSpark with Google Directory 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.
-
Automate Pinterest Replication to SAP HANA
Use CData Sync to customize and automate Pinterest replication to SAP HANA.
-
Integrate Cursor with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Snapchat Ads from within the editor.
-
Create Informatica Mappings From/To an ODBC Data Source for Impala
Create an ODBC connection to Impala in Informatica and browse and transfer Apache Impala.
-
Build MVC Applications with Connectivity to Phoenix
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Phoenix from an ASP.NET MVC application.
-
Connect to Printify in HULFT Integrate
Connect to Printify as a JDBC data source in HULFT Integrate
-
Build Dashboards with WordPress in DBxtra
Create dynamic dashboards and perform analytics based on WordPress in DBxtra.
-
Import Real-Time Dynamics 365 Business Central via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dynamics 365 Business Central in ColdFusion.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy Web
Connect to Presto in MicroStrategy Web using the CData Software ODBC Driver for Presto.
-
Build Charts with Google Ad Manager in Clear Analytics
Create dynamic charts and perform analytics based on Google Ad Manager in Clear Analytics.
-
Connect to Google Ad Manager from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Ad Manager to connect to Google Ad Manager and execute queries in PowerBuilder.
-
Access Live Jira in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Atlassian Jira from your Excel spreadsheets.
-
Migrating data from HubSpot to Databricks using CData SSIS Components.
Easily push HubSpot to Databricks using the CData SSIS Tasks for HubSpot and Databricks.
-
Automated Continuous Zendesk Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zendesk replication to OneLake in Microsoft Fabric.
-
Access Live Oracle Financials Cloud in Coginiti Pro
Connect to and query live Oracle Financials Cloud from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Manage eBay in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for eBay.
-
Bind Live Oracle Sales Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Sales data
-
Build a PostgreSQL Interface for Hive using the CData JDBC Driver
Use the Remoting features of the Hive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Gmail in Cognos Analytics
Use CData Connect AI to connect to Gmail from Cognos Analytics and analyze live Gmail.
-
Integrate with Jira using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Atlassian Jira to a JSON file on disk.
-
Getting Started with the CData Power BI Connector for Paylocity
-