Need to set up DB with API, considering SQL, need your expert advice
basically, we need to have a database where people can drop of files through an API into our system.
so primarily we need a database/database server where people can drop of files through an API. We then need to have to be able to access this data at some point. secondly, we eventually want to have a secure public interface where people can run reports. but this is not a priority
as i have some experience(years ago) with managing SQL database through MS access, i think that basically, it will take the following steps:
get a Windows SQL database server
hire somebody to set up the database/API on it
once its working, use MS Access to pull the data that was put in through the API
obviously, im new at this will the above work, what do i need to be careful with? any advice would be appreciated
|