CData Software - Knowledge Base

Recent Articles

• «
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• 167
• »

• Create JSON Reports on JasperReports Server

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

• Integrate Azure Synapse into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Azure Synapse and integrate live Azure Synapse into your Power Automate tasks.

• Connect to and Visualize Live Act-On in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Act-On.

• Connect to HBase from PowerBuilder

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

• Process & Analyze Google Cloud Storage in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Google Cloud Storage .

• Integrate Access with External Services using SnapLogic

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

• Import Real-Time Elasticsearch in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Elasticsearch in ColdFusion.

• Access SAP HANA as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP HANA from your Oracle system.

• A PostgreSQL Interface for Tally

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

• Automate SAP ByDesign Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP Business ByDesign replication to Azure Data Lake.

• Build Dashboards with Twitter Ads in Dundas BI

  Create dynamic dashboards and perform analytics based on Twitter Ads in Dundas BI.

• A PostgreSQL Interface for Sage 200

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

• Analyze JSON Services in R

  Use standard R functions and the development environment of your choice to analyze JSON with the CData JDBC Driver for JSON.

• Analyze Google Contacts in Looker

  Use CData Connect Cloud to connect to Google Contacts from Looker and build custom apps using live Google Contacts.

• Connect to Azure Active Directory in RazorSQL

  Connect to Azure Active Directory from wizards and query Azure Active Directory from the GUI in the RazorSQL database management tool.

• Model, Search, and Visualize Live Cassandra in ThoughtSpot

  Use CData Connect Cloud to connect to live Apache Cassandra for modeling, searching, and visualizing.

• Write a Simple Go Application to work with Google Ad Manager on Linux

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

• Validate Dynamics 365 Business Central with QuerySurge

  Access and validate Dynamics 365 Business Central in QuerySurge using the CData JDBC Driver.

• Use the CData ODBC Driver for Dynamics 365 Business Central in Microsoft Power Query

  You can use the CData Dynamics 365 Business Central ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Dynamics 365 Business Central into Microsoft Power Query.

• Work with Microsoft Planner in FoxPro

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

• Build Blackbaud FE NXT-Connected Apps in Bubble

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

• How to Connect to Google Analytics in Using Python: 6 Steps

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

• Create Data Visualizations Based On OData Services in Mode

  Use CData Connect Cloud to connect to OData Services from Mode and build visualizations using live

• Build SQL Analysis Services Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for SQL Analysis Services and build visualizations in Tableau Cloud.

• Automated Continuous Certinia Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Certinia replication to PostgreSQL.

• How to Query Smartsheet in MySQL Workbench

  Execute MySQL queries against live Smartsheet from MySQL Workbench.

• Connect to Parquet in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Parquet and connect to Apache Parquet in Akorbi Digital RunMyProcess.

• Create Dynamic CSV Grids Using the Infragistics XamDataGrid

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

• Use Dash to Build to Web Apps on Google Cloud Storage

  Create Python applications that use pandas and Dash to build Google Cloud Storage-connected web apps.

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

  Connect to Microsoft Dynamics 365 from a connection pool in Tomcat.

• Build MVC Applications with Connectivity to Authorize.Net

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Authorize.Net from an ASP.NET MVC application.

• Automated Continuous Google Sheets Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Google Sheets replication to delimited files (CSV/TSV).

• Build Bullhorn CRM-Connected Apps in Mendix

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

• Query Pipedrive as a MySQL Database in Node.js

  Execute MySQL queries against Pipedrive from Node.js.

• LINQ to Splunk

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Splunk Data Provider.

• Connect to Zuora as a Linked Server

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

• Query ConstantContact through ODBC in Node.js

  Use node-odbc to execute SQL queries against ConstantContact from Node.js.

• Use the CData Software ODBC Driver for Jira Service Management in MicroStrategy

  Connect to Atlassian Jira Service Management in MicroStrategy Developer using the CData Software ODBC Driver for Jira Service Management.

• How to import Bing Ads into Apache Solr

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

• Build IBM Informix-Connected Apps in Bubble

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

• Use the CData Software JDBC Driver for SAP HANA in MicroStrategy Desktop

  Connect to SAP HANA in MicroStrategy Desktop using the CData Software JDBC Driver for SAP HANA.

• How to Build an ETL App for Cloudant in Python with CData

  Create ETL applications and real-time data pipelines for IBM Cloudant in Python with petl.

• Visualize Live Shippo of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Shippo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Access Live Microsoft Planner in TIBCO Data Virtualization

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

• Automated Continuous Monday.com Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Monday.com replication to AlloyDB.

• Bidirectional Access to Salesloft from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Salesloft in Filemaker Pro for Mac or Windows.

• Connect to FHIR in Google Apps Script

  Use CData Connect Cloud to access FHIR in Google Apps Script.

• Create Apps from Access in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Microsoft Access and build apps from live Microsoft Access in Qlik Sense Cloud.

• Query Zoho Creator in MySQL Workbench

  Create a virtual MySQL database for Zoho Creator in CData Software Connect (or Connect Server) and work with live Zoho Creator in MySQL Workbench.

• Connect to IBM Informix in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for IBM Informix in Airbyte.

• Validate Blackbaud FE NXT with QuerySurge

  Access and validate Blackbaud FE NXT in QuerySurge using the CData JDBC Driver.

