CData Software - Knowledge Base

Recent Articles

• «
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• 52
• »

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

  Use CData Power BI Connectors to visualize Bing Ads in Power BI.

• Build Data Flows from SQL Server to Cassandra through SSIS

  Easily push SQL Server data to Cassandra using the CData SSIS Tasks for Cassandra.

• Validate Confluence with QuerySurge

  Access and validate Atlassian Confluence in QuerySurge using the CData JDBC Driver.

• How to Connect to & Open Presto in Microsoft Excel

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

• How to create Visio diagrams from Jira Service Management

  Automatically update Atlassian Jira Service Management with the changes you make to Visio master shapes.

• Automated Continuous Blackbaud FE NXT Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to delimited files (CSV/TSV).

• LINQ to Asana

  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 Asana Data Provider.

• Create Reckon-Connected Dashboards in Grafana

  Connect to Reckon via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Reckon.

• Use the CData Software JDBC Driver for Monday.com in MicroStrategy

  Connect to Monday.com in MicroStrategy Developer using the CData Software JDBC Driver for Monday.com.

• Connect to WooCommerce in DBeaver

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

• Create Google Spanner Reports on JasperReports Server

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

• Connect to Highrise in RapidMiner

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

• Analyze Dynamics GP in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Microsoft Dynamics GP and visualize Microsoft Dynamics GP in SAP Analytics Cloud.

• Operational Reporting on Stripe from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Stripe.

• Use the CData Software JDBC Driver for AlloyDB in MicroStrategy

  Connect to Google AlloyDB in MicroStrategy Developer using the CData Software JDBC Driver for AlloyDB.

• How to connect and process TigerGraph from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live TigerGraph

• Operational Reporting on Sugar CRM from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Sugar CRM.

• Connect to WooCommerce in HULFT Integrate

  Connect to WooCommerce as a JDBC data source in HULFT Integrate

• Seamlessly Bring Oracle HCM Cloud into Retool Using CData Connect Cloud

  Integrate Oracle HCM Cloud data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Load NetSuite to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load NetSuite CRM & ERP to a database.

• How to publish and share ShipStation dashboards with Tableau Server

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

• Import Real-Time Azure Active Directory via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Azure Active Directory in ColdFusion.

• Manage Google Sheets in DBArtisan as a JDBC Source

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

• Integrate with Google Drive in SnapLogic

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

• Access Live Zoho Books in Excel (Desktop) via Connect Cloud

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

• How to Work with Sugar CRM in ETL Validator JDBC

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

• Access ActiveCampaign from MySQL in PHP

  Connect to ActiveCampaign through the standard MySQL libraries in PHP.

• Build Sage 200-Connected Apps in Bubble

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

• Build Visualizations of Instagram in Birst

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

• Connect to Sage 300 from Asprova with CData Software ODBC Driver for Sage 300

  This article shows how to connect faster to Sage 300 data from Asprova.

• Parquet Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Parquet facts in real time.

• Visualize Live Bing Ads in the Power BI Service

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

• How to create Todoist federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Todoist in MySQL .

• Build Visualizations of Google Analytics in Birst

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

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

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

• Connect to Azure Table from AWS Glue

  Use CData Connect Cloud to gain access to live Azure Table Storage from your AWS Glue jobs.

• Connect to Azure Active Directory in Jaspersoft Studio

  Execute SQL to remote Azure Active Directory in Jaspersoft Studio.

• Build Dashboards with Act CRM in Dundas BI

  Create dynamic dashboards and perform analytics based on Act CRM in Dundas BI.

• Connect to Presto from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Presto using standard SQL.

• Access Live Active Directory in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Active Directory from your Excel spreadsheets.

• Replicate Multiple Azure DevOps Accounts via the CData Sync CLI

  Replicate multiple Azure DevOps accounts to one or many databases.

• Connect to and Query Raisers Edge NXT in QlikView over ODBC

  Create data visualizations with Raisers Edge NXT in QlikView.

• Build Semantic Layer Views for SQL Server in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft SQL Server.

• Automate Klaviyo Replication to Azure Data Lake

  Use CData Sync to customize and automate Klaviyo replication to Azure Data Lake.

• Build Sugar CRM-Connected Apps in Mendix

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

• Access Live CockroachDB in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live CockroachDB from your Google Sheets.

• Integrate with Kafka using Apache Camel2

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

