CData Software - Knowledge Base

Recent Articles

• «
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• »

• Design BIRT Reports on OData Services

  Provide current OData to your embedded analytics.

• Rapidly Develop Google Search-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.

• Work with Live Adobe Commerce in Power Query

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

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

  Provide connectivity to Okta through an SAP BusinessObjects universe.

• Replicate LinkedIn Ads to Multiple Databases

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

• Connect to Zendesk from PowerBuilder via JDBC

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

• DataBind MariaDB to the DevExpress Data Grid

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

• How to work with Microsoft Planner in Apache Spark using SQL

  Access and process Microsoft Planner in Apache Spark using the CData Software JDBC Driver.

• Build Interactive Dashboards from Sage 50 UK in Amazon QuickSight

  Create a virtual SQL Server database for Sage 50 UK in CData Software Connect Server and import Sage 50 UK into Amazon QuickSight SPICE to build interactive dashboards.

• Natively Connect to Sybase IQ in PHP via ODBC (Linux)

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

• How to connect to Pipedrive from IntelliJ

  Integrate connectivity to Pipedrive with wizards in IntelliJ.

• Automated Continuous DB2 Replication to MySQL

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

• Analyze xBase in R via ODBC

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

• Integrate with Amazon Athena in JReport Designer

  Create charts and reports based on Amazon Athena in JReport Designer.

• Build Reckon Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Reckon and build visualizations in Tableau.

• Use Dash to Build to Web Apps on Sage Intacct

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

• Establish a Live Connection with Aha using Tableau Bridge

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

• How to Build Dynamic React Apps with Kintone

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

• Natively Connect to Google Calendar in PHP via ODBC (Linux)

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

• Access Live Snapchat Ads in TIBCO Data Virtualization

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

• Create a Data Access Object for Facebook Ads using JDBI

  A brief overview of creating a SQL Object API for Facebook Ads in JDBI.

• Connect to Splunk from PowerBuilder via ODBC

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

• Model YouTube Analytics Using Azure Analysis Services

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

• Access SAP HANA XS Advanced from MySQL in PHP

  Connect to SAP HANA XS Advanced through the standard MySQL libraries in PHP.

• Connect to Exact Online from PowerBuilder via ADO.NET

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

• Use Biml to Build SSIS Tasks to Replicate Google Cloud Storage to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Cloud Storage to SQL Server.

• How to work with Exact Online in Apache Spark using SQL

  Access and process Exact Online in Apache Spark using the CData Software JDBC Driver.

• Design BIRT Reports on ShipStation

  Provide current ShipStation to your embedded analytics.

• Automated Continuous JSON Replication to Snowflake

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

• How to connect PolyBase to Typeform

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

• Create SSAS Tabular Models from Oracle SCM

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

• Validate Typeform with QuerySurge

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

• Connect to Adobe Commerce in JRuby

  Create a simple JRuby app with access to live Adobe Commerce.

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

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

• Automated Continuous MongoDB Replication to Apache Cassandra

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

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

  Connect to Splunk in MicroStrategy Web using the CData Software ODBC Driver for Splunk.

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

  Provide connectivity to MariaDB through an SAP BusinessObjects universe.

• Integrate Cloudant into Power Automate Desktop using CData Connect

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

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

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP ERP/NetWeaver.

• Import and Visualize QuickBooks Time in Power View

  Create data visualizations based on QuickBooks Time in Excel.

• Connect to Google Campaign Manager 360 in CloverDX (formerly CloverETL)

  Transfer Google Campaign Manager 360 using the visual workflow in the CloverDX data integration tool.

• How to pipe Snowflake to CSV in PowerShell

  Use standard PowerShell cmdlets to access Snowflake tables.

• Create MYOB AccountRight-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to MYOB AccountRight from OutSystems and build custom enterprise apps using live MYOB AccountRight.

• Query Cosmos DB through ODBC in Node.js

  Use node-odbc to execute SQL queries against Azure Cosmos DB from Node.js.

• How to connect to Exact Online from Spring Boot

  Connect to Exact Online in a Spring Boot Application using CData JDBC Exact Online Driver

• Automated Continuous Dynamics 365 Replication to Vertica

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

• Create Apps from ActiveCampaign in Qlik Sense Cloud

  Use CData Connect Cloud to connect to ActiveCampaign and build apps from live ActiveCampaign in Qlik Sense Cloud.

• Design BIRT Reports on Shippo

  Provide current Shippo to your embedded analytics.

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

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

