CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Avro Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Avro replication to Azure SQL Database.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Couchbase using the Model Context Protocol.
-
Integrate Cline with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Xero Accounting from within your IDE.
-
Import Asana into the Power BI Service for Visualizations
Use CData Connect AI to connect to Asana and provide access to live Asana for custom reports in the Power BI Service.
-
Publish Crystal Reports on PayPal
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PayPal.
-
Create Informatica Mappings From/To an ODBC Data Source for Paylocity
Create an ODBC connection to Paylocity in Informatica and browse and transfer Paylocity.
-
Automate Google Contacts Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Contacts and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
DataBind Controls to BigQuery in Delphi
DataBind to Google BigQuery in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Dropbox from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dropbox to connect to Dropbox from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dropbox in Excel.
-
Tally Reporting in OBIEE with the Tally JDBC Driver
Deploy the Tally JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Sage Cloud Accounting through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Sage Cloud Accounting using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze Live Trello in SAS Viya
Use CData Connect AI to connect to Trello from SAS Viya and deploy self-service analytics using live Trello.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Cloud Storage
Provide connectivity to Google Cloud Storage through an SAP BusinessObjects universe.
-
Build Google Campaign Manager 360-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Campaign Manager 360 and build Google Campaign Manager 360-connected web apps with Axios.
-
Consume ServiceNow OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ServiceNow feeds that reflect any changes in SAP Lumira.
-
Migrating data from Adobe Target to Databricks using CData SSIS Components.
Easily push Adobe Target to Databricks using the CData SSIS Tasks for Adobe Target and Databricks.
-
Viewing Splunk in RAD Studio Data Explorer
How to view Splunk in RAD Studio Data Explorer using the CData ODBC Driver for Splunk.
-
Extend Google Sheets with Google Analytics
Make calls to the API Server from Google Apps Script.
-
Visualize Freshdesk in TIBCO Spotfire through ADO.NET
Integrate Freshdesk into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Python Connector for Google Spanner
Learn to install and license the CData Python Connector
-
How to Access Tableau CRM Analytics Using Entity Framework
This article shows how to access Tableau CRM Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Avro from MySQL in Amazon QuickSight
Connect to Avro and build visualizations of Apache Avro using a MySQL Connection in Amazon QuickSight.
-
A PostgreSQL Interface for SingleStore (MySQL Remoting via JDBC)
Use the Remoting features of the SingleStore JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Design BigQuery Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Connect to Oracle Eloqua in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Live Snapchat Ads in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Snapchat Ads.
-
Access Live Cloudant Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Cloudant data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Work with Printify in FoxPro
Load Printify into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Neo4J in Google Apps Script via SQL Gateway
Use the ODBC Driver for Neo4J and the SQL Gateway to access Neo4J from Google Apps Script.
-
Import AlloyDB into the Power BI Service for Visualizations
Use CData Connect AI to connect to AlloyDB and provide access to live Google AlloyDB for custom reports in the Power BI Service.
-
Access Live SharePoint Excel Services in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SharePoint Excel Services into the statistical analysis tools available in SAS JMP. This article shows how to use SharePoint Excel Services in the Graph Builder and Query Builder.
-
Automated Continuous QuickBooks Replication to Oracle
Use CData Sync for automated, continuous, customizable QuickBooks replication to Oracle.
-
Connect to Live Zuora in PostGresSQL Interface through CData Connect AI
Create a live connection to Zuora in CData Connect AI and connect to your Zuora from PostgreSQL.
-
Establish a Live Connection with Okta using Tableau Bridge
The CData ODBC Driver for Okta enables you to integrate live Okta into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Redis in AWS Lambda (with IntelliJ IDEA)
Connect to live Redis in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Calendar
Create Google Calendar data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Zuora Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zuora from PowerShell? This article demonstrates how to utilize the Zuora Cmdlets for tasks like connecting to Zuora, automating operations, downloading data, and more.
-
DataBind Charts to EventBrite
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Eventbrite 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.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zendesk to Power BI dashboards. Simply drag and drop Zendesk into data visuals on the Power BI canvas.
-
Connect to Exact Online in Jaspersoft Studio
Execute SQL to remote Exact Online in Jaspersoft Studio.
-
Creating WordPress-Connected Applications in Unqork
You can use CData Connect AI to feed WordPress to Unqork and build custom business apps.
-
How to Build an ETL App for Access in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Access in Python with petl.
-
Connect to PostgreSQL in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for PostgreSQL in Airbyte.
-
Use CData Connect AI to Access Azure Data Lake Storage in Microsoft Power Pivot
Use CData Connect AI to connect to live Azure Data Lake Storage in the Power Pivot business intelligence tool.
-
Automated Continuous TaxJar Replication to SQL Server
Use CData Sync for automated, continuous, customizable TaxJar replication to SQL Server.
-
How to Query GraphQL in MySQL Workbench
Execute MySQL queries against live GraphQL from MySQL Workbench.
-
Create Vault CRM-Connected Applications in Appsmith
Connect to Vault CRM via CData Connect AI in Appsmith and create custom business applications with real-time access to Veeva Vault & Vault CRM.
-
How to load MySQL data into Elasticsearch via Logstash
Introducing a simple method to load MySQL data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Write a Simple Go Application to work with Azure Analysis Services on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Analysis Services.
-
Automated Continuous Microsoft Teams Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to SingleStore.
-
Replicate Todoist to Multiple Databases
Replicate Todoist to disparate databases with a point-and-click configuration.
-
Integrate with Exact Online using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Exact Online to a JSON file on disk.
-
How to Import Data from Tableau CRM Analytics into Google Sheets
Import Tableau CRM Analytics into a Google spreadsheet that is automatically refreshed.
-
Integrating LinkedIn Ads in Talend Cloud Data Management Platform
-