• DataBind Controls to Act CRM in C++Builder

  DataBind to Act CRM in C++Builder with standard components and controls.

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

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

• Working with DB2 in LINQPad

  Execute LINQ queries to IBM DB2 in LINQPad.

• Create Dynamic Email Grids Using the Infragistics XamDataGrid

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

• Automated Continuous Sage Cloud Accounting Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Snowflake.

• How to integrate SAP BusinessObjects BI with Apache Airflow

  Access and process SAP BusinessObjects BI in Apache Airflow using the CData JDBC Driver.

• Build Monday.com Visualizations in Tableau Desktop

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

• Integrate with Impala in JReport Designer

  Create charts and reports based on Apache Impala in JReport Designer.

• Create Dynamics GP-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Dynamics GP from Klipfolio and build custom visualizations using live Microsoft Dynamics GP.

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

  Connect to live CSV/TSV Files in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Access Sage Intacct from MySQL in PHP

  Connect to Sage Intacct through the standard MySQL libraries in PHP.

• Build Bing Ads-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Bing Ads from Choreo and build custom apps using live Bing Ads.

• Automated Continuous Printify Replication to Apache Cassandra

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

• Connect to Cassandra in DBeaver

  Use the CData ODBC Driver to connect to Apache Cassandra in DBeaver.

• Automated Continuous eBay Analytics Replication to Oracle

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

• Visualize Live Oracle Sales in the Power BI Service

  Use CData Connect Cloud to connect to live Oracle Sales and create custom reports in the Power BI Service through the On-Premises Gateway.

• Access Live QuickBooks Online in TIBCO Data Virtualization

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

• Prepare, Blend, and Analyze Cassandra in Alteryx Designer

  Build workflows to access live Apache Cassandra for self-service data analytics.

• How to Connect the Power BI Service to Square: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Viewing Zoho Creator in RAD Studio Data Explorer

  How to view Zoho Creator in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Creator.

• Access SAP from MySQL in PHP

  Connect to SAP through the standard MySQL libraries in PHP.

• How to Connect DBeaver to Box via a JDBC Driver

  Manage Box with visual tools in DBeaver like the query browser.

• How to Query Spark in MySQL Workbench

  Execute MySQL queries against live Apache Spark SQL from MySQL Workbench.

• Bridge Xero Connectivity with Apache NiFi

  Access and process Xero Accounting in Apache NiFi using the CData JDBC Driver.

• Connect to Azure DevOps through External Services in Salesforce

  Use CData Connect Cloud to securely provide OData feeds of Azure DevOps to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure DevOps objects that you can access from apps and the dashboard.

• Use the CData ODBC Driver for Sybase IQ in Microsoft Power Query

  You can use the CData Sybase IQ ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sybase IQ into Microsoft Power Query.

• Using AngularJS to Build Dynamic Web Pages with Trello

  Use the CData Connect Server to create Trello OData feeds and build single-page applications with live Trello.

• Access Impala from MySQL in Amazon QuickSight

  Connect to Impala and build visualizations of Apache Impala using a MySQL Connection in Amazon QuickSight.

• Access Live SendGrid in Excel (Desktop)

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

• Use Dash to Build to Web Apps on Teradata

  Create Python applications that use pandas and Dash to build Teradata-connected web apps.

• How to publish and share Monday.com dashboards with Tableau Server

  The CData ODBC driver for Monday.com enables you integrate Monday.com into Tableau dashboards.

• Integrate Live Google Ads into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Google Ads and integrate live Google Ads into apps built in Microsoft Power Apps.

• Query Box as a SQL Server in Node.js

  Execute SQL Server queries against Box from Node.js.

• How to Work with Basecamp in ETL Validator JDBC

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

• Choosing the Best Method to Connect Adobe Commerce to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Adobe Commerce from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Access Live Sage Intacct in AWS Lambda (with IntelliJ IDEA)

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

• Query ServiceNow in DataGrip

  Create a Data Source for ServiceNow in DataGrip and use SQL to query live ServiceNow.

• ETL Procore in Oracle Data Integrator

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

• Connect to MongoDB in RapidMiner

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

• Use the CData Software JDBC Driver for Dynamics CRM in MicroStrategy Web

  Connect to Microsoft Dynamics CRM in MicroStrategy Web using the CData Software JDBC Driver for Dynamics CRM.

• Integrate Real-Time Access to Kafka in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Kafka in real time.

• Connect to SAP HANA in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for SAP HANA and connect to SAP HANA in Akorbi Digital RunMyProcess.

• Integrate Confluence in the Pentaho Report Designer

  Publish reports based on Atlassian Confluence in the Pentaho BI tool.

• Connect to FTP in as an External Source in Dremio

  Use the CData JDBC Driver to connect to FTP as an External Source in Dremio.

• Replicate Snowflake from PowerShell

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

• Use the CData ODBC Driver for Oracle HCM Cloud in SAS JMP

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

• How to connect Amazon QuickSight to Google Analytics

  Create a connection to Google Analytics in CData Connect Cloud and insert Google Analytics into Amazon QuickSight SPICE to build interactive dashboards.

• Integrate with SQL Server in JReport Designer

  Create charts and reports based on Microsoft SQL Server in JReport Designer.

• Connect to SuiteCRM in DBeaver

  Use the CData ODBC Driver to connect to SuiteCRM in DBeaver.

• «
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• 167
• »