Enterprise Module Datawarehouse Configuration for TotalView
These are the instructions for configuring the Enterprise Data Warehouse for PathSolutions TotalView. It is presumed that TotalView is running on a 64bit operating system. For deployment on a 32bit operating system, contact PathSolutions support.
Step 1: Create database and table
Create a database in your DBMS. The database may be on the TotalView server or on a completely different server. It can use any database desired as long as the ODBC connector for that database is available on the TotalView server. The database name can be anything desired.
Run the following script to create the data storage table:
CREATE TABLE Poll
PollTimeNum UNSIGNED INT,
PollNumber UNSIGNED INT,
Interface UNSIGNED INT,
ifType UNSIGNED INT,
ifMTU UNSIGNED INT,
ifSpeed UNSIGNED INT,
ifHighSpeed UNSIGNED INT,
ifAdminStatus UNSIGNED INT,
ifOperStatus UNSIGNED INT,
ifLastChange UNSIGNED INT,
ifInOctets UNSIGNED INT,
ifInUcastPkts UNSIGNED INT,
ifInNUcastPkts UNSIGNED INT,
ifInDiscards UNSIGNED INT,
ifInErrors UNSIGNED INT,
ifOutOctets UNSIGNED INT,
ifOutUcastPkts UNSIGNED INT,
ifOutNUcastPkts UNSIGNED INT,
ifOutDiscards UNSIGNED INT,
ifOutErrors UNSIGNED INT
Step 2: Create ODBC System DSN
On the TotalView server, browse the filesystem to locate the C:\Windows\SysWOW64 directory. Run odbcad32.exe in this directory. This will run the 32bit version of the ODBC connector configuration tool. Click on “System DSN” and click “Add” to create a new data source. Choose the ODBC driver that matches the database that you are connecting to and click “Finish”.
At this point, it will run the configurator for that database. Since each database has a different configuration tool, specific instructions are not included here. Use “TotalViewDB” as the data source name (DSN Name). Make sure to point to the database server and specific database. Enter the login and password for that database. Most configuration tools have a “Test” button that will verify/validate that this is properly configured to access the database.
Step 3: Verify TotalView licensing
On the TotalView web page, there is a hidden web link under the word “Poll” in the upper right corner of all web pages. Click on that page, and then click on the “(License)” link in the middle of the page.
In the upper-right box on this page it lists the Licensed Features. You should see “Enterprise Features (8)” as “Yes”. If not, contact PathSolutions sales (email@example.com) to have this adjusted if you are supposed to be licensed for this feature.
Step 4: Configure TotalView to use the DSN
The following registry entries should be created in the following key:
Descriptions of entries:
• PollODBCFlag: This should be set to 1 to have the program send records to the ODBC connector. It can be set to 0 to shut off this capability.
• PollODBCDataSourceName: This is the name of the ODBC connector that should be used for data exports. It can be anything desired as long as it matches the data source name as configured in the System DSN.
• PollODBCNode: This uniquely identifies this TotalView deployment, permitting multiple collectors to submit data to the data warehouse. It can be anything desired by the user as long as it is unique per TotalView deployment.
Once these entries are created, stop and then re-start the PathSolutions TotalView service. Within 10 minutes, records should start showing up in the database for each poll.