Page 1 of 1

Eviews and snowflake

Posted: Tue Jul 13, 2021 5:23 pm
by Vicky
Hi all,

Wondering if anyone made a successful connection between Eviews and Snowflakes. I can connect Eviews and Excel through ODBC driver, but somehow couldn't make Eviews and Snowflake connected. I also couldn't find Evews logfile.

Thanks in advance if anyone can offer help.

Vicky

Re: Eviews and snowflake

Posted: Wed Jul 14, 2021 11:04 am
by EViews Steve
Turns out the Snowflake ODBC driver won't let you connect interactively as is normally required for use in EViews. To work around this problem, you'll have to manually create a DSN file and then use that from within EViews. Here's what the DSN file should look like:

Code: Select all

[ODBC] DRIVER=SnowflakeDSIIDriver UID=myusername PWD=mypassword SERVER=myservername DATABASE=mydb SCHEMA=myschema WAREHOUSE=mywarehouse ROLE=myrole APP=EViews
Replace all the values above (including your password) with your own specific values then save this file in your Documents folder as testsnow.dsn.

Then start EViews, go to File menu/Open/Workfiles, select ODBC from the File Type dropdown, then select the "testsnow.dsn" from your Documents folder. Assuming all the values were correct, you should see a "Select table" dialog appear with a list of available tables.

Steve