SSIS pipeline transformation shape, which provides phone number parsing functionality by implementing the Google libphonenumber csharp port https://github.com/twcclegg/libphonenumber-csharp (v8.10.16)
See Google libphonenumber web demo Web demo (external link) for demonstration.
- SQL Server 2016/2017 data flow custom Shape
- Transform, normalize, validate and geo locate your phone numbers in SSIS
- Provides functionality of Googles libphonenumber (using its libphonenumber-csharp port) for SQL Server 2016/2017
- SSIS Pipeline transformation shape
- Googles libphonenumber is great - runs on premise and also on your android phone (see https://github.com/google/libphonenumber)
- Transform your unformatted phone numbers to a normalized format (e.g. for your CRM system or for skype integration...)
- Tries to parse strings to phone numbers for national and international numbers
- Can lookup the carrier code and offline geo location
- Tested with Visual Studio 2019 SSIS Extension
- Ready to use - configuration with shape UI
- Call to IsViablePhoneNumber to check if the phone number is viable
- ExtractPossibleNumber
- NormalizedNumber
- NormalizedDigitsOnly
- Format PhoneNumberFormat.E164
- Format PhoneNumberFormat.INTERNATIONAL
- IsValidNumber
- CountryCode
- HasCountryCode
- PreferredDomesticCarrierCode
- GeoCoderDescription (GeoCoder)
- Run gacinstall.com from bin/debug or bin/release --> Will install the shape and the signed phonelib assembly to GAC and adds the shape to SSIS
- Create/Open data flow
- Drag SSIS libphonenumber shape from toolbox to data flow
- Connect input and output
- Use UI of shape for configuration (double-click on shape)
- Run
- From Goolgles libphonenumber and libphonenumber-csharp are preserved in git root as txt files
- Published under the MIT license
- Use at your own risk
Impressum / Imprint in German language to comply with German tele-media regulations.