This documentation applies to the 8.1 version of BMC Atrium Core, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

Creating a job in Atrium Integrator Spoon

You can use Atrium Integrator Spoon to import and export data from inputs like LDAP, BMC Remedy AR Systems forms, BMC Remedy ITSM forms, and those requiring complex staging tasks or complex data manipulations. BMC provides several sample jobs that you can use as a starting point. You can also refer to sample transformations for each step, which can be accessed from the following location: 

<ARInstallationDirectory> \diserver\dataintegration\Sample

Example Video

For an example to import a sample CSV file, see Creating job in Atrium Integrator Spoon video.

For more information about different complex jobs, see Complex jobs in BMC Atrium Integrator Spoon.

Recommendations

  • Use a naming convention for jobs and transformations that makes them easy to identify. Use the same name prefix to identify related jobs and transformations.
  • Use variables for file paths or computer-specific connection information so that file paths and so forth can be determined dynamically instead of statically. You can refer to the Sample jobs for this information.
  • When you create a transformation from Atrium Integrator Spoon, ensure that the AR server connnection used in the CMDBInput CMDBOutput, LookUp, ARInput, and AROutput steps has an entry in the UDM:RAppassword form with the Remedy Application service user and its password.

To customize a sample job or transformation

  1. On the computer where the Atrium Integrator Spoon client installed, select Start > Programs > BMC Software > AR System > BMC Atrium Integrator Spoon. The AR Server connection dialog box appears.
     AR Server Connection 
  2. Log on as follows:

    1. From the AR Server list, select the BMC Remedy AR System server on which you have installed the BMC Remedy AR System database.
    2. In the User Name field, enter the user name for the BMC Remedy AR System server.
      For information about the user name that you must specify, see Atrium Integrator permissions.
    3. In the Password field, enter the credentials for the BMC Remedy AR System server.
    4. Click OK.
  3. In the Atrium Integrator Spoon window, select Tools > Repository > Explore.
    The Repository explorer dialog box shows the sample jobs and transformations in the BMC SAMPLES directory.
  4. Double-click a sample job or transformation.
  5. Select File > Save as.
  6. In the properties window, enter a name for the job or transformation and then click OK.
    The sample job or transformation is saved with the name that you specify.

    Note

    When you create an BMC Remedy AR System transformation from Atrium Integrator Spoon, the records inserted and updated are displayed in the Output column of the Step Matrix table.

  7. Edit the job or transformation as needed.

    Note

    When you schedule a job from Atrium Integrator Spoon, the scheduling information is not updated the AR System Job and AR System Item forms.