• DataBind Controls to Oracle Sales in Delphi

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

• Connect and Visualize Live CockroachDB Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live CockroachDB into the Databricks platform and create visualization dashboards with real-time CockroachDB.

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

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

• Working with SAP in LINQPad

  Execute LINQ queries to SAP ERP/NetWeaver in LINQPad.

• Connect to Live LinkedIn Ads in MicroStrategy through CData Connect Cloud

  Create a live connection to LinkedIn Ads in CData Connect Cloud and connect to your LinkedIn Ads from MicroStrategy.

• Creating CouchDB-Connected Applications in Unqork

  You can use CData Connect to feed Apache CouchDB to Unqork and build custom business apps.

• Access Live Google Calendar in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Google Calendar from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Import and Visualize Freshdesk in Power View

  Create data visualizations based on Freshdesk in Excel.

• Connect to Exact Online in CloverDX (formerly CloverETL)

  Transfer Exact Online using the visual workflow in the CloverDX data integration tool.

• Prepare, Blend, and Analyze Microsoft Teams in Alteryx Designer (ODBC)

  Build workflows to access live Microsoft Teams for self-service data analytics.

• Visualize Jira in TIBCO Spotfire through ODBC

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

• Build Semantic Layer Views for Google Sheets in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Google Sheets.

• Automated Continuous SAP HANA XS Advanced Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to IBM DB2.

• Validate Drift with QuerySurge

  Access and validate Drift in QuerySurge using the CData JDBC Driver.

• Create Dashboards and Visualize Live Bullhorn CRM in Geckoboard

  Use CData Connect Cloud to connect to live Bullhorn CRM and create dashboards for real-time monitoring and visualization in Geckoboard.

• Publish HDFS-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apache HDFS.

• Connect to Dynamics GP in CloverDX (formerly CloverETL)

  Transfer Microsoft Dynamics GP using the visual workflow in the CloverDX data integration tool.

• Establish a Live Connection with Harvest using Tableau Bridge

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

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

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

• Connect to Amazon S3 in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Amazon S3 and the SQL Gateway to access Amazon S3 from Google Apps Script.

• Integrate GitHub in Your Informatica Cloud Instance

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

• Build MVC Applications with Connectivity to Greenplum

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

• Validate HBase with QuerySurge

  Access and validate Apache HBase in QuerySurge using the CData JDBC Driver.

• Connect to REST from a Connection Pool in Jetty

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

• Build MYOB AccountRight-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live MYOB AccountRight.

• How to connect to Avro from Spring Boot

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

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

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

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

• Create Data Visualizations in Cognos BI with MariaDB

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

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

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

• Create PCA Sales-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to PCA Sales from OutSystems and build custom enterprise apps using live PCA Sales.

• Access Smartsheet from MySQL in HeidiSQL

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

• Bridge Google Contacts Connectivity with Apache NiFi

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

• Model MySQL Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and MySQL, enabling the direct import of real-time MySQL.

• Visualize Live Yahoo! Ads in the Power BI Service

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

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

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

• Connect to SAS xpt from PowerBuilder via ADO.NET

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

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

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

• Connect to SuiteCRM from PowerBuilder via JDBC

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

• Create Datasets from Bing Search in Domo Workbench and Build Visualizations of Bing Search Results in Domo

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

• Use the CData Software JDBC Driver for Google Search in MicroStrategy Web

  Connect to Google Search in MicroStrategy Web using the CData Software JDBC Driver for Google Search.

• Automated Continuous Zoho Creator Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Zoho Creator replication to Azure SQL.

• Integrate with live Oracle SCM in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Oracle SCM in Jitterbit.

• How to Connect to SharePoint Excel Services in Using Python: 6 Steps

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

• Build Visualizations of Hive in Birst

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

• Bidirectional Access to Greenhouse from FileMaker Pro

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

• Integrate Live SAP HANA XS Advanced into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for SAP HANA XS Advanced and integrate live SAP HANA XS Advanced into apps built in Microsoft Power Apps.

• Bidirectional Access to Sage Intacct from FileMaker Pro

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

• Add OData Services to Informatica Enterprise Data Catalog

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

• Import Real-Time Oracle via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Oracle Database in ColdFusion.

• Build MariaDB-Connected Apps in Mendix

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

• Create xBase-Connected Visualizations in Klipfolio

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

• DataBind Controls to EnterpriseDB in C++Builder

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

• «
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• 52
• »