• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 38 subscribers
  • Views 253 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

need help about Orion NPM database

omarinfi

Hi,

I am a new user of solarwinds orion npm, and I have a task to extract some data from its database. Well I need to export reports in Excel format, but here in this entreprise where I am a trainee they say that they don't have access to the report writer so I think that I'll have to connect to the orion database through JDBC and use JAVA language and sql query to extract data. Any Idea about this??

Parents
  • 0

    SQL Server supports many connection methods. I sometimes use Excel and/or Access to connect to the database and perform quick queries.

    For more complex reporting, I do nightly extracts to a separate database server so as to not load up the production server - this also might be a option for yourself if your access is limited to the production server.

    Have a look here  for some idea's using Reporting Services.

    Dave.

Reply
  • 0

    SQL Server supports many connection methods. I sometimes use Excel and/or Access to connect to the database and perform quick queries.

    For more complex reporting, I do nightly extracts to a separate database server so as to not load up the production server - this also might be a option for yourself if your access is limited to the production server.

    Have a look here  for some idea's using Reporting Services.

    Dave.

Children

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.