Mar
12
Written by:
John Pocknell
Monday, March 12, 2007
1. What is Team Coding
Team Coding is a cooperative source control feature. You can use Team Coding alone, or in conjunction with a third party version control system. Team Coding works with the Editor to control access and development of functions, procedures, packages, triggers and types. It also supports scripts in the Editor. Some of its key features include:
· Flexible Code Control Groups (CCGs), which help you control objects from one or more schemas, using customizable groupings.
· You can organize objects into CCGs by using object masks representing both specific database objects and collections of similar objects (by using the Oracle % wildcard). You can also set up exclusion masks to exclude specific objects from a CCG.
· Even without a third party version control product, you can use CCGs, to track referenced objects through Team Coding (though without revision history).
· All configuration data is stored in the database under Team Coding control. Individual workstations do not need to be configured.
Even better – it’s a Standard feature which I bet you hadn’t even heard of !
2. What is Server Side Objects Wizard?
The Server-Side Objects Wizard is designed to simplify the task of checking whether Team Coding is already configured on the user’s desktop, and if not, to run a script which installed a small repository (called the Team Coding Repository) into a database schema of the user’s choice (usually the Toad schema).
If you wish to install for the first time, select the first option as illustrated below.
Log on to the database in which you want the Team Coding Repository to be built. The Toad schema is recommended to help you manage where any Toad Server Objects are installed.
In the next step, choose the Team Coding option. This will create the required roles, tables, indexes, triggers, constraints and sequences in the Toad schema. Access to these objects is also granted to the Public role – this allows Team Coding “rules” to apply to every user of Toad.
Follow all the steps for creating the Server Side objects and also for creating the 3 Team Coding roles: TC_ADMIN_ROLE, TC_LDR_ROLE and TC_MGR_ROLE which can then be assigned to users as appropriate.
This is an order where you can control the access users have to the administration features in Team Coding such as the Team Coding Viewer and the ability to freeze, lock, etc. code in the database.
The rights which each role has are as follows:
- Administrator (TC_ADMIN_ROLE) - Can configure the instance to define how Team Coding operates, which VCS (if any) is used, and so on. This role is automatically assigned to the Toad user.
- Project Manager (TC_MGR_ROLE) - Can create and delete code control groups (CCGs) and relate them to a VCS project.
- Team Leader (TC_LDR_ROLE) - Can modify CCGs, define the objects or scripts are included in the group, and freeze objects. Can also delete rows from the Team Coding Viewer.
Users that are not granted one of these three roles hold the assumed role of developer. They can view the status of objects with the Team Coding Viewer and check items in and out of source control.
3. Setting the Usability Options
The usability options allow you to control a Team’s coding behavior in the environment with features such as Automatic Check-Out. Note, you can also specify the VCS provider’s name and default working directory.
4. Checking Team Coding Status
Finally, check the Team Coding Status (using a login with the TC_ADMIN_ROLE) to ensure everything is correctly set up.
Click the Settings button (below) to display the configuration options.
The Configuration tab allows you to select the VCS Provider (if you want to use one) and whether to use Code Control Groups (see 5 below) to determine how Developers can access the code.
Note: Team Coding will facilitate code access control even without a VCS if you do not have one. No versioning will take place, but code can be checked-out, locked and then checked-in to the Team Coding Repository.
The File Extension tab lists the default file types associated with using Team Coding.
The General tab enables you to set certain defaults like automatic generation of a new version number when you Check-In.
5. Code Control Groups
Code Control Groups are like filters which allow you to determine if code is controlled or not. If code is controlled using a Code Control Group, this means when a developer accesses the code through the Editor (or Schema Browser or Project Manager), Team Coding will automatically handle the request and perform a Check-Out from the VCS (if it is configured)
Here is an example of a Code Control Group called “Production Group” where all code in the “QUEST_PROD” schema will be controlled by Team Coding with the exception of the “OW_ORDER_TRIGGER” Trigger which will not.
6. Using Team Coding
Toad is now working under the Team Coding configuration.
When the user next launches Toad, they will see a window pop-up which prompts for the VCS login (if Team Coding is configured with a VCS). This option can be changed so that a VCS login would have to performed separately if the user so wishes.
As the code is Checked Out, Team Coding will automatically compare the code with the code in the database to see if they are the same. If not, a warning message will appear informing you that the code is out-of-sync and giving you the option of running a Compare, using the VCS version or using the Database version.
Once you are finished with the code, Team Coding will jump in again and control the Check In.
Finally, once Team Coding is in use by your Development team, and as a user with TC_ADMIN_TOLE, you will be able to monitor and manage access to your code both within the Team Coding Repository, but also within the VCS itself because Toad can access the VCS management console.
Team Coding Viewer
VCS Browser (Microsoft Visual Sourcesafe)
Correctly set up and implemented across your Development team, Team Coding will simplify and automate code management in a way which is much more secure and workflow oriented, leaving you time to concentrate on other things.
24 comment(s) so far...
Re: Toad for Oracle 9.0 - How To Setup Team Coding and VCS Integration
Welcome to Toad World John. Thanks for the contribution and we look forward to a lot more!
By Ceci on
Tuesday, March 13, 2007
|
Re: Toad for Oracle 9.0 - How To Setup Team Coding and VCS Integration
Nice first blog John - looking forward to reading more.
By Chasker on
Wednesday, March 14, 2007
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Hi John.
I just started enabling team coding in toad 9.0.1.8. we want to use team coding with MS Visual safe 2005.
Team coding status shows 2 items are in red.
1. VCS Provider is not initialized.
2. VCS provided is not connected.
when open toad, i get the error
"22:38:48 Error: Error initializing Team Coding: Failed to initialize VCS provider: Class not registered"
I am not sure which class it refers to.
There is no LOV available in Toad options >> team coding >> source control Provider.
But, in team coding setting i have selected MS visual source safe, which is installed on a network derive, not in my pc, where i am running the toad.
Appreciate, how can i fix the class not registered error.
Ganesan
email: ganesan.srirangan2@alcoa.com
By Ganesan on
Tuesday, July 08, 2008
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
There does not seem to be a method to add constraints to a code control group. Any advise?
Thank you.
By JohnE on
Monday, November 10, 2008
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Hi JohnE,
Team Coding and CCGs only supports the following object types:
Views
Functions
Procedures
Triggers
Packages
Package Bodies
Types
Type Bodies
Java Source
Tables & Constraints are not supported.
Regards,
John
By Pockers on
Wednesday, November 12, 2008
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Hi John.
I followed your instructions until step 4. I logged as Toad user (with TC_ADMIN_ROLE) and opened 'Team coding status' window. Marked by green were 'Team coding support installed', 'Version 6.0' and 'Use team coding' in Permisions block.
To enable team coding I clicked the 'Settings' button, then a message box appeared 'Connection settings will be read-only. For read and write privileges, you must have the Administrator role'.
I use Toad 9.0.1.8
Thank You for any advice
Martin
By MartinS on
Friday, November 21, 2008
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Hi Martin,
Did you check that the user Toad definitely has the TC_ADMIN_ROLE role granted and that you logged out and logged back in?
Also, try assigning the role to another user not yet logged onto Toad, then log on as that user and re-check.
Thanks,
John
By Pockers on
Monday, November 24, 2008
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
The second advice is right - to assign TC_ADMIN_ROLE to another user, log on as the user and check to enable team coding.
Thank You very much.
Martin
By MartinS on
Thursday, November 27, 2008
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Pleased to hear it works for you.
Regards,
John
By Pockers on
Thursday, November 27, 2008
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Hello John,
I have SQLNAV working with Visual Source Safe, for two schemas, however, after I setup a third schema to work with VSS I have the following issue.
When I right click on an object, package or index for example, on one pc I get the checkout option on the popup menu. Logged in as the same user on another pc, I do not get the menu choice to checkout. On the second pc, the menu choice to checkout does appear for the other 2 schemas.
Any ideas? Thank you.
By JohnE on
Friday, January 16, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
On the pc which does not get the pop-up, go into the Toad Options and select Version Control (or Source Control if 9.7) and check to make sure you have the Automatic Check-Out and Automatic Check-In boxes ticked as well as the Prompt for Comment boxes. Also, check that the Source Control Provided field is pointing to the correct VCS system and the correct working folder is selected.
John
By Pockers on
Monday, January 19, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
John,
We have now switched from VSS to Team Foundation Server. One issue is that I keep getting prompted to log into the TFS whenever I click on an object. How can I avoid being prompted to log in after logging once?
Thank you.
By JohnE on
Monday, February 23, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Toad Options | Source Control | "Disable Login Prompt on Connection"
Do you have this option checked on or not?
John
By Pockers on
Monday, February 23, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Is is checked.
By JohnE on
Monday, February 23, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
In that case, you should only be prompted once the first time you access an object. Are you using a Code Control Group, or do have everything accessible through TFS? Is your working directory specified correctly in Toad?
Could you try unchecking the box and having a single connection when you startup Toad to see if you still receive further login prompts?
The other thing is we have not tested TFS yet, so we are currently relying on it's SCC compliance.
Thanks,
John
By Pockers on
Monday, February 23, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Also make sure that TFS is not defaulted to use your Windows network name as a username, which may be different to the one you originally signed in with.
I just found this out in VSS.
John
By Pockers on
Thursday, February 26, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
How well does "Team Coding" integrate with open e.g. a package source from the database and not from a file?
Cheers
By croakk on
Thursday, March 26, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Once Team Coding is configured, it will be used whether you select code from the database or from the file system.
You simply use the Open From Database button in the Editor toolbar or File Open button.
John
By Pockers on
Thursday, March 26, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Thanks.
This is how I would like it to be, so this sounds good.
By croakk on
Thursday, March 26, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
No problem. Let me know if it works OK for you.
Regards,
John
By Pockers on
Thursday, March 26, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
John,
can you confirm if Toad 9.X can use TFS as the version control system? Is there any special/extra needed on the client PC to get it to work? Do you know if SQL Nav 6.X can use TFS as the VCS, too?
Thanks.
By Javier1 on
Friday, July 17, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Hi Javier,
No, Toad does not currently support TFS. It is down as a future requirement.
SQL Navigator 6.x does support TFS.
John
By Pockers on
Monday, July 20, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Hi John, thanks for the article.
Do you know whether Toad 9.7 integrates with the Oracle Repository (comes with Oracle Developer) as the VCS?
Thanks.
By swnd on
Tuesday, August 11, 2009
|
Re: Toad for Oracle 9.0 - How Do I Setup Team Coding and VCS Integration?
Toad's Team Coding does not integrate with Oracle Repository. The lowest common denominator for such support is adherance to the Microsoft SCC API standard. A full list of supported VCSs are listed in the Toad Help.
Thanks,
John
By Pockers on
Tuesday, August 25, 2009
|