CDB - How to install SQL Server client components needed for use with the CMM products (CDB, CAzE, MTA, TSCOMF and Vis).

Version 3
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Capacity Management for Mainframes


    COMPONENT:

    Capacity Management Database


    APPLIES TO:

    Visualizer, Capacity Management Database, Mainview Threshold Advisor, Truesight Capacity Optimization - Mainframe addon and Cost Analyzer for zEnterprise.



    PROBLEM:

     

     How to install SQL Server client components needed for the CMM products.

     


    SOLUTION:

     

    For CDB\Visualizer to function correctly, when connecting to a SQL Server database, the SQL Server ODBC Driver and the SQL Server Bulk utility must be installed on the same Windows machine where Visualizer and\or CDB are installed.  The SQL Server client components can be installed from the full SQL Server installer package however that package tends to be 2-3 Gigabytes in size which can be too large to deal with. 

      

    A SQL Server client only installer is not available; instead Microsoft offers individual feature downloads for SQL Server.  One of the feature downloads is for the Microsoft ODBC Driver for SQL Server.  This is the driver that should be used to set up the ODBC data source for a SQL Server database.  Another feature download is for the SQL Server Command Line Utilities.  This package includes the SQL Server bulk utility program (BCP.exe) which is required for Automator populate.  The third package mentioned below is the SQL Server Management Studio.  This is not required but this includes a graphical user interface that can be used to run SQL, browse the db objects (tables, indexes, etc.) and manage the user databases.  

      

    The SQL Server Management Studio package includes the ODBC driver and the command line utilities, so if this package is installed the other two packages don’t need to be installed.    

      

    Download links for the current versions (as of 6/19/2019) are provided below.  
     

      

    Microsoft ODBC Driver for SQL Server 

    https://www.microsoft.com/download/details.aspx?id=56567

    If the Windows OS is 64 bit select the _x64 download.
    If the Windows OS is 32 bit select the _x86 download. 

    Note: The 64 bit download will install both the 32 bit and 64 bit ODBC drivers.  CDB and Visualizer require the 32 bit ODBC driver.



    Microsoft Command Line Utilities for SQL Server

    https://www.microsoft.com/en-us/download/details.aspx?id=53591

    If the Windows OS is 64 bit select the _x64 download.
    If the Windows OS is 32 bit select the _x86 download.


    Note:  CDB and Visualizer can use either the 32 bit or the 64 bit bulk utility.

    After installing the Command Line Utilities you must update the PATH statement to add the directory where the bulk utility (bcp.exe) was installed.  (i.e.  C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn).  The following KA will provide the steps required to update the PATH statement.
       
    https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000097525


    SQL Server Management Studio (SSMS)

    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

    Note:  This package will install SQL Server Management Studio, the 32 bit and 64 bit ODBC drivers, the bulk utility (bcp.exe) and update the PATH statement.

     

       Related Products:  
       
    1. BMC MainView Capacity Management Family for Mainframes
    2.  
    3. BMC Performance Assurance for Servers

     


    Article Number:

    000096067


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles