[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sonar-dev
Subject:    Re: [sonar-dev] ODI integration in Sonar
From:       Maxime Schneider-Dufeutrelle <sd.maxime () gmail ! com>
Date:       2012-02-23 10:39:13
Message-ID: CAAmi8JuzzAuufGAct37P1qjCPGm-YetXREGCyrDXGuGbNSv=Ng () mail ! gmail ! com
[Download RAW message or body]

Hi Simon,


Thanks for this fast reply.


Best Regards,

Maxime

2012/2/23 Simon Brandhof <simon.brandhof@sonarsource.com>

> Hi Manuel, Maxime,
>
> Storing data directly in database is definitely not possible. A Java
> plugin must be developed.
> If the language of the inspected codebase is not already supported, then
> you should implement a complete plugin like flex<http://svn.codehaus.org/sonar-plugins/trunk/flex/>or
> php <http://svn.codehaus.org/sonar-plugins/trunk/php/> plugins.
>
> Regards
> Simon
>
>
> On 22 February 2012 18:18, Maxime Schneider-Dufeutrelle <
> sd.maxime@gmail.com> wrote:
>
>>
>> Hi everyone,
>>
>> A colleague of mine asked me to post this message on the ML because of
>> some trouble with his account. Thanks to consider it.
>>
>>  Hi all,
>>
>>
>>
>> We are working on a software called ODI (Oracle). It's an ETL.
>>
>> All code of the software is in a Work Repository.
>>
>> I automated the calculation of metrics with some SQL queries from the
>> WorkRepository.
>>
>> So I have the following table:
>>
>> SESSION_NUMBER
>>
>> OBJECT_NUMBER
>>
>> RULE_NUMBER
>>
>> FAILURE_LEVEL
>>
>>
>>
>> And some other colums...
>>
>>
>> An object in ODI can be a variable, a script, a procedure ...
>>
>> All of my metrics are already computed and the compute can be planned.
>>
>> For example, one of my rule is : The variable is on "Historiser" or on
>> "Last Value" and must be on "Non Persistant"
>>
>>
>>
>> I would like to integrate all of my metrics into Sonar.
>>
>> I want to know if I have to develop a plug-in or if I can directly insert
>> datas  into the Sonar's database ?
>>
>> The following sonar's tables seem to match my needs :
>>
>>
>>
>> *         rules
>>
>> *         rule_failures
>>
>> *         metrics
>>
>> *         project_measures
>>
>> Regards,
>>
>> Manuel BRIOT
>> Developper ODI, France
>>
>
>

[Attachment #3 (text/html)]

Hi Simon,<br><br><br>Thanks for this fast reply.<br><br><br>Best \
Regards,<br><br>Maxime<br><br><div class="gmail_quote">2012/2/23 Simon Brandhof <span \
dir="ltr">&lt;<a href="mailto:simon.brandhof@sonarsource.com">simon.brandhof@sonarsource.com</a>&gt;</span><br>
 <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Hi Manuel, Maxime,<br><br>Storing data directly in database \
is definitely not possible. A Java plugin must be developed. <br> If the language of \
the inspected codebase is not already supported, then you should implement a complete \
plugin like <a href="http://svn.codehaus.org/sonar-plugins/trunk/flex/" \
target="_blank">flex</a> or <a \
href="http://svn.codehaus.org/sonar-plugins/trunk/php/" target="_blank">php</a> \
plugins.<br>


<br>Regards<span class="HOEnZb"><font color="#888888"><br>Simon</font></span><div \
class="HOEnZb"><div class="h5"><br><br><div class="gmail_quote">On 22 February 2012 \
18:18, Maxime Schneider-Dufeutrelle <span dir="ltr">&lt;<a \
href="mailto:sd.maxime@gmail.com" target="_blank">sd.maxime@gmail.com</a>&gt;</span> \
wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <br>Hi everyone,<br><br>A <span lang="en"><span>colleague of \
mine asked me to post this message on the ML because of some trouble with his \
account. Thanks to consider it.<br><br> </span></span>

<p><span lang="EN-US">Hi all,</span></p>

<p><span lang="EN-US"> </span></p>

<p><span lang="EN-US">We are
working on a software called ODI (Oracle). </span>It&#39;s an ETL.</p>

<p><span lang="EN-US">All code
of the software is in a Work Repository.</span></p>

<p><span lang="EN-US">I
automated the calculation of metrics with some SQL queries from the
WorkRepository.</span></p>



<p><span lang="EN-US">So I
have the following table:</span></p>



<p><span lang="EN-US">SESSION_NUMBER</span></p>

<p><span lang="EN-US">OBJECT_NUMBER</span></p>

<p><span lang="EN-US">RULE_NUMBER</span></p>

<p><span lang="EN-US">FAILURE_LEVEL</span></p>

<p><span lang="EN-US"> </span></p>

<p><span lang="EN-US">And some
other colums...</span></p>



<p><span lang="EN-US"><br></span></p><p><span lang="EN-US">An
object in ODI can be a variable, a script, a procedure ...</span></p>



<p><span lang="EN-US">All of
my metrics are already computed and the compute can be planned.</span></p>



<p><span lang="EN-US">For
example, one of my rule is : The variable is on &quot;Historiser&quot; or on
&quot;Last Value&quot; and must be on &quot;Non Persistant&quot;</span></p><p><span \
lang="EN-US"> </span></p>

<p><span lang="EN-US">I
would like to integrate all of my metrics into Sonar.</span></p>

<p><span lang="EN-US">I want
to know if I have to develop a plug-in or if I can </span><span lang="EN-US">directly \
</span><span lang="EN-US">insert datas  into the Sonar&#39;s database ?</span></p>



<p><span lang="EN-US">The
following sonar&#39;s tables seem to match my needs :</span></p>

<p><span lang="EN-US"> </span></p>

<p><span lang="EN-US">*        
rules</span></p>



<p><span lang="EN-US">*        
rule_failures</span></p>



<p><span lang="EN-US">*        
metrics</span></p>



<p><span lang="EN-US">*        
project_measures</span></p>



<p>Regards,</p>



<p>Manuel BRIOT</p>



<span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;">Developper
 ODI, France</span><br>
</blockquote></div><br>
</div></div></blockquote></div><br>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic