CData Software - Knowledge Base

Recent Articles

• «
• 513
• 514
• 515
• 516
• 517
• 518
• 519
• 520
• 521
• 522
• »

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

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

• Connect to Jira in NetBeans

  Connect to Atlassian Jira in NetBeans with the data source configuration wizard.

• LINQ to QuickBooks

  LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData Data Providers for ADO.NET. This example uses LINQ to access information from the QuickBooks Data Provider.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed HCL Domino to Power BI dashboards. Simply drag and drop HCL Domino into data visuals on the Power BI canvas.

• Build Sage 200-Connected Apps in Mendix

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

• Build Twitter Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Twitter and build visualizations in Tableau.

• Access Live Freshdesk in AWS Lambda (with IntelliJ IDEA)

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

• Build Slack Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Slack and build visualizations in Tableau.

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

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

• Analyze Exact Online in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Exact Online and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Create SSAS Tabular Models from Basecamp

  How to build a SQL Server Analysis Service Tabular Model from Basecamp using CData drivers.

• Connect to Exact Online from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Exact Online from Crystal Reports.

• Query Azure Analysis Services using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Azure Analysis Services entities in PHP by modeling them as objects.

• Automated Continuous Xero Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Xero replication to Google Cloud SQL.

• Automated Continuous Salesforce Pardot Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Apache Cassandra.

• View Reports on Real-Time FHIR in Power BI Report Server

  Use the CData ODBC Driver for FHIR to visualize FHIR in Power BI Desktop and then publish them to Power BI Report Server.

• How to connect to BigCommerce with Squirrel SQL client

  Connect to BigCommerce and execute queries in the Squirrel SQL Client.

• Automate Drip Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Drip and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Easily Integrate SingleStore in Lazarus Pascal IDE

  Learn how to easily integrate live SingleStore in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Phoenix

  Provide connectivity to Apache Phoenix through an SAP BusinessObjects universe.

• Connect to Shopify from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Shopify to connect to Shopify from Web applications running on WebLogic.

• How to connect SharePoint with Clio through external lists

  Provide Clio to SharePoint users as an external list.

• Edit and Search SAP HANA XS Advanced External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of SAP HANA XS Advanced to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP HANA XS Advanced objects that you can access from apps and the dashboard.

• How to connect PolyBase to Oracle Eloqua

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Eloqua.

• Create Dynamic Coinbase Grids Using the Infragistics XamDataGrid

  Learn how you can connect Coinbase to Infragistics XamDataGrid to build dynamic grids.

• Integrate Oracle Sales with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Oracle Sales with External Services.

• DataBind Controls to Splunk in Delphi

  DataBind to Splunk in Delphi with standard data access components and controls.

• Natively Connect to Smartsheet in PHP via ODBC (Linux)

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

• Connect to SAP SuccessFactors from Asprova with CData Software ODBC Driver for SAP SuccessFactors

  This article shows how to connect faster to SAP SuccessFactors data from Asprova.

• Analyze Amazon Marketplace in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Amazon Marketplace and visualize Amazon Marketplace in SAP Analytics Cloud.

• Connect to MongoDB in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Visualize SAP Ariba Procurement from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SAP Ariba Procurement.

• Use Biml to Build SSIS Tasks to Replicate HubSpot to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HubSpot to SQL Server.

• How to Connect to Elasticsearch in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Elasticsearch. Leverage the pyodbc module for ODBC in Python.

• Publish Azure Active Directory-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Azure Active Directory.

• Build a PostgreSQL Interface for QuickBooks Time using the CData JDBC Driver

  Use the Remoting features of the QuickBooks Time JDBC Driver to create a PostgreSQL entry-point for data access.

• Automated Continuous Amazon DynamoDB Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Apache Kafka.

• Bridge Facebook Ads Connectivity with Apache NiFi

  Access and process Facebook Ads in Apache NiFi using the CData JDBC Driver.

• How to Use a Microsoft Access Database to Update SAP HANA in Real Time

  Update SAP HANA data by creating a linked table in Microsoft Access with the CData SAP HANA ODBC Driver.

• Connect to Live Google Directory in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Google Directory in CData Connect Cloud and connect to your Google Directory from PostgreSQL.

• How to Query Live SharePoint in Claude Desktop

  Connect to and query live SharePoint in Claude Desktop using the CData MCP Server.

• Import MongoDB Using Azure Data Factory

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

• Bridge Google Sheets Connectivity with Apache NiFi

  Access and process Google Sheets in Apache NiFi using the CData JDBC Driver.

• Query Google Calendar from Node.js

  Use the OData endpoint of the CData API Server to connect to your Google Calendar and perform CRUD operations on Google Calendar from Node.js.

• Configure the CData JDBC Driver for Okta in a Connection Pool in Tomcat

  Connect to Okta from a connection pool in Tomcat.

• Building Dynamic Web Pages with Azure DevOps Using AngularJS

  Create single-page applications with live connectivity to Azure DevOps using the CData API Server.

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

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

• 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.

• Build Charts with Office 365 in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Office 365 in Clear Analytics.

• How to Work with Greenplum in ETL Validator JDBC

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

• Feed Impala into FineReport

  How to set Apache Impala as a JDBC data source in FineReport.

• Access Live Sybase IQ in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Sybase IQ to create a Sybase IQ source in TIBCO Data Virtualization Studio and gain access to live Sybase IQ from your TDV Server.

• Create SAP BusinessObjects BI-Connected Applications in Appsmith

  Connect to SAP BusinessObjects BI via CData Connect Cloud in Appsmith and create custom business applications with real-time access to SAP BusinessObjects BI.

• Visualize eBay Analytics in Tableau

  The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics into Tableau dashboards.

• Add Parquet to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Parquet with the Informatica Enterprise Data Catalog to classify and organize data.

• Analyze SAS xpt with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for SAS xpt from Power Pivot. You will use the Table Import Wizard to load SAS XPORT. You can visually build the import query or use any SQL supported by the driver.

• Replicate ConstantContact to Multiple Databases

  Replicate ConstantContact to disparate databases with a point-and-click configuration.

• Access Live Cloudant in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live IBM Cloudant from your Excel spreadsheets.

• Bridge SAP Concur Connectivity with Apache NiFi

  Access and process SAP Concur in Apache NiFi using the CData JDBC Driver.

• Work with Snapchat Ads in FoxPro

  Load Snapchat Ads into a FoxPro database. This article includes full code and a walk-through of the process.

• Replicate Dynamics NAV to Multiple Databases via the CData Sync CLI

  Replicate Microsoft Dynamics NAV to disparate databases with a single configuration.

• Migrating data from Workday to Google BigQuery using CData SSIS Components.

  Easily push Workday to Google BigQuery using the CData SSIS Tasks for Workday and Google BigQuery.

• Connect to Zoho Projects from a Connection Pool in Jetty

  The Zoho Projects JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho Projects from Web apps in Jetty.

• Access Live Oracle Eloqua in Coginiti Pro

  Connect to and query live Oracle Eloqua from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Connect to WordPress from Crystal Reports

  Use CData Connect Cloud to connect to and report on live WordPress from Crystal Reports.

• Build HCL Domino-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to HCL Domino and build web apps with connectivity to live HCL Domino.

• ETL Impala in Oracle Data Integrator

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

• Automated Continuous XML Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable XML replication to Azure SQL Database.

• DataBind ShipStation to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for ShipStation with the DevExpress Windows Forms and Web controls to provide ShipStation to a chart.

• Create Dynamic Dynamics CRM Grids Using the Infragistics XamDataGrid

  Learn how you can connect Dynamics CRM to Infragistics XamDataGrid to build dynamic grids.

• Connect to Okta in CloverDX (formerly CloverETL)

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

• Connect to Clio in CloverDX (formerly CloverETL)

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

• Create Dynamic Asana Grids Using the Infragistics XamDataGrid

  Learn how you can connect Asana to Infragistics XamDataGrid to build dynamic grids.

• Access Azure Active Directory 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 Azure Active Directory.

• Connect to Tableau CRM Analytics from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Tableau CRM Analytics from Filemaker Pro on Mac.

• Stream JSON Services into Apache Kafka Topics

  Access and stream JSON in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Build Dashboards with Freshdesk in DBxtra

  Create dynamic dashboards and perform analytics based on Freshdesk in DBxtra.

• Analyze Dropbox in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Dropbox and visualize live Dropbox in Ingragistics Reveal.

• Analyze Twitter in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Twitter and visualize Twitter in SAP Analytics Cloud.

• Connect to Okta as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Okta.

• Build SendGrid Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live SendGrid and build visualizations in Tableau Cloud.

• Connect to Salesforce Pardot in DBeaver

  Use the CData ODBC Driver to connect to Salesforce Pardot in DBeaver.

• Automated Continuous eBay Replication to SingleStore

  Use CData Sync for automated, continuous, customizable eBay replication to SingleStore.

• Integrating Sybase IQ in Talend Cloud Data Management Platform

• «
• 513
• 514
• 515
• 516
• 517
• 518
• 519
• 520
• 521
• 522
• »