The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

DFM Sybase Permissions

MARK_BOWEN

Hi,

I've created a DSN on my workstation to the DFM database on the DFM Server and can see all the tables using the Sybase Central client but how do I grant the sql login permissions to perform select statements?  Without knowing the passwords to either the DBA, DBO or SYS sql logins?

I've been following the instructions laid out under section 3.5 of the document below but it doesn't seem to mention assigning permissions to the database user you create.

 

http://media.netapp.com/documents/tr-3690.pdf

I'm obviously missing something, any help would be greatly appreciated.

Cheers,

Mark

4 REPLIES 4

MARK_BOWEN

OK, i've just noticed that I can see the data by using the views built in to the db which the aforementioned document does actually mention... my bad!

JIATI0111

Did you get any luck getting ways to query the tables in the DFM database? It got to be using users other than the one created per the instruction since it is limited to access views only by design.

MARK_BOWEN

OK, whilst the views have helped a little in terms of seeing the data.  I would like to export the data using SQL Server Integration Services (SSIS) into a SQL Server database and have the data refreshed on a periodic basis so we can easily report on it using SSRS (Reporting Services).  This is easily achieved within SQL Server but I need more permissions to be able to extract the data from Sybase.

So my original question actually still stands.  How do I grant additional permissions to the DFM Database User that I have created and/or find out the passwords to the built in Sybase database users DBA, DBO, SYS etc?

or am I stuck with exporting the data from the views using the DFM command line & then using SSIS to import these flat files into a MSSQL database?  Can you schedule the 'export' to flat file?

One final question...

Does anyone know whether MSSQL will be supported in the next release of Operations Manager?

Thanks in advance.

adaikkap

Only views can be exported or queried, but not the other db tables.

Regards

adai

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public