CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open Oracle Financials Cloud in Microsoft Excel
This article uses the CData ODBC driver for Oracle Financials Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Multiple BambooHR Accounts
Replicate multiple BambooHR accounts to one or many databases.
-
Automated Continuous YouTube Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Vertica.
-
Rapidly Develop Zoho Books-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create Data Visualizations in Cognos BI with CouchDB
Access Apache CouchDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create HBase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HBase data access from reports, embedded analytics, and more.
-
Replicate IBM Cloud Object Storage in Heroku for Use in Salesforce Connect
Replicate IBM Cloud Object Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate JotForm in Pentaho Data Integration
Build ETL pipelines based on JotForm in the Pentaho Data Integration tool.
-
Connecting Mastra with OData Services via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across hundreds of enterprise sources no replication required.
-
How to connect Amazon QuickSight to Raisers Edge NXT
Create a connection to Raisers Edge NXT in CData Connect AI and insert Raisers Edge NXT into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Jira Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Jira replication to IBM DB2.
-
How to Seamlessly Import Presto Data into IBM SPSS Modeler
Integrate Presto data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Multiple Oracle Eloqua Accounts via the CData Sync CLI
Replicate multiple Oracle Eloqua accounts to one or many databases.
-
Analyze Splunk with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Splunk from Power Pivot. You will use the Table Import Wizard to load Splunk. You can visually build the import query or use any SQL supported by the driver.
-
Connect Airtable to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Airtable using the CData Python MCP Server.
-
Integrating LangGraph with Slack via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Slack within automated workflows.
-
Create Impala Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Edit and Search Smartsheet External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Smartsheet to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Smartsheet objects that you can access from apps and the dashboard.
-
Connect to Live Elasticsearch in MicroStrategy through CData Connect AI
Create a live connection to Elasticsearch in CData Connect AI and connect to your Elasticsearch from MicroStrategy.
-
Analyze Zoho Projects in Looker
Use CData Connect AI to connect to Zoho Projects from Looker and build custom apps using live Zoho Projects.
-
Connect to Access from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Access using standard SQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Pipedrive to Power BI dashboards. Simply drag and drop Pipedrive into data visuals on the Power BI canvas.
-
Create a Data Access Object for Amazon Athena using JDBI
A brief overview of creating a SQL Object API for Amazon Athena in JDBI.
-
How to Seamlessly Import Dynamics NAV Data into IBM SPSS Modeler
Integrate Dynamics NAV data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Live Coinbase in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Coinbase.
-
Connect to SAS Data Sets Using the Script Function in Claris FileMaker Pro
-