CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SurveyMonkey Replication to Snowflake
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Snowflake.
-
Building Dynamic Web Pages with Kintone Using AngularJS
Create single-page applications with live connectivity to Kintone using the CData API Server.
-
Analyze FHIR with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FHIR from Power Pivot. You will use the Table Import Wizard to load FHIR. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Amazon Athena with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Amazon Athena with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Amazon Athena.
-
Prepare, Blend, and Analyze GraphQL in Alteryx Designer (ODBC)
Build workflows to access live GraphQL for self-service data analytics.
-
Integrate Avro with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Avro with External Services.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Salesforce & Force.com within intelligent workflows.
-
View Reports on Real-Time Google Cloud Storage in Power BI Report Server
Use the CData ODBC Driver for Google Cloud Storage to visualize Google Cloud Storage in Power BI Desktop and then publish them to Power BI Report Server.
-
Design BIRT Reports on Kintone
Provide current Kintone to your embedded analytics.
-
Integrate with SAP Ariba Source in JReport Designer
Create charts and reports based on SAP Ariba Source in JReport Designer.
-
Write a Simple Go Application to work with Asana on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Asana.
-
Build Dashboards with Certinia in Dundas BI
Create dynamic dashboards and perform analytics based on Certinia in Dundas BI.
-
Connect to SAP Concur from HeidiSQL
Use CData Connect AI to connect to and query live SAP Concur from HeidiSQL.
-
Use the CData Software ODBC Driver for Presto in MicroStrategy Desktop
Connect to Presto in MicroStrategy Desktop using the CData Software ODBC Driver for Presto.
-
Visualize SAP Business One from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Business One.
-
Redis Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Redis facts in real time.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft OneDrive to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft OneDrive to SQL Server.
-
Build Pipelines with Live Tableau CRM Analytics in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Tableau CRM Analytics from Google Cloud Data Fusion, enabling the integration of live Tableau CRM Analytics into the building and management of effective data pipelines.
-
Access Live Presto in AWS Lambda (with IntelliJ IDEA)
Connect to live Presto in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Replicate Bing Ads to Multiple Databases via the CData Sync CLI
Replicate Bing Ads to disparate databases with a single configuration.
-
Analyze Microsoft Exchange in Cognos Analytics
Use CData Connect AI to connect to Microsoft Exchange from Cognos Analytics and analyze live Microsoft Exchange.
-
Connect to EnterpriseDB in NetBeans
Connect to EnterpriseDB in NetBeans with the data source configuration wizard.
-
Use Microsoft Copilot Studio to talk to your Active Directory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Active Directory for you.
-
Query Printify in ColdFusion
Write standard ColdFusion data access code to connect to Printify.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Teradata
Provide connectivity to Teradata through an SAP BusinessObjects universe.
-
Integrating Claude Code with Gmail via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Gmail within assisted coding and automated development workflows.
-
Create Teradata Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Teradata data access from reports, embedded analytics, and more.
-
Viewing BambooHR in RAD Studio Data Explorer
How to view BambooHR in RAD Studio Data Explorer using the CData ODBC Driver for BambooHR.
-
Automate Twitter Ads Replication to Azure Synapse
Use CData Sync to customize and automate Twitter Ads replication to Azure Synapse.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CockroachDB
Provide connectivity to CockroachDB through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to Jira Assets
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jira Assets from an ASP.NET MVC application.
-
Query Trello through ODBC in Node.js
Use node-odbc to execute SQL queries against Trello from Node.js.
-
Viewing Google Spanner in RAD Studio Data Explorer
How to view Google Spanner in RAD Studio Data Explorer using the CData ODBC Driver for Google Spanner.
-
Prepare, Blend, and Analyze Airtable in Alteryx Designer (Connect AI)
Build workflows to access live Airtable for self-service data analytics.
-
Access Zoho Books from MySQL in Amazon QuickSight
Connect to Zoho Books and build visualizations of Zoho Books using a MySQL Connection in Amazon QuickSight.
-
How to Query Live BigCommerce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live BigCommerce data in natural language using Python.
-
Automated Continuous SAS xpt Replication to Oracle
Use CData Sync for automated, continuous, customizable SAS xpt replication to Oracle.
-
Automated Continuous SAP BusinessObjects BI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to AlloyDB.
-
Access Live FHIR in Coginiti Pro
Connect to and query live FHIR from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to DB2 with Squirrel SQL client
Connect to IBM DB2 and execute queries in the Squirrel SQL Client.
-
How to create REST federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for REST in MySQL .
-
Use the CData Software JDBC Driver for ClickUp in MicroStrategy Web
Connect to ClickUp in MicroStrategy Web using the CData Software JDBC Driver for ClickUp.
-
Visualize HCL Domino in TIBCO Spotfire through OData
Integrate HCL Domino into dashboards in TIBCO Spotfire.
-
Connect to SAP SuccessFactors in Jaspersoft Studio
Execute SQL to remote SAP SuccessFactors in Jaspersoft Studio.
-
Query QuickBooks Online using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume QuickBooks Online entities in PHP by modeling them as objects.
-
Integrate Act CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Act CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Act CRM.
-
Replicate Multiple SAS xpt Accounts
Replicate multiple SAS xpt accounts to one or many databases.
-
Connect to Greenhouse from a Connection Pool in Jetty
The Greenhouse JDBC Driver supports connection pooling: This article shows how to connect faster to Greenhouse from Web apps in Jetty.
-
Replicate Multiple Oracle HCM Cloud Accounts via the CData Sync CLI
Replicate multiple Oracle HCM Cloud accounts to one or many databases.
-
Connect to Facebook Ads from Asprova with CData Software ODBC Driver for Facebook Ads
This article shows how to connect faster to Facebook Ads data from Asprova.
-
Prepare, Blend, and Analyze SAP Hybris C4C in Alteryx Designer (Connect AI)
Build workflows to access live SAP Hybris C4C for self-service data analytics.
-
Connect to Shopify Using the Script Function in Claris FileMaker Pro
-