CData Software - Knowledge Base

Recent Articles

• «
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• 515
• 516
• 517
• »

• Connect to Harvest in Aqua Data Studio

  Access Harvest from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• How to Connect to & Open Zoho CRM in Microsoft Excel

  This article uses the CData ODBC driver for Zoho CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Build Oracle SCM-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Oracle SCM and create custom apps in Mendix.

• Deploy the ADO.NET Provider for EventBrite on an SSRS Report Server

  Connect to Eventbrite 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.

• Automated Continuous SAP ByDesign Replication to SQL Server

  Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SQL Server.

• Connect to SAP ByDesign in HULFT Integrate

  Connect to SAP ByDesign as a JDBC data source in HULFT Integrate

• Create SAP ByDesign Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Use CData Connect Cloud to Access Google Analytics in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Google Analytics in the Power Pivot business intelligence tool.

• DataBind Charts to CockroachDB

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to CockroachDB 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.

• Analyze Splunk in Cognos Analytics

  Use CData Connect Cloud to connect to Splunk from Cognos Analytics and analyze live Splunk.

• Build Semantic Layer Views for QuickBooks in APOS Live Data Gateway

  Use the CData Connector for QuickBooks in APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Desktop.

• Integrate Google Analytics in Pentaho Data Integration

  Build ETL pipelines based on Google Analytics in the Pentaho Data Integration tool.

• Using the CData Software ODBC Driver for Procore in PyCharm

  Connect to Procore as an ODBC data source in PyCharm using the CData Software ODBC Driver for Procore.

• Connect to and Query OneNote in QlikView over ODBC

  Create data visualizations with Microsoft OneNote in QlikView.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Replicate Reckon from PowerShell

  Write a quick PowerShell script to query Reckon. Use connectivity to the live data to replicate Reckon to SQL Server.

• Visualize Oracle Sales in TIBCO Spotfire through OData

  Integrate Oracle Sales into dashboards in TIBCO Spotfire.

• Manage SAP SuccessFactors in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SAP SuccessFactors.

• Write a Simple Go Application to work with Twitter on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Twitter.

• Automate Vault CRM Replication to Azure Data Lake

  Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to Azure Data Lake.

• Visualize Live CockroachDB in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live CockroachDB into custom reports in Power BI.

• Connect Sugar CRM to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Sugar CRM using the CData Python MCP Server.

• Build Dashboards with SAS xpt in Dundas BI

  Create dynamic dashboards and perform analytics based on SAS XPORT in Dundas BI.

• Enable the SuiteCRM JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with SuiteCRM.

• Connect to Unbounce in NetBeans

  Connect to Unbounce in NetBeans with the data source configuration wizard.

• Use the CData Software ODBC Driver for Google Directory in SAS for Real-Time Reporting and Analytics

  Connect to real-time Google Directory in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Directory.

• Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy Web

  Connect to Adobe Commerce in MicroStrategy Web using the CData Software ODBC Driver for Adobe Commerce.

• Use the CData Software ODBC Driver for Act-On in MicroStrategy

  Connect to Act-On in MicroStrategy Developer using the CData Software ODBC Driver for Act-On.

• Extend Google Sheets with Redis

  Make calls to the API Server from Google Apps Script.

• Use the CData Software JDBC Driver for SAP Concur in MicroStrategy Web

  Connect to SAP Concur in MicroStrategy Web using the CData Software JDBC Driver for SAP Concur.

• Create Data Visualizations in Cognos BI with Power BI XMLA

  Access Power BI XMLA as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Integrate with Access using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Access to a JSON file on disk.

• Write a Simple Go Application to work with Zoom on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoom.

• Visualize Oracle Financials Cloud in Tableau

  The CData ODBC driver for Oracle Financials Cloud enables you integrate Oracle Financials Cloud into Tableau dashboards.

• Connect to Dynamics NAV in Aqua Data Studio

  Access Microsoft Dynamics NAV from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Access MYOB AccountRight from MySQL in Amazon QuickSight

  Connect to MYOB AccountRight and build visualizations of MYOB AccountRight using a MySQL Connection in Amazon QuickSight.

• How to import Redis into Apache Solr

  Use the CData Software JDBC Driver for Redis in Data Import Handler and create an automated import of Redis to Apache Solr Enterprise Search platform.

