CData Software - Knowledge Base

Recent Articles

• «
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• 299
• 300
• 301
• »

• Connect to IBM Cloud Object Storage from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage and execute queries in PowerBuilder.

• Automated Continuous Tally Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Tally replication to MongoDB.

• Using AngularJS to Build Dynamic Web Pages with RSS Feeds

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

• How to import Shopify into Apache Solr

  Use the CData Software JDBC Driver for Shopify in Data Import Handler and create an automated import of Shopify to Apache Solr Enterprise Search platform.

• Connect to FHIR through External Services in Salesforce

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

• Build Dashboards with Zoho Projects in Dundas BI

  Create dynamic dashboards and perform analytics based on Zoho Projects in Dundas BI.

• How to Access Asana Using Entity Framework

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

• How to Work with Sage Cloud Accounting in AWS Glue Jobs Using JDBC

  Connect to Sage Cloud Accounting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Use JayDeBeApi to access CockroachDB in Python

  Use standard Python scripting and the development environment of your choice to access live CockroachDB.

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

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

• Build Dashboards with Snowflake in Dundas BI

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

• Automated Continuous Jira Service Management Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Jira Service Management replication to Amazon S3.

• Access SQL Analysis Services from MySQL in Amazon QuickSight

  Connect to SQL Analysis Services and build visualizations of SQL Analysis Services using a MySQL Connection in Amazon QuickSight.

• Integrate xBase into Automated Tasks with Power Automate

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

• Publish Reports with SAP Business One in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Business One.

• Replicate Snowflake to Multiple Databases

  Replicate Snowflake to disparate databases with a single configuration.

• Manage Blackbaud FE NXT in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Blackbaud FE NXT.

• Analyze GitHub in Looker

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

• Query DocuSign in ColdFusion

  Write standard ColdFusion data access code to connect to DocuSign.

• Back Up Microsoft OneDrive to SQL Server through SSIS

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

• How to Query Live Harvest Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Harvest data in natural language using Python.

• Use Biml to Build SSIS Tasks to Replicate Spark to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Spark SQL to SQL Server.

• Build Automated Workflows with Live Databricks in Workato

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

• Connect to Jira Assets in SpagoBI

  Create reports featuring live Jira Assets in SpagoBI Studio. Host Jira Assets reports on SpagoBI Server.

• Access Dynamics CRM 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 Microsoft Dynamics CRM.

• Build Dynamics 365-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Dynamics 365 from Zoho Analytics and import live Microsoft Dynamics 365.

• Use the CData Software ODBC Driver for Google Calendar in MicroStrategy Desktop

  Connect to Google Calendar in MicroStrategy Desktop using the CData Software ODBC Driver for Google Calendar.

• Create Facebook Ads-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Facebook Ads from Klipfolio and build custom visualizations using live Facebook Ads.

• Build Visualizations of xBase in Birst

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

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

• How to Build Dynamic React Apps with Facebook

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

• Integrate with Twitter Ads in JReport Designer

  Create charts and reports based on Twitter Ads in JReport Designer.

• Extract, Transform, and Load Certinia in Informatica PowerCenter

  Create a simple Workflow for Certinia in Informatica PowerCenter.

• How to Visualize Dynamics NAV Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Microsoft Dynamics NAV in Python.

• Create SendGrid-Connected Nintex Workflows

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

• How to Connect DBeaver to Twitter via a JDBC Driver

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

• Create Hive Dataflows on PowerBI.com

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

• Create SSAS Tabular Models from Harvest

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

• Perform Batch Operations with Odoo in Apache NiFi

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

• Automated Continuous MongoDB Replication to SingleStore

  Use CData Sync for automated, continuous, customizable MongoDB replication to SingleStore.

• Access Dropbox from MySQL in PHP

  Connect to Dropbox through the standard MySQL libraries in PHP.

• Build Dashboards with Zoho CRM in DBxtra

  Create dynamic dashboards and perform analytics based on Zoho CRM in DBxtra.

• Replicate Xero for Use in Salesforce Connect

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

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

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

• Access Live Slack in AWS Lambda

  Connect to live Slack in AWS Lambda using the CData JDBC Driver.

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

  Provide connectivity to SAS XPORT through an SAP BusinessObjects universe.

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

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

• DataBind Charts to Raisers Edge NXT

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

• Bridge ActiveCampaign Connectivity with Apache NiFi

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

• How to Connect to & Open Zendesk in Microsoft Excel

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

• Access Act CRM from MySQL in Amazon QuickSight

  Connect to Act CRM and build visualizations of Act CRM using a MySQL Connection in Amazon QuickSight.

