...
Note: To use the Longview Adapter you require a license key with Longview enabled.
Create a new source system in the SSM for the correct source type: Longview to create:
Fact database
SSAS cube
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 theCXO.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.
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 |
|
Example |
|
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 | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
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:
Create a new dimension mapping from a Longview dimension to a CXO dimension.
Remove an existing dimension mapping from a Longview dimension to a CXO dimension.
Update symbol names, symbol attributes and/or dimension description for a mapped Longview dimension.
Create a new member attribute mapping.
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.
...