EViews.com

Posted: **Tue Jul 13, 2021 5:23 pm**

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

Posted: **Wed Jul 14, 2021 11:04 am**

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

EViews.com

Eviews and snowflake

Eviews and snowflake

Re: Eviews and snowflake