Software Tool For PPM

Software for Project Portfolio Management  (Please check suppliers' websites to ensure accurate information)
Provider	Product	Focus
1000Minds	1000Minds	General / collaborative ranking, conjoint analysis / New Zealand / on site, SaaS
4c Systems	4c Portfolio Manager	General / project scoring / suite / UK / on site
Algorithmics	Algo Risk	Financial institutions / cap. allocation, risk, market data / Canada / on site
Artemis	Artemis 7	IT, new prods., gov / proj. & resource management, scoring / Int'l / on site, web
Asta	Teamplan	IT, professional services / project & resource management / UK / on site
Atlantic Global	PPM	IT, gen., mid-sized firms / demand, resource & fin. mngmnt. / UK / SaaS
AtTask	@Task	General, IT / proj. & resource management, workflow, suite / Int'l / SaaS
Augeo Software	Augeo5™ PPM	IT, prof. services, new products / project visibility & control / Europe / on site
Automation Centre	Project Tracker	General / proj. mngmt., Lotus & Microsoft Outlook based, suite / USA / web
Axium	Portfolio	Architecture & Eng / project management & resource planning / USA / on site
Barometrix	Precision IQ™	General / cost-benefit analysis, financials / USA / on site
Bicore	FlightMap	New prods. / preconfigured & custom models / Netherlands / web, hosted
BMC Software	PPM	IT / financial, governance, compliance, vendor management, suite / Int'l / on site
Borland	Tempo™	IT / project & demand management, scheduling, alignment / USA / on site, web
BOT International	Processes on Demand PMO	General, gov / project management, templates, scoring / Int'l / SaaS
CA	Clarity™	IT, new products / project & resource management, suite / Int'l / on site, SaaS
Canea	Canea Framework	Gen. / proj. & resource planning, prioritization, suite / Sweden / on-site, web
Cambridge Systematics	Prioritas™	Transportation / prioritization, custom models / USA, Netherlands / on site, web
Cardinis	Cardinis Suite	IT / strategy, planning & governance, EVM, suite / Italy / on site, web
Catalyze	Equity3	General / budgeting, prioritization based on MCDA / UK, New Zealand / desktop
Clarizen	Clarizen	General / project & resource management, status reporting / Int'l / SaaS
Compuware	Changepoint	IT, prof. services / proj. & resource management, suite / Int'l / on site, SaaS
Cogentus	Promax	Gen. / prioritization w/ funding constraints, custom models / UK, USA / desktop
CopperLeaf	ESP	Asset-intensive industries / planning, budgeting, prioritization / Canada / web
CorasWorks	PPM Version 1.3	Gen., gov / project tracking & reporting / Microsoft Sharepoint app / USA
Cranes Software	InventX™ ePM	New prods. / statistical analytics, customizable, suite / India / on site, web
Daptiv	Daptiv PPM	IT, HR / proj. & resource management, collaboration / Int'l / SaaS
Davies Consulting	AIS™	Energy, healthcare / prioritization, client value functions / USA / on site, web
Decision Lens	Decision Lens	Gen. / collaboration, custom rate-and-weight models, AHP / USA / on site, web
Dekker	PMIS™	General / project & resource management, scorecards / USA / on site, web
Deltek	Deltek Enterprise	General, gov / proj. & resource management, compliance, suite / USA, UK / web
Digite	PPM	IT / Scorecards, what-if analysis / USA, India / SaaS
D-Sight	D-Sight	Gen. / group dec-mkg., multi-crit., collab., PROMETHEE / Belgium / desk, web
Eclipse	Eclipse PPM	General / res. management, prioritization based on objectives / USA / SaaS
EDC Technology	Portfolio Intelligence	Mid-sized firms, schools / schedlng., trackng., scoring, modular / USA / SaaS
Enrich	EPS	Pharma, bio, high-tech / prioritization, cust. models / USA / on site, SaaS
EPM Live	PortfolioEngine	Gen. / planing, demand mgmt., alignmnt., MS SharePoint / USA / on site, SaaS
Expert Choice®	Comparion™ Suite	General / collaboration, scoring, AHP, suite / USA / standalone, SaaS
Folio Technologies	Folio Priority System	Various / portfolio optimization, internal modeling platform / USA / on site, SaaS
Fujitsu	sDIS+	Banking, finance / price & liquidity risk / Int'l / on site, web
Genius Inside	Genius Project	IT, new prods., prof. services / planning & execution, suite / Int'l / on site, SaaS
GenSight	Gensight® PPM	Various / stage-gate, scalable, alignment / genetic algorithms / UK, USA / web
Glomark-Governan	GeniusCompare/Optimizer™	Tech buyers / bus. case preparation, prioritization / USA, Mexico / standalone
Guidon	GuidonVue	Prof services / Six-Sigma, multi-project management / USA / SaaS
HP Software	PPM Center	IT / project & resource management, alignment, suite / Int'l / on site, SaaS
IBM	Rational Focal Point	IT / proj. & res. mngmnt., ALM, benefit scoring, suite / Int'l / on site, SaaS
i-lign	i-lign	Gen. / proj. & resource mngmnt., alignment / New Zealand / Java, web, SaaS
InfoHarvest	Criterium DecisionPlus®	General / multi-criteria decision software, custom models / USA / desktop
Innotas	PPM Solution	IT / governance; resource, financial & time mngmnt., alignment / USA /SaaS
Instantis	EnterpriseTrack™	IT, new prods. industry modules / project tracking, six sigma / USA, UK / SaaS
Inventx®	SP2M™	Industry templates / project & resource management, suite / India / web
iPlanWare	TeamWorks	IT, prof. services, R&D / project, time & resource management / UK / SaaS
i.s.edge	Project Network	General / Dashboard, project management, resource planning / USA / web
KeyedInSolutions	KeyedInProjects	General / project visibility, scoring, scalable, suite / USA / SAAS
Logical Decisions®	LDW Portfolio	General / budgeting, prioritization, custom MCDA models / USA / desktop
Lumina	Analytica	General / custom models, analysis, optimization / USA / desktop, on site
MaestroTec	Maestro-PPM	Prof services, IT / proj. & engagement management, suite / USA / on site, SaaS
Make It Rational	Make It Rational	General / collaborative ranking and decision making, AHP / Europe / SaaS
Meridian Systems	Proliance	Construction, prop. mgmt. / proj. lifecycle management / USA, Canada / on site
Metier	PPM Central	General / project & resource management, forecasting / USA / on site, SaaS
Microsoft	EPM	Gen., IT / proj. & resource mngmnt., alignment, AHP, suite / Int'l / on site, web
Mindmap	MindManager	IT / project planning, collaboration, strategic alignment / USA / Mac, web
OneDesk	OneDesk PPM	New products / Multi-project management, project planning / Canada / SaaS
Onepoint Software	Project Enterprise	Manufacturing / project, resource & collaboration / Europe, USA / on site, SaaS
OpenAir	Enterprise	Prof. services / project management, tracking & billing, EVM / USA / SaaS
Oracle	Crystal Ball®	General / risk analysis, simulation & opt., custom tools / Int'l / spreadsheet
Oracle E-Business	E-Business Suite	Gen. / resource, cust. relationship & supply chain mngmnt., suite / Int'l / web
Oracle Fusion	Fusion PPM	IT / collaboration, multi project management, suite / Int'l / web
Oracle JD Edwards	EnterpriseOne	Gen., gov., mid-sized firms / lifecycle; multi proj. mngmnt., billing / Int'l / web
Oracle PeopleSoft	PeopleSoft PPM	Prof. services, general / templates, project versions / Int'l / on site, web
Oracle Primavera	Primavera Enterprise PPM	Gen, construction / accounting, planning, resource mgmt. / Int'l / on site, web
Palisade	Decision Tools Suite	R&D, gen. / decision & risk modeling, cust. optimization tools / Int'l / Excel
Planisware	Planisware 5	New prods, IT, pharma, aero & defense / balance, algnmnt. / Int'l / on site, SaaS
PlanningForce	Portfolio Planner	Gen. / plan. & res. schdlg., direct priority assgnmt. / Belgium / desktop, onsite
PlanView	Enterprise™	IT, new prods. / proj. & resource management, collaboration, suite / Int'l / web
Portfolio Decisions	Customized software	General / consulting, process improvement, custom tools / USA / on site
Portfolio Decisionware	PDWare™	Gen., small firms / demand & capacity mngmnt., time tracking / USA / on site
Post Vision Technology	PPO™	Prof. services / collaboration, multi-project & res. mgmt. / South Africa / SaaS
PowerPlan	PowerPlant	Utilities / asset management, accounting, custom prioritization / USA / on site
PowerSteering	Enterprise	IT, new products / project management, alignment / USA / SaaS
Project Insight	Project Insight	General / project management, scorecard prioritization / USA / on site, SaaS
Project InVision	InVision 8	IT, prof. serv. / proj. & res. mgmt., alignmnt. / USA, UK, Mexico / on site, SaaS
Project.net	Project.net	General / scorecards, reporting, social networking, open source / USA / web
ProjectObjects	ProjectFolio	IT, new prods. / strategic alignment, targets, suite / Ireland, Italy, India / web
Projectplace	Projectplace	Gen. / collaboration, proj. planning, doc. mgmt. / Europe, India / SaaS, plug-in
Project Portfolio Office	Project Portfolio Office	Gen. / multi-proj, res. mgmt., planning, time cards, scoring / South Africa/ SaaS
ProModel	Portfolio Simulator	General / project management, collaboration, alignment / USA / desktop
Psoda Limited	Psoda	IT, testing, new prods. / proj. mngmnt., scoring / modular / New Zealand / SaaS
QuickArrow	PSA Solution	Prof. services / proj. & resource management, billing / USA / SaaS
SAP®	Port. & Proj. Management	Gen., IT, new products / lifecycle management, alignment, suite / Int'l / on site
Saviom Software	Saviom Project Management	Gen. / program, resource, proj. & time management / Australia, India / on site
Sciforma	Sciforma 4	Gen. / proj. management, scheduling, collaboration / USA / SaaS, on site
Semanticspace	PPM Studio	IT, gen. / proj. & resource mgmt., suite / Int'l / desktop, on site, SaaS
Sentient	PPM	Airlines, manufacturing / pipeline mgmt., suite / New Zealand / on site or SaaS
Serena	Mariner PPM	IT, gen. / proj. & resource management, alignment / USA, Brazil / SaaS
SigmaFlow®	Lean Six Sigma	Gen. / Multi-project tracking, templates, Six Sigma, scoring / USA / SaaS
Skire	Unifier™	Large projs., real estate, facilities / process automation, alignment / USA / web
Smart Org	Portfolio Navigator™	R&D, new prods. / simulation custm. value models, risk anal. / USA, UK / web
SOA Software	Eclipse PPM	IT / governance automation, alignment, suite / USA / mainframe, on site, web
Solution Q	Eclipse	General / risk balancing & reporting / USA / web
Sopheon	Accolade™	New prods. / roadmapping, simulation, strategic alignment / Int'l / web
Stand by Soft	RationalPlan Multi Project	General, small firms / multi-project & resource management / Romania / SaaS
Syncopation Software	DPL Portfolio	Gen. / decision trees, influence diagrams, portfolio optimization / USA / desktop
TeamDynamix	TDPortfolio Planning	Gov., colleges, construction / proj. management / USA / on site, web
Tenrox	PPM	Gen. / time & cost management, proj. execution, suite / Int'l / SaaS
UMS Group	POP©	Utilities / asset mgmt., optimization, custom models / Int'l / spreadsheet apps
UMT	Project Essentials	Gen. / proj. fin., optimization, integrates w/ Microsoft Proj Server / USA / on site
Unanet	Project Portfolio	Prof. services / proj., time & expense mgmt., suite / USA / on Site, SaaS
Unit 4	Agresso Business World	Gen. / res., payroll, proj. & procurement mgmt., suite / Netherlands / web
Vanguard Software	Business Analytics Suite™	Gen. / decision modeling, optimization / suite / USA / desktop
VCSonline	VPMi	General / project & resource management, scoring / USA / SaaS
XenLogic	TOBi	Prof. services / business intelligence, reporting, suite / USA / on site

Microsoft Project Issue with Clarity V13

we recently upgraded from V12.1 to V13 and everything works fine except the Microsoft Project Schedule.

When we try to export to MSP it opens up in MSP and downloads all the task and related information which we could see. Immediate after that it says removing says and all the task populated is getting removed and stays blank.
Not sure anyone face this issue.

Appreciate your feedback on this. 

Answer

We had a user with some issues using MSP 2007 and Clarity...we upgraded to MSP 2010 and problem solved. What we did: Upgrade to MSP 2010, then re-install the connector (MSP/Clarity)

Clarity Integration with Excel and Sharepoint

They are tools which can connect Clarity from Excel and Share point through web services.

Please use the below link and connect ITROI.

http://www.itroisolutions.com/en-us/it-roiproducts/ppmdocumentboss.aspx

PPM Document Boss Demo

Highlights:

• Supports Clarity - Risks, Issues and Change Requests
• Drag & Drop capabilities
• Upload, download capabilities
• Full integration with Microsoft Office 365
• Full search collaboration SharePoint functionality
• Ability to map network drives to Clarity Projects
• Utilize SharePoint as the document repository for Projects
• Fully integrated team and/or collaboration security from Clarity to Sharepoint
• No need for additional Clarity licenses to share documents throughout the enterprise

http://integration-bridge.com/downloads/guc/
path to download

PPM Excel Interface

Automatic data validation (avoid bad data load issues) for lookups, date fields, booleans, and numerics. • Validation directly against lookups in Clarity. • Fast reliable updates. • Fully auditable via staging tables, and logs. • Built in reporting for data loads (automatically generate NSQL Portlets of data loads). • Built in data validation, pinpoint data issues quickly. • Completely configurable interface for Clarity. • No limit to what data can be loaded/retrieved via our PPM Excel Interface.

Clarity Gel Script For Updating the Task attribute based on project attribute

<gel:script
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:sql="jelly:sql" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&rt;
<gel:setDataSource dbId="Niku"/&rt;
<core:catch var="v_exception_WBSO"&rt;
<sql:query var="qry_get_WBSO"&rt;
select
case odf.wbso_subsidy
when 'ws_yes' then 'Yes'
else 'No'
end wbso_subsidy
from odf_ca_project odf,prtask prt
where odf.id=prt.prprojectid
and prt.prid=(${gel_objectInstanceId})
</sql:query&rt;
<gel:log&rt;Update WBSO on Task level.(${gel_objectInstanceId})</gel:log&rt;

</core:catch&rt;
<core:choose&rt;
<core:when test="${v_exception_WBSO eq null}"&rt;
<core:set value="${qry_get_WBSO.rows[0].wbso_subsidy}" var="var_wbso"/&rt;
<gel:log&rt;Update var_wbso on Task level.(${var_wbso})</gel:log&rt;
<core:catch var="v_exception_update"&rt;
<sql:update&rt;
update odf_ca_task set wbso100 = ? where id=(${gel_objectInstanceId})
<sql:param value="${var_wbso}"/&rt;
</sql:update&rt;
</core:catch&rt;
<core:choose&rt;
<core:when test="${v_exception_update != null}"&rt;
<gel:log category="Update" level="ERROR"&rt;
Failure: Update WBSO on Task level.
</gel:log&rt;
</core:when&rt;
<core:otherwise/&rt;
</core:choose&rt;
</core:when&rt;
<core:otherwise&rt;
<gel:log&rt;Error in getting the WBSO of the project. ${v_exception_WBSO}</gel:log&rt;
        </core:otherwise&rt;
    </core:choose&rt;
</gel:script&rt;

Who can see the collabration tab in Clarity?

Project manager

Matrix Using Clarity

There is a requirement in Financial Management of Clarity

--  Resources are will work two different countries(USA,Europe)
 and need to update matrix in the back end. In the report the actual should calculate based on the country which resource works. 

I have updated the matrix based on the below Xog query 

   

       





   <?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_matrix.xsd">
    <Header action="write" externalSource="NIKU" objectType="matrix" version="12.1.1.1208"/>
    <matrices>
        <matrix defaultCurrencyCode="EUR" name="Healthcare Design" type="Cost/Rate">
            <columns>
                <column name="resource"/>
            </columns>
            <matrixRows>

   

                  <   fromDate="2013-01-01" rate="104" resource="HCD0002"

                    standardCost="151" toDate="2013-12-31"/>

   

       

   

For pick the values based on the country/Operational OBS used below function in the backend(oracle) by using PL/SQL

CREATE OR REPLACE FUNCTION CLARITY.z_get_res_rate_fct (

   param_date           VARCHAR2,

   param_resource_id    VARCHAR2,

   param_obs_id         VARCHAR2)

   RETURN NUMBER

AS

   rate     NUMBER;

   matrix   NUMBER;

   matrix1  NUMBER; 

   param_obs_in NUMBER;

BEGIN

-- Actual cost -- if we works for same country project

   SELECT CASE 

             WHEN param_obs_id = 5003878  THEN 5002161 -- Europe

             WHEN param_obs_id = 5003879  THEN 5002360 -- United States

             WHEN param_obs_id = 5003880  THEN 5002161  -- China connect with Europe as per the requirment

             ELSE 0

          END into matrix

     FROM DUAL;

  

select nvl(( SELECT numval3

          FROM (  SELECT pmv.numval3

               FROM ppa_matrix pm, ppa_matrixvalues pmv

              WHERE     pm.matrixkey = pmv.matrixkey

                    AND value1 = param_resource_id

                    and pmv.matrixkey = nvl(matrix,pmv.matrixkey)

                    AND TO_CHAR (pmv.fromdate, 'YYYY') = param_date

           ORDER BY fromDate DESC, numval3 DESC) tes

    WHERE ROWNUM = 1),0) INTO rate from dual;

    

-- Standard cost -- If we works for different country project    

    

    IF RATE=0 THEN

    

    param_obs_in:=0;

        

        IF param_obs_id=5003878 THEN        

          param_obs_in:=5002360;

        ELSIF param_obs_id=5003879 THEN

          param_obs_in:=5002161;

        ELSIF param_obs_id=5003880 THEN

          param_obs_in:=5002360;

        END IF  ;

        

        

        SELECT param_obs_in INTO matrix1 FROM DUAL;

        

             SELECT numval2

             INTO rate

             FROM (SELECT pmv.numval2

                       FROM ppa_matrix pm, ppa_matrixvalues pmv

                      WHERE     pm.matrixkey = pmv.matrixkey

                            AND value1 = param_resource_id

                            and pmv.matrixkey = nvl(matrix1,pmv.matrixkey)

                            AND TO_CHAR (pmv.fromdate, 'YYYY') = param_date

                   ORDER BY fromDate DESC, numval3 DESC) tes WHERE ROWNUM = 1;

    END IF ;

   RETURN rate;

END;

/

Note: When ever do Matrix XOG writing for resources, make sure financial information configured in the resource level. If not configured it wont allow to write matrix for the resource in the back end.

What is the use partition in Clarity ?

Partition is one of the out of box concept and functionality in Clarity, which will help organization to keep one instance multiple discipline like sector wise configuration.

Create one clarity instance and host in to server, based on the sector (Healthcare, lighting, Consumer lifestyle etc..) you can do the partition and no need to create separate instance and licence.


Happy Knowledge
Bala

How many OBS level can create in Clarity?

We can create only 10 OBS level in clarity 12.1.0

Connecting CA Clarity PPM Through Visual Studio 2010

There is a requirement where we need to access clarity data through web service using Visual Studio 2010.

I have connected successfully using below code and steps and hope it helps

Steps In Clarity 

http://serverlocation/niku/wsdl/Query

The above path you can find the list of N-SQL query created in Clarity. If you want to your own customization query, go to clarity and click there is a menu list called Query.
Using N-SQL language you can create the query. after creation you find the query name using the above link.

For example : 
In clarity, i am going to create Query name called "Resource_data", once created  you can access through
this URL : http://serverlocation/niku/wsdl/Query/Resource_data


Steps in Visual Studio 2010

http://serverlocation/niku/wsdl/Query/Resource_data

This is the link we are going to use for accessing the clarity data from Visual Studio 2010.

Step1:

Create one new Web Application/Stand alone project

Step2:

Go To Solution explorer. --> Using Service Reference -- Connect Above mentioned URL.

Step3:

After successful completion of above step, please declare the service name in the top of page.
and start accessing all the classes and method.

Sample Source code based on URL mentioned.


            string sessionId = string.Empty;
            Auth objAuth = new Auth();
            objAuth.Username = "XOG_USER";
            objAuth.Password = "test";


           
         
           Resource_dataFilter objFilter = new Resource_dataFilter();
            objFilter.res_id = "5015283";
            Resource_dataQuery objResourcequery = new Resource_dataQuery();
            objResourcequery.Code = "Resource_data";
            objResourcequery.Filter = objFilter;

            Resource_dataQueryResult objectresult = new Resource_dataQueryResult();
                   
            Resource_dataQueryPortClient objClient = new Resource_dataQueryPortClient();
            sessionId = objClient.WrappedLogin("XOG_USER", "test");
         
            objectresult = objClient.Query(objAuth, objResourcequery);

This example based on the resource id will receive all the respective data through WSDL.
Note: In the source code, highlighted one vary based your URL and query name.

Happy Coding 
Bala

List of Resource Based on Role in Clarity

I am downloading the resources who is having the access to create the task under project.

Sample query


SELECT user_id,user_name
FROM cmn_sec_assgnd_obj_perm_r_v
WHERE object_type = 'RECORD'
AND object_code = 'PRJ_PROJECT'
AND permission_code IN ('prProjectViewer')
AND component_code = 'PRJ'

Happy Coding

Bala

Actuate Spreed Sheet - Connect and Configure Database

As i mentioned in the earlier post and open .vts file.

Step 1:

Click "Data Manager" in Data menu

Step 2:

You can use below connectivity to connect respective destination

- ODBC connection
- JDBC Connection
- File/URL Connection
- SAP Connection
- XML Connection
- Actuate data integration service connection

Step 3:

I have used ODBC connection to connect database for my report.

Note: There is a challenge, some time TNSnames.ora file configuration will not work here. better to create new connectivity datasource by using ODBC connection in control panel.
Also note: windows 7 - we need to use odbc bat file to create new datasource

happy coding
Bala

Actuate Spread Sheet Configure for existing report to modify

Step 1:
Install Actuate Spread Sheet report version 7

Step 2:
Download, There is a file name with extension called VTF.

Step 3:
Convert VTF extension in to .ZIP file and extract all the files.

Step 4:
After extraction, you can see three files with .vts,.guid and rop.
Example:
test.vts
test.guid
test.rop

Step 5:
we will take example of above mentioned files. open "test.vts" file, then it will take in to spreed sheet report to do the changes.

Note: The version 7, will not allow to open immediately, again you have to open same file by using 
menu option "open". 

Clearing the Caches in Clarity

In the URL

please type "Security.caches" in the clarity URL(Refer below URL) and enter you will see some buttons with flush and flush all.

please click on flush all and it will clear your cache.

http://serverlocation/niku/app?action=security.caches


happy coding
Bala

Clarity important tables to connect project and task.

Clarity important tables to connect project and task.
They are three tables 

- odf_ca_project ( This will have the all the attributes created for project)
- odf_ca_task ( This will have the all the attributes created for tasks under project)
- prtask ( This is important table which will connect the project and tasks by using project id.)

Sample query to connect the task and project by using prtask table.

update odf_ca_task oct

set oct.wbso100 = 'Yes'

where oct.id in (select prt.prid from odf_ca_project odf,prtask prt

where prt.prprojectid = odf.id

and odf.wbso_subsidy = 'ws_yes');

Happy coding 

Bala

Clarity 13 Offline Time sheet Will not be avilable

Clarity 13 Offline Time sheet

Offline time sheet will not available any more in clarity 13 release.

Configuring Actuate Spread Sheet Report.

Step 1:

Install actuate spread sheet report from Actuate website. 

Step 1:

Mentioned below file require to do the modification.

Example: R175_Phi_Month_v0.1_qa.VTX design file you will get 

Step 2: 

Convert to the above file to zip file like this R175_Phi_Month_v0.1_qa.ZIP

Step 3: 

After converting extract the zip file and you will fine three files. 

- R175_Phi_Month_v0.1_qa.guid  (Guid File)

- R175_Phi_Month_v0.1_qa (Actuate parameter Template)

- R175_Phi_Month_v0.1_qa (Formula one file)

Click on the Actuate parameter template file, it will open in the spread sheet environment. 

some time if does not open, please reopen through actuate spread sheet. 

Step 4:

After opening go to Data file and then click "Data manager", you can find the connection and query, 

if you have any connection issue in the odbc. create connection through ODBC driver.

Happy coding 

Bala

Create ODBC connection using Windows 7

Step 1:

open this path in windows C:\Windows\SysWOW64

Step 2:

Please click on this file :odbcad32

Step 3:

After clicking the above mentioned file, it will open popup window with contains multiple tabs.

Step 4:
please open "System DSN" tab to select and add the ODBC connection to respective database servers

Happy coding
Bala

Clarity 13 Performance

Clarity 13 Partial load

When you make changes in the page only part of the page needs to be refreshed. instead of whole page like previous version of clarity.

You will notice that there is now a # sign in the URL. This is what allows clarity reload/redraw part of the page instead of whole page.

Actuate Chart Report

Dynamically changing the chart value by using the CustomizeCategoriesAndSeries event

Sub CustomizeCategoriesAndSeries( baseLayer As AcChartLayer, overlayLayer As AcChartLayer, studyLayers() As AcChartLayer )

Super::CustomizeCategoriesAndSeries( baseLayer, overlayLayer, studyLayers )

Dim checkMonth as integer

checkMonth=month(now)

if(checkMonth<>1) then

Dim numberOfSeries As Integer

numberOfSeries = baseLayer.GetNumberOfSeries( )

Dim seriesIndex As Integer

For seriesIndex =checkMonth To numberOfSeries

Dim series As AcChartSeries

Set series = baseLayer.GetSeries( seriesIndex )

Dim point As AcChartPoint

Dim pointIndex As Integer

Set point = series.GetPoint( 1 )

point.SetYValue(0)

Next seriesIndex

end if

End Sub

Full Text Search in SQL Server 2012

The Full Text Search in SQL Server 2012 has been enhanced by allowing you to search and index data stored in extended properties or metadata. Consider a PDF document that has "properties" filled in like Name, Type, Folder path, Size, Date Created, etc. In the newest release of SQL Server, this data could be indexes and searched along with the data in the document itself. The data does have to be exposed to work, but it's possible now

Ad-Hoc Query Paging in Sqlserver 2012

Ad-Hoc Query Paging:

Paging results in SQL Server has been discussed for years. The Order By option in the SQL SELECT statement has been enhanced in SQL Server 2012. Using a combination of OFFSET and FETCH along with ORDER BY gives you control of paging through a result set. Using this technique can really help performance by bring back only the results you want to show to your users when they are needed. The following TSQL code runs against the Person table in the AdventureWorks sample database (available from Microsoft). In the sample query below, SQL Server would return 10 records beginning with record 11. The OFFSET command provides a starting point for the SELECT statement in terms of paging, and the FETCH command provides how many records to return at a time.

SELECT BusinessEntityID, FirstName, LastName FROM Person.Person ORDER BY BusinessEntityID OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

Drag & Drop Feture using HTML 5

I like personally this new interesting feature, two years back i was done  manually through javascript by using list in html and took time. Now in HTML 5 made very simple.

New Features in HTML 5

- New feaures should be based on HTML, DOM, CSS3 and Javascript
- Reduce the need of external plugins (like flash)
- Better error handling
- More markup to replace scripting
- HTML 5 should be device independent.

T-SQL Rediscovered with SQL Server 2012

SQL Server 2012 introduces a plethora of the new enhancements in T-SQL. With newly introduced syntax the code of the 100s lines can be reduced to merely few lines. By converting the old T-SQL syntax to new T-SQL syntax one can immediately get enormous performance improvement. This session will cover T-SQL tips and tricks which will make writing the code more fun!

Sync Fushion Grid Control

i have come across situation like to increase the performance Sync fusion
Grid control. for that have tried all our asp.net datasource. but we couln't able to
increase. finally found Sync fusion control itself having data source object (Grouppassdatasource).

Grouppassdatasource:

which will connect from datacontext.

Datacontext.

you have to create using link to sql data file (deml extension).

Sync fusion datasource name is GroupPassdatasource

Note: GroupPassdatasource should be with update panel

Motion Framework in Infragistics

Infragistics come up with the new technology called "motion frame work". which will give the full feature of visualization of the data in the impresive manner and animated experience.

It will be mainly used across the Silver light and wpf data visualization applications.

Running earlier version of Existing application in VS 2010.

Microsoft come with new option to build the existing application. I am really love to learn the new building option. It's really a simple step to complete the existing
lower version ( for example .net 2.0) application to building in the Visual studio 2010. Thanks to microsoft. The below element have to implement in the web.config file with the version details.

Element Name: in application configuration file.

URL Mapping in Visual studio 2010

visual studio come up with new feature called url mapping

There is method called "Response.RedirectPermanent()" will be used to map the url instead of using web.config method in the earlier version of Visual studio.

Visual Studio 2010 Part 1

I have been to VS 2010-ALM finals at Taj Residency in Bangalore. It’s really a very informative and fun session. I am just writing in my blog to share with you all. Let‘s talk about the speaker.
His name is Teju’s from Microsoft Bangalore. He is a great Man and great attitude and more over is active and young. He has shown many features with us about visual studio 2010. Let’s talk one by one.

My view of session it was great and very informative. Really visual studio 2010 will rock soon all your system. Now we have Beta. Try the nice feature and rock.Carrier perspective it’s going to create lot of opportunities. Really you will love it and do it.

Microsoft comes up with the different packages for Visual studio 2010.
Visual Studio 2010-Ultimate.
This is comprehensive suite of application life cycle management tools for teams to ensure quality results from design to development.

Visual Studio 2010- Premium.
A complete tool set for developer to deliver scalable high quality applications.

Visual Studio 2010- Professional.
This is essential tool set for doing basic development tasks to allow developers to implement their ideas easily.

Visual Studio Test Elements-2010
This is separate tool apart from vsts 2010. This is specifically for the tester.
VSTS 2010 had plenty of improvements and new features. Let’s talk about some coolest and hottest feature.

Debugging and diagnosis:
1) Intelli trace.
a. It’s one of the best feature ever never heard from any other development areas.
This is give you exact definition about the problem. When we have situation like in production environment user’s are having some issues but not having in the other environment. That time only our Intellin trace comes in to picture.

2) Static Code Analysis.
It’s one of the coolest features. Using this tool can define the best practices of the code.
If you not followed the best practices and build will fails.
3) Code Metrics.
User can see the chart level description about the code.
4) 64 Bit Support.
5) Break point Improvement.
a. Filtering
b. Label attachment for each break point.
Architectural Complaints:
1) Layer Diagram:
This is one of the nice features once you assign the layer for the solution. It should stick on that.
2) One shot all dependencies can show.
3) UML Added.
WPF Improvements:
1) Touch Input can possible now.
2) Added new controls like Data grid and Date Picker.
Deployment:
1) One click deployment as like as f5.
Silver light:
1) Siliverlight template added.
Chart Controls
Now in vs2010 added chart control no need to use other third party controls. it available.
Also supports 3D.
Cloud Application
It’s possible with Window Azure.
Share Point
Now we have the project template for share point. All the manipulation can be done through this.
Team Foundation Server:
1) Gated check in.
It’s really coolest feature and user friendly to do it. There is a situation like developer always breaks build. For that we have gated check in to restrict to check in.
2) Self test.
Data can be saved temporarily not in the server location.
3) TFS-Web
Now also can see who is working what like that information can trace from anywhere else.
4) Packages
Now we are able to create packages. Maintainability is good.
Now parent and child hierarchy are available
Branch creation and merging are available.
Database Development:
1) Import schemas.
2) Synchronization available with offline and online.
3) Refactoring database.
Testing
It support’s manual and automated. This is separate development environment.
1) Unit Test wizard.
2) Data driven test.
3) Code coverage.
4) Test impact analysis.
5) Coded UI test with record UI functionality as like mercury and more than.
This is just introduction part. Hope will see many articles about VS2010.

Webservices using Silverlight 2.0

In silverlight can't connect directly to the database. it can only connect through webservices.
Before connecting to webservices. we should aware of security, data integrity, binding, performance.
using silverlight user connect diferent services.the services are webservice, WCF service and REST.
hope know about webservice and wcf, so all are asking about REST. Rest means RePresentation of state transition.
through webclient and httpwebrequest can connect and get the response.
usually webservices can connect through http. while connecting you have to maintain the thread. it's should
run with in thread only. if you not connect through proxy. you should maintain the thread. other wise it would
be problem.
Method 1:
Calling ASMX webservices.
Step 1:
Create asmx webservice and in to silverlight application as a service reference.
Step 2:
ADD namespace in the using section.
Step 3:
Get path of asmx file through this method.
public string GetURLforResource(string resourcePage)
{
string webURL = HtmlPage.Document.DocumentUri.ToString();
string containerPage = webURL.Substring(webURL.LastIndexOf("/") + 1);
return webURL = webURL.Replace(containerPage, resourcePage);
}

Step 4:
Call webservice through this. string webServiceURL = GetURLforResource("WebserviceTest.asmx");
BasicHttpBinding binding = new BasicHttpBinding();
WebserviceTestSoapClient webSVC = new WebserviceTestSoapClient(binding,new EndpointAddress(webServiceURL));
webSVC.HelloWorldCompleted += new EventHandler(webSVC_HelloWorldCompleted);
webSVC.HelloWorldAsync();

also for the method has to create the eventhandler.
Step 5:
This is the event handler to display the result of the webservice method.
void webSVC_HelloWorldCompleted(object sender, HelloWorldCompletedEventArgs e)
{

HtmlPage.Window.Alert(e.Result);
}

Method 2:
Calling WCF service.
Everything same as like the above. one thing must to do in web.config.
while creating wcf it will add automatically binding as wsHttpBinding instead of that
have to modify basicHttpBinding.
Method 3:
Coming soon










-

Navigation between XAML Pages using Silverlight 2.0

Before going in to navigation one thing keep in mind there is no direct way for navigating the xaml files in Silverlight 2.0.
Ok fine let's start our navigation journey. I have two ways to navigate between the xaml files.
let me explain one by one.
# Method 1: Using App.XAML
Step 1:
There is a Application_startup event in App.XAML which will decide the initial load page.
Before that comment all the line in this method. (Example://this.RootVisual = new Page();)
Here in this have to do some little trick.
Step 2:
Declare one public Grid outside the event.
like this: public static Grid root;
and then write this code in the application Startup event.

private void Application_Startup(object sender, StartupEventArgs e)
{
root = new Grid();
root.Children.Add(new Login());
this.RootVisual = root;
}

here only we are adding Grid as a parent control. under that we have xaml page.
Step 3:
Create one more method for navigation.
public static void Navigate(UserControl newPage)
{
UserControl oldpage = root.Children[0] as UserControl;
root.Children.Add(newPage);
root.Children.Remove(oldpage);
}
This is the method will navigate one xaml to another xaml. Basically it's just removing the old page and adding new page.
The above all three steps only in the App.XAML file.
Step 4:
Now come to Login.Xaml, this is the inital page which will load from App.XAML.
After successing the login user has to navigate to productlist page.
The below code will navigate to product list page.
private void Login_Success_Click(object sender, RoutedEventArgs e)
{
App.Navigate(new Product());
}


#Method 2:
This is better approach compare to above.
In the silverlight application should have two files.
1) App.XAML2) Master.XAML
here in Master is the common file which will navigate the files through this.
let me go through step by step:
Step 1:
In the application_startup event load the Master.XAMl (Remove Automated code)
private void Application_Startup(object sender, StartupEventArgs e)
{
this.RootVisual = new Master();
}

