CData Software - Knowledge Base

Recent Articles

• «
• 251
• 252
• 253
• 254
• 255
• 256
• 257
• 258
• 259
• 260
• »

• Use the CData ODBC Driver for Databricks in SAS JMP

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

• Analyze Act CRM in Cognos Analytics

  Use CData Connect Cloud to connect to Act CRM from Cognos Analytics and analyze live Act CRM.

• Connect to XML in as an External Source in Dremio

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

• Access Live Zenefits in Coginiti Pro

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

• How to connect to Oracle Eloqua from Spring Boot

  Connect to Oracle Eloqua in a Spring Boot Application using CData JDBC Oracle Eloqua Driver

• Edit and Search External Clio Objects in Salesforce Connect

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

• Use the CData ODBC Driver for Sage Intacct in SAS JMP

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

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

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

• Back Up PostgreSQL to SQL Server through SSIS

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

• Connect to Google Spanner from PowerBuilder

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

• Create SAP BusinessObjects BI-Connected Visualizations in Klipfolio

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

• Build Instagram-Connected Apps in Mendix

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

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

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

• Analyze Live SAP ByDesign in SAS Viya

  Use CData Connect Cloud to connect to SAP Business ByDesign from SAS Viya and deploy self-service analytics using live SAP Business ByDesign.

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

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

• Model, Search, and Visualize Live Confluence in ThoughtSpot

  Use CData Connect Cloud to connect to live Atlassian Confluence for modeling, searching, and visualizing.

• Use CData Connect Cloud to Access Zoho Projects in Microsoft Power Pivot

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

• How to Build Dynamic React Apps with Sybase

  Use the CData Connect and React to Build Dynamic Web Apps with Live Sybase .

• Connect to EnterpriseDB in the Denodo Platform

  Use CData driver technologies to create a virtual data source for EnterpriseDB in the Denodo Virtual DataPort Administrator.

• Connect to Oracle from AWS Glue

  Use CData Connect Cloud to gain access to live Oracle Database from your AWS Glue jobs.

• Replicate Stripe from PowerShell

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

• Connect to Avalara AvaTax in RazorSQL

  Connect to Avalara AvaTax from wizards and query Avalara AvaTax from the GUI in the RazorSQL database management tool.

• Work with Twilio in FoxPro

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

• Bridge Okta Connectivity with Apache NiFi

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

• Access Live SharePoint in Google Sheets

  Use CData Connect Cloud to gain access to live Microsoft SharePoint from your Google Sheets.

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

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

• Freshdesk Reporting and Star Schemas in OBIEE

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

• Connect to Microsoft OneDrive in JRuby

  Create a simple JRuby app with access to live Microsoft OneDrive.

• Query CockroachDB through ODBC in Node.js

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

• Publish Reports with Calendly in SAP Crystal Reports

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

• Automated Continuous Cosmos DB Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to SQL Server.

• Connect to Azure Synapse in Ruby

  Connect to Azure Synapse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Analyze Facebook in R

  Create data visualizations and use high-performance statistical functions to analyze Facebook in Microsoft R Open.

• Visualize Dynamics NAV in TIBCO Spotfire through ODBC

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

• Integrate Live SingleStore into Custom Business Apps Built in Power Apps

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

• Use Dash to Build to Web Apps on QuickBooks

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

• Access Live Zoho Books in AWS Lambda (with IntelliJ IDEA)

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

• Analyze Smartsheet in Looker

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

• Automate Basecamp Replication to SAP HANA

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

• ETL Oracle HCM Cloud in Oracle Data Integrator

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

• Build Dashboards with Neo4J in DBxtra

  Create dynamic dashboards and perform analytics based on Neo4J in DBxtra.

• Use the Connect Server to Access Basecamp in Microsoft Power Pivot

  Use the Connect Server to connect to live Basecamp in the Power Pivot business intelligence tool.

• Automated Continuous Airtable Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Airtable replication to MongoDB.

• Build Dashboards with Oracle Financials Cloud in Dundas BI

  Create dynamic dashboards and perform analytics based on Oracle Financials Cloud in Dundas BI.

• Access BambooHR from MySQL in PHP

  Connect to BambooHR through the standard MySQL libraries in PHP.

