CData Software - Knowledge Base

Recent Articles

• «
• 274
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• »

• Build Charts with Reckon in Clear Analytics

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

• Integrate Live Bullhorn CRM into Custom Business Apps Built in Power Apps

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

• DataBind Controls to Azure Data Lake Storage in C++Builder

  DataBind to Azure Data Lake Storage in C++Builder with standard components and controls.

• Build GitHub-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live GitHub.

• Create Pinterest Dataflows on PowerBI.com

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

• Build Dashboards with Teradata in Dundas BI

  Create dynamic dashboards and perform analytics based on Teradata in Dundas BI.

• Update Required: HubSpot Connectivity

  HubSpot is modifying the contacts scope of their API and CData has updated the OAuth implentation for their HubSpot connectivity solutions to accommodate.

• Publish Reports with Excel in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Excel.

• Google Calendar Reporting and Star Schemas in OBIEE

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

• Replicate Printful for Use in Salesforce Connect

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

• Add MySQL to Informatica Enterprise Data Catalog

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

• How to create Google Ads federated tables in MySQL

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

• Connect to SAP HANA from a Connection Pool in WebLogic

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

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

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

• Use JayDeBeApi to access Impala in Python

  Use standard Python scripting and the development environment of your choice to access live Apache Impala.

• Import Real-Time Calendly in ColdFusion to Build Applications

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

• Use the CData Software ODBC Driver for Basecamp in MicroStrategy

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

• Access Live Twitter in AWS Lambda

  Connect to live Twitter in AWS Lambda using the CData JDBC Driver.

• How to integrate Metabase with NetSuite

  Use CData Connect Cloud to connect to live NetSuite CRM & ERP and create an interactive dashboard in Metabase from NetSuite CRM & ERP.

• Replicate Zoho Books from PowerShell

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

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

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

• Load JDBC-ODBC Bridge to a Database Using Embulk

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

• Integrate with AlloyDB in JReport Designer

  Create charts and reports based on Google AlloyDB in JReport Designer.

• Access Live Impala in AWS Lambda

  Connect to live Apache Impala in AWS Lambda using the CData JDBC Driver.

• DataBind Controls to SQL Analysis Services in C++Builder

  DataBind to SQL Analysis Services in C++Builder with standard components and controls.

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

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

• Enable the FHIR JDBC Driver in KNIME

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

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

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

• Connect to Confluence from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Atlassian Confluence from Crystal Reports.

• Explore Geographical Relationships in Salesforce with Power Map

  Create data visualizations with Salesforce & Force.com in Power Map.

• Access Quickbase from MySQL in HeidiSQL

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

• Publish Crystal Reports on ShipStation

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

• Integrate Twilio into Power Automate Desktop using CData Connect

  CData Connect for Twilio enables you to integrate Twilio into workflows built using Microsoft Power Automate Desktop.

• How to Connect the Power BI Service to Amazon Athena: Complete Guide

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

• Use the CData Software ODBC Driver for QuickBooks in MicroStrategy

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

• Build a Simple VCL Application for Google Cloud Storage

  How to build a simple VCL Application to view Google Cloud Storage in RAD Studio using the CData ODBC Driver for Google Cloud Storage.

• How to Build Dynamic React Apps with Teradata

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

• Using AngularJS to Build Dynamic Web Pages with MariaDB

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

• Operational Reporting on PostgreSQL from Spotfire Server

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

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

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

• Visualize Live Google Contacts of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Google Contacts using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Work with Live Trello in Power Query

  Use CData Connect Cloud to connect to Trello and work with live Trello in Microsoft Power Query.

• Automated Continuous Snapchat Ads Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Snapchat Ads replication to SQL Server.

• Import Google Directory into FileMaker Pro

  Create reports that integrate Google Directory in Filemaker Pro.

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

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

• Back Up Harvest to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Harvest. In this article, we will employ an SSIS workflow to populate a database with Harvest data.

• Excel Spreadsheet Automation with the QUERY Formula

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

• DataBind Wijmo Grid to Dynamics 365 Business Central

  Provide real-time Dynamics 365 Business Central to interactive controls.

• Publish Aha-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Aha!.

• How to connect to IBM Cloud Data Engine from Google Apps Script

  Use CData Software Connect Server to access IBM Cloud Data Engine in Google Apps Script.

• How to import SAP Concur into Apache Solr

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

• How to load Zoho Projects data into Elasticsearch via Logstash

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

• Enable the Amazon S3 JDBC Driver in KNIME

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

