CData Software - Knowledge Base

Recent Articles

• «
• 339
• 340
• 341
• 342
• 343
• 344
• 345
• 346
• 347
• 348
• »

• Use the CData Software ODBC Driver for Calendly in MicroStrategy Web

  Connect to Calendly in MicroStrategy Web using the CData Software ODBC Driver for Calendly.

• Use the CData Software ODBC Driver for SAP HANA XS Advanced in MicroStrategy

  Connect to SAP HANA XS Advanced in MicroStrategy Developer using the CData Software ODBC Driver for SAP HANA XS Advanced.

• Build Bullhorn CRM Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Bullhorn CRM and build visualizations in Tableau.

• Automated Continuous Adobe Analytics Replication to Google Cloud SQL

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

• Connect to Cassandra in SpagoBI

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

• Connect to PingOne from PowerBuilder via JDBC

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

• Stream Adobe Analytics into Apache Kafka Topics

  Access and stream Adobe Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Import and Visualize LinkedIn in Power View

  Create data visualizations based on LinkedIn in Excel.

• Automated Continuous SAP HANA Replication to Apache Cassandra

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

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

  Use CData Power BI Connectors to visualize Adobe Analytics in Power BI.

• Automated Continuous SAP Business One Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable SAP Business One replication to AlloyDB.

• Load PostgreSQL to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PostgreSQL to a database.

• Connect to Google Drive from PowerBuilder via ODBC

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

• Connect to Blackbaud FE NXT from a Connection Pool in JBoss

  Integrate Blackbaud FE NXT into Java servlets: Use the Management Console in JBoss to install the Blackbaud FE NXT JDBC Driver.

• Connect to SharePoint in Ruby

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

• Integrate Real-Time Access to Drift in SAPUI5 MVC Apps

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

• Integrate with HDFS using Apache Camel2

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

• Automated Continuous OneNote Replication to SQLite

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

• Automated Continuous Oracle HCM Cloud Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to SQL Server.

• Use the CData ODBC Driver for IBM Informix from SharePoint Excel Services

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

• Import Real-Time MarkLogic via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use MarkLogic in ColdFusion.

• How to work with Pinterest in Apache Spark using SQL

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

• Query Email through ODBC in Node.js

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

• How to Query Clio in MySQL Workbench

  Execute MySQL queries against live Clio from MySQL Workbench.

• How to create AlloyDB federated tables in MySQL

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

• Build Azure Active Directory-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Active Directory.

• Automated Continuous QuickBooks Replication to Vertica

  Use CData Sync for automated, continuous, customizable QuickBooks replication to Vertica.

• How to connect Amazon QuickSight to SharePoint

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

• DataBind Controls to Bing Search Results in Delphi

  DataBind to Bing Search in Delphi with standard data access components and controls.

• Automated Continuous CockroachDB Replication to SingleStore

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

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

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

• How to use SQLAlchemy ORM to access Oracle in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Database.

• How to Connect DBeaver to HubSpot via a JDBC Driver

  Manage HubSpot with visual tools in DBeaver like the query browser.

• Automated Continuous Dynamics 365 Replication to Google Cloud SQL

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

• Working with Salesforce Data Cloud in LINQPad

  Execute LINQ queries to Salesforce Data Cloud in LINQPad.

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

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

• Connect to Live Google Calendar in MicroStrategy through CData Connect Cloud

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

• Integrate Kintone in Your Informatica Cloud Instance

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

• Integrate Real-Time Access to Slack in SAPUI5 MVC Apps

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

• Automated Continuous Asana Replication to SQLite

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

• Manage SuiteCRM in DBArtisan as a JDBC Source

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

• Visualize Sugar CRM in TIBCO Spotfire through ADO.NET

  Integrate Sugar CRM into dashboards in TIBCO Spotfire.

• Access ConstantContact in PHP through Connect Server

  Connect to ConstantContact through the standard SQL Server libraries in PHP.

• Query, Visualize, and Share live Impala in Redash

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

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

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

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

  Provide connectivity to Oracle Eloqua through an SAP BusinessObjects universe.

• Visualize Teradata in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Teradata in CData Software Connect (or Connect Server) and build visualizations from live Teradata in Tableau Desktop.

• Create Redis-Connected Visualizations in Klipfolio

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

• Create Datasets from SAP Hybris C4C in Domo Workbench and Build Visualizations of SAP Hybris C4C in Domo

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

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

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

