Creation of "Correlation Rule"

[coocooche]

Hi,
I have Velo 1.4 up and running under this configuration:
Linux Ubuntu 9.10
JBoss 4.2..GA + jbossws-native-2.0.1.GA
MySQL 5.1.37
Sun JDK 1.6

I'm trying to do a reconciliation with my resource mysql using this
http://docs.safehaus.org/display/VELO10/JDBC+Tutorial.
After the first step (3.1.1 from the tutorial), i would like to create
correlation rule as described in the tutorial (3.1.2) to continue with
my reconciliation. I didn't find out the way how to do that. Can
anyone help me please?
Thanks,
Gentjan

[Trouby]

Hey, Welcome,

True, we'r hardy working on improving our docs, some of them are out
of date,
You have to reconcile a resource that creates users first,

Once you have users, you have to map their identity attributes,

After that, when you reconcile another system, you can write the
correlation rule to correlate the resource accounts to the existing
users,

Please let me know what is the logic of the correlation rule you look
for and I'll send it to you!

Usually it's based on a certain attribute that can match between the
user / new account

Thanks

On Jan 19, 5:41 pm, coocooche <gentja...@gmail.com> wrote:
> Hi,
> I have Velo 1.4 up and running under this configuration:
> Linux Ubuntu 9.10
> JBoss 4.2..GA + jbossws-native-2.0.1.GA
> MySQL 5.1.37
> Sun JDK 1.6
>

> I'm trying to do a reconciliation with my resource mysql using thishttp://docs.safehaus.org/display/VELO10/JDBC+Tutorial.

[coocooche]

Hi Asaf,
thanks for the welcome and your quick reply!
This is my situation:

VELO
1- i've created some users into VELO
2- i've added some others Identity attributes to VELO's users such
as ,'email', 'password',
3- i've created a jdbc resource (MySQL type), then i created some
resource attributes: 'name','surname','account_id','password','email'
and finally i created an action “Resource Fetch Active Data Offline”
with the below code:

def accountsQueryManager = cntx.get("accountsQueryManager");
String accountsQuery = "select username as accound_id, name as name,
surname as surname, email as email, password as password from
accounts";
accountsQueryManager.add(accountsQuery);
cntx.set("accountsQueryManager",accountsQueryManager);

---
The MySQL structure is as follow:
create table accounts (
name varchar(255) not null,
surname varchar(255) not null,
username varchar(255) not null unique,
password varchar(255) not null,
email varchar(255) not null,
primary key(username)
);
and the db has few users in it.
---
Now i want to reconciliate the Mysql resource with VELO and i want to
map these resourse's attribute with the VELO's ones.
VELO -- MySQL
account_id -- account_id
name -- name
surname -- surname
password -- password
email -- email

I've just triend to press “reconcile resource now” in the Resource
but i can't see any account created on VELO.
What's wrong with it? What I'm missing?

Thanks,
Gentjan

[coocooche]

[coocooche]

hi,
any news? i don't know how to come out of this situation?
Thanks

[coocooche]

I did as you explain me but i haven't solve my problem. I couldn't
reconcile my jdbc
resource(MySQL table). Velo didn't create any account or user.
Could you give me a link with a simple example of feeding VELO from an
esternal resource?
Ps: i'm using VELO 1.3GA and not 1.4 as I said in a previous post.
Thanks

[coocooche]

hi,
perhaps the problem stands in my groovy script for the action
"Resource Fetch Active Data Offline" that is not ok for the version
1.3GA of VELO?
I delete and re-construct all but anything to do. VELO doesn't
reconcile anything.

Anyone can help me please?

thanks

[Trouby]

Hey,
See the reply I just responded to your second thread,

Please use version 1.4, we invested a lot in the reconciliation
engine,

Thanks,

Asaf.