CData Software - Knowledge Base

Recent Articles

• «
• 135
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• 143
• 144
• »

• Access Live Epicor Kinetic in Google Sheets

  Use CData Connect Cloud to gain access to live Epicor Kinetic from your Google Sheets.

• How to connect PolyBase to SAS Data Sets

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

• Access MarkLogic from MySQL in HeidiSQL

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

• Connect to Live SAP HANA in PostGresSQL Interface through CData Connect Cloud

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

• Establish a Live Connection with SAP HANA using Tableau Bridge

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

• Connect to Greenhouse in HULFT Integrate

  Connect to Greenhouse as a JDBC data source in HULFT Integrate

• Operational Reporting on Marketo from Spotfire Server

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

• Connect to Amazon S3 in as an External Source in Dremio

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

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

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

• Automate Outreach.io Replication to SAP HANA

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

• Visualize BigQuery in TIBCO Spotfire through ADO.NET

  Integrate Google BigQuery into dashboards in TIBCO Spotfire.

• Stream eBay Analytics into Apache Kafka Topics

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

• Access Live QuickBooks Online in Coginiti Pro

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

• How to create Visio diagrams from CockroachDB

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

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

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

• Query, Visualize, and Share live Sage Cloud Accounting in Redash

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

• Access Live Freshdesk in AWS Lambda (with IntelliJ IDEA)

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

• Import Real-Time Redshift in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Amazon Redshift in ColdFusion.

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

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

• Automated Continuous Avalara AvaTax Replication to MongoDB

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

• Automated Continuous IBM Cloud Data Engine Replication to MySQL

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to MySQL.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Import and Visualize Google Ad Manager in Power View

  Create data visualizations based on Google Ad Manager in Excel.

• Publish Veeva-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Veeva Vault.

• Access Phoenix 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 Apache Phoenix.

• Automated Continuous Aha Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Aha replication to Google BigQuery.

• Replicate Multiple CouchDB Accounts

  Replicate multiple CouchDB accounts to one or many databases.

• Automate Sage 200 Integration Tasks from PowerShell

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

• Access eBay Analytics from MySQL in PHP

  Connect to eBay Analytics through the standard MySQL libraries in PHP.

• Automate Instagram Replication to Couchbase

  Use CData Sync to Customize and automate Instagram replication to Couchbase.

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

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for IBM Cloud Object Storage

  Provide connectivity to IBM Cloud Object Storage through an SAP BusinessObjects universe.

• How to integrate Metabase with Blackbaud FE NXT

  Use CData Connect Cloud to connect to live Blackbaud FE NXT and create an interactive dashboard in Metabase from Blackbaud FE NXT.

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

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

• Natively Connect to Bing Search Results in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Bing Search. Leverage the native support for ODBC in PHP.

• Natively Connect to Shippo in PHP

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

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

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

• Automated Continuous Wave Financial Replication to SQLite

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

• Access Live Azure Active Directory in AWS Lambda

  Connect to live Azure Active Directory in AWS Lambda using the CData JDBC Driver.

• How to use SQLAlchemy ORM to access Dynamics GP in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Dynamics GP.

• Import Salesloft into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Salesloft and create custom reports in the Power BI Service.

• Connect to Google Directory from Asprova with CData Software ODBC Driver for Google Directory

  This article shows how to connect faster to Google Directory data from Asprova.

• DataBind Controls to Pipedrive in C++Builder

  DataBind to Pipedrive in C++Builder with standard components and controls.

• Visualize Salesforce Pardot in TIBCO Spotfire through OData

  Integrate Salesforce Pardot into dashboards in TIBCO Spotfire.

• Analyze Live DocuSign in SAS Viya

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

• Create Reports with Salesforce in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Salesforce & Force.com.

• Replicate HCL Domino from PowerShell

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

• Analyze SAP Netweaver Gateway in R

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

• Create Dynamic Redis Grids Using the Infragistics XamDataGrid

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

