Skip to Content
+Creating XSDs (XI data type) for Database resource objects like Tables and Procedures – Part-1.+   When you are working on JDBC adapter to integrate the database objects like Tables, Stored Procedures, the most time consuming and tedious process is creating Metadata- XI Data Types. Imagine if you have to integrate tables/procedures with hundreds of columns, for each table/procedure we need to create a structure manually in XI. But in most of the other Integration Products like webMethods, Tibco the metadata introspection is part of the Tool, of course XI also provides this feature for SAP objects like RFC and Idocs. I am sure SAP will come with this feature in their next release but until that we need some utility to support the functionality. Creating the datatype is pain but big problem is if you found a problem at the time of testing that there is a typo or missing some field in the dataType then you have to touch all the dependent objects and then re-test them all.      When I had to create the DataTypes manually I did not like to do that, instead I decided to write a utility that will generate the XSDs for a given table names. This part-1 only covers the table creation part, this supports Oracle and Microsoft Sql Server only. Part-2 will support the Stored Procedures- Data Type creation and Mapping Templates and will be published soon.      This is the Table Customers in the Database  image   DataType Created in XI Repository using utility  image      If you follow this blog well, creating a first object takes less than half hour then it will take few seconds for any additional objects. Following is the procedure to generate the xsds for creating DataTypes in the IR.       Preparation:   Before running the utility you need to get the database connectivity information and the name of the namespace in the XI where you would like to create Data Types.       Below is the list of parameters you need before running the utility:   * Database  Vendor Name – “ +MSFT+” for Microsoft SQL server or “+ORCL+”  for Oracle0.1.   0.2. Database  Host Name preferably IP address 0.3.   0.4. Database  port number, for example  +1433+0.1.   0.2. Database  SID for example  +ORCL+for Oracle,  +Northwind+  for SQL server0.1.   0.2. Database  User name, for example  +sa+0.1.   0.2. Database  User password, for example  +sa+0.1.   0.2. Object  Type: “ +Table+” or  “+Procedure+”0.1.   0.2. Object  Name: Table name or Procedure Name,  for example  +EMP+0.1.   0.2. Interface  Name: name of the Interface where you want to create data types, for  example  +http://saanvi.com/logistics/customer+0.1.   0.2. Folder  Name: Local Folder Name where you want to generate the xsd file, for  example  +C: temp+        Extract the ZIP file MetadataGen.zip to a working directory ex: c:\workarea\xiUtils, once it’s extracted make sure you have following files in the directory:  image      This package includes the MS Sql server and Oracle jdbc drivers. You can use your own jdbc drivers with replacing the existing driver files.       JVM installed?   Check if the JVM is installed on your PC, if you have installed java webStart then you are fine. Just make sure the jvm is installed if not please install the JVM from java.sun.com.       How to find the JVM?   In the DOS window enter java –version  image
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Laxman Molugu Post author
      Hi Fernandez,

      Thank you very much checking this weblog. There was a typo in my weblog the actual zip file name is xiutils.zip.

      You can download this tool from How to get the Utility? section. click the download link, make sure to turn off popup blockers.

      Thanks and Regards,
      laxman

      (0) 

Leave a Reply