CData Software - Knowledge Base

Recent Articles

• «
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• 232
• 233
• »

• Use the CData Software ODBC Driver for Gmail in MicroStrategy

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

• Replicate IBM Informix to Multiple Databases

  Replicate IBM Informix to disparate databases with a single configuration.

• Access Marketo from MySQL in PHP

  Connect to Marketo through the standard MySQL libraries in PHP.

• Build Automated Workflows with Live SingleStore in Workato

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

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

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

• Connect to SQL Server in Ruby

  Connect to Microsoft SQL Server in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

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

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

• Replicate SAP ByDesign for Use in Salesforce Connect

  Replicate SAP Business ByDesign to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Build SendGrid-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for SendGrid and create custom apps in Mendix.

• Connect to SAP Business One from PowerBuilder

  This article demonstrates how to access SAP Business One from PowerBuilder using the SAP Business One JDBC Driver.

• Export Data from SQL Server to Box through SSIS

  Easily push SQL Server data to Box using the CData SSIS Tasks for Box.

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

  The CData ODBC Driver for SAP enables you to integrate SAP ERP/NetWeaver into workflows built using Microsoft Power Automate Desktop.

• Access Live Wave Financial in AWS Lambda (with IntelliJ IDEA)

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

• Automate Google Analytics Replication to Azure Data Lake

  Use CData Sync to customize and automate Google Analytics replication to Azure Data Lake.

• Connect to Aha in DBeaver

  Use the CData ODBC Driver to connect to Aha! in DBeaver.

• Build IBM Informix-Connected ETL Processes in Google Data Fusion

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

• Edit and Search External Excel Objects in Salesforce Connect

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

• Replicate SAP Netweaver Gateway for Use in Salesforce Connect

  Replicate SAP Netweaver Gateway to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Replicate ADP from PowerShell

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

• Publish Crystal Reports on Zendesk

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

• How to connect to Google Sheets with Squirrel SQL client

  Connect to Google Sheets and execute queries in the Squirrel SQL Client.

• Integrate with Basecamp using Apache Camel2

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

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

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

• Create Dynamic IBM Cloud Data Engine Grids Using the Infragistics XamDataGrid

  Learn how you can connect IBM Cloud Data Engine to Infragistics XamDataGrid to build dynamic grids.

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

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

• Connect to and Visualize Live Asana in Tableau Prep

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

• Connect to Hive in Aqua Data Studio

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

• Replicate LDAP Objects for Use in Salesforce Connect

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

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

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

• Publish HBase-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apache HBase.

• Query GitHub in ColdFusion

  Write standard ColdFusion data access code to connect to GitHub.

• Connect to SAP ByDesign as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Business ByDesign.

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

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

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

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

• Build Visualizations of Azure Table in Birst

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

• Build an OLAP Cube in SSAS from Paylocity

  Establish a connection to Paylocity data from SQL Server Analysis Services, and use the Paylocity Data Provider to build OLAP cubes for use in analytics and reporting.

• Automated Continuous ShipStation Replication to PostgreSQL

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

• Automated Continuous MarkLogic Replication to Amazon S3

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

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

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

• Connect to Facebook Ads from Asprova with CData Software ODBC Driver for Facebook Ads

  This article shows how to connect faster to Facebook Ads data from Asprova.

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

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

• How to connect and process HubDB from Azure Databricks

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

• Connect to Greenplum from a Connection Pool in Jetty

  The Greenplum JDBC Driver supports connection pooling: This article shows how to connect faster to Pivotal GreenPlum from Web apps in Jetty.

• SAP HANA Reporting and Star Schemas in OBIEE

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

• Automate Presto Replication to Azure Synapse

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

• How to connect to Typeform in DBVisualizer

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

• Access Live Shippo in Coginiti Pro

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

• Query Freshdesk in MySQL Workbench

  Create a virtual MySQL database for Freshdesk in CData Software Connect (or Connect Server) and work with live Freshdesk in MySQL Workbench.

• Natively Connect to Cassandra in PHP

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

• How to use SQLAlchemy ORM to access Salesforce Pardot in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce Pardot.

• Natively Connect to Cvent in PHP

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

• How to connect to ConstantContact from IntelliJ

  Integrate connectivity to ConstantContact with wizards in IntelliJ.

• Automated Continuous Veeva Replication to Vertica

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

• Connect to Live Hive in MicroStrategy through CData Connect Cloud

  Create a live connection to Hive in CData Connect Cloud and connect to your Apache Hive from MicroStrategy.

• Visualize Amazon Marketplace in TIBCO Spotfire through ODBC

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

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

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

• Visualize EnterpriseDB in Tableau

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

• Build Dashboards with SendGrid in DBxtra

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

• Provide OData Services of GraphQL from a WCF Application

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

• Redis Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Redis through CData Connect Cloud using different applications and tools.

• Perform Batch Operations with Oracle in Apache NiFi

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

• Query Unbounce as a SQL Server in Node.js

  Execute SQL Server queries against Unbounce from Node.js.

• Connect to ShipStation in HULFT Integrate

  Connect to ShipStation as a JDBC data source in HULFT Integrate

• Use the CData ODBC Driver for Blackbaud FE NXT in SAS JMP

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

• Access Epicor Kinetic as a Remote Oracle Database

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

• How to Visualize Azure Data Catalog Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Azure Data Catalog in Python.

• Connect to Google Contacts as a Linked Server

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

• Manage Microsoft Planner in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Microsoft Planner.

• Create Google Drive Reports on JasperReports Server

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

• Automated Continuous TaxJar Replication to SQL Server

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

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

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

• Build Microsoft Dataverse Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Microsoft Dataverse (CDS) and build visualizations in Tableau Cloud.

• Analyze Jira with Power Pivot

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

• How to connect Amazon QuickSight to Freshdesk

  Create a connection to Freshdesk in CData Connect Cloud and insert Freshdesk into Amazon QuickSight SPICE to build interactive dashboards.

• Query Kafka as a SQL Server in Node.js

  Execute SQL Server queries against Apache Kafka from Node.js.

• Connect to and Query Acumatica in QlikView over ODBC

  Create data visualizations with Acumatica ERP in QlikView.

• How to connect to Dynamics NAV with Squirrel SQL client

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

• Bridge Zoho Books Connectivity with Apache NiFi

  Access and process Zoho Books in Apache NiFi using the CData JDBC Driver.

• How to Build Dynamic React Apps with ActiveCampaign

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

• Connect to HarperDB from PowerBuilder

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

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

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

• Use CData Connect Cloud to Access Zendesk in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Zendesk in the Power Pivot business intelligence tool.

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

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

• Connect to LinkedIn Ads through External Services in Salesforce

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

• Visualize Parquet in TIBCO Spotfire through ODBC

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

• Create Azure Table-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Azure Table from Nintex Workflow Cloud and build custom workflows using live Azure Table Storage.

• Automated Continuous Printful Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Printful replication to AlloyDB.

• Automate Azure DevOps Replication to Azure Synapse

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

• Integrate with Live ActiveCampaign in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to ActiveCampaign from the MuleSoft Anypoint Platform to integrate live ActiveCampaign into custom reports and dashboards.

• Create BigQuery-Connected Business Apps in AppSheet

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

• Visualize SingleStore in TIBCO Spotfire through OData

  Integrate SingleStore into dashboards in TIBCO Spotfire.

• Build Redshift Visualizations in Tableau Cloud

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

• Publish ActiveCampaign-Connected Dashboards in Tableau Server

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

• Connect to Harvest from PowerBuilder

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

• Integrating Drip in Talend Cloud Data Management Platform

• «
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• 231
• 232
• 233
• »