SAP Concur

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

Prerequisites

The user must have credentials for SAP Concur, 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 SAP Concur 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 SAP Concur 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 SAP Concur connection with Lyftron.

"InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;"

Key	Value	Field
Connection Name	Enter your connection details	Required
InitiateOAuth	GETANDREFRESH	Required
OAuthClientId	Your SAP Concur OAuthClientId	Required
OAuthClientSecret	Your SAP Concur OAuthClientSecret	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 SAP Concur connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

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

Generally, querying SAP Concur 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. 

Name	Type	Description
Attendees	Tables	Create, update, delete, and query all attendees owned by the specified user.
AttendeeTypes	Tables	Create, update, delete, and query all active attendee types for the company.
Entries	Tables	Create, update, delete, and query all expense entries owned by the user.
EntryAttendeeAssociations	Tables	Create, update, delete, and query all entry-attendee associations owned by the user. These are the associations between an expense entry and an attendee.
Itemizations	Tables	Create, update, delete, and query all expense itemizations owned by the user.
ListItems	Tables	Create, update, delete, and query all list items based on the search criteria.
Lists	Tables	Create, update, delete, and query all lists based on the search criteria.
QuickExpenses	Tables	Create, update, delete, and query all quick expenses owned by the user.
ReceiptImages	Tables	Create, update, delete, and query all receipt Ids owned by the user.
Reports	Tables	Create, update, delete, and query all reports owned by the user.
Allocations	Views	Lists all allocations per entry or report.
CompanyCardTransactions	Views	Retrieves corporate or credit card charges that are available for use in expense reports.
DigitalTaxInvoices	Views	Gets all digital tax invoices that can be validated by the user based on the search criteria.
ExpenseDelegators	Views	Retrieves the list of users that have granted delegate permissions to you.
ExpenseGroupConfigurationAttendeeTypes	Views	Lists the Attendee Types of the Expense Group Configurations.
ExpenseGroupConfigurationPaymentTypes	Views	Lists the payment types of the Expense Group Configurations.
ExpenseGroupConfigurationPolicies	Views	Lists the policies of Expense Group Configurations.
ExpenseGroupConfigurationPolicyExpenseTypes	Views	Lists the expense types for the Expense Group Configuration Policies.
ExpenseGroupConfigurations	Views	Lists the configurations of expense groups.
FormFields	Views	Query expense form fields.
Forms	Views	Query expense forms.
Locations	Views	Retrieve details of locations that are used by Concur and that are valid at the company of the user.
Notifications	Views	Lists notifications that have failed.
Opportunities	Views	Gets opportunities for a specified trip or for all trips that fall within a date range.
PaymentBatches	Views	Lists all the payment batches.
Suppliers	Views	Lists Suppliers based on the search criteria.
TripBookingPassengers	Views	Lists the passengers for a trip booking.
TripBookings	Views	Query all the bookings for a trip.
TripBookingSegmentCharges	Views	Query all the charges for a trip.
TripBookingSegments	Views	Query all the bookings for a trip.
TripBookingSegmentSeats	Views	Query all the seats for a trip.
Trips	Views	Query all the trips.
Users	Views	Lists user data based on the search criteria.