CData Software - Knowledge Base

Recent Articles

• «
• 266
• 267
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• »

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

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

• How to Query Live LDAP Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live LDAP data in natural language using Python.

• Connect to CouchDB from a Connection Pool in WebLogic

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

• Prepare, Blend, and Analyze RSS Feeds in Alteryx Designer (ODBC)

  Build workflows to access live RSS Feeds for self-service data analytics.

• Connect to Amazon S3 from HeidiSQL

  Use CData Connect Cloud to connect to and query live Amazon S3 from HeidiSQL.

• A PostgreSQL Interface for Adobe Commerce using the CData ODBC Driver

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

• Working with Salesloft in LINQPad

  Execute LINQ queries to Salesloft in LINQPad.

• Automated Continuous Presto Replication to Azure SQL

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

• Write a Simple Go Application to work with Acumatica on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Acumatica ERP.

• Connect to Adobe Commerce in RunMyProcess through Connect Cloud

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

• How to connect PolyBase to Bitbucket

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

• How to Query Cloudant in MySQL Workbench

  Execute MySQL queries against live IBM Cloudant from MySQL Workbench.

• Replicate BigCommerce for Use in Salesforce Connect

  Replicate BigCommerce to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to and Visualize Live Google Search Results in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Search.

• How to Work with Snowflake in AWS Glue Jobs Using JDBC

  Connect to Snowflake from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to Work with Blackbaud FE NXT in AWS Glue Jobs Using JDBC

  Connect to Blackbaud FE NXT from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• MailChimp Reporting in OBIEE with the MailChimp JDBC Driver

  Deploy the MailChimp JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to Office 365 from Asprova with CData Software ODBC Driver for Office 365

  This article shows how to connect faster to Office 365 data from Asprova.

• Replicate Avalara AvaTax for Use in Salesforce Connect

  Replicate Avalara AvaTax to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Create Data Visualizations Based On SharePoint in Mode

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

• Visualize BambooHR in TIBCO Spotfire through OData

  Integrate BambooHR into dashboards in TIBCO Spotfire.

• Automated Continuous Redis Replication to Azure SQL

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

• How to connect PolyBase to HDFS

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

• Analyze ServiceNow in R via JDBC

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

• How to create an RPA flow for Active Directory in UiPath Studio

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

• Access Live Act CRM in TIBCO Data Virtualization

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

• Build EventBrite-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Eventbrite and build visualizations and dashbaords from Eventbrite in Redash.

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

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

• How to Create Power BI Visual Reports with Real-Time Oracle HCM Cloud

  Use CData Power BI Connectors to visualize Oracle HCM Cloud in Power BI.

• A PostgreSQL Interface for Microsoft Planner (MySQL Remoting via JDBC)

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

• Work with SQL Analysis Services in FoxPro

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

• Integrate Live Couchbase into Amazon SageMaker Canvas with RDS

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

• How to Work with NetSuite in ETL Validator JDBC

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

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

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

• Create a Data Access Object for Sage Cloud Accounting using JDBI

  A brief overview of creating a SQL Object API for Sage Business Cloud Accounting in JDBI.

• Query, Visualize, and Share live BigCommerce in Redash

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

• Connect to Live Quickbase in PostGresSQL Interface through CData Connect Cloud

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

• Create Spark Reports on JasperReports Server

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

• Validate WooCommerce with QuerySurge

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

• Connect to Couchbase in CloverDX (formerly CloverETL)

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

• How to connect to Dynamics GP from Spring Boot

  Connect to Dynamics GP in a Spring Boot Application using CData JDBC Dynamics GP Driver

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

• Connect to SingleStore in SpagoBI

  Create reports featuring live SingleStore in SpagoBI Studio. Host SingleStore reports on SpagoBI Server.

• Write a Simple Go Application to work with Amazon Athena on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon Athena.

• REST Reporting and Star Schemas in OBIEE

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

• Access SQL Analysis Services from MySQL in Amazon QuickSight

  Connect to SQL Analysis Services and build visualizations of SQL Analysis Services using a MySQL Connection in Amazon QuickSight.

• Access Google Drive from MySQL in HeidiSQL

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

• Validate QuickBooks with QuerySurge

  Access and validate QuickBooks Desktop in QuerySurge using the CData JDBC Driver.

• Connect to and Visualize Live MongoDB in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live MongoDB.

• Query, Visualize, and Share live OData Services in Redash

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

• How to Seamlessly Import Redshift Data into IBM SPSS Modeler

  Integrate Redshift data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

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

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

• Automated Wave Financial Replication to Teradata

  Use CData Sync to Customize and automate Wave Financial replication to Teradata.

• Automate Zoho Creator Replication to SAP HANA

  Use CData Sync to customize and automate Zoho Creator replication to SAP HANA.

• Bridge TigerGraph Connectivity with Apache NiFi

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

• Automated Continuous Printify Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Printify replication to OneLake in Microsoft Fabric.

• Seamlessly Bring API into Retool Using CData Connect Cloud

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

• Connect to CouchDB in SpagoBI

  Create reports featuring live Apache CouchDB in SpagoBI Studio. Host CouchDB reports on SpagoBI Server.

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

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

• Integrate with Printify in JReport Designer

  Create charts and reports based on Printify in JReport Designer.

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

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

• Google Spanner Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Spanner through CData Connect Cloud using different applications and tools.

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

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

• Automated Continuous CouchDB Replication to AlloyDB

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

• Integrate Live HCL Domino into Amazon SageMaker Canvas with RDS

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

• Natively Connect to Invoiced in PHP

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

• Enable the TigerGraph JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with TigerGraph.

• Use the CData ODBC Driver for Zoom from SharePoint Excel Services

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

• How to integrate Metabase with Azure Table

  Use CData Connect Cloud to connect to live Azure Table Storage and create an interactive dashboard in Metabase from Azure Table Storage.

• Prepare, Blend, and Analyze Outreach.io in Alteryx Designer (Connect Cloud)

  Build workflows to access live Outreach.io for self-service data analytics.

• How to Connect DBeaver to Sage 200 via a JDBC Driver

  Manage Sage 200 with visual tools in DBeaver like the query browser.

• Write a Simple Go Application to work with Azure Data Catalog on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Data Catalog.

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

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

• Connect to WooCommerce in RapidMiner

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

• Import MariaDB Using Azure Data Factory

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

• Connect to MarkLogic as an External Source in Dremio

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

• Build MVC Applications with Connectivity to GraphQL

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

• How to Connect to Google Campaign Manager 360 in Using Python: 6 Steps

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

• Create Datasets from IBM Informix in Domo Workbench and Build Visualizations of IBM Informix in Domo

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

• Create Reports from NetSuite in Looker Studio

  Use CData Connect Cloud to gain access to live NetSuite CRM & ERP and create custom reports in Looker Studio.

• Connect to SuiteCRM in NetBeans

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

• Integrate IBM Cloud Object Storage in Pentaho Data Integration

  Build ETL pipelines based on IBM Cloud Object Storage in the Pentaho Data Integration tool.

• Connect to Cosmos DB from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Azure Cosmos DB from Crystal Reports.

• How to Connect to & Open ConstantContact in Microsoft Excel

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

• Automated Continuous Splunk Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Splunk replication to IBM DB2.

• Automate Impala Replication to Azure Synapse

  Use CData Sync to customize and automate Apache Impala replication to Azure Synapse.

• Integrate Greenhouse in Pentaho Data Integration

  Build ETL pipelines based on Greenhouse in the Pentaho Data Integration tool.

• Connect to Microsoft Exchange in NetBeans

  Connect to Microsoft Exchange in NetBeans with the data source configuration wizard.

• Connect to Live Avro in MicroStrategy through CData Software Connect Server

  Create a virtual database for Avro in CData Software Connect Server and connect to it from MicroStrategy.

• Connect to Square in CloverDX (formerly CloverETL)

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

• Create Invoiced Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Automated Continuous Parquet Replication to Apache Kafka

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

• Build Acumatica-Connected Apps in Bubble

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

• Create SSAS Tabular Models from Smartsheet

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

• Build Data Flows from SQL Server to Impala through SSIS

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

• Build Visualizations of Live FTP in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for FTP Servers and build custom reports in Power BI.

• Use the CData Software ODBC Driver for MongoDB in MicroStrategy Desktop

  Connect to MongoDB in MicroStrategy Desktop using the CData Software ODBC Driver for MongoDB.

• Connect to Reckon Accounts Hosted in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Reckon Accounts Hosted in Google Apps Script.

• Build Dashboards with OneNote in DBxtra

  Create dynamic dashboards and perform analytics based on Microsoft OneNote in DBxtra.

• Use the CData Software JDBC Driver for ShipStation in MicroStrategy Web

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

• «
• 266
• 267
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• »