CData Software - Knowledge Base

Recent Articles

• «
• 301
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• »

• ETL Zoho Creator in Oracle Data Integrator

  This article shows how to transfer Zoho Creator into a data warehouse using Oracle Data Integrator.

• Build SQL Analysis Services-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SQL Analysis Services and build web apps with connectivity to live SQL Analysis Services.

• Automated Continuous DocuSign Replication to Apache Cassandra

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

• Teradata Reporting in OBIEE with the Teradata JDBC Driver

  Deploy the Teradata JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to Dynamics CRM as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Microsoft Dynamics CRM.

• Connect to Live Zendesk in MicroStrategy through CData Connect Cloud

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

• Operational Reporting on QuickBooks Online from Spotfire Server

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

• Natively Connect to Bing Search Results in PHP

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

• Connect to Twilio from a Connection Pool in WebLogic

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

• Access Cloudant from MySQL in HeidiSQL

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

• Create Informatica Mappings From/To a JDBC Data Source for Sage 50 UK

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

• Import Exact Online into FileMaker Pro

  Create reports that integrate Exact Online in Filemaker Pro.

• Build MVC Applications with Connectivity to Airtable

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Airtable from an ASP.NET MVC application.

• Connect to SAS Data Sets in Jaspersoft Studio

  Execute SQL to remote SAS Data Sets in Jaspersoft Studio.

• Access Zoom in PHP through Connect Server

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

• DataBind Charts to Jira Service Management

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Atlassian Jira Service Management 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 Informatica Mappings From/To an ODBC Data Source for ConstantContact

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

• Query Zoho Projects as a MySQL Database in Node.js

  Execute MySQL queries against Zoho Projects from Node.js.

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

• Extract, Transform, and Load SharePoint in Informatica PowerCenter

  Create a simple Workflow for Microsoft SharePoint in Informatica PowerCenter.

• Use CData Connect Cloud to Access Azure Data Lake Storage in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Azure Data Lake Storage in the Power Pivot business intelligence tool.

• Working with Snowflake in LINQPad

  Execute LINQ queries to Snowflake in LINQPad.

• Publish Reports with Amazon S3 in SAP Crystal Reports

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

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

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

• Drip Reporting in OBIEE with the Drip JDBC Driver

  Deploy the Drip JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to Salesforce Pardot from PowerBuilder

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

• How to Connect to Azure Active Directory in Using Python: 6 Steps

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

• Access Live Azure Synapse in TIBCO Data Virtualization

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

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

  Use CData Power BI Connectors to visualize SingleStore in Power BI.

• A PostgreSQL Interface for Kafka

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

• Replicate Google Ads to Multiple Databases

  Replicate Google Ads to disparate databases with a single configuration.

• Analyze Live Cloudant in SAS Viya

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

• Connect to Salesforce from PowerBuilder

  This article demonstrates how to access Salesforce & Force.com from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce.

• Analyze Google Ads in Looker

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

• Connect to Elasticsearch from Asprova with CData Software ODBC Driver for Elasticsearch

  This article shows how to connect faster to Elasticsearch data from Asprova.

• Visualize Oracle Sales in Sisense

  Create an ElastiCube in Sisense app with access to Oracle Sales.

• View Reports on Real-Time Power BI XMLA in Power BI Report Server

  Use the CData ODBC Driver for Power BI XMLA to visualize Power BI XMLA in Power BI Desktop and then publish them to Power BI Report Server.

• Bridge JSON Connectivity with Apache NiFi

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

• Prepare, Blend, and Analyze SAP ByDesign in Alteryx Designer

  Build workflows to access live SAP Business ByDesign for self-service data analytics.

• Replicate Aha to Multiple Databases

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

• Automate eBay Analytics Replication to Azure Data Lake

  Use CData Sync to customize and automate eBay Analytics replication to Azure Data Lake.

• Model SendGrid Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and SendGrid, enabling the direct import of real-time SendGrid.

• Connect to ADP in CloverDX (formerly CloverETL)

  Transfer ADP using the visual workflow in the CloverDX data integration tool.

• Create Printify-Connected Visualizations in Klipfolio

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

• How to Work with Facebook in ETL Validator JDBC

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

• Build Google Sheets-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Google Sheets from Choreo and build custom apps using live Google Sheets.

• Visualize Shippo in TIBCO Spotfire through ADO.NET

  Integrate Shippo into dashboards in TIBCO Spotfire.

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

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

• Connect to Amazon Marketplace in DBeaver

  Use the CData ODBC Driver to connect to Amazon Marketplace in DBeaver.

• Access Live Monday.com in TIBCO Data Virtualization

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

• Connect to Greenhouse from PowerBuilder

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

• How to connect to MYOB AccountRight in DBVisualizer

  Integrate MYOB AccountRight with visual data analysis tools and data connection wizards in DBVisualizer

• Google Sheets Reporting in OBIEE with the Google Sheets JDBC Driver

  Deploy the Google Sheets JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

  Create ETL applications and real-time data pipelines for Microsoft Dynamics 365 in Python with petl.

• Use Biml to Build SSIS Tasks to Replicate CockroachDB to SQL Server

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

• Natively Connect to Pipedrive in PHP

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

• Integrate with SAP BusinessObjects BI in JReport Designer

  Create charts and reports based on SAP BusinessObjects BI in JReport Designer.

• Automated Continuous Asana Replication to MongoDB

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

• Automated Continuous Excel Online Replication to Databricks

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

• Model Azure Analysis Services Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Azure Analysis Services, enabling the direct import of real-time Azure Analysis Services.

• Access QuickBooks Time 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 QuickBooks Time.

• Automated Continuous Trello Replication to MySQL

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

• How to connect to Zoho Projects with Squirrel SQL client

  Connect to Zoho Projects and execute queries in the Squirrel SQL Client.

• PowerShell Scripting to Replicate Sybase to MySQL

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

• Connect to Box in Aqua Data Studio

  Access Box from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Bidirectional Access to Snowflake from FileMaker Pro

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

• Use Dash to Build to Web Apps on IBM Cloud Object Storage

  Create Python applications that use pandas and Dash to build IBM Cloud Object Storage-connected web apps.

• Create Impala-Connected Business Apps in AppSheet

  Connect to Impala via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Apache Impala.

• Natively Connect to Zoho Inventory in PHP

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

• Visualize Live Zenefits in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Zenefits.

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

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

• Prepare, Blend, and Analyze Dynamics 365 Business Central in Alteryx Designer

  Build workflows to access live Dynamics 365 Business Central for self-service data analytics.

• Integrate Real-Time Access to IBM Informix in SAPUI5 MVC Apps

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

• Connect to and Visualize Live WordPress in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live WordPress.

• Access Live Shopify in Coginiti Pro

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

• Connect to SAP BusinessObjects BI from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for SAP BusinessObjects BI to connect to SAP BusinessObjects BI and execute queries in PowerBuilder.

• Automated Continuous SharePoint Excel Services Replication to Local Delimited Files

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

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

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

• Edit and Search External Calendly Objects in Salesforce Connect

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

• Access SuiteCRM from MySQL in HeidiSQL

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

• Operational Reporting on Reckon Accounts Hosted from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Reckon Accounts Hosted.

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

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

• Create SSAS Tabular Models from Zendesk

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

• Replicate Multiple Hive Accounts

  Replicate multiple Hive accounts to one or many databases.

• Automated Continuous GitHub Replication to Snowflake

  Use CData Sync for automated, continuous, customizable GitHub replication to Snowflake.

• Validate JDBC-ODBC Bridge with QuerySurge

  Access and validate JDBC-ODBC Bridge in QuerySurge using the CData JDBC Driver.

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

  Use CData Power BI Connectors to visualize Microsoft Teams in Power BI.

• How to load Presto data into Elasticsearch via Logstash

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

• DataBind Wijmo Grid to Wave Financial

  Provide real-time Wave Financial to interactive controls.

• Visualize SAP Fieldglass in TIBCO Spotfire through ODBC

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

• Create Jira-Connected Visualizations in Klipfolio

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

• LINQ to Adobe Analytics

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Adobe Analytics Data Provider.

• Import Real-Time Dynamics GP in ColdFusion to Build Applications

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

• Build PayPal-Connected Apps in Mendix

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

• Connect to Confluence in Google Apps Script

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

• Visualize Live Google Search Results in Power BI (via CData Connect Cloud)

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

• Connect to Sybase IQ from PowerBuilder

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

• Access Live MYOB AccountRight in TIBCO Data Virtualization

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

• Connect to Monday.com in SpagoBI

  Create reports featuring live Monday.com in SpagoBI Studio. Host Monday.com reports on SpagoBI Server.

• Google Contacts Reporting and Star Schemas in OBIEE

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

• «
• 301
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• »