• Access Live Greenplum in Google Sheets through Connect Spreadsheets

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

• Create Data Visualizations in Cognos BI with MailChimp

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

• How to create MailChimp federated tables in MySQL

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

• Query Azure DevOps in DataGrip

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

• Query, Visualize, and Share live Amazon S3 in Redash

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

• Query SAP Ariba Source through ODBC in Node.js

  Use node-odbc to execute SQL queries against SAP Ariba Source from Node.js.

• Connect to Square from Blazor Apps

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

• Automated Microsoft Teams Replication to Teradata

  Use CData Sync to Customize and automate Microsoft Teams replication to Teradata.

• Explore Geographical Relationships in DB2 with Power Map

  Create data visualizations with IBM DB2 in Power Map.

• Build Automated Outreach.io-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Outreach.io and build automated workflows in Zapier.

• Design BIRT Reports on Bing Search Results

  Provide current Bing Search to your embedded analytics.

• Automate Azure Data Lake Storage Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Azure Data Lake Storage from PowerShell? This article demonstrates how to utilize the Azure Data Lake Storage Cmdlets for tasks like connecting to Azure Data Lake Storage, automating operations, downloading data, and more.

• Integrate Microsoft Teams with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Microsoft Teams with External Services.

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

  Create a live connection to Spark in CData Connect Cloud and connect to your Apache Spark SQL from PostgreSQL.

• Replicate Act CRM to Multiple Databases

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

• Import Basecamp into Microsoft Power Query

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

• Use JayDeBeApi to access DB2 in Python

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

• Automated Continuous SAP Replication to Local Delimited Files

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

• How to Build Dynamic React Apps with eBay Analytics

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

• How to connect to BambooHR from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for BambooHR and work with BambooHR in Microsoft Excel on Mac OS X.

• Query SAP SuccessFactors in DataGrip

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

• Analyze ShipStation in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of ShipStation and visualize live ShipStation in Infragistics Reveal.

• Use the CData SSIS Components to Insert New or Update Existing Reckon Accounts Hosted Records from SQL Server

  Easily push SQL Server data to Reckon Accounts Hosted using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Reckon Accounts Hosted or update existing records with data from a SQL Server database.

• Jira Service Management Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Jira Service Management facts in real time.

• Access Live Yahoo! Japan Data Solution in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Yahoo! Japan Data Solution from your Excel spreadsheets.

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

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

• Build Trello Visualizations in Tableau Cloud

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

• Design BIRT Reports on JSON Services

  Provide current JSON to your embedded analytics.

• How to load Active Directory data into Elasticsearch via Logstash

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

• Integrate with live Oracle in Jitterbit

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

• Create BigQuery Dataflows on PowerBI.com

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

• Publish Klaviyo-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Klaviyo.

• Use the CData Software JDBC Driver for WooCommerce in MicroStrategy Desktop

  Connect to WooCommerce in MicroStrategy Desktop using the CData Software JDBC Driver for WooCommerce.

• Design BIRT Reports on Smartsheet

  Provide current Smartsheet to your embedded analytics.

• Automated Continuous Reckon Accounts Hosted Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQL Server.

• Operational Reporting on Google Search Results from Spotfire Server

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

• How to Connect to & Open Salesforce Pardot in Microsoft Excel

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

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

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

• Automated Continuous Couchbase Replication to IBM DB2

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

• How to connect to Couchbase in DBVisualizer

  Integrate Couchbase with visual data analysis tools and data connection wizards in DBVisualizer

• Access Live Presto in TIBCO Data Virtualization

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

• Automated Continuous Adobe Commerce Replication to Apache Kafka

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

• Create Reports from LinkedIn Ads in Looker Studio

  Use CData Connect Cloud to gain access to live LinkedIn Ads and create custom reports in Looker Studio.

• How to Build Dynamic React Apps with Elasticsearch

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

• Connect to SharePoint from a Connection Pool in Jetty

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

• How to Connect the Power BI Service to Jira Service Management: Complete Guide

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

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

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

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

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

• Use the CData Software ODBC Driver for SAP Concur in MicroStrategy

  Connect to SAP Concur in MicroStrategy Developer using the CData Software ODBC Driver for SAP Concur.

• Access Bullhorn CRM as a Remote Oracle Database

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

• «
• 339
• 340
• 341
• 342
• 343
• 344
• 345
• 346
• 347
• 348
• »