Our company currently uses Commercial Media to handle our website programming. In the course of those operations, we are sometimes asked by them to provide information that only one such as I (DBA) would have access to; information within certain tables such as facil_no in T_FACILITY, Problem is, they often only ask someone other than me, such as a contact in Marketing. The answer to this so far, is to have me make those tables available to this Marketing contact so answers can be made available to CM whenever called for.
My question is this: if such things happen at other organizations, how are they handled? I could make a report in Reporting Services that pulls that data from whatever table is looked for, but that's about 21 tables and I don't want to have to do that. Unfortunately, I am not versed in dynamic SQL which might make this task a bit easier - or at least more efficient, coding-wise. I know that it's possible to make tables available in System Tables in Tessitura, but I'm not sure that's a good idea either.
Any suggestions?
As always, thank you in advance, Tessiturians.
BONUS TRIVIA MORSEL: On this day, October 13th, in 1792, the cornerstone of the White House was laid.
Hi Matt,
If you are familiar with creating SSIS packages you can simple create a package to transfer table data into Excel naming each sheet according to the table.
Schedule the package to run nightly( in what ever frequency you want).
You can also use Import—Export Wizard to create the package.
If not you can create a stored procedure and run it when ever.
Reference:-
http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/
Make sure that you save the Excel file in a shared folder on the server and the user have the access.
Creating reports for ‘21’ tables with the necessary information is not feasible according to me. This might require a little research initially but its worth it. These solutions doesn’t require coding.
Currently I am not having any packages built for exporting data as I have no requirement yet but I use couple of them for importing data.
Thank you,
Revanth.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Friday, October 15, 2010 2:10 PM To: Revanth Anne Subject: Re: [Tessitura Technical Forum] Table Openness
Matt Gonzales: The answer to this so far, is to have me make those tables available to this Marketing contact so answers can be made available to CM whenever called for.
Matt Gonzales:
The answer to this so far, is to have me make those tables available to this Marketing contact so answers can be made available to CM whenever called for.
Not a great idea. If they repeatedly need to know something from a system table that the user in question (in Marketing?!) doesn't usually have access to, I'd set up a custom report that pulls only the minimum tables, columns, types, etc. that this person needs to see.
From: Matt Gonzales <bounce-mattgonzales9808@tessituranetwork.com> Sent: 10/13/2010 12:00:58 PM
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!