CData Software - Knowledge Base

Recent Articles

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

• DataBind Wijmo Grid to Zuora

  Provide real-time Zuora to interactive controls.

• Access Live Avro in TIBCO Data Virtualization

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

• Work with FHIR in FoxPro

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

• Access Klaviyo in PHP through Connect Server

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

• Automated Continuous Veeva Vault Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Veeva Vault replication to Microsoft Access.

• Connect to LinkedIn in Ruby

  Connect to LinkedIn in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Import Google Spanner Using Azure Data Factory

  Use CData Connect Cloud to connect to Google Spanner from Azure Data Factory and import live Google Spanner.

• Operational Reporting on Amazon DynamoDB from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Amazon DynamoDB.

• Connect to Live YouTube Analytics in MicroStrategy through CData Connect Cloud

  Create a live connection to YouTube Analytics in CData Connect Cloud and connect to your YouTube Analytics from MicroStrategy.

• A PostgreSQL Interface for Box (MySQL Remoting via JDBC)

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

• Connect to Redis in Jaspersoft Studio

  Execute SQL to remote Redis in Jaspersoft Studio.

• Access Klipfolio from MySQL in PHP

  Connect to Klipfolio through the standard MySQL libraries in PHP.

• Build Visualizations of Outreach.io in Birst

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

• Automated Continuous ConstantContact Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable ConstantContact replication to OneLake in Microsoft Fabric.

• Visualize Live Azure Synapse in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Azure Synapse into custom reports in Power BI.

• Automated Continuous BigCommerce Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable BigCommerce replication to Google BigQuery.

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

  Provide connectivity to TaxJar through an SAP BusinessObjects universe.

• Access Google Spanner in PHP through Connect Server

  Connect to Google Spanner through the standard SQL Server libraries in PHP.

• Automated Continuous LinkedIn Ads Replication to SQLite

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

• Analyze Acumatica in Looker

  Use CData Connect Cloud to connect to Acumatica from Looker and build custom apps using live Acumatica ERP.

• Edit and Search External Elasticsearch Objects in Salesforce Connect

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

• Use JayDeBeApi to access SAP Netweaver Gateway in Python

  Use standard Python scripting and the development environment of your choice to access live SAP Netweaver Gateway.

• DataBind SAP BusinessObjects BI to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for SAP BusinessObjects BI with the DevExpress Windows Forms and Web controls to provide SAP BusinessObjects BI to a chart.

• Create Teradata-Connected Nintex Workflows

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

• Visualize Live Zenefits in Tableau

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

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

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

• Automated Continuous Active Directory Replication to Apache Kafka

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

• Build DocuSign-Connected Apps in Choreo

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

• How to connect to SAP HANA XS Advanced in DBVisualizer

  Integrate SAP HANA XS Advanced with visual data analysis tools and data connection wizards in DBVisualizer

• Using AngularJS to Build Dynamic Web Pages with Twitter

  Use the CData Connect Server to create Twitter OData feeds and build single-page applications with live Twitter.

• Integrate with Sybase IQ using Apache Camel2

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

• PowerShell Scripting to Replicate Printful to MySQL

  Write a simple PowerShell script to replicate Printful to a MySQL database.

• Deploy the ADO.NET Provider for GraphQL on an SSRS Report Server

  Connect to GraphQL from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Create Xero-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Xero from Klipfolio and build custom visualizations using live Xero Accounting.

• Use Biml to Build SSIS Tasks to Replicate SAP Netweaver Gateway to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Netweaver Gateway to SQL Server.

• Build Oracle Sales-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Oracle Sales from Zoho Analytics and import live Oracle Sales.

• Connect to and Visualize Live Okta in Tableau Prep

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

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

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

• How to Build Dynamic React Apps with Greenplum

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

• How to Build an ETL App for Procore in Python with CData

  Create ETL applications and real-time data pipelines for Procore in Python with petl.

• Create Dashboards and Visualize Live Google Calendar in Geckoboard

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

• Using the CData Software ODBC Driver for Salesforce Pardot in PyCharm

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

• Query Typeform in DataGrip

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

• Dynamics NAV Reporting in OBIEE with the Dynamics NAV JDBC Driver

  Deploy the Dynamics NAV JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to Act CRM in HULFT Integrate

  Connect to Act CRM as a JDBC data source in HULFT Integrate

