Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note: To use the Longview Adapter you require a license key with Longview enabled.

  1. Create a new source system in the SSM for the correct source type: Longview to create:

    • Fact database

    • SSAS cube

  2. Initialize the Longview adapter and the source. This 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.

  3. Open command line as Administrator, browse to the Longview adapter folder and run the initialize command to create the configuration database.

Info

Avoid using spaces in the parameter values.

...

To update the connection fields, run the following command with the correct values and source name. When certain values do not need to be replaced, remove those parameters. Especially use this command when updating password. If password is updated by SQL update query it will not be encrypted, running this command updates and encrypts the password.

Command

set-lv-source-configuration

Parameters

  • source: Name of source for which longview connection is set

  • url (optional): Longview connection URL

  • username (optional): Longview connection username

  • password (optional): Longview connection password

  • listener-port (optional): Longview connection listener port

  • access (optional): Longview connection access

  • user-group (optional): Longview connection user group

  • instance-id (optional): Longview connection instance id

Example

.\CXO.Adapter.LongviewTidemark.Cli.exe set-lv-source-configuration source:MyLongviewTaxSource url:http://longview.tax.com username:daniel password:secret_password listener-port:8000 access:V3_COMPATIBLE_ACCESS user-group:Admin instance-id:LVTax

.\CXO.Adapter.LongviewTidemark.Cli.exe set-lv-source-configuration source:MyLongviewTaxSource password:secret_password

.\CXO.Adapter.LongviewTidemark.Cli.exe set-lv-source-configuration source:MyLongviewTaxSource

Other option to update the connection fields is by running the following query with the correct values and source name. When certain values do not need to be replaced, remove those lines from the queryto be replaced, remove those lines from the query. This update query should not be used for updating the Password value since it will not be encrypted. Use the above command for updating password.

QUERY 2

Code Block
languagesql
update  sc
set     sc.Url = '...',
        sc.UserName = '...',
        sc.Password = '...',
        sc.ListenerPort = 0,
        sc.Access = '...',
        sc.UserGroup = '...',
        sc.InstanceId = '...'
from    LVSourceConfiguration sc
join    Source s on sc.SourceId = s.Id
where   s.Name = 'SOURCE NAME HERE'

...

Code Block
languagesql
update  sc
set     sc.Url = 'https://example-url-to-longview-source.com',
        sc.UserName = 'Administrator',
        sc.Password = 'secret_password'
from    LVSourceConfiguration sc
join    Source s on sc.SourceId = s.Id
where   s.Name = 'MyLongviewSource'

...

For updating dimension configuration of a Longview source:

  1. Create a new dimension mapping from a Longview dimension to a CXO dimension.

  2. Remove an existing dimension mapping from a Longview dimension to a CXO dimension.

  3. Update symbol names, symbol attributes and/or dimension description for a mapped Longview dimension.

  4. Create a new member attribute mapping.

  5. Remove an existing member attribute mapping.

If you want to map a Longview dimension mapping to a CXO dimension that already has a Longview dimension mapped to it, first remove the existing mapping before adding the new mapping.

...