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,
Have you looked at the System Table Listing report in the Miscellaneous folder?That might help with this issue.
Unknown said: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.
You can give users view only access to system tables. See the system table section in the Security Administration document for details.
There are a few IDs that your web integrator may want that do require querying the database. Facility ID is one of those. Most of them, though, can be found in a system table or on the screen where the item is set up (such as MOS and performances).
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
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.
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!