CData Software - Knowledge Base

Recent Articles

• «
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• 156
• »

• Access Zoho Creator from MySQL in Amazon QuickSight

  Connect to Zoho Creator and build visualizations of Zoho Creator using a MySQL Connection in Amazon QuickSight.

• Work with SingleStore in FoxPro

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

• Import Stripe into FileMaker Pro

  Create reports that integrate Stripe in Filemaker Pro.

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

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

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

  Connect to NetSuite CRM & ERP in MicroStrategy Web using the CData Software ODBC Driver for NetSuite.

• Automated Continuous Pipedrive Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Pipedrive replication to Microsoft Access.

• Integrate with IBM Cloud Object Storage in JReport Designer

  Create charts and reports based on IBM Cloud Object Storage in JReport Designer.

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

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

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

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

• Query Klipfolio as a SQL Server in Node.js

  Execute SQL Server queries against Klipfolio from Node.js.

• Connect to Salesloft in Jaspersoft Studio

  Execute SQL to remote Salesloft in Jaspersoft Studio.

• How to import Quickbase into Apache Solr

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

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

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

• Explore Geographical Relationships in Microsoft Planner with Power Map

  Create data visualizations with Microsoft Planner in Power Map.

• Connect to Klaviyo from PowerBuilder via ADO.NET

  This article demonstrates how to access Klaviyo from Appeon PowerBuilder using the CData ADO.NET Provider for Klaviyo.

• Create Dashboards and Visualize Live Azure Synapse in Geckoboard

  Use CData Connect Cloud to connect to live Azure Synapse and create dashboards for real-time monitoring and visualization in Geckoboard.

• Build Semantic Layer Views for Oracle HCM Cloud in APOS Live Data Gateway

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

• Create Data Visualizations in Cognos BI with DocuSign

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

• Integrate with Snapchat Ads using Apache Camel2

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

• Analyze SAP ByDesign in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of SAP Business ByDesign and visualize SAP Business ByDesign in SAP Analytics Cloud.

• Visualize Google Campaign Manager 360 in TIBCO Spotfire through ODBC

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

• Integrate with DB2 using Apache Camel2

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

• PowerShell Scripting to Replicate Couchbase to MySQL

  Write a simple PowerShell script to replicate Couchbase to a MySQL database.

• How to publish and share Cassandra dashboards with Tableau Server

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

• Access Live Salesforce Data Cloud in AWS Lambda (with IntelliJ IDEA)

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

• Visualize Zoho CRM in Tableau

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

• Natively Connect to Slack in PHP

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

• Automated Continuous Amazon DynamoDB Replication to MySQL

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

• Perform Batch Operations with Twitter in Apache NiFi

  Connect to Twitter and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

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

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

• Query OData Services in MySQL Workbench

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

• Visualize SAP Business One in TIBCO Spotfire through OData

  Integrate SAP Business One into dashboards in TIBCO Spotfire.

• Connect to Facebook from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Facebook, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy

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

• Create Data Visualizations in Cognos BI with HubDB

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

• Query Oracle Financials Cloud in DataGrip

  Create a Data Source for Oracle Financials Cloud in DataGrip and use SQL to query live Oracle Financials Cloud.

• How to publish and share Cvent dashboards with Tableau Server

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

• Query Dynamics CRM in MySQL Workbench

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

• Enable the Todoist JDBC Driver in KNIME

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

• Bidirectional Access to Stripe from FileMaker Pro

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

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

  Use CData JDBC drivers to import and use Microsoft Planner in ColdFusion.

• Using AngularJS to Build Dynamic Web Pages with Act CRM

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

• Analyze Live Amazon S3 in SAS Viya

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

• Automated Continuous Klaviyo Replication to SQLite

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle HCM Cloud

  Provide connectivity to Oracle HCM Cloud through an SAP BusinessObjects universe.

• Build Asana-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Asana and build Asana-connected web apps with Axios.

• How to Connect to & Open Dynamics 365 Business Central in Microsoft Excel

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

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

  Use CData Power BI Connectors to visualize MYOB AccountRight in Power BI.

• Connect to Avalara AvaTax in CloverDX (formerly CloverETL)

  Transfer Avalara AvaTax using the visual workflow in the CloverDX data integration tool.

