I need to look at the contents of a dictionary table I've acquired by creating a dictionary, scheme, and data source. It appears to have been successfully acquired according to Data Source Acquire Now saying Successful. I'd like to view the table to see if it contains what I expect. I've downloaded a SQL tool (called SQL MDF Viewer) onto the WFA system. I am now trying to find where the WFA Cache database is and am searching throughout C:\Program Files\NetApp\WFA... but can not find any .MDF files which is what the tool opens
Thanks Sinhaa, (duh, yeah. MDF is MsSQL, not MySQL, my bad 🙂 ... but admittedly new to both.
Okay, I switched to DbVisualizer and installed it directly on my WFA server. I get error messages indicated that the user/pswd I'm using are proper credentials (user: wfa, pswd: Wfa123) but I still am prompted for the database name and I'm guessing at it. I have tried 'wfa', 'cache' and 'playground'. Noether 'wfa' nor 'cache' seem to (error: Access denied for user 'wfa'@'%' to database 'wfa') work but when I entered 'playground' as database name it actually seems to connect to something. But I am not interested in the playground. I'm wanting to look at a dictionary I have added which as I understand is in the normal WFA Cache database. What concept am I missing?