Step 2:
In the master page clear all the content except usercontrol tag.
<UserControl x:Class="SilverlightThird.Master" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Width="400" Height="300"> </UserControl>
Step 3:
In the code behind of Master page write the below code.
public partial class Master : UserControl
{
public Master()
{

InitializeComponent();
if (this.Content == null)
{
this.Content = new Login();
}
}

public void Navigate(UserControl Nextpage)
{
this.Content = Nextpage;
}
}

Step 4:
Now come to Login.xaml file.
In the success method of login.xaml.cs file write this below it will navigate.

hope this will help.

Custom Fonts in Silverlight 2.0

Hi all today i have learned something called custom fonts in silverlight 2.0.
it's really surprising me, it's very good feature.
follow the below stpes to create custom fonts in silverlight 2.0

Step1:
Create one silverlight applicaton. mean while get ttf extension file name.
Note: ttf is the extension for font.
step2:
Add atleast one ttf file in to our project folder
Example:webdings.ttf
step3:
after adding in to our project. add the code like the below in example.
then you will get the custom fonts in your browser.
Syntax:
FontFamily="Font_File_Name#Font_Name”
Example:
<TextBlock FontFamily="webdings.ttf#webdings" Text="Test"> </TextBlock>

Note:font_file_name and font_name is different except few.
if you give correct font_name then only it will work.

