CData Software - Knowledge Base
Recent Articles
-
Replicate Multiple ClickUp Accounts via the CData Sync CLI
Replicate multiple ClickUp accounts to one or many databases.
-
Integrate with Zoom using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoom to a JSON file on disk.
-
Connect to Office 365 in Jaspersoft Studio
Execute SQL to remote Microsoft Office 365 in Jaspersoft Studio.
-
Extending QuickBooks Desktop Reporting
The CData ADO.NET Provider for QuickBooks Desktop make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Profit and Loss Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.
-
Use Dash to Build to Web Apps on Trello
Create Python applications that use pandas and Dash to build Trello-connected web apps.
-
Create Sage 300 Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for Invoiced in MicroStrategy
Connect to Invoiced in MicroStrategy Developer using the CData Software ODBC Driver for Invoiced.
-
Oracle HCM Cloud Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle HCM Cloud facts in real time.
-
Manage Adobe Commerce in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Adobe Commerce.
-
Excel Online Reporting in OBIEE with the Excel Online JDBC Driver
Deploy the Excel Online JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create a Data Access Object for JotForm using JDBI
A brief overview of creating a SQL Object API for JotForm in JDBI.
-
Create YouTube Analytics-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to YouTube Analytics from Klipfolio and build custom visualizations using live YouTube Analytics.
-
Feed Elasticsearch into FineReport
How to set Elasticsearch as a JDBC data source in FineReport.
-
Object-Relational Mapping (ORM) with PostgreSQL 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 PostgreSQL into a Java-based ORM framework, Hibernate.
-
LINQ to SFTP
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SFTP Data Provider.
-
Connect to Authorize.Net in DBArtisan
Use wizards in DBArtisan to configure Authorize.Net as a data source.
-
Integrate with SAP Fieldglass in JReport Designer
Create charts and reports based on SAP Fieldglass in JReport Designer.
-
Connect to XML from a Connection Pool in WebLogic
Use the CData JDBC Driver for XML to connect to XML Files from Web applications running on WebLogic.
-
Build Hive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Hive and build web apps with connectivity to live Apache Hive.
-
Viewing Oracle Eloqua in RAD Studio Data Explorer
How to view Oracle Eloqua in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Eloqua.
-
Object-Relational Mapping (ORM) with Salesforce Data Cloud 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 Salesforce Data Cloud into a Java-based ORM framework, Hibernate.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Salesforce & Force.com to Power BI dashboards. Simply drag and drop Salesforce & Force.com into data visuals on the Power BI canvas.
-
Analyze Live Smartsheet in SAS Viya
Use CData Connect AI to connect to Smartsheet from SAS Viya and deploy self-service analytics using live Smartsheet.
-
Build Automated Workflows with Live Act CRM in Workato
Use CData Connect AI to connect to live Act CRM and build automated workflows in Workato.
-
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 ODBC Driver for Zendesk in SAS for Real-Time Reporting and Analytics
Connect to real-time Zendesk in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zendesk.
-
Replicate Sybase in Heroku for Use in Salesforce Connect
Replicate Sybase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData ADO.NET Provider for WordPress
-