• Using CData ODBC drivers from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC drivers to connect to an external data source from Excel spreadsheets in SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards in their Excel spreadsheets using data from sources like Salesforce, QuickBooks, Dynamics CRM and many more.

• How to Visualize WordPress Data in Python with pandas

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

• Publish Reports with Pinterest in SAP Crystal Reports

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

• Visualize Live PayPal in Tableau

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

• Create Presto-Connected Dashboards in Grafana

  Connect to Presto via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Presto.

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

  Provide connectivity to Quickbase through an SAP BusinessObjects universe.

• Visualize Sugar CRM in TIBCO Spotfire through OData

  Integrate Sugar CRM into dashboards in TIBCO Spotfire.

• Build a Simple VCL Application for Jira Service Management

  How to build a simple VCL Application to view Atlassian Jira Service Management in RAD Studio using the CData ODBC Driver for Jira Service Management.

• Create Spark-Connected Dashboards in Grafana

  Connect to Spark via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Apache Spark SQL.

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

• Automated Continuous Impala Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Impala replication to PostgreSQL.

• How to work with ActiveCampaign in Apache Spark using SQL

  Access and process ActiveCampaign in Apache Spark using the CData Software JDBC Driver.

• Model, Search, and Visualize Live Oracle Financials Cloud in ThoughtSpot

  Use CData Connect Cloud to connect to live Oracle Financials Cloud for modeling, searching, and visualizing.

• Explore Geographical Relationships in Azure Synapse with Power Map

  Create data visualizations with Azure Synapse in Power Map.

• Integrate Zoho Inventory in Your Informatica Cloud Instance

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

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

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

• Connect to Facebook Ads as an External Source in Dremio

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

• Connect to BambooHR from PowerBuilder via ADO.NET

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

• How to create an RPA flow for Salesforce Data Cloud in UiPath Studio

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

• Connect to Google Spanner through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Google Spanner using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

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

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

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

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

• Connect to SAS xpt in RazorSQL

  Connect to SAS xpt from wizards and query SAS XPORT from the GUI in the RazorSQL database management tool.

• Create Instagram-Connected Dashboards in Grafana

  Connect to Instagram via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Instagram.

• Connect to ClickUp as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for ClickUp.

• Connect to Microsoft Teams in RapidMiner

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

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

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

• Integrate with Google Calendar using Apache Camel2

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

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

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

• Automated Continuous Google Search Replication to Databricks

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

• Automate Basecamp Replication to Azure Synapse

  Use CData Sync to customize and automate Basecamp replication to Azure Synapse.

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

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

• DataBind Controls to Okta in Delphi

  DataBind to Okta in Delphi with standard data access components and controls.

• Replicate WordPress for Use in Salesforce Connect

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

• Use the CData Software ODBC Driver for Jira Assets in MicroStrategy Desktop

  Connect to Jira Assets in MicroStrategy Desktop using the CData Software ODBC Driver for Jira Assets.

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

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

• Automated Continuous HDFS Replication to MongoDB

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

• Analyze Salesforce Pardot in Cognos Analytics

  Use CData Connect Cloud to connect to Salesforce Pardot from Cognos Analytics and analyze live Salesforce Pardot.

• Connect to and Visualize Live Freshdesk in Tableau Prep

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

• Automated Continuous Todoist Replication to Snowflake

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

• Build Jira Service Management-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Atlassian Jira Service Management and build web apps with connectivity to live Atlassian Jira Service Management.

• Automated Continuous SAP ByDesign Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Amazon S3.

• Connect to and Query Oracle Service Cloud in QlikView over ODBC

  Create data visualizations with Oracle Service Cloud in QlikView.

• Connect to Azure DevOps in RazorSQL

  Connect to Azure DevOps from wizards and query Azure DevOps from the GUI in the RazorSQL database management tool.

• Excel Spreadsheet Automation on Avalara AvaTax with the QUERY Formula

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

• How to Connect DBeaver to QuickBooks via a JDBC Driver

  Manage QuickBooks Desktop with visual tools in DBeaver like the query browser.

• Create Google Ad Manager-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Google Ad Manager from AppSheet and build custom business apps using live Google Ad Manager.

• Automate Dynamics 365 Business Central Replication to Azure Data Lake

  Use CData Sync to customize and automate Dynamics 365 Business Central replication to Azure Data Lake.

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

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

• How to Connect to & Open Act-On in Microsoft Excel

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

• Publish Crystal Reports on Klipfolio

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

• «
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• »