• Connect to Zoom in as an External Source in Dremio

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

• How to create an RPA flow for Freshdesk in UiPath Studio

  Use the Freshdesk ODBC Driver to create workflows that access real-time Freshdesk without any coding.

• Build Semantic Layer Views for MYOB AccountRight in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for MYOB AccountRight.

• Build JotForm-Connected ETL Processes in Google Data Fusion

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

• Use the CData Software JDBC Driver for Wave Financial in MicroStrategy Desktop

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

• Use JayDeBeApi to access CouchDB in Python

  Use standard Python scripting and the development environment of your choice to access live Apache CouchDB.

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

  Connect to BigCommerce 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.

• Automated Continuous Active Directory Replication to SQLite

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

• Connect to RSS Feeds in CloverDX (formerly CloverETL)

  Transfer RSS Feeds using the visual workflow in the CloverDX data integration tool.

• Integrate Real-Time Access to SAP BusinessObjects BI in SAPUI5 MVC Apps

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

• Connect to Google Spanner in RunMyProcess through Connect Cloud

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

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

  Create an ODBC connection to Zoho Inventory in Informatica and browse and transfer Zoho Inventory.

• Access Access from MySQL in Amazon QuickSight

  Connect to Access and build visualizations of Microsoft Access using a MySQL Connection in Amazon QuickSight.

• DataBind Wijmo Grid to Adobe Commerce

  Provide real-time Adobe Commerce to interactive controls.

• How to connect PolyBase to HCL Domino

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HCL Domino.

• Create SSAS Tabular Models from Cvent

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

• Explore Geographical Relationships in Epicor Kinetic with Power Map

  Create data visualizations with Epicor Kinetic in Power Map.

• Publish Invoiced-Connected Dashboards in Tableau Server

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

• Import Adobe Commerce Using Azure Data Factory

  Use CData Connect Cloud to connect to Adobe Commerce from Azure Data Factory and import live Adobe Commerce.

• How to Visualize Confluence Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Atlassian Confluence in Python.

• Automated Continuous Hive Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Hive replication to SQL Server.

• Visualize Redshift from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Amazon Redshift.

• Using the CData Software ODBC Driver for Greenplum in PyCharm

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

• Build Pipelines with Live Couchbase in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Couchbase from Google Cloud Data Fusion, enabling the integration of live Couchbase into the building and management of effective data pipelines.

• Automated Continuous ClickUp Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable ClickUp replication to Amazon Redshift.

• Analyze Amazon S3 in R

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

• DataBind Wijmo Grid to Marketo

  Provide real-time Marketo to interactive controls.

• Analyze Amazon DynamoDB with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Amazon DynamoDB from Power Pivot. You will use the Table Import Wizard to load Amazon DynamoDB. You can visually build the import query or use any SQL supported by the driver.

• Build Semantic Layer Views for OneNote in APOS Live Data Gateway

  Use the CData Connector for OneNote in APOS Live Data Gateway to build Semantic Layer Views for Microsoft OneNote.

• Build Visualizations of Live Azure Data Catalog in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Azure Data Catalog and build custom reports in Power BI.

• How to connect to Shippo with Squirrel SQL client

  Connect to Shippo and execute queries in the Squirrel SQL Client.

• Access Live CockroachDB in Excel (Desktop)

  Use CData Connect Cloud to gain access to live CockroachDB from your Excel spreadsheets.

• Access Live MYOB AccountRight in Coginiti Pro

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

• Connect to Coinbase in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Coinbase and connect to Coinbase in Akorbi Digital RunMyProcess.

• Build Klaviyo-Connected Web Apps in Servoy

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

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

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

• Viewing Google Ads in RAD Studio Data Explorer

  How to view Google Ads in RAD Studio Data Explorer using the CData ODBC Driver for Google Ads.

• How to create Visio diagrams from MariaDB

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

• How to connect to SharePoint with Squirrel SQL client

  Connect to Microsoft SharePoint and execute queries in the Squirrel SQL Client.

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

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

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

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• How to connect to xBase in DBVisualizer

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

• Automated Continuous Zoho Projects Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Zoho Projects replication to Google Cloud SQL.

• Import Printful into FileMaker Pro

  Create reports that integrate Printful in Filemaker Pro.

• Automated Continuous ShipStation Replication to SQL Server

  Use CData Sync for automated, continuous, customizable ShipStation replication to SQL Server.

• Automate Twitter Ads Replication to SAP HANA

  Use CData Sync to customize and automate Twitter Ads replication to SAP HANA.

• «
• 274
• 275
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• »