Using the Adapter Setup Wizard

Accessing and Navigating the Adapter Setup Wizard

To access the Adapter Setup wizard, open SAS IT Resource Management and select Newthen selectIT Resource Managementthen selectAdapter Setup. To navigate through the pages of the wizard, use the following wizard buttons:
Help
displays a Help topic for the current window.
Cancel
abandons changes that were made since the last save and closes the current window.
Back
displays the previous window in the wizard.
Next
displays the next window in the wizard.
Finish
saves changes that were made since the last save and closes the current window.

Steps to Complete the Adapter Setup Wizard

The Adapter Setup wizard guides you through several steps that help define the ETL jobs, staged tables, summarized aggregation tables, information maps, and Gallery transformations for the selected adapter. The steps vary based on the requirements of the adapter that you select.
Here are all of the possible steps or pages that the Adapter Setup wizard can present for a given adapter:
  • Specify an adapter for your input data source.
  • Specify the configuration level that controls the scope and amount of output jobs.
  • Specify the IT data mart.
  • Specify staging parameters such as the location of the raw data and how to handle duplicate data.
  • Select domain categories for the selected adapter.
  • Select the time periods for which you want to create aggregation jobs and report jobs.
  • Specify the location of any user-written formulas.
  • Specify the SAS Content Server for report packages.
  • View a summary of the specifications that you have chosen and the ETL objects that the Adapter Setup wizard creates when the resulting jobs are executed.

Creating Jobs Using the Adapter Setup Wizard

