CData Software - Knowledge Base

Recent Articles

• «
• 175
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• »

• Validate Google Drive with QuerySurge

  Access and validate Google Drive in QuerySurge using the CData JDBC Driver.

• Build Semantic Layer Views for JSON Services in APOS Live Data Gateway

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

• Automated Continuous Azure Synapse Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Azure Synapse replication to Amazon S3.

• Build Hive Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Apache Hive and build visualizations in Tableau.

• Work with Live Act CRM in Power Query

  Use CData Connect Cloud to connect to Act CRM and work with live Act CRM in Microsoft Power Query.

• Visualize SQL Server 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 SQL Server into TIBCO Spotfire.

• Import Google Drive into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Google Drive. In this article, you will use the OData format to import Google Drive into Microsoft Power Query.

• Stream AlloyDB into Apache Kafka Topics

  Access and stream Google AlloyDB in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Bidirectional Access to JotForm from FileMaker Pro

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

• Connect to HubSpot in Google Apps Script

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

• Analyze Facebook Ads in Looker

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

• Build Charts with LinkedIn in Clear Analytics

  Create dynamic charts and perform analytics based on LinkedIn in Clear Analytics.

• How to Use a Microsoft Access Database to Update Cloudant in Real Time

  Update Cloudant data by creating a linked table in Microsoft Access with the CData Cloudant ODBC Driver.

• Replicate Google Campaign Manager 360 from PowerShell

  Write a quick PowerShell script to query Google Campaign Manager 360. Use connectivity to the live data to replicate Google Campaign Manager 360 to SQL Server.

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

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

• Build Visualizations of BigCommerce in Birst

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

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

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

• Automated Continuous Amazon DynamoDB Replication to Azure SQL

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

• Replicate Google Calendar to Multiple Databases

  Replicate Google Calendar to disparate databases with a single configuration.

• How to connect and process Shopify from Azure Databricks

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

• Establish a Live Connection with MYOB AccountRight using Tableau Bridge

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

• Design BIRT Reports on REST

  Provide current REST to your embedded analytics.

• Create Epicor Kinetic Dashboards in Bold BI

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

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

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

• Build Interactive Dashboards from Authorize.Net in Amazon QuickSight

  Create a virtual SQL Server database for Authorize.Net in CData Software Connect Server and import Authorize.Net into Amazon QuickSight SPICE to build interactive dashboards.

• Build Authorize.Net-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Authorize.Net and build web apps with connectivity to live Authorize.Net.

• Query IBM Informix in DataGrip

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

• Connect to Square in RazorSQL

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

• Viewing ServiceNow in RAD Studio Data Explorer

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

• Use the CData Software ODBC Driver for Azure Data Catalog in MicroStrategy

  Connect to Azure Data Catalog in MicroStrategy Developer using the CData Software ODBC Driver for Azure Data Catalog.

• Query GraphQL in MySQL Workbench

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

• Automated Continuous Twitter Ads Replication to MongoDB

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

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

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

• Connect to Teradata in SpagoBI

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

• Import Elasticsearch into FileMaker Pro

  Create reports that integrate Elasticsearch in Filemaker Pro.

• Build ActiveCampaign-Connected Apps in Bubble

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

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

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

• Visualize Klaviyo in TIBCO Spotfire through OData

  Integrate Klaviyo into dashboards in TIBCO Spotfire.

• A PostgreSQL Interface for Couchbase

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

• How to import Airtable into Apache Solr

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

• Connect to ADP from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live ADP from Filemaker Pro on Mac.

• DataBind Controls to Tally in Delphi

  DataBind to Tally ERP in Delphi with standard data access components and controls.

• Manage DocuSign in DBArtisan as a JDBC Source

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

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

• Build Interactive Dashboards from Sybase IQ in Amazon QuickSight

  Create a virtual SQL Server database for Sybase IQ in CData Software Connect Server and import Sybase IQ into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to and Query Google Spanner in QlikView over ODBC

  Create data visualizations with Google Spanner in QlikView.

• Natively Connect to SQL Analysis Services in PHP

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

• Connect to Oracle as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Oracle Database.

• Automated Continuous Zoho Inventory Replication to MongoDB

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

• Use the CData ODBC Driver for OData in SAS JMP

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

• How to connect Amazon QuickSight to Office 365

  Create a connection to Microsoft Office 365 in CData Connect Cloud and insert Microsoft Office 365 into Amazon QuickSight SPICE to build interactive dashboards.

• How to load Stripe data into Elasticsearch via Logstash

  Introducing a simple method to load Stripe data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Create Apps from Zoho Inventory in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Zoho Inventory and build apps from live Zoho Inventory in Qlik Sense Cloud.

• Access Live Zoho Books in AWS Lambda

  Connect to live Zoho Books in AWS Lambda using the CData JDBC Driver.

• Build Instagram-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Instagram and build web apps with connectivity to live Instagram.

• Prepare, Blend, and Analyze Zoho Projects in Alteryx Designer

  Build workflows to access live Zoho Projects for self-service data analytics.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to Phoenix from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Phoenix to connect to Apache Phoenix and execute queries in PowerBuilder.

• Model, Search, and Visualize Live SurveyMonkey in ThoughtSpot

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

• Automate Twitter Ads Replication to Azure Synapse

  Use CData Sync to customize and automate Twitter Ads replication to Azure Synapse.

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

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

• Visualize Live SAP Concur in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live SAP Concur into custom reports in Power BI.

• Connect to SAP Concur in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

  Create an ODBC connection to Amazon Marketplace in Informatica and browse and transfer Amazon Marketplace.

• Build Redis-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Redis and build web apps with connectivity to live Redis.

• Create Data Visualizations in Cognos BI with Klaviyo

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

• How to connect to LinkedIn Ads in DBVisualizer

  Integrate LinkedIn Ads with visual data analysis tools and data connection wizards in DBVisualizer

• Build Dashboards with Tally in DBxtra

  Create dynamic dashboards and perform analytics based on Tally ERP in DBxtra.

• Connect to LinkedIn through External Services in Salesforce

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

• Connect to Impala in DBArtisan

  Use wizards in DBArtisan to configure Apache Impala as a data source.

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

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

• How to Build Dynamic React Apps with Redshift

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

• Validate Pipedrive with QuerySurge

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

• Build Charts with BigCommerce in Clear Analytics

  Create dynamic charts and perform analytics based on BigCommerce in Clear Analytics.

• Create Dynamic SAP SuccessFactors Grids Using the Infragistics XamDataGrid

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

• Create Amazon Marketplace Reports on JasperReports Server

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

• Oracle SCM Cloud Connectivity

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

• Integrate Teradata in the Pentaho Report Designer

  Publish reports based on Teradata in the Pentaho BI tool.

• Use Biml to Build SSIS Tasks to Replicate Google Search Results to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Search to SQL Server.

• Automated Continuous Procore Replication to Oracle

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

• Replicate Vertica to Multiple Databases

  Replicate Vertica to disparate databases with a point-and-click configuration.

• Integrate Spark in the Pentaho Report Designer

  Publish reports based on Apache Spark SQL in the Pentaho BI tool.

• Automated Continuous EnterpriseDB Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Amazon Redshift.

• Build Salesforce Pardot-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Salesforce Pardot and build web apps with connectivity to live Salesforce Pardot.

• Automate OneNote Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft OneNote replication to Couchbase.

• Integrate Azure Table with External Services using SnapLogic

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

• How to Visualize Google Cloud Storage Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Google Cloud Storage in Python.

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

  Use CData Power BI Connectors to visualize Highrise CRM in Power BI.

• Using AngularJS to Build Dynamic Web Pages with Hive

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

• Feed EventBrite into FineReport

  How to set Eventbrite as a JDBC data source in FineReport.

• Connect to Impala from AWS Glue

  Use CData Connect Cloud to gain access to live Apache Impala from your AWS Glue jobs.

• DataBind Charts to Email

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Email from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

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

  Provide connectivity to CSV/TSV Files through an SAP BusinessObjects universe.

• Connect to Phoenix in Ruby

  Connect to Apache Phoenix in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to Klaviyo in the Denodo Platform

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

• Replicate SAS xpt to Multiple Databases

  Replicate SAS XPORT to disparate databases with a point-and-click configuration.

• Access Unbounce as a Remote Oracle Database

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

• How to Work with Microsoft Exchange in ETL Validator JDBC

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

• Connect to Authorize.Net from PowerBuilder

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

• Replicate HubSpot for Use in Salesforce Connect

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

• «
• 175
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• »