• Enable the Redis JDBC Driver in KNIME

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

• Import SAS xpt into FileMaker Pro

  Create reports that integrate SAS XPORT in Filemaker Pro.

• Analyze Stripe in Looker

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

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

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

• Integrate BigQuery in Your Informatica Cloud Instance

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

• How to create Visio diagrams from SAP Ariba Source

  Automatically update SAP Ariba Source with the changes you make to Visio master shapes.

• Replicate Multiple Klaviyo Accounts via the CData Sync CLI

  Replicate multiple Klaviyo accounts to one or many databases.

• Integrate with live Monday.com in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Monday.com in Jitterbit.

• Import Sage 50 UK into Microsoft Power Query

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

• Connect to Raisers Edge NXT in DBeaver

  Use the CData ODBC Driver to connect to Raisers Edge NXT in DBeaver.

• Visualize SAS Data Sets in Tableau

  The CData ODBC driver for SAS Data Sets enables you integrate SAS Data Sets into Tableau dashboards.

• How to Connect DBeaver to Harvest via a JDBC Driver

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

• Automate Azure Data Catalog Replication to Azure Synapse

  Use CData Sync to customize and automate Azure Data Catalog replication to Azure Synapse.

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

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

• Publish SAS xpt-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAS XPORT.

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

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

• Edit and Search External Amazon Athena Objects in Salesforce Connect

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

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

  Connect to Google Directory from a connection pool in Tomcat.

• How to Query Live SAP Ariba Source Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live SAP Ariba Source data in natural language using Python.

• Create Data Visualizations Based On SAP Ariba Procurement in Mode

  Use CData Connect Cloud to connect to SAP Ariba Procurement from Mode and build visualizations using live

• How to Connect to & Open SAP Fieldglass in Microsoft Excel

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

• Build ServiceNow-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to ServiceNow from Zoho Analytics and import live ServiceNow.

• Connect to DocuSign 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 DocuSign.

• Manage Workday in DBArtisan as a JDBC Source

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

• How to Work with Exact Online in ETL Validator JDBC

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

• Integrate with SAP ByDesign in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live SAP Business ByDesign in SnapLogic.

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

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

• Query QuickBooks Online in ColdFusion

  Write standard ColdFusion data access code to connect to QuickBooks Online.

• Automated Continuous Confluence Replication to Databricks

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

• Connect to Exact Online in DBArtisan

  Use wizards in DBArtisan to configure Exact Online as a data source.

• Natively Connect to Gmail in PHP via ODBC (Linux)

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

• Explore Geographical Relationships in Google Campaign Manager 360 with Power Map

  Create data visualizations with Google Campaign Manager 360 in Power Map.

• JSON Drivers: Parsing Hierarchical Data

  Configure our JSON drivers to parse the entirety of a JSON data set as a single table or as separate, relational tables.

• Automated Continuous Dynamics 365 Replication to IBM DB2

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

• Query WordPress through ODBC in Node.js

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

• Create SSAS Tabular Models from Zoho Creator

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

• Integrate with Square in JReport Designer

  Create charts and reports based on Square in JReport Designer.

• A PostgreSQL Interface for Zoho Inventory (MySQL Remoting via JDBC)

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

• Connect to Paylocity in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• A PostgreSQL Interface for Greenplum using the CData ODBC Driver

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

• Automated Continuous WooCommerce Replication to Apache Kafka

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

• How to load SuiteCRM data into Elasticsearch via Logstash

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

• How to load PayPal data into Elasticsearch via Logstash

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

• Analyze SharePoint in Looker

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

• Visualize Zoho Inventory in TIBCO Spotfire through ADO.NET

  Integrate Zoho Inventory into dashboards in TIBCO Spotfire.

• Feed PayPal into FineReport

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

• Automated Continuous SharePoint Excel Services Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Azure SQL.

• Using the CData Software ODBC Driver for eBay in PyCharm

  Connect to eBay as an ODBC data source in PyCharm using the CData Software ODBC Driver for eBay.

• Integrating Oracle Service Cloud in Talend Cloud Data Management Platform

• «
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• 156
• »