Accesssing Client bin Images in XAML.

In the client can not only xap file also can contain images. Those images can acccess from silverlight application.


Client Bin
Bluehils.jpg
imageaccess.xap

the above two files are there in the client bin.


if you want to access that image have to simple thing.


<Image Source="/Bluehills.jpg"> </Image>


Note:"/"

Stylesheet using Silverlight.

In silverlight having different approach to creating styles. also styles can write in app.xaml in silverlight application.
app.xaml is a application resource file. it will shares styles accross all the pages.
also it will maintain all the configuration details.
This is the syntax for creating styles in App.XAML.


<Application.Resources>
<Style x:Key="stTextblock" TargetType="TextBlock"> <
Setter Property="Foreground" Value="Red"/> </Style>
</Application.Resources>

we can call this style accross all the pages and it's applicable only for TextBlock controls.


<Grid x:Name="LayoutRoot" Background="White">
<TextBlock x:Name="txtShow" Style="{StaticResource stTextblock}" Text="Bala">
</TextBlock> </Grid>

Best Practices for keeping large number of images in Silverlight

Before creating silverlight application. Create seprate soltion for keeping large number images.Application performance will increase. also maintaining the application will be easy.

Step 1:
Create one silverlight application.
step 2:
Create silverlight class library.The name of the project solution is "Resource"
step 3:
maintain all the images under "Resource" library.
step 4:
Add the "Resouce" reference to silverlight application.
step 5:
Bind the images in to silverlight application.
Example
like this:<image source="Resource;component/picture/winter.jpg>
"Reource" is Assembly or application name.

Picture is folder name

SLsvcutil.exe in silverlight

Generating Proxies for WCF Services in Silverlight.
The only way to generate the proxies in silverlight 2 through service reference.
But in silverlight 3 is different. it's having command line tool to geneate the proxies.
SLsvcutil.exe.
happy coding with silverlight.

Silver light 2.0 Timer

I have seen many forums asking about the timer so i thought i'd toss up a simple example.
To create timer have to use Dispatchtimer in System.Windows.Threading.
Go through the below example.
<Canvas>
<Canvas.Resources>
<Storyboard x:Name="Timer">
<DoubleAnimation Storyboard.TargetName="rectTimer" Storyboard.TargetProperty="Width" BeginTime="0:0:0" Duration="2"></DoubleAnimation>
</Storyboard>
</Canvas.Resources>
<Rectangle Loaded="rectTimer_Loaded" Visibility="Collapsed" x:Name="rectTimer">
</Rectangle>
</Canvas>

private void rectTimer_Loaded(object sender, RoutedEventArgs e)
{
System.Windows.Threading.DispatcherTimer myDispatcherTimer = new System.Windows.Threading.DispatcherTimer();
myDispatcherTimer.Interval = new TimeSpan(0, 0, 0,1, 100);
myDispatcherTimer.Tick +=new EventHandler(myDispatcherTimer_Tick);
myDispatcherTimer.Start();
}
void myDispatcherTimer_Tick(object sender, EventArgs e)
{
HtmlPage.Window.Alert("TickEvent");
}

Making Transparent In Silverlight..

Now take a example of grid
Example:
<Grid x:Name="LayoutRoot" Background="{x:Null}">

How do we extract "XAP" file in Silverlight?

It's like archive and contains all the resources of silverlight application.
How do we extract xap file?
Step1:
Copy the xap file from clientBin and store in desktop of your machine.
step2:
change the extension in to zip
Example:
test.xap
test.xap.zip
Now you can extract the file.
it's contains one dll and asemblymanifest.info

Event Handler Using Silverlight

It's possible to create the eventhandler through XAML. also using codebehind can attach
event dynamically. It's usefull for dynamically craeate controls.
Example:
<Button Name="btnTest" Content="Test" Width="100" Background="Blue" Margin="1" Height="25"></Button>
public Page()
{
InitializeComponent();
btnTest.Click += btnTest_Click; //Attach Event
btnTest.Click -= btnTest_Click; //Detach Event
}

void btnTest_Click(object sender, RoutedEventArgs e)
{
MessageBox.Show("Hi How are you");
}

What is use of AppManifest.xml and Assemblyinfo.cs in Silverlight

App(Application) Manifest.
This is the place where we can find the list of assemblies used in the application.
Location Path:Properties/AppManifest
ApplicationInfo
It's contains the information about the project like version, name and publisher.
Location: Properties/Assemblyinfo.cs

HtmlPage.Window.Invoke in Silverlight

This method will invoke the javascript method from code behind.
Example

