Learn more
 

CData Software - Knowledge Base

Recent Sugar CRM Articles

Connect to Sugar CRM as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Sugar CRM.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sugar CRM

Provide connectivity to Sugar CRM through an SAP BusinessObjects universe.

Enable the Sugar CRM JDBC Driver in KNIME

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

Create Informatica Mappings From/To a JDBC Data Source for Sugar CRM

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

Configure the CData JDBC Driver for Sugar CRM in a Connection Pool in Tomcat

Connect to Sugar CRM from a connection pool in Tomcat.

How to Connect to Sugar CRM in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Sugar CRM. Leverage the pyodbc module for ODBC in Python.

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

Connect to and Visualize Live Sugar CRM in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sugar CRM.

Build Dashboards with Sugar CRM in Dundas BI

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

Publish Sugar CRM-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Sugar CRM.

How to Connect to & Open Sugar CRM in Microsoft Excel

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

Create Informatica Mappings From/To an ODBC Data Source for Sugar CRM

Create an ODBC connection to Sugar CRM in Informatica and browse and transfer Sugar CRM.

Connect to Sugar CRM in Jaspersoft Studio

Execute SQL to remote Sugar CRM in Jaspersoft Studio.

Create SSAS Tabular Models from Sugar CRM

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

How to Access Sugar CRM Using Entity Framework

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