Accelo – Lyftron

Overview

The Lyftrondata Provider for Accelo offers the most natural way to access Accelo data from Lyftrondata 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 Accelo data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftrondata’s Accelo 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 Accelo.
Comprehensive full support of ANSI Sql to query data with ease.
Collaborative query processing.

Prerequisites

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

Establishing a Connection with Lyftrondata's Quickstart Steps

Create your Accelo connection with Lyftrondata 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 Accelo 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 Accelo connection with Lyftrondata.

Key	Value	Field
Connection Name	Enter your connection details	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 Lyftrondata logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftrondata, click on Lyftrondata 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 Lyftrondata logging and debugging section, to debug the error.

Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftrondata Accelo connector and can utilize the connector to E xtract, Warehouse, Analyze, Visualize and Share your data.

Data Model

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

Generally, querying APIs 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. These types of situations are clearly documented at the top of the table page linked below.

Name	Type	Description
Activities	Tables	Returns a list of activities on the Accelo deployment.
ActivityClasses	Tables	Returns a list of activity classes.
ActivityContactsInteractions	Tables	Returns an array of contact objects that have an interaction against the activity.
ActivityCountInteractions	Tables	Returns a count of the activity interactions listed against the activity identified..
ActivityStaffInteractions	Tables	Returns an array of staff objects that have an interaction against the activity.
ActivityThreads	Tables	Returns information on timed logged and the value charged against a collection of activities.
ActivityTimeAllocations	Tables	Returns information on timed logged and the value charged against a collection of activities.
Addresses	Tables	Returns the address information of companies and contacts on the Accelo deployment.
Affiliations	Tables	Returns a list of affiliation objects on the deployment.
AffiliationStatus	Tables	Returns the status of an affiliation specified by its AffiliationId.
AffiliationStatuses	Tables	Returns a list of affiliation statuses on the deployment.
Assets	Tables	Returns a list of assets on the Accelo deployment.
AssetTypes	Tables	Returns a list of asset types.
Companies	Tables	Returns a list of companies from the Accelo deployment.
CompanyAddresses	Tables	Returns the address information of a given company.
CompanyContacts	Tables	Returns a list of contacts for a company identified by its CompanyId.
CompanyMainContact	Tables	Returns the main contact of a company identified by its CompanyId. This is the contact associated with the company's default affiliation.
CompanyManagers	Tables	Returns a list of managers for a company identified by its CompanyId.
CompanySegmentations	Tables	Returns a list of company segmentations for a company identified by its CompanyId.
CompanyStatus	Tables	Returns the status of a company specified by its CompanyId.
CompanyStatuses	Tables	Returns a list of company statuses on the deployment.
ContactAddresses	Tables	Returns the address information of a given contact.
Contacts	Tables	Returns a list of contacts from the Accelo deployment.
ContactSegmentations	Tables	Returns a list of contact segmentations for a contact identified by its ContactId.
ContactStatus	Tables	Returns the status of a contact specified by its ContactId.
ContactStatuses	Tables	Returns a list of contact statuses on the deployment.
ContractPeriod	Tables	Returns a single contract period object from the Accelo deployment.
ContractPeriods	Tables	Returns a list of contract periods for a contract, specified by its ContractId.
Contracts	Tables	Returns a list of contracts from the Accelo deployment.
ContractStatuses	Tables	Returns a list of contract statuses on the deployment.
ContractTypes	Tables	Returns a list of contract types on the Accelo deployment.
Contributors	Tables	Returns a list of contributors from the Accelo deployment.
ContributorTypes	Tables	Returns a list of contributor types on the deployment.
CountActivityClasses	Tables	Returns a count of the number of activity classes listed.
CountActivityThreads	Tables	Returns a count of the number of activity threads listed.
CountAddresses	Tables	Returns a count of the addresses listed.
CountAffiliations	Tables	Returns a count of the affiliations listed.
Expenses	Tables	Returns a list of expenses from the Accelo deployment.
ExpenseTypes	Tables	Returns a list of expense types on the deployment.
Filters	Tables	Returns a list of saved filters on the Accelo deployment. This list will not include any filters created by other users which have not been shared.
Invoices	Tables	Returns a list of invoices from the Accelo deployment.
IssueClasses	Tables	Returns a list of issue classes on the deployment.
IssuePriorities	Tables	Returns a list of issue priorities.
IssueResolutions	Tables	Returns a list of issue resolutions.
Issues	Tables	Returns a list of issues from the Accelo deployment.
IssueStatuses	Tables	Returns a list of issue statuses on the deployment.
IssueTypes	Tables	Returns a list of issue types.
JobCollections	Tables	Returns a list of collections of a job, specified by its JobId
JobMilestones	Tables	Returns a list of milestones of a job, specified by its JobId
Jobs	Tables	Returns a list of jobs (projects) from the Accelo deployment.
JobStatuses	Tables	Returns a list of job statuses on the deployment.
JobTypes	Tables	Returns a list of job types.
LatestModifiedCompanies	Tables	Returns the most recently changed companies on the Accelo deployment.
LatestModifiedContacts	Tables	Returns a list of contacts on the Accelo deployment sorted by the most recently modified.
LatestModifiedJobs	Tables	Returns a list of job on the deployment, sorted by the most recently modified, that is in descending order of DateModified.
Milestones	Tables	Returns a list of milestones from the Accelo deployment.
MilestoneStatuses	Tables	Returns a list of milestone statuses on the deployment.
ObjectBudgets	Tables	Returns a list of object budget from the Accelo deployment.
ObjectBudgetsMaterials	Tables	Returns a list of materials on the deployment.
ObjectBudgetsServices	Tables	Returns a list of services on the deployment.
ObjectBudgetsTemplates	Tables	Returns a list of item templates on the deployment.
ProspectProbabilities	Tables	Returns a list of all probabilities on the deployment.
Prospects	Tables	Returns a list of prospects on deployment.
ProspectStatus	Tables	Returns the prospect status of a prospect, identified by its ProspectId.
ProspectStatuses	Tables	Returns a list of prospect statuses on the deployment.
ProspectTypes	Tables	Returns a list of prospect types on the deployment.
Purchases	Tables	Returns a list of purchases on deployment.
QuoteCollections	Tables	Returns a list of collections against an quote, specified by its QuoteId
Quotes	Tables	Returns a list of quotes on deployment.
QuoteStatuses	Tables	Returns a list of quote statuses on the deployment.
Rates	Tables	Returns a list of rates on deployment.
RecentCompanies	Tables	Returns the most recently created companies on the Accelo deployment
RecentContacts	Tables	Returns a list of contacts on the Accelo deployment sorted by the most recently created.
RecentIssues	Tables	a list of issues on the deployment sorted by most recently submitted, that is, in descending order of DateSubmitted.
RecentJobs	Tables	Returns a list of job on the deployment, sorted by the most recently created, that is in descending order of DateCreated.
Referrals	Tables	Returns a list of referrals on deployment.
Requests	Tables	Returns a list of requests on deployment.
RequestThreads	Tables	Returns a list of request threads on the deployment.
Resources	Tables	Returns a list of resources on deployment.
Segmentations	Tables	Returns a list of segmentations for the deployment.
SignOffs	Tables	Returns a list of signoffs for the deployment.
SignoffsAttachments	Tables	Returns a list of attachments for the deployment.
SignoffsRecipients	Tables	Returns a list of all recipients for the deployment.
Skills	Tables	Returns a list of skills on deployment.
Staff	Tables	Returns a list of staff members on deployment.
StaffMemberships	Tables	Returns a list of staff memberships for the deployment.
Tags	Tables	Returns a list of tags on deployment.
Tasks	Tables	Returns a list of tasks on deployment.
TaskStatuses	Tables	Returns a list of task statuses on the deployment.
ThreadActivities	Tables	Returns a count of the activity interactions listed against the activity identified..
TimeExternals	Tables	Returns a list of time externals on deployment.
Timers	Tables	Returns a list of timers on deployment.
User	Tables	Returns current user information.

Advanced Settings

To view a detailed advanced settings options, go to Accelo Advanced Settings. Complete list of the parameters you can configure in the connection string can be found by clicking Connection String Parameters.

{[{category.name}]}