Installation Prerequisites

Important: Restart server after installing .NET core hosting bundle

Setting up

Install Longview Tidemark Adapter.
Open CXO Configurator>Maintenance and click Register Services and Websites.
Select Register Longview Tidemark Adapter Api to add service account details.
Create Client in the CXO Identity Provider.

Create new Generic Client.
Select Allow Offline Access option.
Add the following scopes:
1. User profile
2. User groups
Add Redirect URL(s) in the following format:
{LongviewTidemarkAdapterUrl}/signin-oidc
Add Post Logout Redirect URL(s) in the following format:
{LongviewTidemarkAdapterUrl}/signin-oidc-auth

RedirectUri’s are case sensitive so it’s good practice to use lowercase in all URLs.

To use Longview Tidemark Adapter you need a license key with Longview enabled

Initialize the Longview adapter. This needs to be one time for the initial setup and is performed by running a few commands which require few parameters as an input.
For more information on the available commands and their parameters, run the CXO.Adapter.LongviewTidemark.Cli.exe help command for detailed descriptions.
Open command line as Administrator, browse to the Longview Tidemark Adapter\Extraction folder and run the initialize command to create the configuration database.

Command	initialize
Parameters	server-name: Name of the server on which the database should be created database-name: Name of the database to be created authentication-type: windows / proprietary username: SQL user name (if authentication-type = proprietary) password: SQL user password (if authentication-type = proprietary)
Example	`.\CXO.Adapter.LongviewTidemark.Cli.exe initialize server-name:cxo-dev-sql02 database-name:CXO.Adapter.LongviewTidemark.Configuration authentication-type:Proprietary username:cxo password:somePassword`

Run the set-authentication-settings command to set up the identity provider values

Command	set-authentication-settings
Parameters	idp-authority: URL to IDP setup idp-client-id: The client id set in IDP idp-client-secret: The client secret from IDP idp-client-allowed-user-group: The user group that is allowed to use the Longview Adapter
Example	`.\CXO.Adapter.LongviewTidemark.Cli.exe set-authentication-settings idp-authority:https://cxoUrl/idp idp-client-id:LongviewClientUI idp-client-secret:secret idp-client-allowed-user-group:ADM`

Create a new source system in the SSM for the correct source type: Longview to create:
- Fact database
- SSAS cube
- It’s recommended to use the same source name in the SSM as in the command below, otherwise scheduling extractions will not work
Run the create-source-in-adapter command to create a new Longview source.

IMPORTANT: At this point you can decide the type of Longview source as either Longview Close or Longview Tax. This selection cannot be changed after source creation!
Longview Plan and Longview Close work the same way. Similarly, Longview Tax and Transfer Pricing work the same way. But if you want to integrate with Longview Plan, you need to select Longview Close, and if you want to connect to Transfer Pricing, you will have to select Longview Tax.

Command	create-source-in-adapter
Parameters	source-type: longview-close/longview-tax source-name: Name of source to be created. This should be the same name as was used in the SSM factdb-name: Name of the fact database that was created via SSM factdb-server: SQL server on which the fact database is hosted factdb-authentication-type: Integer value indicating how to authenticate with fact database: 0 = proprietary, 1 = windows. factdb-username (optional): SQL username in case of proprietary authentication factdb-password (optional): SQL password in case of proprietary authentication ssas-server-name: SQL server on which the SSAS cube is hosted ssas-database-name: name of the SSAS database ssas-cube-name: name of the SSAS cube within the database, should be “CXO“ for regular scenarios. first-period (optional): the first period in case the customer works with a broken book year. Example: Apr. Note: Currently only works for Longview-Close sources.
Example	`.\CXO.Adapter.LongviewTidemark.Cli.exe create-source-in-adapter source-type:longview-close source-name:MyLongviewCloseSource factdb-name:cxo_fact_MyLongviewCloseSource factdb-server:cxo-dev-sql02 factdb-authentication-type:1 ssas-server-name:cxo-dev-as01 ssas-database-name:MyLongviewCloseSource ssas-cube-name:CXO first-period:Apr`

After running the above commands, the adapter is configured, and a first source is available. When multiple sources are required, run the create-source-in-adapter command for each source that is required.
Each source is created with a default configuration for dimensions, Longview symbol names, etc. These defaults need to be changed for the source to function properly. This is explained in the Longview Adapter - User Interface Guide