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 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
- 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 Log on as follows:
- From the AR Server list, select the BMC Remedy AR System server on which you have installed the BMC Remedy AR System database.
- 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. - In the Password field, enter the credentials for the BMC Remedy AR System server.
- Click OK.
- 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. - Double-click a sample job or transformation.
- Select File > Save as.
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.
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.
Comments
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.
Hello Andrew,
Thank you for your comment. The concerned writer is looking into this.
Thanks,
Prachi
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
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?
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?
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
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.
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
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
Hello Kevin,
I apologize for the inconvenience. I will discuss this with the SME and will write back to you.
Regards,
Nidhi
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
where can i find the info regarding loading attachment (.csv) into CMDB using Spoon?
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