MAXIMO ODBC DRIVER

Click Select Workbook to select the Excel file from which you want to extract data. Generally, use for a non-encrypted port and for an encrypted port. Enter the name of the server that hosts the database the Host name , the port number, and the name of the database that you want to connect to. Because you are not connecting to an Oracle database, you can provide dummy values for user name and password. Set Up Data Sources — Add more data to this data source or prepare your data before you analyze it. Select Microsoft Excel Driver as the driver for which you want to set up the data source.

Uploader:	Nijar
Date Added:	25 May 2015
File Size:	49.34 Mb
Operating Systems:	Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads:	43106
Price:	Free* [*Free Regsitration Required]

The port number is dependent on the type of server you are connecting to and whether you are connecting to an encrypted port.

Set up the listener on the agent to oxbc for incoming requests from the Oracle Database. Some of the errors that you may encounter while providing the connection information are listed here:. Create the Heterogeneous Services Initialization File. Make report generation easier for the user who is not a computer expert. Use custom SQL to connect to a specific query rather than the entire data source. Now in version 7. This program mines data from Maximo to estimate the cost of future preventative maintenance costs.

Provide "tickler" emails to system owners to remind them to complete upcoming or tardy tasks. Accurate and complete documentation of each and every NC is of paramount performance.

Select Microsoft Excel Driver as the driver for which you want to set up the data source.

Turn on JavaScript

If you want to delimit the data to be imported from the Excel file, then define a name for the range of data being sourced:. Import the metadata using the Import Metadata Wizard.

This tool scans the Maximo database and culls out PM workorders that are overdue or soon to be overdue. For example, use a data source naming convention that helps other users of the data source figure out which data source to connect to.

This involves the following steps: In this article Before you begin Make the connection and set up the data source. Log in to reply. There is no mechanism in Trackwise to validate that the equipment or system entered is indeed a valid Maximo entry. This connector requires a driver to talk to the database. Test the data source to verify the connection.

Creating an ODBC connection to an IBM DB2 database - FME Knowledge Center

Work Order Scheduling Let's face it, scheduling a bunch of work orders in Maximo is a bit of a chore. Under Tableselect a table or use the text box to search for a odbx by name.

Potential annual times savings at major corporations can easily exceed 1 million dollars. From the Insert menu, select Name and then Define. The wizard displays all the worksheets in the source Excel file under the Tables node in the list of available objects.

For example, both must be either bit or bit. All examples here share one or more of the following common motivations:.

Late Preventative Maintenance Notification Tool This tool scans the Maximo database and culls out PM workorders that are overdue or soon to be overdue. The naming convention for this file should be as macimo Enter the following in the file: This tool is a great time saver for any programmer looking to generates reports out of Maximo.

Thanks for your attention to this post Build Charts and Oxbc Data — Begin your data analysis. There were no write backs allowed to the database, only querying of the data. However, it must not contain the init prefix.