Cloud Cruiser became HPE Consumption Analytics on Nov. 1st. You'll still see the old name in places while we update this site.

 

 

Consumption Analytics Documentation

Home > Cloud Cruiser 3 > Setting Up Collection > Steps for all collectors > Setting up a data source

Setting up a data source

To connect to the source from which they will collect data, many collectors require information such as a URL and access credentials. This information is collectively called a data source. You can define a data source directly within the job XML, which is called an explicit data source, or create a managed data source in the HPE Consumption Analytics Portal Portal and refer to it from the job.

Explicit data source

An explicit data source sets all connection information directly on the bean, which means credentials are embedded in plain text in the XML file. For example, an explicit data source for the JDBC collector can be set up as:

<bean class="com.cloudcruiser.batch.CCRecordCollectTasklet">
  <property name="feedName" value="jdbcSample"/>
  <property name="collector">
    <bean id="sampleJdbcReader" class="com.cloudcruiser.batch.collect.SmartJdbcCollector">
      <property name="feedConfig" ref="feedConfig"/>
      <property name="dataSourceConfig">
        <bean class="com.cloudcruiser.batch.collect.JdbcDataSourceConfig">
          <property name="url" value="jdbc:jtds:sqlserver://127.0.0.1::1433/ccdb"/>
          <property name="username" value="cloudcollect"/>
          <property name="password" value="1234"/>
        </bean>
      </property>
    </bean>
  </property>
</bean>

An explicit data source is convenient when developing jobs, but is less secure and can increase maintenance complexity when credentials change.

Managed data source

A managed data source is securely maintained in the HPE Consumption Analytics Portal database and is referenced by name from one or more jobs. Because a managed data source is more secure than an explicit one, and because it gives you a single place to maintain connection information to a system from which you collect data, the best practice is to use a managed data source.

To set up a managed data source

  1. Go to Data > Data Sources.
  2. Click plus_icon.png at the bottom of the list.
  3. Enter a name for the data source, use the drop-down menu to select a type, and click OK.
  4. In the following page, enter values for all fields.
    These fields vary by data source type. See the section for your data source under
    Native collectors or Universal collectors for a description of these fields.
  5. (optional) Click Test Connection to test the data source parameters, then make corrections if the test fails.

    ​A failed test is usually the result of network problems or bad credentials. To troubleshoot, try these steps:

    1. Verify the username and password by using them to log into the target system from its native interface.
    2. Verify that the HPE Consumption Analytics Portal computer can reach the computer specified in the data source by pinging the latter from the former.
  6. Click Save.

Database driver for a JDBC data source

If you create a managed JDBC data source, you need to specify a database driver for it. For a Microsoft SQL Server data source, the driver you need is located at <install_dir>/lib/jtds-1.2.6.jar.

To set up or modify a database driver

  1. Go to Data > Data Sources and select your JDBC data source.
  2. Click Manage Drivers, then click the ‘+’ icon to add a new driver.
  3. Enter a Driver Name and, optionally, fill out other fields with relevant information.
  4. Click Add Files to upload JDBC driver files.
    The JDBC driver is a file with the extension .jar (some drivers need more than one file).
  5. Choose your files, then click OK.
  6. Click Save.
Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP