CData Software - Knowledge Base

Recent Articles

• «
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• »

• Connect to Dynamics CRM in Jaspersoft Studio

  Execute SQL to remote Microsoft Dynamics CRM in Jaspersoft Studio.

• A PostgreSQL Interface for Azure Data Catalog

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

• Process & Analyze QuickBooks Time in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live QuickBooks Time .

• Create Informatica Mappings From/To a JDBC Data Source for IBM Informix

  Create IBM Informix data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Replicate Multiple ConstantContact Accounts

  Replicate multiple ConstantContact accounts to one or many databases.

• Query Dynamics NAV as a MySQL Database in Node.js

  Execute MySQL queries against Microsoft Dynamics NAV from Node.js.

• Connect to GitHub from PowerBuilder

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

• How to Connect to & Open DocuSign in Microsoft Excel

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

• Build Charts with Sage Intacct in Clear Analytics

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

• Author and Share Power BI Reports on Real-Time SAP Ariba Procurement

  Use the CData ODBC Driver for SAP Ariba Procurement to visualize SAP Ariba Procurement in Power BI Desktop and then upload to the Power BI service.

• How to create Spark federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache Spark SQL in MySQL .

• Automated Continuous Google Contacts Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Google Contacts replication to Apache Cassandra.

• Connect to SAP BusinessObjects BI in Jaspersoft Studio

  Execute SQL to remote SAP BusinessObjects BI in Jaspersoft Studio.

• Connect to Sage Intacct in DBeaver

  Use the CData ODBC Driver to connect to Sage Intacct in DBeaver.

• Viewing Harvest in RAD Studio Data Explorer

  How to view Harvest in RAD Studio Data Explorer using the CData ODBC Driver for Harvest.

• How to Connect DBeaver to Unbounce via a JDBC Driver

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

• Explore Geographical Relationships in HBase with Power Map

  Create data visualizations with Apache HBase in Power Map.

• Author and Share Power BI Reports on Real-Time Outreach.io

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

• Connect to SAP HANA from PowerBuilder

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

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

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

• Connect to Slack in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous Snapchat Ads Replication to Amazon S3

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

• Access REST from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live REST from HeidiSQL.

• Automated Continuous Dynamics CRM Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Apache Cassandra.

• Create Informatica Mappings From/To an ODBC Data Source for IBM Cloud Data Engine

  Create an ODBC connection to IBM Cloud Data Engine in Informatica and browse and transfer IBM Cloud Data Engine.

• Provide OData Services of Oracle Eloqua from a WCF Application

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

• LINQ to Office 365

  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 Office 365 Data Provider.

• Operational Reporting on Harvest from Spotfire Server

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

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

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

• Connect to Drift from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Drift to connect to Drift from Web applications running on WebLogic.

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

  Provide connectivity to Microsoft Dynamics CRM through an SAP BusinessObjects universe.

• Analyze Google Ads in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Google Ads and visualize Google Ads in SAP Analytics Cloud.

• Automated PostgreSQL Replication to Teradata

  Use CData Sync to Customize and automate PostgreSQL replication to Teradata.

• Connect to Google Analytics in DBArtisan

  Use wizards in DBArtisan to configure Google Analytics as a data source.

• Integrate with Facebook in JReport Designer

  Create charts and reports based on Facebook in JReport Designer.

• Connect to Workday from Crystal Reports

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

• Connect to Azure Synapse through External Services in Salesforce

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

• Visualize Zoho Inventory in TIBCO Spotfire through ADO.NET

  Integrate Zoho Inventory into dashboards in TIBCO Spotfire.

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

  Connect to Freshdesk 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.

• Connect to Instagram in JRuby

  Create a simple JRuby app with access to live Instagram.

• Query Snowflake as a SQL Server Database in Node.js

  Execute SQL Server queries against Snowflake from Node.js.

• How to Access Google Analytics Using Entity Framework

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

• Access Live Bitbucket in Coginiti Pro

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

• Build BigQuery Visualizations in Tableau Desktop

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

• Integrate Live Coinbase into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Coinbase and integrate live Coinbase into apps built in Microsoft Power Apps.

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

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

• Build Semantic Layer Views for xBase in APOS Live Data Gateway

  Use the CData Connector for xBase in APOS Live Data Gateway to build Semantic Layer Views for xBase.

• Access Facebook Ads in PHP through Connect Server

  Connect to Facebook Ads through the standard SQL Server libraries in PHP.

• Automate Google Directory Replication to Couchbase

  Use CData Sync to Customize and automate Google Directory replication to Couchbase.

• Analyze SAP HANA in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of SAP HANA and visualize SAP HANA in SAP Analytics Cloud.

• Query MYOB AccountRight through ODBC in Node.js

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

• Connect to Zendesk in Google Apps Script

  Use the ODBC Driver for Zendesk and the SQL Gateway to access Zendesk from Google Apps Script.

• Import Real-Time RSS Feeds in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use RSS Feeds in ColdFusion.

• Analyze Oracle HCM Cloud with Power Pivot

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

• Connect to Klaviyo from PowerBuilder

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

• Build Dashboards with QuickBooks Online in Dundas BI

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

• Create SharePoint Reports on JasperReports Server

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

• Import JSON Services into FileMaker Pro

  Create reports that integrate JSON in Filemaker Pro.

• Prepare, Blend, and Analyze Redis in Alteryx Designer

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

• Perform Batch Operations with Oracle Service Cloud in Apache NiFi

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

• Connect to Jira Service Management in Jaspersoft Studio

  Execute SQL to remote Atlassian Jira Service Management in Jaspersoft Studio.

• How to Build Dynamic React Apps with Todoist

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

• Connect to Live Oracle Eloqua in MicroStrategy through CData Connect Cloud

  Create a live connection to Oracle Eloqua in CData Connect Cloud and connect to your Oracle Eloqua from MicroStrategy.

• Automated Continuous Quickbase Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Quickbase replication to Amazon Redshift.

• Automate SAP BusinessObjects BI Replication to Couchbase

  Use CData Sync to Customize and automate SAP BusinessObjects BI replication to Couchbase.

• Access Live Pipedrive in TIBCO Data Virtualization

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

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

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

• Visualize SingleStore in TIBCO Spotfire through OData

  Integrate SingleStore into dashboards in TIBCO Spotfire.

• Connect to Act-On in NetBeans

  Connect to Act-On in NetBeans with the data source configuration wizard.

• Use the CData SSIS Components to Insert New or Update Existing GitHub Records from SQL Server

  Easily push SQL Server data to GitHub using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into GitHub or update existing records with data from a SQL Server database.

• Model Google Contacts Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Google Contacts, enabling the direct import of real-time Google Contacts.

• Replicate Shippo to Multiple Databases

  Replicate Shippo to disparate databases with a point-and-click configuration.

• Connect to GraphQL through External Services in Salesforce

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

• Explore Geographical Relationships in Google Contacts with Power Map

  Create data visualizations with Google Contacts in Power Map.

• A PostgreSQL Interface for Salesloft

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

• Integrate Real-Time Access to Salesforce Marketing in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Marketing Cloud in real time.

• Bidirectional Access to BigQuery from FileMaker Pro

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

• Model, Search, and Visualize Live SharePoint in ThoughtSpot

  Use CData Connect Cloud to connect to live Microsoft SharePoint for modeling, searching, and visualizing.

• Use the CData Software ODBC Driver for Pinterest in MicroStrategy

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

• Access Live Email in TIBCO Data Virtualization

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

• Feed Jira into FineReport

  How to set Atlassian Jira as a JDBC data source in FineReport.

• DataBind Charts to Smartsheet

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

• Connect to TaxJar from PowerBuilder

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

• Create Reports with Twitter in SAP Crystal Reports

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

• Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy Desktop

  Connect to Google Ad Manager in MicroStrategy Desktop using the CData Software JDBC Driver for Google Ad Manager.

• Access Azure Data Lake Storage from MySQL in PHP

  Connect to Azure Data Lake Storage through the standard MySQL libraries in PHP.

• How to Build Dynamic React Apps with HBase

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

• Extract, Transform, and Load SAS xpt in Informatica PowerCenter

  Create a simple Workflow for SAS XPORT in Informatica PowerCenter.

• Build Interactive Dashboards from Printify in Amazon QuickSight

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

• Build Pipelines with Live Jira Service Management in Google Cloud Data Fusion (via CData Connect Cloud)

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

• Automate Excel Online Replication to Azure Data Lake

  Use CData Sync to customize and automate Microsoft Excel Online replication to Azure Data Lake.

• Enable the Zendesk JDBC Driver in KNIME

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

• Connect to and Query Salesloft in QlikView over ODBC

  Create data visualizations with Salesloft in QlikView.

• Import Drip into FileMaker Pro

  Create reports that integrate Drip in Filemaker Pro.

• Automated Continuous IBM Informix Replication to Snowflake

  Use CData Sync for automated, continuous, customizable IBM Informix replication to Snowflake.

• Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Desktop

  Connect to SAP Netweaver Gateway in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Netweaver Gateway.

• Build an OLAP Cube in SSAS from CouchDB

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

• Build Dynamics 365-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Microsoft Dynamics 365 and build web apps with connectivity to live Microsoft Dynamics 365.

• Access IBM Informix from MySQL in PHP

  Connect to IBM Informix through the standard MySQL libraries in PHP.

• Automated Continuous Hive Replication to Google BigQuery

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

• «
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• »