CData Software - Knowledge Base

Recent Articles

• «
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• 135
• »

• Connect to GraphQL from a Connection Pool in Jetty

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

• Create Data Visualizations in Cognos BI with SharePoint

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

• A PostgreSQL Interface for Printful

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

• Connect to SharePoint Excel Services in Ruby

  Connect to SharePoint Excel Services in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

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

• Connect to Zendesk in RunMyProcess through Connect Cloud

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

• How to create Visio diagrams from CockroachDB

  Automatically update CockroachDB with the changes you make to Visio master shapes.

• Access Live Zoho Creator in Google Sheets

  Use CData Connect Cloud to gain access to live Zoho Creator from your Google Sheets.

• Work with CouchDB in FoxPro

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

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

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

• How to import SendGrid into Apache Solr

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

• Access Live API in Excel 365 Online (Excel for the web)

  Connect to API from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Visualize Live YouTube Analytics in the Power BI Service

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

• BigQuery Reporting and Star Schemas in OBIEE

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

• Create SAP HANA XS Advanced Reports on JasperReports Server

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

• Automated Continuous Greenplum Replication to Local Delimited Files

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

• Import Real-Time Splunk in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Splunk in ColdFusion.

• Query Certinia in DataGrip

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

• Automated Continuous Printful Replication to SQLite

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

• Prepare, Blend, and Analyze Avalara AvaTax in Alteryx Designer

  Build workflows to access live Avalara AvaTax for self-service data analytics.

• How to work with ConstantContact in Apache Spark using SQL

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

• Automated Continuous Excel Replication to Snowflake

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

• Create Greenplum-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Greenplum from Klipfolio and build custom visualizations using live Pivotal GreenPlum.

• Connect to Databricks in Jaspersoft Studio

  Execute SQL to remote Databricks in Jaspersoft Studio.

• Provide OData Services of Shopify from a WCF Application

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

• How to Import Oracle Sales into SQL Server using SSIS

  Easily back up Oracle Sales to SQL Server using the SSIS components for Oracle Sales.

• Natively Connect to Smartsheet in PHP

  The CData ODBC driver for Smartsheet enables you to create PHP applications with connectivity to Smartsheet. Leverage the native support for ODBC in PHP.

• Integrate Live Freshdesk into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Freshdesk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Freshdesk.

• How to Query Jira Service Management in MySQL Workbench

  Execute MySQL queries against live Atlassian Jira Service Management from MySQL Workbench.

• A PostgreSQL Interface for LinkedIn

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

• Connect to and Query Bullhorn CRM in QlikView over ODBC

  Create data visualizations with Bullhorn CRM in QlikView.

• Extract, Transform, and Load DocuSign in Informatica PowerCenter

  Create a simple Workflow for DocuSign in Informatica PowerCenter.

• Connect to Sage 200 from PowerBuilder

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

• Automated Continuous Neo4J Replication to Google Cloud SQL

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

• Connect to ADP in DBArtisan

  Use wizards in DBArtisan to configure ADP as a data source.

• Use the CData Software JDBC Driver for Twitter Ads in MicroStrategy

  Connect to Twitter Ads in MicroStrategy Developer using the CData Software JDBC Driver for Twitter Ads.

• Viewing YouTube Analytics in RAD Studio Data Explorer

  How to view YouTube Analytics in RAD Studio Data Explorer using the CData ODBC Driver for YouTube Analytics.

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

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

• How to integrate Email with Apache Airflow

  Access and process Email in Apache Airflow using the CData JDBC Driver.

• How to create Visio diagrams from Google Directory

  Automatically update Google Directory with the changes you make to Visio master shapes.

• Publish Email-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Email.

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

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

• How to connect to Dropbox from Spring Boot

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

• Connect to Zendesk from Crystal Reports

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

• Import Active Directory into FileMaker Pro

  Create reports that integrate Active Directory in Filemaker Pro.

• Work with SuiteCRM in FoxPro

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

• Process & Analyze Azure Table in Databricks (AWS)

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

• Automated Continuous Shippo Replication to SingleStore

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sybase IQ

  Provide connectivity to Sybase IQ through an SAP BusinessObjects universe.

• Bridge Act CRM Connectivity with Apache NiFi

  Access and process Act CRM in Apache NiFi using the CData JDBC Driver.

