{"id":116,"date":"2008-05-20T07:26:04","date_gmt":"2008-05-20T07:26:04","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?p=116"},"modified":"2009-04-05T07:53:50","modified_gmt":"2009-04-05T07:53:50","slug":"ilm-and-sap-basic-ma-installation","status":"publish","type":"post","link":"https:\/\/www.wapshere.com\/missmiis\/ilm-and-sap-basic-ma-installation","title":{"rendered":"ILM and SAP – Basic MA Installation"},"content":{"rendered":"

I’ve just installed the SAP MA (also called the ERP MA) for the first time. As usual it took four times as long as seemed strictly necessary so, in this post, I shall summarise the steps I took to\u00c2\u00a0create a basic MA, able to import Users and Employees from SAP into ILM.<\/p>\n

<\/p>\n

1. Software Requirements<\/h3>\n

For some reason I found it really hard to find a nice, simple list of what is required on the ILM server. So here’s my attempt:<\/p>\n\n\n\n\n\n\n\n\n
Windows 2003 Enterprise 32-bit<\/td>\nNot 64-bit, as I found out the hard way.<\/td>\n<\/tr>\n
Visual Studio 2005<\/td>\nInstalled with preferred language – VB.NET or VC#. You can deselect the other options if you like.<\/td>\n<\/tr>\n
SQL 2005<\/td>\nI believe SQL 2000 is also ok.<\/td>\n<\/tr>\n
Visual Studio 2003<\/td>\nYes! As well! This is needed\u00c2\u00a0by the SAP .NET Connector, though again\u00c2\u00a0you can install it with minimal settings. In fact there is a way to avoid installing VS 2003 but you will need access to a computer with the SAP Connector already installed, from which you can copy certain files. See this post by Tomek<\/a> for his workaround.<\/td>\n<\/tr>\n
SAP .NET Connector 2.0.1<\/td>\nDownloadable from http:\/\/service.sap.com\/connectors though it needs a username and password, so maybe you can see if the local SAP admin already has one.<\/td>\n<\/tr>\n
ERP MA<\/td>\nThere’s a more recent version that the CD one available here<\/a>.<\/td>\n<\/tr>\n

\u00c2\u00a0\u00c2\u00a0<\/p>\n<\/tbody>\n<\/table>\n

2. Configure the Schema<\/h3>\n

The SAP MA is not\u00c2\u00a0able to go off into your SAP system, discovering the schema for itself. It is necessary to use the ERP MA Configuration Tool <\/strong>to produce copy of the required schema elements\u00c2\u00a0in an XML \u00c2\u00a0file, which you will then import into your MA.<\/p>\n

We mucked around for quite some time trying to create our own configuration, before paying attention to the template referred to in the documentation.\u00c2\u00a0This is a preconfigured schema which should work for most standard SAP installations (I would imagine, being no SAP expert – though it worked for the one I was connecting to), and will grab all active users and employees.<\/p>\n

So here’s what you need to do:<\/p>\n

    \n
  1. Run the ERP MA Configuration Tool<\/strong> from the Programs menu created by the installation<\/li>\n
  2. Choose File -> Open Configuration<\/strong><\/li>\n
  3. Browse for the Microsoft ERP Management Agent <\/strong>program folder<\/li>\n
  4. Open the ERPDefaultTemplate.xml<\/strong><\/li>\n
  5. Fill in the Connection Information as follows:\n