CData Software - Knowledge Base
Recent Articles
-
Access SurveyMonkey 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 SurveyMonkey.
-
Connect to AlloyDB in HULFT Integrate
Connect to AlloyDB as a JDBC data source in HULFT Integrate
-
Visualize Oracle SCM in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle SCM into TIBCO Spotfire.
-
Using the CData Software ODBC Driver for Avalara AvaTax in PyCharm
Connect to Avalara AvaTax as an ODBC data source in PyCharm using the CData Software ODBC Driver for Avalara AvaTax.
-
Connect to SAP in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import Real-Time HCL Domino via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HCL Domino in ColdFusion.
-
Use the CData Software ODBC Driver for Bing Ads in MicroStrategy
Connect to Bing Ads in MicroStrategy Developer using the CData Software ODBC Driver for Bing Ads.
-
Connect to Microsoft OneDrive in Jaspersoft Studio
Execute SQL to remote Microsoft OneDrive in Jaspersoft Studio.
-
How to Access Facebook Using Entity Framework
This article shows how to access Facebook using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous TaxJar Replication to Snowflake
Use CData Sync for automated, continuous, customizable TaxJar replication to Snowflake.
-
DataBind Controls to Bullhorn CRM in C++Builder
DataBind to Bullhorn CRM in C++Builder with standard components and controls.
-
Access Live LDAP Objects in AWS Lambda (with IntelliJ IDEA)
Connect to live LDAP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Google Drive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Drive data access from reports, embedded analytics, and more.
-
How to use SQLAlchemy ORM to access Outreach.io in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Outreach.io.
-
Use the CData Software JDBC Driver for Confluence in MicroStrategy
Connect to Atlassian Confluence in MicroStrategy Developer using the CData Software JDBC Driver for Confluence.
-
Deploy the ADO.NET Provider for xBase on an SSRS Report Server
Connect to xBase from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate Sybase in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sybase from Informatica Cloud.
-
Access Live Gmail in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gmail into the statistical analysis tools available in SAS JMP. This article shows how to use Gmail in the Graph Builder and Query Builder.
-
Object-Relational Mapping (ORM) with Exact Online 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 Exact Online into a Java-based ORM framework, Hibernate.
-
Build Semantic Layer Views for Active Directory in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Active Directory.
-
Integrating Gumloop with BigCommerce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on BigCommerce within automated workflows.
-
Connect to Salesforce Data Cloud in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software JDBC Driver for Parquet in MicroStrategy
Connect to Apache Parquet in MicroStrategy Developer using the CData Software JDBC Driver for Parquet.
-
Automated Continuous Microsoft Planner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to SingleStore.
-
Visualize Live Zoom of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoom using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Google Data Catalog in NetBeans
Connect to Google Data Catalog in NetBeans with the data source configuration wizard.
-
How to create an RPA flow for SAS xpt in UiPath Studio
Use the SAS xpt ODBC Driver to create workflows that access real-time SAS XPORT without any coding.
-
How to Design Oracle Service Cloud Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Automated Continuous ClickUp Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ClickUp replication to OneLake in Microsoft Fabric.
-
Integrating Dataiku with Dynamics 365 Business Central via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Dynamics 365 Business Central.
-
Build an OLAP Cube in SSAS from Snapchat Ads
Establish a connection to Snapchat Ads data from SQL Server Analysis Services, and use the Snapchat Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to IBM Informix in Aqua Data Studio
Access IBM Informix from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query, Visualize, and Share live Monday.com in Redash
Use CData Connect AI to connect to live Monday.com in Redash for querying, visualizing, and sharing.
-
Replicate Multiple Salesforce Accounts via the CData Sync CLI
Replicate multiple Salesforce accounts to one or many databases.
-
Use Dash to Build to Web Apps on YouTube Analytics
Create Python applications that use pandas and Dash to build YouTube Analytics-connected web apps.
-
Build Visualizations of TigerGraph in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of TigerGraph in Birst.
-
Integrate Zoom with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoom with External Services.
-
Use Azure AI Foundry to Talk to Your PayPal 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 PayPal for you.
-
Impala Reporting in OBIEE with the Impala JDBC Driver
Deploy the Impala JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Natively Connect to eBay in PHP
The CData ODBC driver for eBay enables you to create PHP applications with connectivity to eBay. Leverage the native support for ODBC in PHP.
-
Operational Reporting on Sage Intacct from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sage Intacct.
-
Integrate Cline with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live IBM Cloudant from within your IDE.
-
Connect to SAP SuccessFactors in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP SuccessFactors in Airbyte.
-
How to create an RPA flow for Google Cloud Storage in UiPath Studio
Use the Google Cloud Storage ODBC Driver to create workflows that access real-time Google Cloud Storage without any coding.
-
Connect and Query Live Gmail Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Gmail into Databricks
-
Connect to Google Ad Manager from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Ad Manager to connect to Google Ad Manager from Web applications running on WebLogic.
-
Create Data Visualizations in Cognos BI with PayPal
Access PayPal as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Cline with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Drive from within your IDE.
-
How to Work with Oracle Service Cloud in ETL Validator JDBC
Connect to Oracle Service Cloud from ETL Validator jobs using the CData Software JDBC Driver.
-
Import Jira Service Management Using Azure Data Factory
Use CData Connect AI to connect to Jira Service Management from Azure Data Factory and import live Atlassian Jira Service Management.
-
Access Microsoft Teams from MySQL in Amazon QuickSight
Connect to Microsoft Teams and build visualizations of Microsoft Teams using a MySQL Connection in Amazon QuickSight.
-
How to connect to Act CRM from IntelliJ
Integrate connectivity to Act CRM with wizards in IntelliJ.
-
Integrate SAP Ariba Source with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Ariba Source with External Services.
-
Bind Live Confluence Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Confluence data
-
How to Import Data from SAP SuccessFactors into Google Sheets
Import SAP SuccessFactors into a Google spreadsheet that is automatically refreshed.
-
Connect to SAP SuccessFactors in SpagoBI
Create reports featuring live SAP SuccessFactors in SpagoBI Studio. Host SAP SuccessFactors reports on SpagoBI Server.
-
Automated NetSuite SuiteAnalytics Replication to Teradata
Use CData Sync to Customize and automate NetSuite SuiteAnalytics replication to Teradata.
-
Create QuickBooks Online-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to QuickBooks Online from OutSystems and build custom enterprise apps using live QuickBooks Online.
-
Automated Continuous Sage 300 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sage 300 replication to Apache Kafka.
-
Visualize Google Ad Manager from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Ad Manager.
-
Natively Connect to JSON Services in PHP
The CData ODBC driver for JSON enables you to create PHP applications with connectivity to JSON. Leverage the native support for ODBC in PHP.
-
Automated ServiceNow Replication to Teradata
Use CData Sync to Customize and automate ServiceNow replication to Teradata.
-
Use Claude to Talk to Your WooCommerce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your WooCommerce for you.
-
Connect to BigQuery in DBeaver
Use the CData ODBC Driver to connect to Google BigQuery in DBeaver.
-
Use Dash to Build to Web Apps on Snapchat Ads
Create Python applications that use pandas and Dash to build Snapchat Ads-connected web apps.
-
Use the CData Software ODBC Driver for BigCommerce in MicroStrategy Web
Connect to BigCommerce in MicroStrategy Web using the CData Software ODBC Driver for BigCommerce.
-
Add Microsoft OneDrive to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Microsoft OneDrive with the Informatica Enterprise Data Catalog to classify and organize data.
-
PowerShell Scripting to Replicate SAP BusinessObjects BI to MySQL
Write a simple PowerShell script to replicate SAP BusinessObjects BI to a MySQL database.
-
Connect to MySQL in Jaspersoft Studio
Execute SQL to remote MySQL in Jaspersoft Studio.
-
Use JayDeBeApi to access Microsoft Teams in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Teams.
-
Connect to Instagram in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Instagram in Airbyte.
-
ETL Zuora in Oracle Data Integrator
This article shows how to transfer Zuora into a data warehouse using Oracle Data Integrator.
-
How to Import Data from API into Google Sheets
Import API into a Google spreadsheet that is automatically refreshed.
-
Getting Started with the CData Tableau Connector for Elasticsearch
-