Page.xaml
<UserControl x:Class="_22Dec2009.Page" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Width="1024" Height="800"> <Grid x:Name="LayoutRoot" Background="White"> <Border BorderThickness="2" BorderBrush="AliceBlue" CornerRadius="2" Margin="3"> <Button x:Name="Test" Click="Button_Click" Content="Test" Background="AliceBlue" Width="30" Height="20"> </Button> </Border> </Grid></UserControl>
Page.xaml.cs
This is code it will call the javascript method.
private void Button_Click(object sender, RoutedEventArgs e)

{ HtmlPage.Window.Invoke("getAlert", false); }
Default.aspx
<script language="javascript">
function getAlert() {
alert("sdf"); } </script>
Have you noticed in the eventargs. here in silverlight different..

Note:
Also we can call the javascript method throgh this code.
HtmlPage.Window.CreateInstance("getAlert", false);
happy coding! Enjoy

Response Redirect in Silverlight.

here in silverlight we have to use below code navigate to from one pages to another pages.
in the code we can mention target as well as browser features like height width....

Example
HtmlPage.Window.Navigate(new Uri("http://www.google.com"),"_blank","width:100,height:20");

Full Screen Options in Silverlight.

i am just come to know in silverlight from the coding level we can make full screen for the browser.

This is namespace have to use for the making the full screen.
System.Windows;
Example code is
Application.Current.Host.Content.IsFullScreen=!Application.Current.Host.Content.IsFullScreen

Content Delivery Network.

Scott Guthrie has announced last september. This is one of the greatest improvement for who ever using Ajax in their application. Generally when we use Ajax all the library files will be loaded from our own server.

when end user accessing this site it has to travel through wire from few hundred miles to thousand miles.for avoiding these microsoft come up with new network called "Content Delivery Network".
if we use this in our project the performance will increase.

let me explain how it will increase the performance. suppose if you are accessing the site in India.
Content delivery network will find the shortest distance network and then it will load the all library files.
Instead of loading from one place.
Example:
<script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.3.2.min.js" type="text/javascript"></script>
instead of mentioning our own path

Materialized Views in Oracle

In some scenarios, you won't be in a position to improve the performance of a query without changing the database design. In those scenarios you can think of using materialized view.

Materialized view is a database object that contains the result of a query (it actually contains the rows).


SQL> create materialized view mview
2 build immediate
3 refresh complete on demand
4 as select count(1) from
5 (select state,zip,city,count(1) from mv_test1 group by state,zip,city);

Materialized view created.

Depends on the REFRESH mode specified MV will be refreshed ON DEMAND, ON COMMIT or at specific time.

Advantage:
Main advantage is Improved query perfomance.

Example:
Same query which is used to create the MV is executed here and it took 1.26 secs.

SQL> select count(1) from
2 (select state,zip,city,count(1) from mv_test1 group by state,zip,city);

COUNT(1)
----------
347

Elapsed: 00:00:01.26.

But selecting from MV took 0.01 seconds.

SQL> select * from mview ;

COUNT(1)
----------
347

Elapsed: 00:00:00.01

Disadvantage:

If you use refresh option as ON COMMIT and the MV is created on a transaction table which go through several DML operations, DB resources will be utilized to refresh the MV, and in turn it will slow down the db performance.

"String Builder" function in Javascript using Ajax(Enabling Scriptmanager).

I have come across new functionality called "stringbuilder" in javascript using Ajax.

please follow the below steps to enable the Stringbuilder.

Step 1:

Add script manager tag in the aspx page.


Step 2:

Example:

<script type="text/javascript">
function buildAString(title)
{
var headTagStart = "";
var headTagEnd = "";
var titleTagStart = "";
var sb = new Sys.StringBuilder(this._headTagStart);
sb.append(titleTagEnd);
sb.append(title);
sb.append(titleTagEnd);
sb.append(headTagEnd);
// Displays: "The result: "
alert("The result" + sb.toString());
}
var title = "A Title";
buildAString(title);
</script>

Calling Parent Method from child control using Events & Delegates.

Before starting we should very clear about event and delegate

Event: it's handler which will call the delegate and it will call the method.

Delegate: it's a function pointer, it will point to the particular function.

Let me explain about calling parent method from the child control.


Step 1: create one aspx pages and usercontrol pages.


step 2:

In the usercontrol create one button and lable. The scenoria is like this when user click on the button has to call the child method as well as the parent method.

Step 3:

Create one user control with the following code.


Childcontrol.ascx

<asp:Button ID="btnShow" runat="server" />
<asp:Label ID="lblShow" runat="server"></asp:Label>



Childcontrol.ascx.cs

public delegate void callDelegate();
public event callDelegate callEvent;

protected void Page_Load(object sender, EventArgs e)
{
btnShow.Click += delegate
{
lblShow.Text = "Hi how are u";
this.showData();
};
}
protected virtual void showData()
{
if (this.callEvent != null)
{
this.callEvent();
}
}


Step 4:


Create one aspx page with name of Parent with the following code.

parent.aspx


<%@ Register Src="~/UserControl/Childuser.ascx" TagPrefix="child" TagName="UC" %>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblParent" runat="server"></asp:Label>
<child:UC id="UC1" runat="server"></child:UC>
</div>
</form>
</body>
</html>


parent.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
UC1.callEvent += new Childuser.callDelegate(UC1_callEvent);
}

void UC1_callEvent()
{
lblParent.Text = "Hi Parent";
}

Base Pages using C#.Net

Now i am come with the scenario clearing the session on each page writing the code.
for clearing the session in common place.
we can use some thing called base pages. so that we can keep the code in seprate place.
Step 1:
Create one class file with the name of basepages.cs.
This will contain the one method which will clear the session objects permanently.
Example:
public class BasePages:System.Web.UI.Page
{
public void clearSession()
{ if (Page.User.Identity.IsAuthenticated == false)
{ Session.Abandon();
Response.Redirect("login.aspx");
}
}
}
step 2
Create one login with the extension of .Aspx page.in the code behind just inherit that base class method.
public partial class SessionCheck : Performance.BasePages
{
protected void Page_Load(object sender, EventArgs e)
{
base.clearSession();
}
}

Memory Profiler.

This is the tool which will find out memory leakage. using this we can fine tune the code.

download: http://memprofiler.com/