Eviews and snowflake

For questions regarding installation and registration of EViews.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

Vicky
Posts: 1
Joined: Tue Jul 13, 2021 4:17 pm

Eviews and snowflake

Postby Vicky » 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

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

Re: Eviews and snowflake

Postby EViews Steve » 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


Return to “Installation and Registration”

Who is online

Users browsing this forum: No registered users and 11 guests