CData Software - Knowledge Base

Recent Articles

• «
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• »

• Automated Continuous Amazon Athena Replication to Apache Cassandra

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

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

  Provide connectivity to Oracle Database through an SAP BusinessObjects universe.

• Create Reports from MySQL in Looker Studio

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

• Create Zoho CRM-Connected Visualizations in Klipfolio

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

• Use Dash to Build to Web Apps on Pipedrive

  Create Python applications that use pandas and Dash to build Pipedrive-connected web apps.

• Replicate Zoho Creator for Use in Salesforce Connect

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

• Visualize Live Snapchat Ads in the Power BI Service

  Use CData Connect Cloud to connect to live Snapchat Ads and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to Create Power BI Visual Reports with Real-Time Dynamics 365 Business Central

  Use CData Power BI Connectors to visualize Dynamics 365 Business Central in Power BI.

• Validate xBase with QuerySurge

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

• How to Build Dynamic React Apps with MariaDB

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

• Publish Reports with Jira Service Management in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Atlassian Jira Service Management.

• Connect to SAP ByDesign through External Services in Salesforce

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

• Using CData JDBC Drivers from IntelliJ IDEA

  CData JDBC Drivers make it easy for Java developers to work with a variety of data sources. In this article we show how to use any CData JDBC Driver to create a JDBC data source in the IntelliJ Java IDE. You will then use the JDBC data source to execute queries in the Table Editor.

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

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

• Analyze Azure Analysis Services in R

  Create data visualizations and use high-performance statistical functions to analyze Azure Analysis Services in Microsoft R Open.

• Author and Share Power BI Reports on Real-Time HarperDB

  Use the CData ODBC Driver for HarperDB to visualize HarperDB in Power BI Desktop and then upload to the Power BI service.

• Working with Google Ad Manager in LINQPad

  Execute LINQ queries to Google Ad Manager in LINQPad.

• Extract, Transform, and Load Shippo in Informatica PowerCenter

  Create a simple Workflow for Shippo in Informatica PowerCenter.

• Operational Reporting on Microsoft Exchange from Spotfire Server

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

• Automated Continuous Sage Cloud Accounting Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MongoDB.

• Access Oracle Sales from MySQL in PHP

  Connect to Oracle Sales through the standard MySQL libraries in PHP.

• Integrate Real-Time Access to Google Ads in SAPUI5 MVC Apps

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

• Integrate Snapchat Ads in Your Informatica Cloud Instance

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

• ETL Google Campaign Manager 360 in Oracle Data Integrator

  This article shows how to transfer Google Campaign Manager 360 into a data warehouse using Oracle Data Integrator.

• Connect to Printify in Aqua Data Studio

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

• Query, Visualize, and Share live GitHub in Redash

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

• Automated Continuous Google Campaign Manager 360 Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Apache Cassandra.

• Prepare, Blend, and Analyze Facebook Ads in Alteryx Designer

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

• Deploy the ADO.NET Provider for Google Ads on an SSRS Report Server

  Connect to Google Ads from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Add SQL Server to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for SQL Server with the Informatica Enterprise Data Catalog to classify and organize data.

• Connect to Microsoft Exchange in Aqua Data Studio

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

• Access Trello from MySQL in PHP

  Connect to Trello through the standard MySQL libraries in PHP.

• How to pipe MailChimp to CSV in PowerShell

  Use standard PowerShell cmdlets to access MailChimp tables.

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

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

• Connect to Google Analytics in Aqua Data Studio

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

• Build Apps with Live WooCommerce in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live WooCommerce into the Adalo platform and build custom mobile and web applications with real-time WooCommerce.

• Create Data Visualizations Based On Acumatica in Mode

  Use CData Connect Cloud to connect to Acumatica from Mode and build visualizations using live

• Analyze Hive in Infragistics Reveal

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

• How to connect to FHIR from Spring Boot

  Connect to FHIR in a Spring Boot Application using CData JDBC FHIR Driver

• Automated Continuous Microsoft Dataverse Replication to Local Delimited Files

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

• Integrate Live QuickBooks Online into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to QuickBooks Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live QuickBooks Online.

• Connect to Couchbase in NetBeans

  Connect to Couchbase in NetBeans with the data source configuration wizard.

• Build Charts with PayPal in Clear Analytics

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

• Connect to and Visualize Live Oracle in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Database.

• Visualize Trello in TIBCO Spotfire through ADO.NET

  Integrate Trello into dashboards in TIBCO Spotfire.

