Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

iBot Phone Delivery

743326Mar 1 2010 — edited Mar 2 2010
Hi All -

I've been playing around with some of the iBot options using OBIEE Delivers trying to get alerts to different devices. I've been able to get alerts via email, but have not been successful in having an alert sent to my phone.

I've given the device type as my phone carrier (Verizon) and added my phone number. Let's say my phone number is 555-123-4567 (American phone number). I've tried many different formats to make this work:

5551234567
15551234567
915551234567

Documentation says to not use spaces, punctuation, etc, so I have not tried those formats...

When I run my iBot, I receive no errors in the iBot error logs, but receive no notifications to my phone. If I run this delivery method coupled with other methods (dashboard alerts and email), the other two methods succeed, but the phone method is ignored like it wasn't even entered. I've tried running both through a delivery profile and through specific devices.

I have a BlackBerry Curve 8330. Can anyone please help??

Regards,
Jason
This post has been answered by 646090 on Mar 2 2010
Jump to Answer

Comments

Turribeach
How do you expect Delivers to send you the report? By SMS? Does your server have a modem and a telephone line? Even if it did there is no integration in Delivers I am afraid. All you can is to specify different email addresses for your different devices. For instance I am sure you have an email address linked to your Verizon mobile phone. Use that on your mobile device profile.
743326
Hi Christian -

Thanks for the response. The reason I was looking into this was because I had always seen the other available device delivery options other than email (phone, pager, handheld, other) but had never used them. I was curious to see the type of output and the display format that would display on the phone.

As far as how OBIEE would deliver the message to the phone, I was guessing the delivery format would be SMS, but it was just a guess. I believe that each phone number with a Verizon account has a corresponding internal email, so I was expecting some interaction with the email through the Verizon carrier that would convert to an SMS text notification.

Currently all alerts I have set up have been through email, and no one has ever asked me for anything different. This experiment was more to understand the full capabilities of the tool better so that if a client ever asked for this type of delivery (i.e. they had a work phone with text only capabilities and no email) I would be able to handle the request.

Given the fact that there is only one line in the tool's documentation of how to use the phone number delivery option, I shouldn't be that surprised if it isn't supported :)

Thanks again for the info, and if anyone knows of a way to use this option, please let me know!

Regards,
Jason
Leigh Wilson
if you need to sms a report/info to a user from an iBot another approach would be to sign up with an email/sms service provider where-by the ibot sends the text report to the specific email address, ie: "smsphone@emailsmsservice.com" and usually you include phone number in the subject area... the sms is then sent to the telephone number supplied. I did this on one of my last projects, worked well.

dependancy on the sms/email service provider though, costs are usually negligible (ie. 5c per sms). also, on one particular night at 2am the ibot scheduler went nuts and sms'd me about 2000 times between 2am and 3am until i managed to remote in and kill the server. ehehehe. have fun.
757287
Edited by: user9208525 on Mar 2, 2010 7:52 AM

Edited by: user9208525 on Mar 2, 2010 7:53 AM
646090
Answer
Hi Jason,

I think Leigh's method is the best way except for one thing, I wouldn't use an external provider to forward emails as text messages.

Just about every major cell phone service provider gives you that functionality for free (assuming you have a text message package). All you have to do is send an email to something like <your 10 digit phone number>@<service provider's API>.com. For example, if your phone number is 123-456-7890 and you had a Verizon plan then you would send an email to 1234567890@vtext.com.

Using this method, you would setup an addition email device (not a phone device) using the phone number formatted as an
email address. Here's a link to some of the API's for major cell phone providers: http://www.makeuseof.com/tag/email-to-sms/

I've read the documentation for OBIEE, especially around the Delivers module and there is a lot of wording that implies the phone device can be a valid iBot target. However, I've never understand exactly how it would work (besides the work around described above) and I have had no luck configuring it. Would love to hear if anyone had success with it.

Best regards,

-Joe
Marked as Answer by 743326 · Sep 27 2020
Turribeach
Delivers always implied that it could deliver to other devices but it's a big lie. All it can do is to have separate email addresses for different devices so you could specify a format that suits that device (i.e. text only for mobile phone, PDF for blackberry, etc).

I still can't believe how you North Americans let the cell operators screw you with SMS delivery charges. Here is Europe and most of the rest of the world it's CPP, which means Calling Party Pays, which means only the person sending the SMS pays, not the receiving party. Email to SMS translations are free too.
743326
Haha, maybe we'll go on a cell phone strike until they remove the fees! But then how would people get their mobile OBIEE updates?? :)

I've got a plan for 500 texts / month for $5 USD, and then I pay overage fees for everything above that, so that 2,000 text messages in one hour would have hurt me pretty bad...

Joe, your solution worked as a very nice workaround. It's a shame that OBIEE "offers" the phone notifications when they don't actually work, but this was a nice solution to get messages to phones without email.

I would take note that I had to send the message as plain text, and for some reason the HTML and PDF versions I tried sending did not display well. Also, if you send as SMS (so for Verizon it was the @vtext address) and you have a character limit (I think mine is 160), it cuts off the message. To work around the character limit, I sent as MMS (@vzwpix address) and it sent the whole message (still in plain text).

Thanks to everyone for the input!

Regards,
Jason
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details