CData Software - Knowledge Base

Recent Articles

• «
• 167
• 168
• 169
• 170
• 171
• 172
• 173
• 174
• 175
• 176
• »

• Jira Service Management Reporting in OBIEE with the Jira Service Management JDBC Driver

  Deploy the Jira Service Management JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Automated Continuous JotForm Replication to PostgreSQL

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

• Integrate Live Vault CRM into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Veeva Vault & Vault CRM and integrate live Veeva Vault & Vault CRM into apps built in Microsoft Power Apps.

• Connect to Live Impala in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Impala in CData Connect Cloud and connect to your Apache Impala from PostgreSQL.

• Troubleshoot QuickBooks Errors

  In this entry you will find resolutions for the most common issues that can occur while connecting to QuickBooks.

• Analyze Redshift in Looker

  Use CData Connect Cloud to connect to Redshift from Looker and build custom apps using live Amazon Redshift.

• Create Power BI Reports on Real-Time Odoo

  Use the CData ODBC Driver for Odoo to visualize Odoo ERP in Power BI Desktop.

• DataBind Charts to Outreach.io

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

• Automated Continuous Impala Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Impala replication to Azure SQL Database.

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

  Use CData Power BI Connectors to visualize Basecamp in Power BI.

• A PostgreSQL Interface for Outreach.io using the CData ODBC Driver

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

• Query, Visualize, and Share live Azure Analysis Services in Redash

  Use CData Connect Cloud to connect to live Azure Analysis Services in Redash for querying, visualizing, and sharing.

• Integrate Real-Time Access to Snapchat Ads in SAPUI5 MVC Apps

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

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

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

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

  Provide connectivity to SAP Hybris C4C through an SAP BusinessObjects universe.

• Connect to SAP Netweaver Gateway in the Denodo Platform

  Use CData driver technologies to create a virtual data source for SAP Netweaver Gateway in the Denodo Virtual DataPort Administrator.

• How to pipe Todoist to CSV in PowerShell

  Use standard PowerShell cmdlets to access Todoist tables.

• How to Use a Microsoft Access Database to Update Teradata in Real Time

  Update Teradata data by creating a linked table in Microsoft Access with the CData Teradata ODBC Driver.

• Query Wave Financial in ColdFusion

  Write standard ColdFusion data access code to connect to Wave Financial.

• Validate Google Campaign Manager 360 with QuerySurge

  Access and validate Google Campaign Manager 360 in QuerySurge using the CData JDBC Driver.

• Excel Spreadsheet Automation on Google Cloud Storage with the QUERY Formula

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

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

• Replicate SAP Ariba Source to Multiple Databases

  Replicate SAP Ariba Source to disparate databases with a point-and-click configuration.

• Automated Continuous NetSuite Replication to Oracle

  Use CData Sync for automated, continuous, customizable NetSuite replication to Oracle.

• Connect to Oracle Financials Cloud from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Financials Cloud using standard SQL.

• Use the CData API Server to Access Zuora in Microsoft PowerPivot

  Use the CData API Server to connect to live Zuora in the Power Pivot business intelligence tool.

• Automated Continuous Vault CRM Replication to Amazon S3

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

• Publish Dynamics CRM-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics CRM.

• Consume Google Analytics OData Feeds in PowerBuilder

  This article demonstrates how to consume Google Analytics as OData feeds from PowerBuilder using the API Server.

• Query Sage 200 in DataGrip

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

• Connect to Coinbase in DBeaver

  Use the CData ODBC Driver to connect to Coinbase in DBeaver.

• Automate MailChimp Replication to Azure Synapse

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

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

  Provide connectivity to TigerGraph through an SAP BusinessObjects universe.

• Access Live Quickbase in TIBCO Data Virtualization

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

• Excel Files as Data Sources Using CData ADO.NET Providers

  Bjoern Meyer from Text Control explores using the CData Data Providers with TX Text Control Words, the Text Control Reporting template designer.

• Connect to xBase from PowerBuilder via ODBC

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

• Automate EventBrite Replication to Azure Synapse

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

• Access Live Sage 50 UK in Coginiti Pro

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

• Analyze Cvent in R via ODBC

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

• Connect to PayPal from HeidiSQL

  Use CData Connect Cloud to connect to and query live PayPal from HeidiSQL.

• Working with FHIR in LINQPad

  Execute LINQ queries to FHIR in LINQPad.

