Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Upload CRM files using different keys

Thiago_Henriqu7
Level 1
Level 1

Hello,

Can I upload data to my Data Sources using multiple keys, besides its SyncID?

Example:

My [Main Data Source [SyncID=socialsecurityid]], has five keyvaluepairs of user information:

[socialsecurityid]

[nationalinsurancenumber]

[telephone]

[email]

[sex]

In real-time I didn´t feed it with [telephone].

I have one offline CRM database wich uses [NacionalInsuranceNumber] as primary key, HAS [telephone] information BUT NOT have [socialsecurityid].

Can I upload this [telephone] information, from this offline CRM database, to my [Main Data Source [SyncID=socialsecurityid]], using keyvaluepair [nationalinsurancenumber] as matching-key?

Thank you in advance, I´m in real trouble here.

1 Accepted Solution
Varun_Kalra
Correct answer by
Community Advisor
Community Advisor

Hi Thiago,

You can use one data source for ID sync, and can later upload the files straight away to this data source using the normal inbound files:

ftp_dpm_[DPID]_[timestamp].sync

If you have another data source, that is offline and you are not using it's data source ID/ integration code in ID sync. Then you can link these two data sources by uploading an offline ID sync file. It will be an ID match file. Then you can upload the data for that data source too.

Check this doc for more details on onboarding an ID sync file:

Name and Content Requirements for ID Synchronization Files

Thanks,

Varun Kalra

View solution in original post

2 Replies
Varun_Kalra
Correct answer by
Community Advisor
Community Advisor

Hi Thiago,

You can use one data source for ID sync, and can later upload the files straight away to this data source using the normal inbound files:

ftp_dpm_[DPID]_[timestamp].sync

If you have another data source, that is offline and you are not using it's data source ID/ integration code in ID sync. Then you can link these two data sources by uploading an offline ID sync file. It will be an ID match file. Then you can upload the data for that data source too.

Check this doc for more details on onboarding an ID sync file:

Name and Content Requirements for ID Synchronization Files

Thanks,

Varun Kalra

View solution in original post

Thiago_Henriqu7
Level 1
Level 1

Hi Varun,

Thanks for the answer.

I´ve created one Data Source for each SyncID. Then I´ve synced them through a Profile Merge Rule.

But I will explore your sugestion of an offline ID sync file.