Skip to main content

Posts Tagged ‘Siebel EIM’

Using PostgreSQL to Massage Data for Siebel EIM

Recently, I had a Siebel Clinical Trial Management System (CTMS) client requirement to load data into the database, clearly the purview of Siebel Enterprise Integration Manager (EIM). The client sent me the data in a spreadsheet, and it looked something like this: Site_Number Contact_ID Role 800,1,300,500 1-2ASW Pharmacist 6,7,2 1-4RSW Doctor 1,2,4,6,7,8 1-5E33 Lead CRA […]