• Connect to XML in Aqua Data Studio

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

• Use the CData Software ODBC Driver for Azure Table in MicroStrategy Desktop

  Connect to Azure Table Storage in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Table.

• Automated Continuous SAP BusinessObjects BI Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Azure SQL Database.

• Connect to QuickBooks Online from HeidiSQL

  Use CData Connect Cloud to connect to and query live QuickBooks Online from HeidiSQL.

• Connect to GMO MakeShop in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access GMO MakeShop in Google Apps Script.

• Access Live Epicor Kinetic in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live Epicor Kinetic from your Excel spreadsheets.

• Analyze eBay in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of eBay and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Integrate Vault CRM into Power Automate Desktop using CData Connect

  CData Connect for Vault CRM enables you to integrate Veeva Vault & Vault CRM into workflows built using Microsoft Power Automate Desktop.

• Connect to and Visualize Live Sybase IQ in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sybase IQ.

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

  Use CData JDBC drivers to import and use NetSuite CRM & ERP in ColdFusion.

• Access Live Sage 200 in AWS Lambda (with IntelliJ IDEA)

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

• Build a Singer.io Tap for Jira With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Jira data using

• Create Trello Dataflows on PowerBI.com

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

• Enable the SAP JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with SAP ERP/NetWeaver.

• Automated Continuous Exact Online Replication to MySQL

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

• Build Automated MySQL-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live MySQL and build automated workflows in Zapier.

• Work with Live Zoho Projects in Power Query

  Use CData Connect Cloud to connect to Zoho Projects and work with live Zoho Projects in Microsoft Power Query.

• Integrate Greenplum with External Services using SnapLogic

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

• How to connect to LinkedIn Ads from IntelliJ

  Integrate connectivity to LinkedIn Ads with wizards in IntelliJ.

• Building Dynamic Web Pages with SAP Hybris C4C Using AngularJS

  Create single-page applications with live connectivity to SAP Hybris C4C using the CData API Server.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed SAP SuccessFactors to Power BI dashboards. Simply drag and drop SAP SuccessFactors into data visuals on the Power BI canvas.

• Build Data Flows from HDFS to SQL Server using SSIS

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

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

  Create an ODBC connection to NetSuite in Informatica and browse and transfer NetSuite CRM & ERP.

• Build NetSuite-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live NetSuite CRM & ERP.

• Operational Reporting on Raisers Edge NXT from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Raisers Edge NXT.

• Visualize Facebook in TIBCO Spotfire through ODBC

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

• Automated Continuous HDFS Replication to SQLite

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

• Build Jira-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Atlassian Jira.

• Import Google Campaign Manager 360 into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Google Campaign Manager 360 and provide access to live Google Campaign Manager 360 for custom reports in the Power BI Service.

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

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

• Establish a Live Connection with Xero using Tableau Bridge

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

• Build an OLAP Cube in SSAS from Google Cloud Storage

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

• Connect to Live Microsoft Exchange in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Microsoft Exchange in CData Connect Cloud and connect to your Microsoft Exchange from PostgreSQL.

• Integrate with Couchbase in JReport Designer

  Create charts and reports based on Couchbase in JReport Designer.

• Connect to Azure Table as an External Source in Dremio

  Use the CData JDBC Driver to connect to Azure Table as an External Source in Dremio.

• Create Data Visualizations in Cognos BI with Azure Data Lake Storage

  Access Azure Data Lake Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Stream SurveyMonkey into Apache Kafka Topics

  Access and stream SurveyMonkey in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Continuous ServiceNow Replication to Oracle

  Use CData Sync for automated, continuous, customizable ServiceNow replication to Oracle.

• Natively Connect to XML in PHP via ODBC (Linux)

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

• Connect to Salesforce Data Cloud in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

  Use the Salesforce ODBC Driver to create workflows that access real-time Salesforce & Force.com without any coding.

• Connect to CouchDB in the Denodo Platform

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

• Build Apps with Live Reckon in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Reckon into the Adalo platform and build custom mobile and web applications with real-time Reckon.

• Using the CData Software ODBC Driver for Bullhorn CRM in PyCharm

  Connect to Bullhorn CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bullhorn CRM.

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

• «
• 167
• 168
• 169
• 170
• 171
• 172
• 173
• 174
• 175
• 176
• »