• Connect to Slack in RapidMiner

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

• Natively Connect to Trello in PHP

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

• Use the CData ODBC Driver for HBase in SAS JMP

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

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

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

• Automated Continuous Confluence Replication to Local Delimited Files

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

• Access Zendesk from MySQL in HeidiSQL

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

• Install a Microsoft Excel Add-In Manually

  Some Microsoft Excel users may need to follow these steps to manually add the CData Excel Add-In formulas, enabling you to execute your own database queries.

• How to create an RPA flow for Azure Data Lake Storage in UiPath Studio

  Use the Azure Data Lake Storage ODBC Driver to create workflows that access real-time Azure Data Lake Storage without any coding.

• Connect to Blackbaud FE NXT from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Blackbaud FE NXT from Crystal Reports.

• Automate ConstantContact Replication to SAP HANA

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

• Analyze Monday.com in R

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

• Access Live Jira Service Management in AWS Lambda (with IntelliJ IDEA)

  Connect to live Atlassian Jira Service Management in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Explore Geographical Relationships in Printify with Power Map

  Create data visualizations with Printify in Power Map.

• Connect to Oracle Financials Cloud from a Connection Pool in Jetty

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

• Build Asana-Connected Apps in Bubble

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

• Automated Continuous Clio Replication to SQLite

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

• Replicate SendGrid for Use in Salesforce Connect

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

• Replicate SendGrid to Multiple Databases

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

• Replicate MailChimp to Multiple Databases

  Replicate MailChimp to disparate databases with a single configuration.

• How to Access Zoho Books Using Entity Framework

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

• How to Work with Freshdesk in ETL Validator JDBC

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

• Connect to Google Drive in JRuby

  Create a simple JRuby app with access to live Google Drive.

• Replicate Sage Intacct to Multiple Databases

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

• Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy

  Connect to Amazon Marketplace in MicroStrategy Developer using the CData Software ODBC Driver for Amazon Marketplace.

• Connect to Klipfolio from PowerBuilder

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

• Create a Data Access Object for Sugar CRM using JDBI

  A brief overview of creating a SQL Object API for Sugar CRM in JDBI.

• Prepare, Blend, and Analyze Unbounce in Alteryx Designer

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

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

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

• Import Printify into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Printify and create custom reports in the Power BI Service.

• Access Paylocity in PHP through Connect Server

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

• How to Connect DBeaver to Asana via a JDBC Driver

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

• How to connect to AlloyDB from IntelliJ

  Integrate connectivity to Google AlloyDB with wizards in IntelliJ.

• Use the CData ODBC Driver for Shippo in SAS JMP

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

• Connect to Phoenix in Jaspersoft Studio

  Execute SQL to remote Apache Phoenix in Jaspersoft Studio.

• How to import QuickBooks Online into Apache Solr

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

• Import Real-Time SAS Data Sets in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use SAS Data Sets in ColdFusion.

• Build SAP SuccessFactors-Connected Apps in Bubble

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

• Connect to Zuora in DBeaver

  Use the CData ODBC Driver to connect to Zuora in DBeaver.

• Replicate SingleStore for Use in Salesforce Connect

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

• Analyze Okta in R

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

• Creating Monday.com-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Monday.com to Unqork and build custom business apps.

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

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

• Replicate SurveyMonkey for Use in Salesforce Connect

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

• Connect to Cassandra in RazorSQL

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

• Build Automated NetSuite-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live NetSuite CRM & ERP and build automated workflows in Zapier.

• Publish Crystal Reports on JotForm

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date JotForm.

• DataBind Controls to Zuora in C++Builder

  DataBind to Zuora in C++Builder with standard components and controls.

• Automated Continuous Couchbase Replication to Local Delimited Files

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

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

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

• Visualize Basecamp in Tableau Desktop (through CData Connect)

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

• Connect to Facebook from a Connection Pool in Jetty

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

• «
• 135
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• 143
• 144
• »