We are currently using FDM to post data to Essbase. The solution I have designed is to use SQL SSIS package to import data from text files into a SQL staging table. I then do some manipulation of the data. I am using SSIS due to the functionality that can be incorporated.
I then use FDM to import the data from the SQL table using an import script in VB.
This all works, but what I want to know is if I can call a vbscript from the SSIS package (can be a batch file), to automate the import, validate and export process?
In essence I need a batch script to run 3 fish process in FDM, so no manual intervention is needed.
You should be able to do this using the upsShell utility (upsShell.exe) that ships with FDM. This allows you to start a batch process from the command line, so could be incorporated into a batch file which could be called from your SSIS package. Take a look at the batchloader section of the FDM admin guide as this will get you started on what needs to be done