Integration of EViews with custom external database

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

abielr
Posts: 9
Joined: Wed Feb 04, 2009 12:25 pm

Integration of EViews with custom external database

Postby abielr » Tue May 04, 2010 10:12 am

I have a custom time series database server which I would like to integrate with EViews. To interface with the server the client sends a request in XML over HTTP. The server returns an XML block over HTTP that contains numerical data in binary form with base64 encoding.

Is it even technically possible to build an add-in for EViews that will interface with the database? I suspect that the Eviews language itself does not have the functionality, in which case I would need to write an add-in in another language that EViews can then work with.

Thanks.

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Integration of EViews with custom external database

Postby EViews Steve » Tue May 04, 2010 10:48 am

If you had an ODBC driver for your custom external database, EViews could read and write from it fine. Refer to our documentation for interfacing with ODBC databases. (e.g. wfopen(type=odbc) dsn_name "select * from table_name")

Assuming you don't have an ODBC driver, I would suggest using an external program to get the data from your database, and then use our COM Automation interface to write that data into an EViews workfile. Our COM interface supports Get and Put methods that take in arrays of numeric and string data. All you would have to do is get your data into an array format and then call our Put method to store this data into an EViews workfile.

Look at our whitepaper for examples on how to do this:
http://eviews.com/download/whitepapers/ ... mation.pdf

Steve


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests