CData Software - Knowledge Base

Recent Articles

• «
• 139
• 140
• 141
• 142
• 143
• 144
• 145
• 146
• 147
• 148
• »

• Operational Reporting on Dynamics NAV from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Dynamics NAV.

• How to connect to GitHub from IntelliJ

  Integrate connectivity to GitHub with wizards in IntelliJ.

• Access Live HubSpot in Excel (Desktop)

  Use CData Connect Cloud to gain access to live HubSpot from your Excel spreadsheets.

• Connect to HubDB in CloverDX (formerly CloverETL)

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

• Integrate with Amazon DynamoDB in JReport Designer

  Create charts and reports based on Amazon DynamoDB in JReport Designer.

• How to Use a Microsoft Access Database to Update Salesforce Marketing in Real Time

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

• Connect to Raisers Edge NXT from a Connection Pool in Jetty

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

• Integrate with Live AlloyDB in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to AlloyDB from the MuleSoft Anypoint Platform to integrate live Google AlloyDB into custom reports and dashboards.

• Integrate with Parquet using Apache Camel2

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

• Build Bullhorn CRM Visualizations in Tableau Desktop

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

• Automated Continuous Xero Replication to Apache Kafka

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

• Integrate Microsoft Exchange with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Microsoft Exchange with External Services.

• Build Semantic Layer Views for Zoho CRM in APOS Live Data Gateway

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

• Connect to MySQL through SSH Using the Built-In Client

  A detailed overview of the SQL Gateway, its function, and its features.

• Connect to Live Monday.com in MicroStrategy through CData Connect Cloud

  Create a live connection to Monday.com in CData Connect Cloud and connect to your Monday.com from MicroStrategy.

• Rapidly Develop Spark-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.

• How to connect to eBay Analytics from IntelliJ

  Integrate connectivity to eBay Analytics with wizards in IntelliJ.

• Automated EventBrite Replication to Teradata

  Use CData Sync to Customize and automate Eventbrite replication to Teradata.

• How to integrate Metabase with Oracle Service Cloud

  Use CData Connect Cloud to connect to live Oracle Service Cloud and create an interactive dashboard in Metabase from Oracle Service Cloud.

• How to Visualize DB2 Data in Python with pandas

  Use pandas and other modules to analyze and visualize live IBM DB2 in Python.

• Create Informatica Mappings From/To an ODBC Data Source for Databricks

  Create an ODBC connection to Databricks in Informatica and browse and transfer Databricks.

• How to connect to SAS Data Sets from Google Apps Script

  Use CData Software Connect Server to access SAS Data Sets in Google Apps Script.

• Establish a Live Connection with Databricks using Tableau Bridge

  The CData ODBC Driver for Databricks enables you to integrate live Databricks into Tableau Cloud dashboards using the Tableau Bridge.

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

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

• Establish a Live Connection with LinkedIn using Tableau Bridge

  The CData ODBC Driver for LinkedIn enables you to integrate live LinkedIn into Tableau Cloud dashboards using the Tableau Bridge.

• Connect to Microsoft Teams from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Microsoft Teams from Filemaker Pro on Mac.

• Integrate SAP Concur in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Concur from Informatica Cloud.

• How to Access Live MongoDB in Power Automate Desktop via ODBC

  The CData ODBC Driver for MongoDB enables you to integrate MongoDB into workflows built using Microsoft Power Automate Desktop.

• Build Twilio-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Twilio and build Twilio-connected web apps with Axios.

• Automated Continuous Sybase Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Sybase replication to Snowflake.

• Import Parquet into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Parquet and create custom reports in the Power BI Service.

• Use the CData ODBC Driver for SAS xpt from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for SAS xpt to connect to SAS XPORT from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAS XPORT in Excel.

• Automated Continuous Microsoft Planner Replication to SQLite

  Use CData Sync for automated, continuous, customizable Microsoft Planner replication to SQLite.

• Create Datasets from Impala in Domo Workbench and Build Visualizations of Impala in Domo

  Use the CData Software ODBC Driver for Impala to create datasets from Apache Impala in Domo Workbench and then build visualizations in the Domo service.

• Build Cassandra-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Cassandra and create custom apps in Bubble.

• Analyze Amazon DynamoDB in Looker

  Use CData Connect Cloud to connect to Amazon DynamoDB from Looker and build custom apps using live Amazon DynamoDB.

• Visualize Jira Assets in Tableau

  The CData ODBC driver for Jira Assets enables you integrate Jira Assets into Tableau dashboards.

• Replicate SAP Ariba Procurement from PowerShell

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

• Connect to Twilio from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Twilio from Filemaker Pro on Mac.

• Access XML from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live XML Files from HeidiSQL.

• Access Live FHIR in Coginiti Pro

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

• Connect to Kafka in Aqua Data Studio

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

• PowerShell Scripting to Replicate Outreach.io to MySQL

  Write a simple PowerShell script to replicate Outreach.io to a MySQL database.

• Build Visualizations of Amazon S3 in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon S3 in Birst.

• Connect to PayPal in RapidMiner

  Integrate PayPal with standard components and data source configuration wizards in RapidMiner Studio.

• Create Dynamic Azure Data Lake Storage Grids Using the Infragistics XamDataGrid

  Learn how you can connect Azure Data Lake Storage to Infragistics XamDataGrid to build dynamic grids.

• Access Live Elasticsearch in TIBCO Data Virtualization

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

• How to Create Power BI Visual Reports with Real-Time Zendesk

  Use CData Power BI Connectors to visualize Zendesk in Power BI.

• Integrate Oracle into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Oracle Database and integrate live Oracle Database into your Power Automate tasks.

• Connect to AlloyDB in JRuby

  Create a simple JRuby app with access to live Google AlloyDB.

• Integrate with Freshdesk in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Freshdesk in SnapLogic.

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

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

• Publish Crystal Reports on Basecamp

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Basecamp.

• Automated Continuous ShipStation Replication to Vertica

  Use CData Sync for automated, continuous, customizable ShipStation replication to Vertica.

• Rapidly Develop ClickUp-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 Informatica Mappings From/To a JDBC Data Source for Avro

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

• Use the CData ODBC Driver for IBM Cloud Object Storage in SAS JMP

  You can use the CData ODBC Driver to integrate IBM Cloud Object Storage into the statistical analysis tools available in SAS JMP. This article shows how to use IBM Cloud Object Storage in the Graph Builder and Query Builder.

• Access HCL Domino from MySQL in Amazon QuickSight

  Connect to HCL Domino and build visualizations of HCL Domino using a MySQL Connection in Amazon QuickSight.

• Use CData Connect Cloud to Access Square in Microsoft Power Pivot

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

• Automated Continuous Zoho Books Replication to Vertica

  Use CData Sync for automated, continuous, customizable Zoho Books replication to Vertica.

• Create Data Visualizations in Cognos BI with Quickbase

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

• Visualize QuickBooks Online in TIBCO Spotfire through ODBC

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

• Design BIRT Reports on Elasticsearch

  Provide current Elasticsearch to your embedded analytics.

• Object-Relational Mapping (ORM) with Greenplum 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 Pivotal GreenPlum into a Java-based ORM framework, Hibernate.

• Query, Visualize, and Share live Amazon Athena in Redash

  Use CData Connect Cloud to connect to live Amazon Athena in Redash for querying, visualizing, and sharing.

• Create Tally Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tally data access from reports, embedded analytics, and more.

• Replicate Microsoft Project to Multiple Databases

  Replicate Microsoft Project to disparate databases with a single configuration.

• DataBind Wijmo Grid to API

  Provide real-time API to interactive controls.

• How to connect to MYOB AccountRight from Spring Boot

  Connect to MYOB AccountRight in a Spring Boot Application using CData JDBC MYOB AccountRight Driver

• ETL BigQuery in Oracle Data Integrator

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

• Connect to SAP HANA from PowerBuilder

  This article demonstrates how to access SAP HANA from PowerBuilder using the SAP HANA JDBC Driver.

• Access Azure Table as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Table Storage from your Oracle system.

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

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

• Automated Continuous Adobe Commerce Replication to Oracle

  Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Oracle.

• DataBind Wijmo Grid to ClickUp

  Provide real-time ClickUp to interactive controls.

• Replicate Square from PowerShell

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

• Automate Freshdesk Replication to SAP HANA

  Use CData Sync to customize and automate Freshdesk replication to SAP HANA.

• How to use SQLAlchemy ORM to access Amazon DynamoDB in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon DynamoDB.

• Connect to Invoiced in NetBeans

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

• How to connect PolyBase to Amazon DynamoDB

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

• Process & Analyze HubDB in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live HubDB .

• A PostgreSQL Interface for JSON Services

  Use the SQL Gateway and JSON ODBC Driver to create a PostgreSQL entry-point for data access.

• Natively Connect to EventBrite in PHP

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

• Create Reports from MailChimp in Looker Studio

  Use CData Connect Cloud to gain access to live MailChimp and create custom reports in Looker Studio.

• Automated Continuous Jira Service Management Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Jira Service Management replication to Amazon Redshift.

• Analyze SuiteCRM with Power Pivot

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

• Access Live Parquet in AWS Lambda

  Connect to live Apache Parquet in AWS Lambda using the CData JDBC Driver.

• Integrate with MongoDB in JReport Designer

  Create charts and reports based on MongoDB in JReport Designer.

• Provide OData Services of Azure DevOps from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Azure DevOps by developing a WCF Service Application.

• How to Connect to & Open Microsoft Dataverse in Microsoft Excel

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

• Create Zoho Inventory-Connected Business Apps in AppSheet

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

• Import XML into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access XML Files. In this article, you will use the OData format to import XML Files into Microsoft Power Query.

• How to work with Dropbox in Apache Spark using SQL

  Access and process Dropbox in Apache Spark using the CData Software JDBC Driver.

• Create Reports with Zoho Books in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Zoho Books.

• How to use SQLAlchemy ORM to access Authorize.Net in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Authorize.Net.

• Use CData Connect Cloud to Access QuickBooks Online in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live QuickBooks Online in the Power Pivot business intelligence tool.

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

• «
• 139
• 140
• 141
• 142
• 143
• 144
• 145
• 146
• 147
• 148
• »