Concur V2 Connector is a hierarchical connector that interacts with the Concur service through the REST API to perform operations on non-relational hierarchical data.
You can use Concur V2 Connector to perform read, create, update, or delete operations on objects in Concur. For example, you can read expense object data through the GET or GET by ID operation associated with the object.
Create a Concur V2 connection to connect to Concur from Data Integration and interact with the Concur service to perform operations on non-relational hierarchical data. You can use the Concur V2 connection in mappings and mapping tasks.
You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.
Create a mapping task to process data based on the data flow logic defined in a mapping. Concur V2 Connector has the following features:
•You can use the request message XML editor to specify the request parameters to perform a specific operation in Concur.
•When you run a mapping task, the Secure Agent interacts with the Concur service through the REST API to perform operations on non-relational hierarchical data and converts the data into relational groups.
•You can parameterize the connection and XML request attributes in a mapping.
•Concur V2 Connector uses version 3.0 of Concur API.
When you set up a Concur V2 connection, you can specify a hybrid OAuth 2 or a new OAuth 2 connection.
Example
You are an operation manager and you want to archive the travel and list of expense details of employees who have been traveling across the globe in the past one year. You can find the travel and list of expense details in Concur based on the employee ID, retrieve data through the Get operation on the GetAllLists object, and then write the details to an Oracle database target. With Concur V2 Connector, you retrieve the employee data in an XML structure and then define a corresponding relational structure to write to the relational target.