Skip to content

A phone number parsing and normalization SSIS Pipeline Component: SSIS shape implementation of Googles libphonenumber (using its libphonenumber-csharp port) for SQL Server 2016/2017

License

Notifications You must be signed in to change notification settings

ChrisMayor/SSISlibphonenumber

Repository files navigation

SSIS libphonenumber - A phone number parsing and normalization SSIS Pipeline Component

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.

Highlights:

  • 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

Currently implemented functionality V1:

  • 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)

Screenshots V1 (Visual Studio 2019 / SSIS Extension)

SSIS Toolbox (Data Flow)

SSIS Data Flow sample

Shape UI Configuration

Shape Input

Shape Output (1)

Shape Output (2)

Install Instructions:

  • 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

Licenses:

  • From Goolgles libphonenumber and libphonenumber-csharp are preserved in git root as txt files

Disclaimer / Impressum

  • Published under the MIT license
  • Use at your own risk

Impressum / Imprint in German language to comply with German tele-media regulations.

About

A phone number parsing and normalization SSIS Pipeline Component: SSIS shape implementation of Googles libphonenumber (using its libphonenumber-csharp port) for SQL Server 2016/2017

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks

Packages

No packages published