For more information about creating a job in Atrium Integrator Spoon, see the Spoon User Guide at http://wiki.pentaho.com/display/EAI/Spoon+User+Guide.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments

  1. Andrew Hicox

    Are you kidding me?

    The entirety of the "how to create a job in Atrium Integrator Spoon" page consists of "enter your username and password, here's where the examples directory is (with zero documentation) also here's a link to the Pentaho wiki?"

    Jeez. Thanks BMC. You may have a wonderful product here, but unless you start communicating then I have absolutely no way of knowing that.

    I need to import some CSV files into a custom remedy form. Would it be easier for me to drop down to C, and code an API program to do this from scratch? Well at this point it would be. You know why? The C API has actual documentation.

    Dec 08, 2014 12:14
    1. Prachi Kalyani

      Hello Andrew,

      Thank you for your comment. The concerned writer is looking into this.

      Thanks,

      Prachi

      Dec 09, 2014 12:46
    1. Amol Redij

      Hello Andrew,

      Thank you for your comment.

      We are trying to work on your comment and in order to understand it better, I need some additional information.

      In your comment, the sentence about importing from a CSV file, is that just an example you used or did you reach this topic while searching for a process to import the CSV? 

      I would appreciate your input.

      Regards,
      Amol

      Dec 31, 2014 06:10
  2. Andrew Hicox

    Amol,

    We have a large number of spreadsheets that are currently used by various departments to provide packages of data that are imported into our Remedy system. These are imported to various forms, some out of the box, some custom. Currently I have a rather large library of perl scripts which process and import these using the C API. I have been given the task of re-implementing this library of import routines via AtriumIntegrator.

    I am not necessarily looking for a direct example of doing this. I don't need a demo. I need the documentation so I can learn how to build it myself. So what I was looking for when I searched for and found this page is neatly summarized in the first sentence of this page:

    "You can use Atrium Integrator Spoon to import and export data from inputs like LDAP, BMC Remedy AR Systems forms, BMC Remedy ITSM forms, and those requiring complex staging tasks or complex data manipulations. "

    Fantastic! How, specifically?

    Jan 15, 2015 10:17
  3. Andrew Hicox

    PING!

    I still need this information. You have not responded in more than a month.

    To be clear, I am not asking for anything extraordinary. I really am not! I'm merely asking for the answer to this question: "how do I use AtriumIntegrator to import data from a file, into a form?"

    I mean, completely forget the filetype. I don't even care. Give me a written explanation: how to open a file, read it's contents, execute logic on a row-by-row basis, and push records into a form.

    Perhaps that information exists somewhere on this wiki, and I just can't find it? That would be wonderful, please just give me a link so I can get down to business and start getting things done with AtriumIntegrator.

    I'd even pay for a class on AtriumIntegrator. Does one exist?

    Feb 18, 2015 11:01
    1. Amol Redij

      Hi Andrew,

      Apologies for the delay in responding to your query. We understand that it has been a long wait for you.

      During this time, we had been in discussions with the SMEs and coming up with a simplified process to help our users understand the process in a better manner.

      Accordingly, we have created a video that explains the steps in detail along with a live demo. The video is attached on this page.

      Hope this addresses your concern.

      We will be glad to help you with other additional information as required.

      Regards,

      Amol

      Feb 19, 2015 02:30
  4. Andrew Hicox

    Amol,

    THANK YOU!

    That is exactly the kind of information I'm looking for. When can we expect documentation on the specifics of what you are doing in that video?

    For instance. What in the heck does the "lazy conversion" checkbox even mean? Why do I need to uncheck it? What happens if I do check it? If that's documented, please point me to it, because that is exactly the sort of thing I need to know as a professional software developer trying to use this product in a production environment.

    How about if I needed to insert logic between the CSV import and the CMDB output? For instance, what if my CSV file contains data for two classes, and I need an IF statement to route a row to say either the ComputerSystem or Equipment class?

    AtriumIntegrator looks like such a powerful tool. One that truthfully has the potential to replace nearly every external API program I've written in years!

    It's not to much to say that I'm actually inspired by that. Unfortunately, I'm also infinitely frustrated ... because I can only learn about it via disconnected bits and pieces of information scattered across this wiki, random blog postings on communities, and whatever random tidbits google can find for me.

     

    Feb 19, 2015 12:21
    1. Amol Redij

      Hi Andrew,

      Thank you for sharing the details of things you are expecting from the documentation.

      We have understood your concerns. We will certainly put in efforts to have enhance the documentation to provide better understanding and experience to our users. This will take some time though, based on the priorities we currently have.

      However, to quickly address your concern, you may please look at this page - http://wiki.pentaho.com/display/EAI/CSV+Input, which gives details about the various fields on the console. It also provides explanation on "Lazy Conversion" field. Pentaho is a third party tool that we use and hence we haven't documented every detail about using that tool, as a detailed user manual is available, for which we have provided a link in our documentation - For more information about creating a job in Atrium Integrator Spoon, see the Spoon User Guide at http://wiki.pentaho.com/display/EAI/Spoon+User+Guide.

      On your question of inserting a certain logic between the CSV import and CMDB output, I will speak with the concerned SME and get back to you.

      Regards,

      Amol

      Feb 20, 2015 07:35
  5. Kevin Bumber

    Amol,


    Quite a bit of Remedy is comprised of third-party tools that have been duct tapped together. You should either write documentation on how to use these third-party tools with Remedy or provide a brief explanation and direct links to the third-party documentation that you're referencing. I'm not happy with the "go look somewhere else" approach to figure out how to use Pentaho and I'd imagine that most customers aren't. I'd much rather see "here's how you use Pentaho with Remedy" guides, how-to's, and documentation. We come to BMC's documentation for answers, not redirections.

    -Kevin

    Dec 05, 2017 09:58
    1. Nidhi Das

      Hello Kevin,

      I apologize for the inconvenience. I will discuss this with the SME and will write back to you.

      Regards,
      Nidhi

      Jan 04, 2018 12:07
    1. Chaitanya vikas Ghanta

      Hi Kevin,

      Thanks for sharing this! I understand your problem. We are working with the SMEs on rewriting this part of the documentation to make it more useful and informative. As of now it is work in progress.

      Regards,
      Chaitanya

      Sep 20, 2018 04:22
  6. Mahidhar Godala

    where can i find the info regarding loading attachment (.csv) into CMDB using Spoon?

    Aug 13, 2019 10:54
    1. Maithili Deshpande

      Hi Mahidhar, 

      Please see this link to help with your query - https://help.pentaho.com/Documentation/8.1/Products/Data_Integration/Transformation_Step_Reference/CSV_File_Input

      In case you are looking for additional information on a specific activity, please reach out to BMC Support to help with a resolution. 

      Thanks!

      Regards,

      Maithili

      Mar 04, 2020 03:56