• Use the CData Software JDBC Driver for CouchDB in MicroStrategy Web

  Connect to Apache CouchDB in MicroStrategy Web using the CData Software JDBC Driver for CouchDB.

• Automated Continuous Spark Replication to Vertica

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

• Process & Analyze Twitter Ads in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Twitter Ads .

• How to integrate Dynamics NAV with Apache Airflow

  Access and process Microsoft Dynamics NAV in Apache Airflow using the CData JDBC Driver.

• Bidirectional Access to Google Campaign Manager 360 from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Google Campaign Manager 360 in Filemaker Pro for Mac or Windows.

• Integrate OData Services in Your Informatica Cloud Instance

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

• Rapidly Develop Dynamics CRM-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Build Charts with Teradata in Clear Analytics

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

• Connect to Shopify in HULFT Integrate

  Connect to Shopify as a JDBC data source in HULFT Integrate

• Process & Analyze Bullhorn CRM in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Bullhorn CRM .

• Access Neo4J in PHP through Connect Server

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

• Import and Visualize Shopify in Power View

  Create data visualizations based on Shopify in Excel.

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

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

• Visualize HubSpot in Tableau

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

• Work with IBM Cloud Object Storage in FoxPro

  Load IBM Cloud Object Storage into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to PayPal in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for PayPal and connect to PayPal in Akorbi Digital RunMyProcess.

• Create Dynamics CRM-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Dynamics CRM from Klipfolio and build custom visualizations using live Microsoft Dynamics CRM.

• Build GraphQL-Connected ETL Processes in Google Data Fusion

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

• Automate Google Search Integration Tasks from PowerShell

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

• Access Live Google Ad Manager in Coginiti Pro

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

• How to connect to Tally from IntelliJ

  Integrate connectivity to Tally ERP with wizards in IntelliJ.

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

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

• DataBind Azure DevOps to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Azure DevOps with the DevExpress Windows Forms and Web controls to provide Azure DevOps to a chart.

• Analyze Amazon S3 in Cognos Analytics

  Use CData Connect Cloud to connect to Amazon S3 from Cognos Analytics and analyze live Amazon S3.

• Replicate Jira Service Management for Use in Salesforce Connect

  Replicate Atlassian Jira Service Management to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Query OneNote in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft OneNote.

• Deploy the ADO.NET Provider for Phoenix on an SSRS Report Server

  Connect to Apache Phoenix from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• DataBind IBM Informix to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for IBM Informix with the DevExpress Windows Forms and Web controls to provide IBM Informix to a chart.

• ETL GraphQL in Oracle Data Integrator

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

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

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

• Visualize Live Avalara AvaTax in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Avalara AvaTax.

• Provide OData Services of Zenefits from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Zenefits by developing a WCF Service Application.

• Create SSAS Tabular Models from Pipedrive

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

• Build ActiveCampaign-Connected Web Apps in Servoy

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

• Connect to FTP in Jaspersoft Studio

  Execute SQL to remote FTP Servers in Jaspersoft Studio.

• Natively Connect to Stripe in PHP

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

• Model, Search, and Visualize Live Xero in ThoughtSpot

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

• Create Reports from BigQuery in Looker Studio

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

• DataBind Redis to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Redis with the DevExpress Windows Forms and Web controls to provide Redis to a chart.

• Automate Google Spanner Replication to SAP HANA

  Use CData Sync to customize and automate Google Spanner replication to SAP HANA.

• Bridge Reckon Accounts Hosted Connectivity with Apache NiFi

  Access and process Reckon Accounts Hosted in Apache NiFi using the CData JDBC Driver.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Using AngularJS to Build Dynamic Web Pages with Confluence

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

• Rapidly Develop Clio-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Create SQL Server Reports on JasperReports Server

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

• How to Work with Sage 50 UK in ETL Validator JDBC

  Connect to Sage 50 UK from ETL Validator jobs using the CData Software JDBC Driver.

• Import Twitter into FileMaker Pro

  Create reports that integrate Twitter in Filemaker Pro.

• Query SurveyMonkey through ODBC in Node.js

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

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

• Use JayDeBeApi to access SharePoint in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft SharePoint.

• How to Connect DBeaver to MySQL via a JDBC Driver

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

• How to Build Dynamic React Apps with RSS Feeds

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

• Build Charts with Spark in Clear Analytics

  Create dynamic charts and perform analytics based on Apache Spark SQL in Clear Analytics.

• Create Datasets from Act-On in Domo Workbench and Build Visualizations of Act-On in Domo

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zendesk

  Provide connectivity to Zendesk through an SAP BusinessObjects universe.

• «
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• »