Sugar CRM

The Lyftron Provider for Sugar CRM offers the most natural way to access Sugar CRM data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Sugar CRM data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Sugar CRM data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

• Comprehensive Delta load mechanism.
• Real-time access to Sugar CRM.
• Comprehensive full support of ANSI Sql to query data with ease.
• Collaborative query processing.

Prerequisites

The user must have credentials for Sugar CRM, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

Establishing a Connection with Lyftron's Quickstart Steps

Create your Sugar CRM connection with Lyftron by following the 5 easy steps show below:

Step1. Add your connection

Click on Connect section on the left panel →  Click on Add Connection button

Step2. Select your connector

In the connector selection panel, search and click Sugar CRM for your connection 

Step3. Enter your connection details

In the Connection String section enter the values of the below parameters. The following connection string is required to establish Sugar CRM connection with Lyftron.

URL=[your_url];User=[your_User];Password=[your_Password];

Key	Value	Field
Connection Name	Enter your connection details	Required
URL	http://mySugarCRM.com	Required
User	your SugarCRM User.	Required
Password	your Sugar Password	Required
Logfile**	Use the logfile option to debug your job and provide your connection name to generate the log file.  [ConnectionConfigurationPath]\Connection_name_log.tx	Optional
Verbosity**	Choose verbosity 1-5 based on the severity of debugging	Optional

** For more information, check the Lyftron logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.

Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.

Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron Sugar CRM connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

The provider models the data in SugarCRM into a list of tables that can be queried using standard SQL statements.

Generally, querying SugarCRM tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. 

Views

