...

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.

...

• 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

.

• Each source is created with a default configuration for dimension mappings, Longview symbol names, etc. These defaults need to be changed for the source to function properly. The next section explains how to configure the Longview sources.

Longview Source Configuration

A newly created Longview source needs additional configuration to function properly. Since the Longview adapter currently does not have a user interface, these configurations have to be done by running SQL scripts on the Longview configuration database.

Longview Connection

To show the currently configured connection information for the sources in the Longview adapter, run the following query on the configuration database:

select	s.Name, 
		Type = CASE 
			 WHEN s.Type =  1 THEN 'Longview Close'
			 WHEN s.Type =  2 THEN 'Longview Tax'
			 ELSE 'Unknown'
		END,
		sc.Url,
		sc.UserName,
		sc.Password,
		sc.ListenerPort,
		sc.Access, 
		sc.UserGroup,
		sc.InstanceId
from    Source s
join    LVSourceConfiguration sc on sc.SourceId = s.Id

The results of this query shows per source the URL to the Longview instance, the username and password to authenticate with the Longview system and a few other Longview-specific fields. The values for these fields should be provided by people managing the Longview system to connect to.

To update the connection fields, run the following query with the correct source name:

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'