CData Software - Knowledge Base

Recent Articles

• «
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• »

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

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

• Create Reports from Adobe Commerce in Looker Studio

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

• Working with SendGrid in LINQPad

  Execute LINQ queries to SendGrid in LINQPad.

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

  Use CData Power BI Connectors to visualize Jira Assets in Power BI.

• How to create an RPA flow for RSS Feeds in UiPath Studio

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

• Create Apps from Impala in Qlik Sense Cloud

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

• How to Connect to & Open HubSpot in Microsoft Excel

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

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

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

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

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

• Access Salesforce Marketing from MySQL in PHP

  Connect to Salesforce Marketing through the standard MySQL libraries in PHP.

• Import SAP Hybris C4C into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to SAP Hybris C4C and provide access to live SAP Hybris C4C for custom reports in the Power BI Service.

• Seamlessly Bring QuickBooks Time into Retool Using CData Connect Cloud

  Integrate QuickBooks Time data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Build Dashboards with Workday in DBxtra

  Create dynamic dashboards and perform analytics based on Workday in DBxtra.

• Connect and Visualize Live Act-On Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Act-On into the Databricks platform and create visualization dashboards with real-time Act-On.

• Connect to Sage 300 from PowerBuilder via JDBC

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

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

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

• Automated Continuous Elasticsearch Replication to IBM DB2

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

• Connect to DocuSign as a Linked Server via SQL Gateway

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

• Connect to JotForm in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous Active Directory Replication to Databricks

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

• DataBind Controls to Teradata in C++Builder

  DataBind to Teradata in C++Builder with standard components and controls.

• Create Data Visualizations in Cognos BI with Dropbox

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

• QuickBooks Reporting and Star Schemas in OBIEE

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

• Bridge Dynamics 365 Connectivity with Apache NiFi

  Access and process Microsoft Dynamics 365 in Apache NiFi using the CData JDBC Driver.

• Working with Snapchat Ads in LINQPad

  Execute LINQ queries to Snapchat Ads in LINQPad.

• Presto Reporting and Star Schemas in OBIEE

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

• Build Visualizations of Dropbox in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dropbox in Birst.

• Build OneNote-Connected Visualizations in datapine

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

• Build Act CRM Visualizations in Tableau Cloud

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

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

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

• HBase Reporting and Star Schemas in OBIEE

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

• Build Bing Search-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Bing Search Results from Zoho Analytics and import live Bing Search.

• Build SAP ByDesign Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live SAP Business ByDesign and build visualizations in Tableau Cloud.

• DataBind Charts to ServiceNow

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to ServiceNow 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.

• Process & Analyze Salesforce Pardot in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Pardot .

• How to Connect to Blackbaud FE NXT in Using Python: 6 Steps

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

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

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

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

  Connect to Teradata from a connection pool in Tomcat.

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

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

• How to Use CData Connect to Access Live Phoenix in Power Automate

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

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

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

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

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

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

  Use CData Software Connect Server to create a virtual SQL Server Database for Zoom and integrate live Zoom into apps built in Microsoft Power Apps.

• Build Semantic Layer Views for Active Directory in APOS Live Data Gateway

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

• Create xBase Dataflows on PowerBI.com

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

• How to publish and share Google Campaign Manager 360 dashboards with Tableau Server

  The CData ODBC driver for Google Campaign Manager 360 enables you integrate Google Campaign Manager 360 into Tableau dashboards.

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

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

• Integrate Greenhouse with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Greenhouse with External Services.

• A PostgreSQL Interface for Reckon Accounts Hosted (MySQL Remoting via JDBC)

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

• How to integrate Metabase with QuickBooks Online

  Use CData Connect Cloud to connect to live QuickBooks Online and create an interactive dashboard in Metabase from QuickBooks Online.

• Natively Connect to BigCommerce in PHP

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

• Seamlessly Bring Amazon S3 into Retool Using CData Connect Cloud

  Integrate Amazon S3 data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Automated Continuous Zoho Inventory Replication to SQLite

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

• Design BIRT Reports on eBay

  Provide current eBay to your embedded analytics.

• Working with Cloudant in LINQPad

  Execute LINQ queries to IBM Cloudant in LINQPad.

• Connect to OneNote as a Linked Server via SQL Gateway

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

• Connect to Dynamics NAV as a Linked Server via CData Connect

  Use CData Connect to set up a linked server for Microsoft Dynamics NAV.

• Build Klaviyo-Connected ETL Processes in Google Data Fusion

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

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

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

• Visualize Live Slack in Tableau

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

• Connect to Paylocity from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Paylocity from Filemaker Pro on Mac.

• Explore Geographical Relationships in Databricks with Power Map

  Create data visualizations with Databricks in Power Map.

• Access Live Adobe Commerce in AWS Lambda

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

• 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.

• Author and Share Power BI Reports on Real-Time Google Ads

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

• Connect to JSON Services in DBArtisan

  Use wizards in DBArtisan to configure JSON as a data source.

• Integrate Instagram in the Pentaho Report Designer

  Publish reports based on Instagram in the Pentaho BI tool.

• Replicate Multiple SharePoint Accounts

  Replicate multiple SharePoint accounts to one or many databases.

• Automated Continuous IBM Cloud Data Engine Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to PostgreSQL.

• Connect to Cosmos DB from PowerBuilder via ODBC

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

• ETL Klipfolio in Oracle Data Integrator

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

• Analyze Avro in R via ODBC

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

• Use JayDeBeApi to access ShipStation in Python

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

• Use the CData ODBC Driver for SAP Ariba Source in Microsoft Power Query

  You can use the CData SAP Ariba Source ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Ariba Source into Microsoft Power Query.

• Visualize WordPress from Tableau

  Use the Tableau Desktop business intelligence tool to connect to WordPress.

• 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 to Office 365 in Using Python: 6 Steps

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

• Integrate Google Cloud Storage in Your Informatica Cloud Instance

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

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

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

• Use Dash to Build to Web Apps on Office 365

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

• Automated Continuous Outreach.io Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Outreach.io replication to Azure SQL.

• Automated Continuous Salesforce Replication to Apache Cassandra

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

• Visualize TigerGraph in TIBCO Spotfire through ODBC

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

• Create Asana-Connected Enterprise Applications in OutSystems

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

• Access Live Freshdesk in Coginiti Pro

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

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

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

• Connect to Salesforce in JRuby

  Create a simple JRuby app with access to live Salesforce & Force.com.

• Use the CData Software ODBC Driver for Sybase IQ in MicroStrategy Web

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

• Create Google Calendar-Connected Business Apps in AppSheet

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

• Import HDFS into Microsoft Power Query

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

• Process & Analyze SendGrid in Databricks (AWS)

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

• Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy

  Connect to SAP Ariba Source in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Source.

• Integrate Live Freshdesk into Amazon SageMaker Canvas with RDS

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

• Automated Continuous Impala Replication to Databricks

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

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

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

• Create Xero-Connected Business Apps in AppSheet

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

• Creating Jira Service Management-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Atlassian Jira Service Management to Unqork and build custom business apps.

• Connect to Klipfolio in RapidMiner

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

• Build Data Flows from Redshift to SQL Server using SSIS

  Easily back up Amazon Redshift to SQL Server using the SSIS components for Redshift.

• Build Automated Workflows with Live Sansan in Workato

  Use CData Connect Cloud to connect to live Sansan and build automated workflows in Workato.

• «
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• »