CData Software - Knowledge Base
Recent Articles
-
Connect to Reckon Accounts Hosted in Jaspersoft Studio
Execute SQL to remote Reckon Accounts Hosted in Jaspersoft Studio.
-
Build a PostgreSQL Interface for Unbounce using the CData JDBC Driver
Use the Remoting features of the Unbounce JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to & Open Square in Microsoft Excel
This article uses the CData ODBC driver for Square to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bidirectional Access to Sage Cloud Accounting from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage Business Cloud Accounting in Filemaker Pro for Mac or Windows.
-
Bidirectional Access to GraphQL from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate GraphQL in Filemaker Pro for Mac or Windows.
-
Automate Sage Intacct Replication to Azure Synapse
Use CData Sync to customize and automate Sage Intacct replication to Azure Synapse.
-
Connect TaxJar to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect TaxJar with IBM WebSphere for seamless data integration and connectivity.
-
Query, Visualize, and Share live HubSpot in Redash
Use CData Connect AI to connect to live HubSpot in Redash for querying, visualizing, and sharing.
-
Connect to eBay as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for eBay.
-
Automated Continuous Monday.com Replication to SQLite
Use CData Sync for automated, continuous, customizable Monday.com replication to SQLite.
-
Object-Relational Mapping (ORM) with Drip 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 Drip into a Java-based ORM framework, Hibernate.
-
Bridge Cloudant Connectivity with Apache NiFi
Access and process IBM Cloudant in Apache NiFi using the CData JDBC Driver.
-
LINQ to ServiceNow
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 ServiceNow Data Provider.
-
How to Connect DBeaver to Avalara AvaTax via a JDBC Driver
Manage Avalara AvaTax with visual tools in DBeaver like the query browser.
-
Import API into the Power BI Service for Visualizations
Use CData Connect AI to connect to API and provide access to live API for custom reports in the Power BI Service.
-
Use the CData Software ODBC Driver for Avro in MicroStrategy
Connect to Apache Avro in MicroStrategy Developer using the CData Software ODBC Driver for Avro.
-
Use JayDeBeApi to access Dropbox in Python
Use standard Python scripting and the development environment of your choice to access live Dropbox.
-
Create Data Visualizations in Cognos BI with Hive
Access Apache Hive as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to QuickBooks Time from a Connection Pool in Jetty
The QuickBooks Time JDBC Driver supports connection pooling: This article shows how to connect faster to QuickBooks Time from Web apps in Jetty.
-
Automated Continuous Basecamp Replication to SQLite
Use CData Sync for automated, continuous, customizable Basecamp replication to SQLite.
-
Bridge Printful Connectivity with Apache NiFi
Access and process Printful in Apache NiFi using the CData JDBC Driver.
-
Analyze Invoiced in R via JDBC
Use standard R functions and the development environment of your choice to analyze Invoiced with the CData JDBC Driver for Invoiced.
-
Publish Reports with Google Directory in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Directory.
-
How to create Square federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Square in MySQL .
-
Connect to Zoho Inventory from AWS Glue
Use CData Connect AI to gain access to live Zoho Inventory from your AWS Glue jobs.
-
Create Power BI Reports on Real-Time Oracle Financials Cloud
Use the CData ODBC Driver for Oracle Financials Cloud to visualize Oracle Financials Cloud in Power BI Desktop.
-
Create Jira Service Management Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Jira Service Management data access from reports, embedded analytics, and more.
-
Visualize Live Google Search Results of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Search using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Twilio in MicroStrategy Desktop
Connect to Twilio in MicroStrategy Desktop using the CData Software ODBC Driver for Twilio.
-
View Reports on Real-Time Trello in Power BI Report Server
Use the CData ODBC Driver for Trello to visualize Trello in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Klipfolio in the Pentaho Report Designer
Publish reports based on Klipfolio in the Pentaho BI tool.
-
Automated Continuous FHIR Replication to SQL Server
Use CData Sync for automated, continuous, customizable FHIR replication to SQL Server.
-
Working with Okta in LINQPad
Execute LINQ queries to Okta in LINQPad.
-
How to create an RPA flow for Gmail in UiPath Studio
Use the Gmail ODBC Driver to create workflows that access real-time Gmail without any coding.
-
Build Data Flows from Raisers Edge NXT to SQL Server using SSIS
Easily back up Raisers Edge NXT to SQL Server using the SSIS components for Raisers Edge NXT.
-
Query Redshift as a MySQL Database in Node.js
Execute MySQL queries against Amazon Redshift from Node.js.
-
How to connect to Airtable from IntelliJ
Integrate connectivity to Airtable with wizards in IntelliJ.
-
Connect to FHIR through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with FHIR using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating LangChain with LinkedIn Ads via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on LinkedIn Ads within automated workflows.
-
Use Agno to Talk to Your DocuSign via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your DocuSign for you.
-
Manage xBase in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for xBase.
-
Consume Amazon S3 OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon S3 as OData feeds from PowerBuilder using the API Server.
-
ETL PostgreSQL in Oracle Data Integrator
This article shows how to transfer PostgreSQL into a data warehouse using Oracle Data Integrator.
-
Create Power BI Reports on Real-Time SFTP
Use the CData ODBC Driver for SFTP to visualize SFTP in Power BI Desktop.
-
Integrate with Office 365 in JReport Designer
Create charts and reports based on Microsoft Office 365 in JReport Designer.
-
Build Dashboards with Phoenix in Dundas BI
Create dynamic dashboards and perform analytics based on Apache Phoenix in Dundas BI.
-
Connect to SQL Analysis Services in DBArtisan
Use wizards in DBArtisan to configure SQL Analysis Services as a data source.
-
Query ServiceNow as a SQL Server Database in Node.js
Execute SQL Server queries against ServiceNow from Node.js.
-
Use the CData Software ODBC Driver for Microsoft Planner in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Planner in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Planner.
-
Visualize Google Data Catalog in TIBCO Spotfire through OData
Integrate Google Data Catalog into dashboards in TIBCO Spotfire.
-
Connect to SAP ByDesign as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP Business ByDesign.
-
Building Dynamic Web Pages with IBM Informix Using AngularJS
Create single-page applications with live connectivity to IBM Informix using the CData API Server.
-
Automated Continuous Airtable Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Airtable replication to AlloyDB.
-
Integrating PayPal in Talend Cloud Data Management Platform
-