setting auto increment start value?

One Star

setting auto increment start value?

I have tried find instructions how to set the start value of the auto increment attribute in the data model but no luck. can somebody help? I know how to use the auto incremet as id but want to change the value where it begins to increment. it's possible in mysql so I suppose its possible in talend mdm/exist?
cheers, samuli
Highlighted
One Star

Re: setting auto increment start value?

yes its possible.
1. In TOS got to MDM section
2. go to Data Container|System|CONF
3. On the Entity Drop Down list, select Autoincrement and hit the search
4. Edit the search record returned, and go to Source section
Good luck.
Employee

Re: setting auto increment start value?

Hi,
This value is stored in the system datacontainer called 'CONF'. You can edit the XML to set the value you need.
<AutoIncrement>
<id>AutoIncrement</id>
<entry>
<key>."Datacontainer"."Entity"."Pk"</key>
<value>1</value>
</entry>

Regards,
Cyril
One Star

Re: setting auto increment start value?

sronkane,
It is possible indeed as muraliv and csonnefraud detailed.
But I'll let you one advice, as I've struggled multiple times resetting multiple counters... Id is just an identifier, so unless there is a really strong point to use a AUTO_INCREMENT type, you should use UUID instead. That way, you don't have to keep resetting Auto Increment start values every time you want to redo your tests.
If you are using AUTO_INCREMENT to keep track of creation order, you could deal with that in other ways:
- Create CreateDate and UpdateDate on the DataModel;
- Query Journal and see all the CRUD actions on every record, ordered in any way you want.
Best regards,
Diogo Afonso

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download