• Automated Continuous Veeva Replication to SingleStore

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

• Connect to SAP ByDesign in HULFT Integrate

  Connect to SAP ByDesign as a JDBC data source in HULFT Integrate

• Publish Reports with SAS xpt in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAS XPORT.

• Replicate Multiple Google Directory Accounts

  Replicate multiple Google Directory accounts to one or many databases.

• Prepare, Blend, and Analyze HBase in Alteryx Designer

  Build workflows to access live Apache HBase for self-service data analytics.

• Manage BigQuery in DBArtisan as a JDBC Source

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

• Query, Visualize, and Share live Marketo in Redash

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

• Connect to SendGrid in DBeaver

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

• Connect to and Visualize Live Shopify in Tableau Prep

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

• Integrate with Salesloft in JReport Designer

  Create charts and reports based on Salesloft in JReport Designer.

• Query Confluence in MySQL Workbench

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

• How to connect to Oracle HCM Cloud from IntelliJ

  Integrate connectivity to Oracle HCM Cloud with wizards in IntelliJ.

• A PostgreSQL Interface for SingleStore

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

• How to load Gmail data into Elasticsearch via Logstash

  Introducing a simple method to load Gmail data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Connect to Stripe from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Stripe from Crystal Reports.

• Integrate Dynamics CRM in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dynamics CRM from Informatica Cloud.

• Connect to LinkedIn Ads in Aqua Data Studio

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

• Import and Visualize Neo4J in Power View

  Create data visualizations based on Neo4J in Excel.

• Build Spark-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Spark from Zoho Analytics and import live Apache Spark SQL.

• Visualize Stripe in TIBCO Spotfire through OData

  Integrate Stripe into dashboards in TIBCO Spotfire.

• Analyze CockroachDB in Looker

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

• Query Dynamics NAV in DataGrip

  Create a Data Source for Dynamics NAV in DataGrip and use SQL to query live Microsoft Dynamics NAV.

• Build Oracle SCM-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Oracle SCM and build web apps with connectivity to live Oracle SCM.

• How to Use CData Connect to Access Live Clio in Power Automate

  CData Connect for Clio enables you to integrate Clio into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous Amazon Athena Replication to SingleStore

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

• How to import SAP into Apache Solr

  Use the CData Software JDBC Driver for SAP in Data Import Handler and create an automated import of SAP ERP/NetWeaver to Apache Solr Enterprise Search platform.

• Replicate Multiple SAP BusinessObjects BI Accounts

  Replicate multiple SAP BusinessObjects BI accounts to one or many databases.

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

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

• Query Instagram in MySQL Workbench

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

• Use Dash to Build to Web Apps on Acumatica

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

• How to Access NetSuite Using Entity Framework

  This article shows how to access NetSuite CRM & ERP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Use the CData Software ODBC Driver for Printful in MicroStrategy Desktop

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

• Use the CData ODBC Driver for Asana in Microsoft Power Query

  You can use the CData Asana ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Asana into Microsoft Power Query.

• LINQ to Twitter

  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 Twitter Data Provider.

• Connect to Impala from PowerBuilder

  This article demonstrates how to access Apache Impala from Appeon PowerBuilder using the CData ADO.NET Provider for Impala.

• Using AngularJS to Build Dynamic Web Pages with Procore

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

• Integrate with Salesforce using Apache Camel2

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

• Create Dynamic Microsoft Dataverse Grids Using the Infragistics XamDataGrid

  Learn how you can connect Microsoft Dataverse to Infragistics XamDataGrid to build dynamic grids.

• How to connect PolyBase to Excel

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Excel.

• Connect to and Visualize Live Azure Data Lake Storage in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Data Lake Storage.

• Connect to Salesforce Marketing from a Connection Pool in JBoss

  Integrate Salesforce Marketing Cloud into Java servlets: Use the Management Console in JBoss to install the Salesforce Marketing JDBC Driver.

• Using AngularJS to Build Dynamic Web Pages with SQL Analysis Services

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

• Access Live Snowflake in TIBCO Data Virtualization

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

• How to Visualize SAP Ariba Source Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SAP Ariba Source in Python.

• Automated Continuous Greenplum Replication to Apache Kafka

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

• Working with Coinbase in LINQPad

  Execute LINQ queries to Coinbase in LINQPad.

• Query Twitter in DataGrip

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

• Back Up Snapchat Ads to SQL Server through SSIS

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

• Connect to Hive in the Denodo Platform

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

• «
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• 299
• 300
• 301
• »