Report Writing - Who does it?

Hi Kjersten, we have three IT persons to create any custom report, screen or utility, and run any ad-hoc query for the end-users. No one else creates any report or has direct access to Tessitura database (through SQL Server interface) for security reasons. I think if it’s too spread out across the organization, it will be hard to manage data security and also to remain PCI compliant.

Best,

Mo

National Ballet of Canada

I'm looking for some ideas on how you handle custom report writing in your organization as well as what you think are the pros and cons of your chosen model.  So, for example, does 1 person in IT handle all custom reporting needs or do you have a power user in each department that can write reports, but use IT to vet them and move them into the Production system?  Or something else entirely?  

We're tossing around ideas and trying to balance what we expect to be a big desire for more custom reporting quickly vs. the security concerns around having non-IT folks access the database.  

Thanks!

Kjersten Schladetzky
Program Manager, American Museum of Natural History 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Kjersten, we have three IT persons to create any custom report, screen or utility, and run any ad-hoc query for the end-users. No one else creates any report or has direct access to Tessitura database (through SQL Server interface) for security reasons. I think if it’s too spread out across the organization, it will be hard to manage data security and also to remain PCI compliant.

Best,

Mo

National Ballet of Canada

I'm looking for some ideas on how you handle custom report writing in your organization as well as what you think are the pros and cons of your chosen model.  So, for example, does 1 person in IT handle all custom reporting needs or do you have a power user in each department that can write reports, but use IT to vet them and move them into the Production system?  Or something else entirely?  

We're tossing around ideas and trying to balance what we expect to be a big desire for more custom reporting quickly vs. the security concerns around having non-IT folks access the database.  

Thanks!

Kjersten Schladetzky
Program Manager, American Museum of Natural History 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!