• How to Seamlessly Import Sage 50 UK Data into IBM SPSS Modeler

  Integrate Sage 50 UK data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Manage Google Search Results in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Google Search.

• Create Freshdesk-Connected Business Apps in AppSheet

  Connect to Freshdesk via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Freshdesk.

• Connect to Drip in CloverDX (formerly CloverETL)

  Transfer Drip using the visual workflow in the CloverDX data integration tool.

• Visualize Trello in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Trello into TIBCO Spotfire.

• Connect to Pipedrive in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Pipedrive in the Denodo Virtual DataPort Administrator.

• How to create an RPA flow for Neo4J in UiPath Studio

  Use the Neo4J ODBC Driver to create workflows that access real-time Neo4J without any coding.

• How to connect Amazon QuickSight to Yahoo! Japan Data Solution

  Create a connection to Yahoo! Japan Data Solution in CData Connect Cloud and insert Yahoo! Japan Data Solution into Amazon QuickSight SPICE to build interactive dashboards.

• Import Paylocity Using Azure Data Factory

  Use CData Connect Cloud to connect to Paylocity from Azure Data Factory and import live Paylocity.

• Connect to Clio from PowerBuilder via ADO.NET

  This article demonstrates how to access Clio from Appeon PowerBuilder using the CData ADO.NET Provider for Clio.

• Connect to Bing Ads from AWS Glue

  Use CData Connect Cloud to gain access to live Bing Ads from your AWS Glue jobs.

• Access Live Google Cloud Storage in AWS Lambda

  Connect to live Google Cloud Storage in AWS Lambda using the CData JDBC Driver.

• Migrating data from Tableau CRM Analytics to Google BigQuery using CData SSIS Components.

  Easily push Tableau CRM Analytics to Google BigQuery using the CData SSIS Tasks for Tableau CRM Analytics and Google BigQuery.

• ETL Shippo in Oracle Data Integrator

  This article shows how to transfer Shippo into a data warehouse using Oracle Data Integrator.

• How to Work with Neo4J in ETL Validator JDBC

  Connect to Neo4J from ETL Validator jobs using the CData Software JDBC Driver.

• How to import EventBrite into Apache Solr

  Use the CData Software JDBC Driver for EventBrite in Data Import Handler and create an automated import of Eventbrite to Apache Solr Enterprise Search platform.

• Build Dashboards with SAP ByDesign in DBxtra

  Create dynamic dashboards and perform analytics based on SAP Business ByDesign in DBxtra.

• Build Pipelines with Live Greenplum in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Greenplum from Google Cloud Data Fusion, enabling the integration of live Pivotal GreenPlum into the building and management of effective data pipelines.

• Import Google Analytics Using Azure Data Factory

  Use CData Connect Cloud to connect to Google Analytics from Azure Data Factory and import live Google Analytics.

• Create Informatica Mappings From/To a JDBC Data Source for Zoho CRM

  Create Zoho CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Replicate Zoho Projects in Heroku for Use in Salesforce Connect

  Replicate Zoho Projects to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Publish Reports with Excel in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Excel.

• Query OneNote in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft OneNote.

• Automated Continuous Jira Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Jira replication to Google BigQuery.

• Extract, Transform, and Load EnterpriseDB in Informatica PowerCenter

  Create a simple Workflow for EnterpriseDB in Informatica PowerCenter.

• Natively Connect to Tableau CRM Analytics in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Tableau CRM Analytics. Leverage the native support for ODBC in PHP.

• How to pipe Adobe Analytics to CSV in PowerShell

  Use standard PowerShell cmdlets to access Adobe Analytics tables.

• Access Live Amazon DynamoDB in AWS Lambda (with IntelliJ IDEA)

  Connect to live Amazon DynamoDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Build Apps with Live PostgreSQL in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live PostgreSQL into the Adalo platform and build custom mobile and web applications with real-time PostgreSQL.

• How to connect to Kafka from Spring Boot

  Connect to Kafka in a Spring Boot Application using CData JDBC Kafka Driver

• Create Power BI Reports on Real-Time Sage 200

  Use the CData ODBC Driver for Sage 200 to visualize Sage 200 in Power BI Desktop.

• Build Apps with Live LinkedIn Ads Using the Low-Code Development Platform of Mendix

• «
• 508
• 509
• 510
• 511
• 512
• 513
• 514
• 515
• 516
• 517
• »