on Sep 23, 2008Our programming group would like to query the enVision database to pull data for an application they are developing. Is there anyone on the board querying the enVision database outside of the enVision application?
Thanks in advance.
-Scott
Our programming group would like to query the enVision database to pull data for an application they are developing. Is there anyone on the board querying the enVision database outside of the enVision application?
Thanks in advance.
-Scott
Thanks Matt.
We rather quickly determined that hooking the database wasn't an option.
I'm going to take the easy way out and schedule a report to generate a .csv.
Right now it looks like I'll have to create a share on the appliance that they can grab the file from - I tried mapping a drive, but mapped drives don't populate the "directory path" pop-up box within the report configuration page.
-Scott
Hi Scott,
Hmmm.... try adding a storage location with UNC path and remember to add the NIC_System user to the asset that is going to host the share. I have not tried it myself and would be selfishly interested in if it works...
Best Regards,
Alan
Hi Scott,
The IPDB is not open architecture (it's not a relational database so there's no ODBC hook to it, or any other non-enVision API for that matter) - the best you could do is run the lsdata command, save the output to a file, and send the output to your query group - they could manipulate the data that way.