As an alternative to installing vCenter Server on a Windows machine, you can download the VMware vCenter Server Appliance. The vCenter Server Appliance is a preconfigured Linux-based virtual machine optimized for running vCenter Server and associated services. The current VMware Vcenter Import rules give the choice between SQL or Oracle import. However, the appliance comes pre-configured with a PostgreSQL database which is currently not supported by DTS.
To still be able to import VMware Vcenter data into the LANDesk Inventory Database follow these steps:
Step 1- SSH into your VCSA and in the following configuration file /storage/db/vpostgres/pg_hba.conf you will need to add the network in which you will be connecting from, for example:
host all all 172.30.0.0/24 trust
Step 2 - SSH into your VCSA and in the following configuration file /storage/db/vpostgres/postgresql.conf you will need to add the IP Address(s) that you want vPostgres to listen for remote connection. If you use "*", it will allow all addresses, for example:
listen_addresses = '*'
Step 3 - For the changes to go into effect, you will need to restart the vPostgres DB by SSH-ing into your VCSA and running the following command:
service vmware-vpostgres restart
Step 4 - Download the latest ODBC driver for PostgreSQL (32-bit!) and install this on the LANDesk Core Server.
Step 5 - Create a DSN by opening the 32-bit Data Sources (ODBC). To do so:
- Run c:\windows\sysWOW64\odbcad32.exe
- Select Add at User DSN
- Select the Unicode PostgreSQL Driver
- Enter the following values
Data Source: PostgreSQL35W
Database: VCDB (default)
Server: (Server name of your appliance)
UserName: vc (default)
SSL Mode: disable
- Click Test to see if your connection-settings are good; If not, re-check Step 1 to 5.
Step 6 - Enter the LANDesk Console and open Data Analytics Data Translation Services
- Go to Import Data and make a copy of all 'Import VMWare ....' Rules
- Rename the copies to 'ODBC Import VMware ...'
- Open all 'ODBC Import VMware ...' rules and go through the configuration screens
- On all 'Data Source' screens, change the information to ODBC and select the DSN created before.
Use the same username/password as in the DSN. DON"T CHANGE ANYTHING ELSE IN THE CONFIGURATIONS, and save them.
- Create a New Rule Group called ODBC VMware Import
- Drag and drop the 'ODBC VMware Import ...' rules into the new group
- Go to the VMware Vcenter Group and drag and drop all non-VMWare Import rules from the sub-groups into your new group
- Change the run order of the ODBC VMware Import group (right click on the group) to:
ODBC Import VMWare Vcenter Host Info
Processor.speed from Processor Type
Pad Computer.Network.TCPIP Address
Calculate Computre.Processor.Features.Cores per Package
ODBC Import VMWare Vcenter Host Images
VMWAre Vcenter Set Computer.Bios.Vmware UUID
ODBC Import VMWare Vcenter VM Host Name
ODBC Import VMware Vcenter VM Info
- Run immediately or schedule the group to run periodically