Copy Data from an external portal to RTC

I have a bit of a complicated request. Basically my client has a portal where they log fault reports. This is a web-based portal and is connected to a MS SQL DB. They would like these fault reports to be handled internally in RTC. So I suggested that we created a new work item in RTC that matches how this fault report looks like in the web portal. My question is, can a java app be written to extract this information from the web-portal into RTC? The client does not want to do this manually, so therefore I assume we have to look at the RTC API's and try to create something for this. Any guidance/suggestions on this would be appreciated.

Thanks

Leesen