Any thoughts on this would also be appreciated. Work Order Scheduling Let’s face it, scheduling a bunch of work orders in Maximo is a bit of a chore. Delimit the Data in the Excel File Optional 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: One is that in 7. There were no write backs allowed to the database, only querying of the data.

Uploader: Daizahn
Date Added: 6 August 2015
File Size: 35.71 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 26005
Price: Free* [*Free Regsitration Required]

Ensure that you first deploy the source module before you deploy the mapping.

The range should include the column names and the data. It is a tremendous repository of valuable information regarding asset management for large multinational corporations. An example of the VBA code that harvests data from Maximo: The user name and password in the Edit Location dialog box are not enclosed within double quotation marks.

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

Troubleshooting Some of the errors that you may encounter while providing the connection information are listed here: Make report generation easier for the user who is not a computer expert. Serdakowski then worked his “magic” to prepare the reports as specified.


The naming convention for this file should be as follows: The tool will send out emails to each owner, clustering all records for each owner into one email. To connect to SQL Server and import metadata, refer to the following sections: Maximo Data Scrubber This program combs through the Maximo database and isolates 5 defined exceptions and 2 specific database changes.

Set up the resources and environment that the broker requires for Open Database Connectivity ODBC connections to databases on distributed systems. From the Schema drop-down list, select a schema or use the text box maxmo search for a schema by name.

Solved: Consuming Maximo data from Oracle. – Microsoft Power BI Community

Often at the worst possible time. For more information, see Database connections. It is possible that your server is configured to use a non-standard port.

The program assists system owners in optimizing Preventative Maintenance frequencies and costs.

Consuming Maximo7.5 data from Oracle.

In this article Before you begin Make the connection maxiko set up the data source. Contact your administrator if you don’t know which port to connect to. AutoSoft Systems has prepared a customized dashboard for a major pharmaceutical manufacturer that measures a myriad of metrics across the entire corporate.

To set up ODBC connections to databases, follow the instructions in this section. Plus, we utilize the Maximo data to enhance additional applications developed on different platforms. Create a mapping in the module that contains the target table. Potential annual times savings at major corporations can easily exceed 1 million dollars.


Enabling ODBC connections to the databases

Modify the file as shown: This utility can be set up to run automatically at whatever frequency is desired. Serdakowski to prepare the specifications for the report.

Follow the instructions in Connecting to a database from Windows systems. Right-click the module and select Import. The port number is dependent on the type of server you are connecting to and whether you are connecting to an encrypted port.

To configure the agent, you must set the initialization parameters in the heterogeneous services initialization file. To import metadata into the ODBC module: Select the database file and click Next.

If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download page where you can find driver links and installation instructions.