• Query GraphQL in ColdFusion

  Write standard ColdFusion data access code to connect to GraphQL.

• Use JayDeBeApi to access Cvent in Python

  Use standard Python scripting and the development environment of your choice to access live Cvent.

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

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

• Automated Continuous Paylocity Replication to Databricks

  Use CData Sync for automated, continuous, customizable Paylocity replication to Databricks.

• Build Dashboards with SAP ByDesign in DBxtra

  Create dynamic dashboards and perform analytics based on SAP Business ByDesign in DBxtra.

• How to work with Sage Intacct in Apache Spark using SQL

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

• Create Bullhorn CRM Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Bullhorn CRM to build custom dashboards in Bold BI.

• Create Stripe-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Stripe from Klipfolio and build custom visualizations using live Stripe.

• Extract, Transform, and Load Microsoft Teams in Informatica PowerCenter

  Create a simple Workflow for Microsoft Teams in Informatica PowerCenter.

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

  Connect to ActiveCampaign from a connection pool in Tomcat.

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

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

• Connect to SAP SuccessFactors in RunMyProcess through Connect Cloud

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

• How to import ServiceNow into Apache Solr

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

• Connect to SAP BusinessObjects BI in DBArtisan

  Use wizards in DBArtisan to configure SAP BusinessObjects BI as a data source.

• Extract, Transform, and Load Access in Informatica PowerCenter

  Create a simple Workflow for Microsoft Access in Informatica PowerCenter.

• Greenhouse Reporting and Star Schemas in OBIEE

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Directory

  Provide connectivity to Google Directory through an SAP BusinessObjects universe.

• Query ConstantContact as a MySQL Database in Node.js

  Execute MySQL queries against ConstantContact from Node.js.

• Establish a Live Connection with SingleStore using Tableau Bridge

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

• Use the CData Software JDBC Driver for Dropbox in MicroStrategy

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

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

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

• How to Work with Okta in ETL Validator JDBC

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

• Twitter Reporting and Star Schemas in OBIEE

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

• Build Dynamics 365-Connected Apps in Mendix

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

• Visualize Calendly in TIBCO Spotfire through ADO.NET

  Integrate Calendly into dashboards in TIBCO Spotfire.

• Visualize EnterpriseDB in TIBCO Spotfire through ODBC

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

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

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

• Export Data from SQL Server to Amazon Athena through SSIS

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

• Automate SAP HANA Replication to SAP HANA

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

• Connect to YouTube Analytics through External Services in Salesforce

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

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

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

• Access SingleStore from MySQL in HeidiSQL

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

• Automated Continuous Monday.com Replication to Oracle

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

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

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

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

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

• Access Redshift from MySQL in HeidiSQL

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

• Validate PostgreSQL with QuerySurge

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

• Bidirectional Access to SurveyMonkey from FileMaker Pro

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

• Connect to Hive as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Apache Hive.

• Use the CData ODBC Driver for Reckon in SAS JMP

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

• Build Amazon Marketplace-Connected Apps in Bubble

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

• Query, Visualize, and Share live NetSuite in Redash

  Use CData Connect Cloud to connect to live NetSuite CRM & ERP in Redash for querying, visualizing, and sharing.

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

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

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

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

• Connect to Jira Assets from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Jira Assets to connect to Jira Assets from Web applications running on WebLogic.

• Work with Dynamics NAV in FoxPro

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

• ETL Greenplum in Oracle Data Integrator

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

• Automate Epicor Kinetic Replication to SAP HANA

  Use CData Sync to customize and automate Epicor Kinetic replication to SAP HANA.

• Integrate Coinbase in the Pentaho Report Designer

  Publish reports based on Coinbase in the Pentaho BI tool.

• How to publish and share MarkLogic dashboards with Tableau Server

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

• Manage Salesloft in DBArtisan as a JDBC Source

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

• Automated Continuous SAP Ariba Source Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Google Cloud SQL.

• PowerShell Scripting to Replicate Amazon DynamoDB to MySQL

  Write a simple PowerShell script to replicate Amazon DynamoDB to a MySQL database.

• Automated Continuous Printful Replication to Apache Kafka

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

• «
• 251
• 252
• 253
• 254
• 255
• 256
• 257
• 258
• 259
• 260
• »