Here is my problem. I am not an IT programer, i do not know PL/SQL, but i need to write a very user friendly Quality defect database. We are going to be using Apple ipads to input the defects in real time into this data base. I need to attach data, pictures, PDF, and other files into this data base.How are you going to do this? What is the nature of the "data" and "other files"? How is it captured? Do you intend to use the iPad camera to take the pictures? Where do the PDFs and files come from?
I also need to have it web accessable to view reports and run querries.Web accessible to whom? The iPad users? Other users? How will they access it: Desktop computers? iPads? iPhones? Other mobile devices? Internally or over the internet? Does the data have to be available in real-time?
I have written a great interface using Filemaker pro 12 and Filemaker GO, however our IT deparment wants it put into Oracle.Why do IT want to use Oracle? Is it that they don't want to use Filemaker at all? Do they want to integrate with existing Oracle systems? Or would they accept using the iPad/Filemaker solution for data capture, then transfer it to Oracle for the long-term storage of the data and the "web accessible...reports and queries"?
The reason i used Filemaker Pro 12 is that the design phase was extremely simple and it integrates perfectly with the Ipad. Please Help, are there any programs that interface with Apex that will allow for an easy page design for entry? I can share my filemaker database for reivew if anyone has any ideas?APEX is certainly capable of making the information web accessible via reports, charts etc. However unlike native iOS apps like Filemaker Go, it's not possible for web-based apps to access all of the iPad's features. You won't be able to use the iPad camera to take photographs or scan barcodes within the application; upload pictures from the photo library; record an audio note; attach a Pages document; or capture a signature from the touch screen.