• Access SAP SuccessFactors from MySQL in PHP

  Connect to SAP SuccessFactors through the standard MySQL libraries in PHP.

• Extract, Transform, and Load Drift in Informatica PowerCenter

  Create a simple Workflow for Drift in Informatica PowerCenter.

• Explore Geographical Relationships in Snapchat Ads with Power Map

  Create data visualizations with Snapchat Ads in Power Map.

• Integrate OData Services into Power Automate Desktop using CData Connect

  CData Connect for OData Services enables you to integrate OData into workflows built using Microsoft Power Automate Desktop.

• Connect to Microsoft Planner in Jaspersoft Studio

  Execute SQL to remote Microsoft Planner in Jaspersoft Studio.

• How to Import MarkLogic into SQL Server using SSIS

  Easily back up MarkLogic to SQL Server using the SSIS components for MarkLogic.

• Visualize Live SQL Analysis Services in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for SQL Analysis Services and create custom reports in the Power BI Service.

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

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

• Model, Search, and Visualize Live Jira Service Management in ThoughtSpot

  Use CData Connect Cloud to connect to live Atlassian Jira Service Management for modeling, searching, and visualizing.

• Connect to SuiteCRM in NetBeans

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

• Automated Continuous Square Replication to Apache Cassandra

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

• Analyze Active Directory in Looker

  Use CData Connect Cloud to connect to Active Directory from Looker and build custom apps using live Active Directory.

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

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

• Use the CData ODBC Driver for Harvest in Microsoft Power Query

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

• Connect to Oracle Sales from Blazor Apps

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

• How to Access MongoDB Using Entity Framework

  This article shows how to access MongoDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Integrate Sybase IQ into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Sybase IQ and integrate live Sybase IQ into your Power Automate (Microsoft Flow) tasks.

• Model, Search, and Visualize Live Dynamics 365 Business Central in ThoughtSpot

  Use CData Connect Cloud to connect to live Dynamics 365 Business Central for modeling, searching, and visualizing.

• How to import Harvest into Apache Solr

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

• Connect to Reckon in RapidMiner

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

• How to Import Snapchat Ads into SQL Server using SSIS

  Easily back up Snapchat Ads to SQL Server using the SSIS components for Snapchat Ads.

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

  Provide connectivity to Amazon S3 through an SAP BusinessObjects universe.

• Query, Visualize, and Share live Monday.com in Redash

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

• Design BIRT Reports on SAP ByDesign

  Provide current SAP Business ByDesign to your embedded analytics.

• Visualize LinkedIn in Sisense

  Create an ElastiCube in Sisense app with access to LinkedIn.

• Connect to Live API in MicroStrategy through CData Connect Cloud

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

• Visualize Live Amazon Athena in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Amazon Athena.

• Integrate Real-Time Access to Bing Search in SAPUI5 MVC Apps

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

• Operational Reporting on Teradata from Spotfire Server

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

• Connect to Microsoft Planner in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Query SAS Data Sets as a SQL Server in Node.js

  Execute SQL Server queries against SAS Data Sets from Node.js.

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

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

• Connect to SAP ByDesign from a Connection Pool in Jetty

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

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

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

• How to connect Amazon QuickSight to NetSuite

  Create a connection to NetSuite CRM & ERP in CData Connect Cloud and insert NetSuite CRM & ERP into Amazon QuickSight SPICE to build interactive dashboards.

• Create Dynamics GP Reports on JasperReports Server

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

• Query Trello in MySQL Workbench

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

• Access Live SAP HANA in AWS Lambda (with IntelliJ IDEA)

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

• Analyze MarkLogic in R

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

• Operational Reporting on Azure Table from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Azure Table Storage.

• Back Up Sage 300 to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage 300. In this article, we will employ an SSIS workflow to populate a database with Sage 300 data.

• Visualize Act-On in Sisense

  Create an ElastiCube in Sisense app with access to Act-On.

• Build Apps with Live Raisers Edge NXT in Adalo using CData Connect Cloud

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

• Connect to ConstantContact in Aqua Data Studio

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

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

• Access Drip from MySQL in HeidiSQL

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

• Manage JSON Services in DBArtisan as a JDBC Source

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

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

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

• A PostgreSQL Interface for Amazon Marketplace

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

• Connect to Microsoft Teams in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Teams as a data source.

• «
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• 135
• »