CData Software - Knowledge Base

Recent Articles

• «
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• »

• How to Access Live ConstantContact in Power Automate Desktop via ODBC

  The CData ODBC Driver for ConstantContact enables you to integrate ConstantContact into workflows built using Microsoft Power Automate Desktop.

• Stream Raisers Edge NXT into Apache Kafka Topics

  Access and stream Raisers Edge NXT in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to Snapchat Ads in Jaspersoft Studio

  Execute SQL to remote Snapchat Ads in Jaspersoft Studio.

• Back Up SAP BusinessObjects BI to SQL Server through SSIS

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

• Model, Search, and Visualize Live Freshdesk in ThoughtSpot

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

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

• Automated Continuous MYOB AccountRight Replication to PostgreSQL

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

• Perform Batch Operations with Oracle Service Cloud in Apache NiFi

  Connect to Oracle Service Cloud and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Automated Continuous SharePoint Excel Services Replication to SQL Server

  Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to SQL Server.

• Build Visualizations of Gmail in Birst

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

• How to Connect to & Open DocuSign in Microsoft Excel

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

• Build a Simple VCL Application for Sage Intacct

  How to build a simple VCL Application to view Sage Intacct in RAD Studio using the CData ODBC Driver for Sage Intacct.

• A PostgreSQL Interface for Greenhouse

  Use the SQL Gateway and Greenhouse ODBC Driver to create a PostgreSQL entry-point for data access.

• Build Charts with Box in Clear Analytics

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

• Natively Connect to SFTP in PHP

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

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

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

• Connect to QuickBooks Online in as an External Source in Dremio

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

• Integrate Calendly in Your Informatica Cloud Instance

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

• Use the CData ODBC Driver for Sybase IQ in SAS JMP

  You can use the CData ODBC Driver to integrate Sybase IQ into the statistical analysis tools available in SAS JMP. This article shows how to use Sybase IQ in the Graph Builder and Query Builder.

• Use Dash to Build to Web Apps on Twitter Ads

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

• Connect to Excel Online through External Services in Salesforce

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

• Create Google Sheets Reports on JasperReports Server

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

• Use the CData ODBC Driver for Google Data Catalog in SAS JMP

  You can use the CData ODBC Driver to integrate Google Data Catalog into the statistical analysis tools available in SAS JMP. This article shows how to use Google Data Catalog in the Graph Builder and Query Builder.

• Analyze Live Azure Table in SAS Viya

  Use CData Connect Cloud to connect to Azure Table Storage from SAS Viya and deploy self-service analytics using live Azure Table Storage.

• How to connect and process QuickBooks from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks

• Edit and Search External QuickBooks Objects in Salesforce Connect

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

• How to Connect to & Open Elasticsearch in Microsoft Excel

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

• Access Typeform as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Typeform from your Oracle system.

• Create Apps from Kafka in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Apache Kafka and build apps from live Apache Kafka in Qlik Sense Cloud.

• Connect to SQL Server in Google Apps Script

  Use the ODBC Driver for SQL Server and the SQL Gateway to access Microsoft SQL Server from Google Apps Script.

• DataBind Controls to Zoho Inventory in C++Builder

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

• Connect to BigQuery in DBArtisan

  Use wizards in DBArtisan to configure Google BigQuery as a data source.

• Automate Oracle Replication to Azure Synapse

  Use CData Sync to customize and automate Oracle Database replication to Azure Synapse.

• Visualize Live Neo4J of Power BI Report Builder in Power BI Service

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

• Build ShipStation Visualizations in Tableau Desktop

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

• Create Todoist Dataflows on PowerBI.com

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

• Connect to Harvest in Google Apps Script

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

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

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

• Model Twitter Ads Using Azure Analysis Services

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

• Integrate with Monday.com in JReport Designer

  Create charts and reports based on Monday.com in JReport Designer.

• Working with Adobe Commerce in LINQPad

  Execute LINQ queries to Adobe Commerce in LINQPad.

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

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

• Enable the LinkedIn Ads JDBC Driver in KNIME

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

• Work with SuiteCRM in FoxPro

  Load SuiteCRM into a FoxPro database. This article includes full code and a walk-through of the process.

• Import Real-Time LinkedIn in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use LinkedIn in ColdFusion.

• Access IBM Informix in PHP through Connect Server

  Connect to IBM Informix through the standard SQL Server libraries in PHP.

• Integrate Real-Time Access to Jira Service Management in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Atlassian Jira Service Management in real time.

• How to Import ActiveCampaign into SQL Server using SSIS

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

• Export Data from SQL Server to Reckon Accounts Hosted through SSIS

  Easily push SQL Server data to Reckon Accounts Hosted using the CData SSIS Tasks for Reckon Accounts Hosted.

• Build Semantic Layer Views for Microsoft Teams in APOS Live Data Gateway

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

• Automate eBay Analytics Integration Tasks from PowerShell

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

• Create SSAS Tabular Models from Workday

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

• Automate Exact Online Replication to Azure Data Lake

  Use CData Sync to customize and automate Exact Online replication to Azure Data Lake.

• Query Twitter Ads in ColdFusion

  Write standard ColdFusion data access code to connect to Twitter Ads.

• Automate Avro Integration Tasks from PowerShell

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

• Author and Share Power BI Reports on Real-Time Sage 300

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

• Analyze Live WooCommerce in SAS Viya

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

• How to connect to Zendesk from IntelliJ

  Integrate connectivity to Zendesk with wizards in IntelliJ.

• Use the Connect Server to Access Sybase IQ in Microsoft Power Pivot

  Use the Connect Server to connect to live Sybase IQ in the Power Pivot business intelligence tool.

• Use the CData Software JDBC Driver for Hive in MicroStrategy

  Connect to Apache Hive in MicroStrategy Developer using the CData Software JDBC Driver for Hive.

• Automated Continuous SAP BusinessObjects BI Replication to Snowflake

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Snowflake.

• How to connect and process Amazon DynamoDB from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon DynamoDB

• Feed Monday.com into FineReport

  How to set Monday.com as a JDBC data source in FineReport.

• Automated Continuous Quickbase Replication to IBM DB2

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

• Design BIRT Reports on Twitter

  Provide current Twitter to your embedded analytics.

• Visualize Sybase in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Sybase in CData Software Connect (or Connect Server) and build visualizations from live Sybase in Tableau Desktop.

• Add JDBC-ODBC Bridge to Informatica Enterprise Data Catalog

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

• Viewing FTP in RAD Studio Data Explorer

  How to view FTP Servers in RAD Studio Data Explorer using the CData ODBC Driver for FTP.

• Access Oracle in PHP through Connect Server

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

• Choosing the Best Method to Connect Sage Cloud Accounting to SQL Server: 5 Options Explained

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

• DataBind Charts to Act CRM

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

• Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Desktop

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

• How to Connect DBeaver to Pinterest via a JDBC Driver

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

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

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

• Analyze SAP Ariba Source in R

  Use standard R functions and the development environment of your choice to analyze SAP Ariba Source with the CData JDBC Driver for SAP Ariba Source.

• Analyze Marketo in R

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

• Access Jira from MySQL in HeidiSQL

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

• Visualize Live Oracle Service Cloud in the Power BI Service

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

• How to work with LinkedIn in Apache Spark using SQL

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

• Access Live Blackbaud FE NXT in Google Sheets

  Use CData Connect Cloud to gain access to live Blackbaud FE NXT from your Google Sheets.

• Connect to Real-Time Google Data Catalog Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 283
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• »