Giorgio ha la necessità di creare un insieme di filtri di dati sulla base di nazioni, città e stati.
In Campaign, le tabelle clienti sono già state mappate e sono stati definiti i livelli destinatari.
Nome classe del driver JDBC – com.microsoft.sqlserver.jdbc.SQLServerDriver
Percorso driver JDBC – C:\tools\Java\MsJdbc\sqljdbc.jar
Insieme finito di stati distinti (altrimenti denominati regioni, a seconda della nazione)
Il campo hh_id field corrisponde ai destinatari costituiti da unità familiari.
Il campo indiv_id della tabella Geographic corrisponde ai destinatari costituiti da individui.A questo punto può passare alla creazione del codice XML.
<!-- Create the data configuration that groups related Data Filters -->
<ExecuteBatch>
<name>DataFilters</name>
<operations>
<AddDataConfiguration>
<dataConfiguration>
<id>1</id>
<name>
Geographic</name>
</dataConfiguration>
</AddDataConfiguration>
</operations>
</ExecuteBatch><!-- Add logical fields used to define data filters -->
<AddLogicalFields>
<logicalFields>
<LogicalField>
<id>1</id>
<name>
Country</name>
<type>
java.lang.String</type>
</LogicalField>
<LogicalField>
<id>2</id>
<name>
City</name>
<type>
java.lang.String</type>
</LogicalField>
<LogicalField>
<id>3</id>
<name>
State</name>
<type>
java.lang.String</type>
</LogicalField>
<LogicalField>
<id>4</id>
<name>
HouseholdID</name>
<type>
java.lang.Long</type>
</LogicalField>
<LogicalField>
<id>5</id>
<name>
IndividualID</name>
<type>
java.lang.Long</type>
</LogicalField>
</logicalFields>
</AddLogicalFields><!-- Provide information needed to generate data filters -->
<GenerateDataFilters>
<!-- Specify the table to be scanned for unique combinations of values from which data filters will be defined. -->
<tableName>
Geographic</tableName>
<!-- Identify the data configuration with which generated data filters will be associated. -->
<configurationName>
Geographic</configurationName>
<!-- Specify the data source connection information. -->
<jdbcUrl>
jdbc:sqlserver://localhost:1433;databaseName=Customers</jdbcUrl>
<jdbcUser>
sa</jdbcUser>
<jdbcPassword>
myPassword</jdbcPassword>
<jdbcDriverClass>
com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbcDriverClass>
<jdbcDriverClassPath>
<string>
C:\tools\Java\MsJdbc\sqljdbc.jar</string>
</jdbcDriverClassPath><!-- Specify the fixed fields. -->
<fixedFields>
<FixedField>
<expression>
USA</expression>
<logicalFieldName>
Country</logicalFieldName>
<physicalFieldName>
country</physicalFieldName>
</FixedField>
</fixedFields>
<fixedFields>
<FixedField>
<expression>
France</expression>
<logicalFieldName>
Country</logicalFieldName>
<physicalFieldName>
country</physicalFieldName>
</FixedField>
</fixedFields>
<fixedFields>
<FixedField>
<expression>
Britain</expression>
<logicalFieldName>
Country</logicalFieldName>
<physicalFieldName>
country</physicalFieldName>
</FixedField>
</fixedFields><!-- Specify the profile fields. -->
<profileFields>
<ProfileField>
<logicalFieldName>
State</logicalFieldName>
<physicalFieldName>
state</physicalFieldName>
</ProfileField>
<ProfileField>
<logicalFieldName>
City</logicalFieldName>
<physicalFieldName>
city</physicalFieldName>
</ProfileField>
</profileFields>
</GenerateDataFilters><!-- Map physical to logical fields -->
<ExecuteBatch>
<name>addTables</name>
<operations>
<AddDataTable>
<dataTable>
<id>1</id>
<name>
Geographic</name>
<fields>
<TableField>
<name>
country</name>
<logicalFieldId>1</logicalFieldId>
</TableField>
<TableField>
<name>
city</name>
<logicalFieldId>2</logicalFieldId>
</TableField>
<TableField>
<name>
state</name>
<logicalFieldId>3</logicalFieldId>
</TableField>
<TableField>
<name>
hh_id</name>
<logicalFieldId>4</logicalFieldId>
</TableField>
<TableField>
<name>
indiv_id</name>
<logicalFieldId>5</logicalFieldId>
</TableField>
</fields>
</dataTable>
</AddDataTable>
</operations>
</ExecuteBatch><!--Add Audiences-->
<ExecuteBatch>
<name>addAudiences</name>
<operations>
<AddAudience>
<audience>
<id>1</id>
<name>
household</name>
<fields>
<AudienceField>
<logicalFieldId>4</logicalFieldId>
<fieldOrder>0</fieldOrder>
</AudienceField>
</fields>
</audience>
</AddAudience>
<AddAudience>
<audience>
<id>2</id>
<name>
individual</name>
<fields>
<AudienceField>
<logicalFieldId>5</logicalFieldId>
<fieldOrder>0</fieldOrder>
</AudienceField>
</fields>
</audience>
</AddAudience>
</operations>
</ExecuteBatch>Giorgio ha attribuito al file XML del filtro di dati il nome di geographicDataFilters.xml e l'ha salvato nella directory tools/bin dell'installazione di Marketing Platform utilizzata. Apre un prompt dei comandi e si serve dell'utility datafilteringScriptTool per popolare le tabelle di sistema dei filtri di dati.
Sa che i gruppi sono già stati impostati in Marketing Platform con utenti assegnati per città.
Continua quindi a cercare i filtri di dati e i gruppi fino a completare tutte le assegnazioni.
IBM Unica Marketing Platform
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|