Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Importing the OFAC SDN list via XML Expand / Collapse
Author
Message
Posted Saturday, January 5, 2008 10:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 8, 2009 9:21 AM
Points: 16, Visits: 36
Can I ask where you work? Or at least the kind of company?
Thanks>
Pablo
Post #439308
Posted Sunday, January 6, 2008 5:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, May 3, 2014 1:28 PM
Points: 160, Visits: 246
A financial services company in Atlanta, GA (The Henssler Financial Group).


Post #439334
Posted Wednesday, January 9, 2008 7:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 8, 2009 9:21 AM
Points: 16, Visits: 36
Tim, one last doubt ...
when I have a new transaction and I have to check the customer against SDN, I have a lot of cases with the same SOUNDEX result, and that has nothing to do with the name i am searching.
So I need to do something else in order to decide if I got a match ...
what else are u doing?
Post #440672
Posted Wednesday, January 9, 2008 8:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, May 3, 2014 1:28 PM
Points: 160, Visits: 246
SOUNDEX of course is far from exact - Joe Smith will match Jose Smithers, etc.
The first time the comparison was run, we had a few dozen false positives.
That is why we maintain a table of the 'potential matches', so they can be excluded by our daily job that does the compare. This table also maintains who checked it and when, a column indicated if a match/false positive and any comments.

Once the initial compare is run and the false positives identified, subsequent runs (we run the job daily) only return results when:
1) The SDN is updated
2) We add a new client

The numbers for us in the above two instances, are very small.

This downside also has an upside, in that you know that if the names are even close, you will get a notification and it provides a great audit trail for the SEC.

This is also why we could not use any of the existing services. They have no methodology to know that you have already checked Joe Smith against that specific SDN entry for Jose Smithers and it is NOT a match. All existing products/web services are new searches/compares each time. By maintaining our own results/compares, we can run the comparison against our entire client list each time there are changes to the SDN and for each new client. Our auditors love it.



Post #440676
Posted Wednesday, January 9, 2008 8:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 8, 2009 9:21 AM
Points: 16, Visits: 36
sounds good, thanks!
Post #440685
Posted Wednesday, May 21, 2008 4:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 22, 2011 9:48 AM
Points: 5, Visits: 63
Hello...
I've created import routines for SDn list.
Let me know if you are interested...
I can help you.

Divyesh
Post #504890
Posted Wednesday, May 21, 2008 4:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 8, 2009 9:21 AM
Points: 16, Visits: 36
i am very interested.
tell me a little bit more about it
Thanks
Pablo
Post #504894
Posted Thursday, May 22, 2008 8:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 22, 2011 9:48 AM
Points: 5, Visits: 63
Hi Pablo..
I have application that requires importing SDN list and keeping it up-to-date. If a new name is added it should be inserted into tables and if any name is removed from the list, it should be marked "inactive" but should still be kept in the database.
I created SSIS package that downloads XML file from FTP site and wrote stored procs to process the files into SQL Tables.
If you have the requirements and would like to share with me let me know... I can do it for you...

Divyesh
Post #505230
Posted Thursday, May 22, 2008 9:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 8, 2009 9:21 AM
Points: 16, Visits: 36
i need to do exactly the same.
there is not a lot to invent about this.
pls, see my nick, and contact me so we can arrange somthing about it.
thanks
Pablo
Post #505291
Posted Thursday, May 22, 2008 1:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 22, 2011 9:48 AM
Points: 5, Visits: 63
Hi Pablo...

I sent email to your gmail but it bounced back..
Post #505425
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse