CData Software - Knowledge Base
Recent Articles
-
Access Live Adobe Analytics in AWS Lambda (with IntelliJ IDEA)
Connect to live Adobe Analytics in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Oracle Financials Cloud in Infragistics Reveal
Use the CData API Server to create an OData API on top of Oracle Financials Cloud and visualize live Oracle Financials Cloud in Infragistics Reveal.
-
Create Dynamics NAV Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics NAV data access from reports, embedded analytics, and more.
-
Object-Relational Mapping (ORM) with Oracle Service 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 Oracle Service Cloud into a Java-based ORM framework, Hibernate.
-
How to connect to Todoist in DBVisualizer
Integrate Todoist with visual data analysis tools and data connection wizards in DBVisualizer
-
Rapidly Develop PingOne-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.
-
A PostgreSQL Interface for RSS Feeds (MySQL Remoting via JDBC)
Use the Remoting features of the RSS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Cassandra Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cassandra replication to Google Cloud SQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Projects
Provide connectivity to Zoho Projects through an SAP BusinessObjects universe.
-
Connect to Klipfolio in JRuby
Create a simple JRuby app with access to live Klipfolio.
-
Build Charts with HBase in Clear Analytics
Create dynamic charts and perform analytics based on Apache HBase in Clear Analytics.
-
Analyze LinkedIn Ads with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LinkedIn Ads from Power Pivot. You will use the Table Import Wizard to load LinkedIn Ads. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData ODBC Driver for ActiveCampaign in Microsoft Power Query
You can use the CData ActiveCampaign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ActiveCampaign into Microsoft Power Query.
-
Access Live Facebook Ads in Coginiti Pro
Connect to and query live Facebook Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to integrate eBay with Apache Airflow
Access and process eBay in Apache Airflow using the CData JDBC Driver.
-
Creating Facebook-Connected Applications in Unqork
You can use CData Connect AI to feed Facebook to Unqork and build custom business apps.
-
Create Power BI Reports on Real-Time Highrise
Use the CData ODBC Driver for Highrise to visualize Highrise CRM in Power BI Desktop.
-
Using the CData Software ODBC Driver for Jira Service Management in PyCharm
Connect to Jira Service Management as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jira Service Management.
-
Use Biml to Build SSIS Tasks to Replicate EnterpriseDB to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate EnterpriseDB to SQL Server.
-
eBay Analytics Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on eBay Analytics facts in real time.
-
How to work with SFTP in Apache Spark using SQL
Access and process SFTP in Apache Spark using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access OData Services in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of OData.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy
Connect to Dynamics 365 Business Central in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
How to integrate Basecamp with Apache Airflow
Access and process Basecamp in Apache Airflow using the CData JDBC Driver.
-
Integrating Gumloop with Amazon DynamoDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon DynamoDB within automated workflows.
-
Operational Reporting on Oracle Financials Cloud from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Financials Cloud.
-
A PostgreSQL Interface for Zendesk using the CData ODBC Driver
Use the SQL Gateway and Zendesk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Pipedrive from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pipedrive from HeidiSQL.
-
Connect to Instagram in ACL Analytics
Connect to Instagram via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Instagram.
-
Connect to Impala in NetBeans
Connect to Apache Impala in NetBeans with the data source configuration wizard.
-
Build Adobe Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Adobe Analytics.
-
Connect to SAS xpt in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Azure Data Catalog in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access RSS Feeds in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for RSS Feeds.
-
Load ServiceNow to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ServiceNow to a database.
-
Use Azure AI Foundry to Talk to Your Microsoft Planner via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Microsoft Planner for you.
-
Edit and Search Tally External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Tally ERP to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Tally objects that you can access from apps and the dashboard.
-
Load Sugar CRM to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sugar CRM to a database.
-
Connect to Airtable in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Airtable and connect to Airtable in Akorbi Digital RunMyProcess.
-
Access ActiveCampaign in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ActiveCampaign.
-
Build Charts with SAP HANA in Clear Analytics
Create dynamic charts and perform analytics based on SAP HANA in Clear Analytics.
-
Connect to Oracle Financials Cloud from a Connection Pool in JBoss
Integrate Oracle Financials Cloud into Java servlets: Use the Management Console in JBoss to install the Oracle Financials Cloud JDBC Driver.
-
A PostgreSQL Interface for Snowflake using the CData ODBC Driver
Use the SQL Gateway and Snowflake ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ADO.NET Provider for OneNote
-