• A PostgreSQL Interface for Sybase IQ using the CData ODBC Driver

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

• Access Live OneNote in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live Microsoft OneNote from your Google Sheets.

• Access Live Amazon Marketplace in TIBCO Data Virtualization

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

• Query Zuora through ODBC in Node.js

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

• Create Reports with OneNote in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft OneNote.

• Sugar CRM Cloud Connectivity

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

• Automated Continuous YouTube Analytics Replication to Vertica

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

• Bidirectional Access to Reckon from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Reckon in Filemaker Pro for Mac or Windows.

• Automated Continuous Amazon Athena Replication to SQLite

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

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

• How to connect to Sage 300 from MS Excel on Mac OS X

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

• Connect to Google Spanner in Ruby

  Connect to Google Spanner in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Access Live Google Ads in TIBCO Data Virtualization

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

• Automated Continuous Act-On Replication to Vertica

  Use CData Sync for automated, continuous, customizable Act-On replication to Vertica.

• Explore Geographical Relationships in Office 365 with Power Map

  Create data visualizations with Microsoft Office 365 in Power Map.

• Analyze Stripe with Power Pivot

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

• Connect to Sage 200 in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Sage 200 and connect to Sage 200 in Akorbi Digital RunMyProcess.

• Build WordPress Visualizations in Tableau Desktop

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

• Visualize Elasticsearch in Tableau

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

• Query Spark through ODBC in Node.js

  Use node-odbc to execute SQL queries against Apache Spark SQL from Node.js.

• Build Data Flows from SQL Server to Cvent through SSIS

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

• How to Access Google Contacts Using Entity Framework

  This article shows how to access Google Contacts using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• How to Build an ETL App for SFTP in Python with CData

  Create ETL applications and real-time data pipelines for SFTP in Python with petl.

• DataBind Wijmo Grid to xBase

  Provide real-time xBase to interactive controls.

• Connect to Amazon S3 from PowerBuilder via ODBC

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

• Visualize Live YouTube Analytics in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live YouTube Analytics into custom reports in Power BI.

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

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

• Integrate with Sage Intacct using Apache Camel2

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

• Query Airtable as a MySQL Database in Node.js

  Execute MySQL queries against Airtable from Node.js.

• Query Oracle Financials Cloud through ODBC in Node.js

  Use node-odbc to execute SQL queries against Oracle Financials Cloud from Node.js.

• Operational Reporting on Twilio from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Twilio.

• How to publish and share Freshdesk dashboards with Tableau Server

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

• Connect to Tableau CRM Analytics from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Tableau CRM Analytics, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Create Cosmos DB Reports on JasperReports Server

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

• Integrate Real-Time Access to Monday.com in SAPUI5 MVC Apps

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

• A PostgreSQL Interface for CockroachDB using the CData ODBC Driver

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

• Build Data Flows from Clio to SQL Server using SSIS

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

• Build an MVC Application with Connectivity to QuickBooks

  CData ADO.NET Providers can be used from many tools and IDEs. In this article we show how to connect to QuickBooks from an MVC project using the CData ADO.NET Provider for QuickBooks. Although this article uses the QuickBooks Data Provider, the same process can be used with any of the CData ADO.NET Providers.

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

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

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

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

• Create Datasets from SQL Server in Domo Workbench and Build Visualizations of SQL Server in Domo

  Use the CData Software ODBC Driver for SQL Server to create datasets from Microsoft SQL Server in Domo Workbench and then build visualizations in the Domo service.

• Automated Continuous SAP SuccessFactors Replication to IBM DB2

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

• DocuSign Reporting in OBIEE with the DocuSign JDBC Driver

  Deploy the DocuSign JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to Visualize Azure DevOps Data in Python with pandas

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

• Manage WooCommerce in DBArtisan as a JDBC Source

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

• How to pipe Xero to CSV in PowerShell

  Use standard PowerShell cmdlets to access Xero tables.

• Visualize Live ActiveCampaign in Tableau

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

• Build a Simple VCL Application for Twitter

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

• Feed Amazon S3 into FineReport

  How to set Amazon S3 as a JDBC data source in FineReport.

• How to Easily Query Marketo in OpenOffice Base

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