The Adapter Setup wizard enables you to define and create the ETL jobs that are required to process your IT resource data. Because the Adapter Setup wizard can create jobs without deploying them, you do not need to run the Adapter Setup wizard frequently for a given adapter. For best results, run the Adapter Setup wizard initially for a given adapter and do not run it again for the same adapter unless you have significant changes in how you would like to process input data. Running the Adapter Setup wizard additional times does not update the jobs, transformations, or tables from the previous runs. Instead, it creates new jobs, transformations, and tables.
To specify all of the necessary parameters that the Adapter Setup wizard requires to create the jobs for an adapter, perform the following steps:
  1. From the SAS IT Resource Management menu, select Newthen selectIT Resource Managementthen selectAdapter Setup to open the Adapter Setup wizard.
  2. Specify the adapter for which you want to create jobs.
    Specify the Adapter
    Specify the Adapter Page
    1. Click the adapter that you want to use from the list of the adapters provided. You can move the cursor over an adapter to a view a tooltip that provides the full name of the adapter, any former names of the adapter, and information about the types of data that the adapter provides. The remaining pages and parameters that are presented in the Adapter Setup wizard are based on the specific adapter that you select on this page.
      Note: The AS/400 and IMS adapters are not available for selection on this page. The staging code that is required for these data sources is not automated by the Adapter Setup wizard. However, SAS IT Resource Management supplies staging transformations for these adapters. You can use these staging transformations to create staging jobs manually for these data sources. For more information about how to create a staging job manually using a staging transformation, see Add a Staging Transformation to a Staging Job.
      For more information about the specific adapters that SAS IT Resource Management supports, see Supported Adapters.
    2. Click Next.
  3. Specify the configuration level that represents the scope of output jobs that you want the Adapter Setup wizard to create.
    Note: If you are using an adapter that does not include aggregations that are categorized with configuration levels, then the level is automatically set to create a staging job only and this page does not display.
    Specify the Level of Output
    Specify the Level of Output Page
    Configuration levels enable you to specify the general scope or amount of aggregation tables and jobs that you want the Adapter Setup wizard to create. These levels provide various presentations of granularity in the data based on the aggregations and metrics that are available for an adapter. The jobs that are created for each level include the metrics that are used in the reports for that level. These jobs might also include other metrics that have been predetermined to be useful for reporting on the given level.
    Configuration levels are unique for each adapter. However, in some cases, the levels can be identical for a given adapter. For more information about the metrics and aggregations that are supported for each adapter, see the SAS IT Resource Management metrics documentation. To locate the SAS IT Resource Management documentation, use the Products Index at http://support.sas.com/documentation/index.html.
    To specify the level of output, complete the following steps:
    1. Select one of the following configuration levels:
      Staging Job Only
      creates a staging job only for the adapter. If you select this option, no aggregation jobs, information map jobs, or reporting jobs are created.
      Minimal
      creates a staging job and additional jobs that include metrics, aggregations, and report definitions for a small number of reports. This level is for reporting on a small scale. You might use this level to create jobs that are related to low-priority, non-critical machines.
      Typical
      creates a staging job and a robust set of jobs that include metrics, aggregations, and report definitions for a typical set of reports. This level includes all of the jobs that are part of the Minimal level. In addition, it includes metrics, aggregations, and jobs that IT Resource Management has identified as being of interest for the selected adapter. You might use this level to create jobs that are related to mission critical resources.
      This configuration level is the default option.
      Full
      creates a staging job and a comprehensive set of jobs that include most metrics, aggregations, and report definitions that SAS IT Resource Management supports. This level includes all of the jobs that are part of the Typical level. In addition, it includes many of the other metrics that are recommended for an adapter. You might use this level when you want the full benefits of the domain intelligence that is available with the IT Resource Management solution as well as additional information from the full set of metrics that are available from the adapter data sources.
      Note: Increasing the configuration level results in more complex transformations and jobs. If you select Full when you need only the Typical level, then the extra complexity causes the Adapter Setup wizard to be slower to complete than is necessary for your needs. Also, the nightly ETL jobs will take longer to process.
    2. Click Next.
  4. Specify the IT data mart where you want to save the ETL jobs that the Adapter Setup wizard will create, or create a new IT data mart.
    Specifying the IT Data Mart
    Specify an IT Data Mart Page
    1. Select an IT data mart from the list of available IT data marts. If you do not want to use one of the data marts in the list, then click New IT Data Mart. This action launches a wizard that guides you through the process of creating and defining a new IT data mart. When you are finished, the wizard returns you to the Adapter Setup wizard.
    2. Click Next.
  5. Specify staging parameters for the selected adapter. Staging parameters vary by adapter as they specify the configurations that are required to extract, transform, and load specific raw data into staged tables. The following image is an example of the staging parameters for the DT Perf Sentry adapter:
    Specifying Staging Parameters for the Adapter
    Staging Parameters Page
    1. Specify the staging parameters in order to govern how you want the staging code to execute for the adapter. The parameters that are marked with an asterisk (*) require a value. All other parameters do not require a value.
      You can also click Reset for a given staging parameter to use the default value if there is one available for the parameter. If the default value is already selected, then the Reset option is not available. You can also click Reset to defaults to set all the staging parameters to the default values.
      Note: Reset to defaults does not reset a parameter that is dependent on another parameter if the parent parameter does not change.
      For more information about the staging parameters that are available for each adapter, see Staging Parameters.
    2. Click Next.
      Note: If you selected the adapter VMware vCenter, then the Adapter Setup wizard presents two pages of staging parameters: one for VMware Data Acquisition jobs and one for VMware vCenter jobs. For more information about accessing raw data for the VMware vCenter adapter, see Data Sources Supported by SAS IT Resource Management Adapters.
  6. Specify one or more domain categories that you want the Adapter Setup wizard to use when creating the resulting jobs.
    Note: If you are using an adapter that does not have aggregation and information map jobs available from the Adapter Setup wizard, then the wizard creates only a staging job and skips this page.
    Select the Domain Categories for the Adapter
    Select Domain Categories Page
    The preceding example shows the domain categories that are available for the DT Perf Sentry adapter. All of the domain categories that are related to Server data have been selected. Note that the description in the box on the right corresponds with the domain category that is highlighted in the Select domain categories box.
    The Adapter Setup wizard helps you manage system performance by enabling you to select only the domain categories that are essential to the performance management and capacity planning processes for your enterprise. The Adapter Setup wizard creates a predefined set of jobs based on the domain categories that you select. The time that the Adapter Setup wizard takes to create the jobs varies based on the number of staged tables, aggregation jobs, and report jobs that are generated for the domain categories that you select.
    Note: If you are using an adapter that does not include domain categories, then this page does not display.
    For more information about domain categories, see Domain Categories.
    1. Click one or more domain categories to enable or disable the domain category for staging and aggregation. At least one domain category must be selected before you can continue to the next page of the wizard.
    2. Click Next.
  7. Select the time periods and key metrics that you want to use for the aggregation and reporting jobs.
    Note: If you are using an adapter that does not have aggregation and information map jobs available from the Adapter Setup wizard, then the wizard creates only a staging job and skips this page.
    Select Time Periods and Metrics
    Select Time Periods Page
    The preceding example shows that all time periods and key metrics have been selected. Note that the description in the box on the right corresponds with the time period that is highlighted in the Select time periods box.
    The time periods are another way that the Adapter Setup wizard helps you manage system performance, aggregations, and jobs by enabling you to select only the time periods that are essential to the performance management and capacity planning processes for your enterprise. The Adapter Setup wizard creates only the aggregation and report jobs that reflect the time periods and key metrics that you select. In turn, you do not have to sort through extra jobs and reports that focus on time intervals that you do not need.
    Note: You must select at least one time period or the Key metrics option to continue. (That is, you can select any combination of these four choices: Day, Week, Month, or Key metrics, but you must select at least one.)
    For more information about the specific aggregations that the Adapter Setup wizard creates based on time period and shift, see Aggregations by Time Period.
    1. Select the time periods for which you want to create aggregation and report jobs.
      Day
      creates aggregation jobs and the daily, weekly, and monthly report jobs that generate reports about the daily data.
      Week
      creates aggregation jobs and the weekly report job that generate reports about the weekly data.
      Month
      creates aggregation jobs and the monthly report job that generate reports about the monthly data. If you check the Shift option, additional aggregations are created and additional reports are included in the monthly report job.
      Note: If you also select Shift (as described in the next step), then additional aggregations are created and additional reports are included in the report jobs.
    2. Select Shift if you want to the generate aggregations, information maps, and reports that are based on shift data, in addition to daily, weekly, or monthly data.
      Note: In some cases, Shift might be selected by default because of the adapter that you selected earlier in the wizard.
    3. Select Key metrics if you want to generate aggregation tables, information maps, and reports that include only the key metrics that focus on the most critical data for a performance area or domain category.
      Note: If the domain categories that you selected do not include key metrics, then this option is not available.
    4. Click Next.
  8. Specify the location of any user-written formulas to use in addition to the formulas that SAS IT Resource Management supplies.
    Specify User-Written Formulas
    Specify Formulas Page
    The staged tables and aggregation tables that the Adapter Setup wizard creates include computed columns that reference various formulas. When the tables with computed columns are instantiated, SAS IT Resource Management looks for the corresponding formulas in the list of supplied formulas.
    If you have customized or user-written formulas that you want to use instead, then use this page of the wizard to specify the location of the user-written formulas that you want to use. The Adapter Setup wizard then looks in the folder that you specified for any formulas that have the same name as those in the tables that it creates. If a formula with the same name is in the folder, then the wizard uses that formula. If the formula is not found in your specified location, then the wizard searches for the formula in this location: Shared Data/SAS IT Resource Management/IT Formulas. If the formula is still not found, then the wizard searches for it in this location: Products/SAS IT Resource Management/IT Formula.
    1. Click Browse to navigate to and select the folder that includes any user-written formulas that you want to use instead of the formulas that SAS IT Resource Management supplies. This field is optional and does not allow manual entries. If you do not have user-written formulas that you want to use and do not specify a folder in this field, then the Adapter Setup wizard defaults to the supplied formulas.
    2. Click Next.
  9. Specify the location of the SAS Content Server where the report definitions are retrieved and where the reports that are generated from the resulting jobs are stored. Also specify whether you want the Adapter Setup wizard to automatically deploy the jobs that it creates.
    This page does not appear if you selected the configuration level Staging Job Only on the second page of the wizard. In this case, the Adapter Setup wizard creates only one staging job that you must deploy manually.
    Specify SAS Content Server and Job Deployment Page
    Specify SAS Content Server and Job Deployment Page
    Note: If you are using domain categories that do not result in reporting jobs, then the SAS Content Server options are not available on this page. For more information, see Jobs That the Adapter Setup Wizard Creates for Domain Categories.
    The report definitions that the Adapter Setup wizard uses to create the report jobs are stored on the SAS Metadata Server. In addition, the reports that are generated from the report jobs are stored on the SAS Content Server.
    1. If you are using domain categories that result in reporting jobs, specify the following parameters for the SAS Content Server:
      SAS Content Server
      specifies the name of the server that is used as the SAS Content Server for storing report definitions and report job outputs.
      Repository folder path
      specifies the path within the SAS Content Server where the report definitions and reports are stored. The default location is /SASContentServer/repository/default/sasdav/ITRM.
      URL file name parameters
      URL file name parameters specifies the parameters that pertain to the URL filename, such as Proxy, user ID, or password. For example, the contents of this field could be user='userID', pass='password', and so on. The contents of this field are used to communicate with Gallery Manager. In most configurations, these parameters are not needed.
      A value is optional in this field. The default value for this field is blank.
      For information about the contents that can be entered in this field, see the “FILENAME Statement, URL Access Method” topic in the SAS(R) 9.3 Statements: Reference.
      Note: The contents of the field are not verified.
    2. Specify the following parameters to indicate whether you want the Adapter Setup wizard to deploy the jobs that it creates:
      Deploy jobs automatically
      specifies if you want the Adapter Setup wizard to deploy all of the jobs that it creates. Otherwise, the Adapter Setup wizard only creates the jobs and you must deploy them manually.
      Deployment directory
      specifies the location where the jobs are deployed if you select to deploy the jobs automatically.
      Note: If you are working with z/OS, then the location for deployment must be a directory in the UFS file system. The Adapter Setup wizard does not support the automatic deployment of jobs to a partitioned data set (PDS) directory.
    3. Click Next.
  10. View a summary of the metadata that you specified for the adapter, staging, aggregations, information maps, reports, and jobs that you specified with the Adapter Setup wizard.
    View Specifications
    Summary Page
    The summary consolidates all of the specifications that you provided on the previous pages of the wizard.
    1. Review the summary and ensure that it reflects the specifications and results that you expect. If you want to change a value that you specified on a previous page, click Back to navigate to the appropriate page and change the parameter value as needed.
      The last item on the Summary page provides the location where a log file for the current Adapter Setup wizard instance is stored. This text file is automatically stored on your machine after each execution of the Adapter Setup wizard. The log includes all of the information that is detailed on the Summary page of the Adapter Setup wizard as well as the dates and times at which the Adapter Setup wizard was run. For more information about the log file, see Log File Created by the Adapter Setup Wizard.
    2. Click Finish when complete. The wizard creates the jobs and saves them in an <adapter><number> folder within the IT data mart that you selected. The time that the Adapter Setup wizard takes to create the resulting jobs varies based on the adapter and the parameters that you specify. A progress bar shows the status when the wizard creates the appropriate jobs. If the jobs cannot be created, an error message is displayed.
      Note: The first time you edit a job that the Adapter Setup wizard created, the job is marked as needing to be saved (that is, an asterisk is next to the name in the title bar of the Job Editor window). This is because the Job Editor is storing the initial editor settings for how the job is displayed in the window. The job was saved when the Adapter Setup wizard executed.
    If you do not select to have the Adapter Setup wizard automatically deploy the jobs that it creates, then you must deploy the resulting jobs if you want to run them in batch mode. You can right-click a job to open a menu that provides various options such as deployment and scheduling tasks. For information about running the jobs that the Adapter Setup wizard creates, see Running Jobs. For more information about deploying a job, see Deploy a Job for Scheduling or SAS Data Integration Studio Help.