Name	Type	Description
Accounts	Tables	Create, update, delete, and query the Accounts module in SugarCRM.
ACLRoles	Tables	Create, update, delete, and query the ACLRoles module in SugarCRM.
Activities	Tables	Create, update, delete, and query the Activities module in SugarCRM.
Administration	Tables	Create, update, delete, and query the Administration module in SugarCRM.
Bugs	Tables	Create, update, delete, and query the Bugs module in SugarCRM.
Calls	Tables	Create, update, delete, and query the Calls module in SugarCRM.
CampaignLog	Tables	Create, update, delete, and query the CampaignLog module in SugarCRM.
Campaigns	Tables	Create, update, delete, and query the Campaigns module in SugarCRM.
CampaignTrackers	Tables	Create, update, delete, and query the CampaignTrackers module in SugarCRM.
Cases	Tables	Create, update, delete, and query the Cases module in SugarCRM.
Comments	Tables	Create, update, delete, and query the Comments module in SugarCRM.
Contacts	Tables	Create, update, delete, and query the Contacts module in SugarCRM.
Contracts	Tables	Create, update, delete, and query the Contracts module in SugarCRM.
ContractTypes	Tables	Create, update, delete, and query the ContractTypes module in SugarCRM.
Currencies	Tables	Create, update, delete, and query the Currencies module in SugarCRM.
CustomQueries	Tables	Create, update, delete, and query the CustomQueries module in SugarCRM.
DataSets	Tables	Create, update, delete, and query the DataSets module in SugarCRM.
DocumentRevisions	Tables	Create, update, delete, and query the DocumentRevisions module in SugarCRM.
Documents	Tables	Create, update, delete, and query the Documents module in SugarCRM.
EAPM	Tables	Create, update, delete, and query the EAPM (external API module) in SugarCRM.
EmailAddresses	Tables	Create, update, delete, and query the EmailAddresses module in SugarCRM.
EmailMarketing	Tables	Create, update, delete, and query the EmailMarketing module in SugarCRM.
Emails	Tables	Create, update, delete, and query the Emails module in SugarCRM.
EmailTemplates	Tables	Create, update, delete, and query the EmailTemplates module in SugarCRM.
Employees	Tables	Create, update, delete, and query the Employees module in SugarCRM.
Filters	Tables	Create, update, delete, and query the Filters module in SugarCRM.
ForecastManagerWorksheets	Tables	Create, update, delete, and query the ForecastManagerWorksheets module in SugarCRM.
Forecasts	Tables	Create, update, delete, and query the Forecasts module in SugarCRM.
ForecastSchedule	Tables	Create, update, delete, and query the ForecastSchedule module in SugarCRM.
ForecastWorksheets	Tables	Create, update, delete, and query the ForecastWorksheets module in SugarCRM.
InboundEmail	Tables	Create, update, delete, and query the InboundEmail module in SugarCRM.
KBDocuments	Tables	Create, update, delete, and query the KBDocuments module in SugarCRM.
Leads	Tables	Create, update, delete, and query the Leads module in SugarCRM.
Manufacturers	Tables	Create, update, delete, and query the Manufacturers module in SugarCRM.
Meetings	Tables	Create, update, delete, and query the Meetings module in SugarCRM.
Notes	Tables	Create, update, delete, and query the Notes module in SugarCRM.
Notifications	Tables	Create, update, delete, and query the Notifications module in SugarCRM.
OAuthKeys	Tables	Create, update, delete, and query the OAuthKeys module in SugarCRM.
OAuthTokens	Tables	Create, update, delete, and query the OAuthTokens module in SugarCRM.
Opportunities	Tables	Create, update, delete, and query the Opportunities module in SugarCRM.
PdfManager	Tables	Create, update, delete, and query the PdfManager module in SugarCRM.
ProductCategories	Tables	Create, update, delete, and query the ProductCategories module in SugarCRM.
Products	Tables	Create, update, delete, and query the Products module in SugarCRM.
ProductTemplates	Tables	Create, udpate, delete, and query the ProductTemplates module in SugarCRM.
ProductTypes	Tables	Create, udpate, delete, and query the ProductTypes module in SugarCRM.
Project	Tables	Create, update, delete, and query the Project module in SugarCRM.
ProjectTask	Tables	Create, update, delete, and query the ProjectTask module in SugarCRM.
ProspectLists	Tables	Create, update, delete, and query the ProspectLists module in SugarCRM.
Prospects	Tables	Create, update, delete, and query the Prospects module in SugarCRM.
Quotas	Tables	Create, update, delete, and query the Quotas module in SugarCRM.
Quotes	Tables	Create, update, delete, and query the Quotes module in SugarCRM.
Releases	Tables	Create, update, delete, and query the Releases module in SugarCRM.
ReportMaker	Tables	This is a table representing the ReportMaker module in SugarCRM.
Reports	Tables	This is a table representing the Reports module in SugarCRM.
Reports_1	Tables	This is a table representing the Reports module in SugarCRM.
RevenueLineItems	Tables	This is a table representing the RevenueLineItems module in SugarCRM.
Roles	Tables	This is a table representing the Roles module in SugarCRM.
SavedSearch	Tables	This is a table representing the SavedSearch module in SugarCRM.
Schedulers	Tables	This is a table representing the Schedulers module in SugarCRM.
Shippers	Tables	This is a table representing the Shippers module in SugarCRM.
Styleguide	Tables	This is a table representing the Styleguide module in SugarCRM.
Subscriptions	Tables	This is a table representing the Subscriptions module in SugarCRM.
SugarFavorites	Tables	This is a table representing the SugarFavorites module in SugarCRM.
Tasks	Tables	This is a table representing the Tasks module in SugarCRM.
TaxRates	Tables	This is a table representing the TaxRates module in SugarCRM.
TeamNotices	Tables	This is a table representing the TeamNotices module in SugarCRM.
Teams	Tables	This is a table representing the Teams module in SugarCRM.
TimePeriods	Tables	This is a table representing the TimePeriods module in SugarCRM.
TrackerPerfs	Tables	This is a table representing the TrackerPerfs module in SugarCRM.
TrackerQueries	Tables	This is a table representing the TrackerQueries module in SugarCRM.
Trackers	Tables	This is a table representing the Trackers module in SugarCRM.
TrackerSessions	Tables	This is a table representing the TrackerSessions module in SugarCRM.
Users	Tables	This is a table representing the Users module in SugarCRM.
UserSignatures	Tables	This is a table representing the UserSignatures module in SugarCRM.
WebLogicHooks	Tables	This is a table representing the WebLogicHooks module in SugarCRM.
WorkFlow	Tables	This is a table representing the WorkFlow module in SugarCRM.
Audit	Views	Ceate, update, delete, and query the Audit module in SugarCRM.