CData Software - Knowledge Base

Recent Articles

• «
• 385
• 386
• 387
• 388
• 389
• 390
• 391
• 392
• 393
• 394
• »

• How to connect to Zoho Books from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Zoho Books and work with Zoho Books in Microsoft Excel on Mac OS X.

• Use the CData Software JDBC Driver for Sugar CRM in MicroStrategy

  Connect to Sugar CRM in MicroStrategy Developer using the CData Software JDBC Driver for Sugar CRM.

• How to publish and share ADP dashboards with Tableau Server

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

• Build Charts with Zuora in Clear Analytics

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

• How to connect to BigQuery from IntelliJ

  Integrate connectivity to Google BigQuery with wizards in IntelliJ.

• Connect to Shippo in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Replicate Multiple Oracle Eloqua Accounts via the CData Sync CLI

  Replicate multiple Oracle Eloqua accounts to one or many databases.

• Connect to Zoho Projects in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Zoho Projects in the Denodo Virtual DataPort Administrator.

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

  Provide connectivity to SurveyMonkey through an SAP BusinessObjects universe.

• LINQ to Zendesk

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zendesk Data Provider.

• Access Live SQL Analysis Services in AWS Lambda

  Connect to live SQL Analysis Services in AWS Lambda using the CData JDBC Driver.

• Integrate Tally into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Tally ERP and integrate live Tally ERP into your Power Automate (Microsoft Flow) tasks.

• Access Live Veeva Vault in TIBCO Data Virtualization

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

• Automated Continuous SAS xpt Replication to PostgreSQL

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

• Create HarperDB-Connected Nintex Workflows

  Use CData Software Connect Server to connect to HarperDB from Nintex Workflow Cloud and build custom workflows using live HarperDB.

• Connect to Kintone in Aqua Data Studio

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

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

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Cloudant.

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

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

• Automate SAP SuccessFactors Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP SuccessFactors replication to Azure Data Lake.

• Build Excel Online-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Excel Online from Choreo and build custom apps using live Microsoft Excel Online.

• Visualize Xero from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Xero Accounting.

• Connect to Raisers Edge NXT in RazorSQL

  Connect to Raisers Edge NXT from wizards and query Raisers Edge NXT from the GUI in the RazorSQL database management tool.

• Build a Simple VCL Application for Jira

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

• Automated Continuous Active Directory Replication to SQL Server

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

• Connect to Blackbaud FE NXT in JRuby

  Create a simple JRuby app with access to live Blackbaud FE NXT.

• Extract, Transform, and Load Procore in Informatica PowerCenter

  Create a simple Workflow for Procore in Informatica PowerCenter.

• Automate Invoiced Integration Tasks from PowerShell

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

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

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

• How to Create Power BI Visual Reports with Real-Time Dynamics CRM

  Use CData Power BI Connectors to visualize Microsoft Dynamics CRM in Power BI.

• Build Dashboards with Oracle in Dundas BI

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

• Import Real-Time Azure DevOps via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Azure DevOps in ColdFusion.

• How to connect to Klipfolio from Google Apps Script

  Use CData Software Connect Server to access Klipfolio in Google Apps Script.

• Query Dropbox in DataGrip

  Create a Data Source for Dropbox in DataGrip and use SQL to query live Dropbox.

• Build QuickBooks Time-Connected Apps in Choreo

  Use CData Connect Cloud to connect to QuickBooks Time from Choreo and build custom apps using live QuickBooks Time.

• Query QuickBooks Online through ODBC in Node.js

  Use node-odbc to execute SQL queries against QuickBooks Online from Node.js.

• How to work with Avalara AvaTax in Apache Spark using SQL

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

• Enable the Drift JDBC Driver in KNIME

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

• Integrate with SAP Hybris C4C in JReport Designer

  Create charts and reports based on SAP Hybris C4C in JReport Designer.

• Connect to Google Contacts from a Connection Pool in JBoss

  Integrate Google Contacts into Java servlets: Use the Management Console in JBoss to install the Google Contacts JDBC Driver.

• Analyze SFTP in R via JDBC

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

• Create Presto Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Presto to build custom dashboards in Bold BI.

• Query Sybase in ColdFusion

  Write standard ColdFusion data access code to connect to Sybase.

• Connect to Zendesk in DBArtisan

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

• Import EnterpriseDB into FileMaker Pro

  Create reports that integrate EnterpriseDB in Filemaker Pro.

• Automate Sugar CRM Integration Tasks from PowerShell

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

• Connect to Live Salesforce Marketing in MicroStrategy through CData Connect Cloud

  Create a live connection to Salesforce Marketing in CData Connect Cloud and connect to your Salesforce Marketing Cloud from MicroStrategy.

• Connect to Redshift from PowerBuilder via JDBC

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

• Provide OData Services of Dynamics GP from a WCF Application

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

• Import eBay Analytics into FileMaker Pro

  Create reports that integrate eBay Analytics in Filemaker Pro.

• Connect to Microsoft Planner in Jaspersoft Studio

  Execute SQL to remote Microsoft Planner in Jaspersoft Studio.

• Build IBM Informix Visualizations in Tableau Desktop

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

• How to publish and share HarperDB dashboards with Tableau Server

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

• Create Dashboards and Visualize Live GMO MakeShop in Geckoboard

  Use CData Connect Cloud to connect to live GMO MakeShop and create dashboards for real-time monitoring and visualization in Geckoboard.

• Load Impala to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Impala to a database.

• Design BIRT Reports on Zoho Creator

  Provide current Zoho Creator to your embedded analytics.

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

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

• Connect to Dropbox in SpagoBI

  Create reports featuring live Dropbox in SpagoBI Studio. Host Dropbox reports on SpagoBI Server.

• How to create an RPA flow for Oracle Service Cloud in UiPath Studio

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

• Work with Snowflake in FoxPro

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

• How to Connect DBeaver to eBay Analytics via a JDBC Driver

  Manage eBay Analytics with visual tools in DBeaver like the query browser.

• Build Interactive Dashboards from XML in Amazon QuickSight

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

• Create Zenefits Dataflows on PowerBI.com

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

• DataBind Wijmo Grid to Quickbase

  Provide real-time Quickbase to interactive controls.

• Prepare, Blend, and Analyze Bullhorn CRM in Alteryx Designer (ODBC)

  Build workflows to access live Bullhorn CRM for self-service data analytics.

• How to integrate Azure Table with Apache Airflow

  Access and process Azure Table Storage in Apache Airflow using the CData JDBC Driver.

• Build Automated Workflows with Live SharePoint in Workato

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

• Connect to Azure Synapse in DBArtisan

  Use wizards in DBArtisan to configure Azure Synapse as a data source.

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

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

• How to use SQLAlchemy ORM to access SAP Netweaver Gateway in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Netweaver Gateway.

• Build an OLAP Cube in SSAS from Clio

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

• Connect to Real-Time Sage Intacct Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 385
• 386
• 387
• 388
• 389
• 390
• 391
• 392
• 393
• 394
• »