Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Installation Prerequisites

  • CXO Version 21.3.3 (or higher)

  • .NET 5.0 has to be installed

Installation

  • Install Longview Adapter

CXO configuration and source creation

Note: To be able to use the Longview Adapter you need a license key with Longview enabled.

  • Create a new source system in the SSM for the correct source type: Longview. This should create:

    • Fact database

    • SSAS cube

  • In the next steps you will run a few commands to initialize the Longview adapter and the source. These commands need a few parameters for input, please avoid using spaces in the parameter values.
    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 adapter 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:longview_adapter_configuration authentication-type:Proprietary username:cxo password:somePassword

  • Then run the create-source-in-adapter command to create a new Longview source.

    IMPORTANT: Here you decide the type of Longview source: Longview Close or Longview Tax. This cannot be changed after source creation!

Command

create-source-in-adapter

Parameters

  • source-type: longview-close / longview-tax

  • source-name: name of source to be created

  • 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.

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

  • After running these commands the adapter is configured and a first source is available. When multiple sources are required, run the create-source-in-adapter for each source needed.

  • T

  • Configure Longview adapter

    • Run command to initialize adapter

    • Run command to create a new source

    • Configure symbols, etc.

    • Run commands to extract metadata and data

  • No labels