For the API it doesn’t matter if your catalog database is FDB or SQL, it can query it. MediaScript works with embedded data and has no mechanism to talk to a Portfolio database. So the first question would be are you an ‘Enterprise’ edition customer who has access to the API? If so, we have separate private forums for those who need assistance with API development and you should contact your Extensis Sales representative for more information on that.
However I’ve done example MediaScripts that work with custom field data from Portfolio, but where that data is being embedded (automatically if in the Web Client) into the original, usually into the ‘xap’ namespace which MediaScript can then read. But you say that’s not workable to you as it’s video files you’re working with? However, our product information page for “What’s New in Portfolio Server 10” states:
So maybe it can work for you, but the second question is therefore what video file format(s) are you working with? Maybe it’s one that’s supported for XMP metadata embed. If so, then yes you could use MediaScript to read your custom field data that you embed into the original assets. Without using this though, the only data MediaScript will take from video files is your typical video information, for example width, height, duration, frame count and frame rate. Not data that you’re defining in Portfolio therefore.