ETL stands for Extract, Transform and Load, which is a process used to collect data from various sources, transform the data depending on business rules/needs and load the data into a destination database.

The need to use ETL arises from the fact that in modern computing business data resides in multiple locations and in many incompatible formats.

Numbers entered without area codes will have a default area code prepended to them. Any extensions will be listed as xnnnnn following the phone number. If an initial 1 is added to the number, it will be removed, since users already know to dial a one before making a long distance call.

validating sql-85

The ODBC connector is a database abstraction layer that makes it possible for Asterisk to communicate with a wide range of databases without requiring the developers to create a separate database connector for every database Asterisk wants to support.

This saves a lot of development effort and code maintenance.

Load The final ETL step involves loading the transformed data into the destination target, which might be a database or data warehouse.

Many of the biggest software players produce ETL tools, including IBM (IBM Info Sphere Data Stage), Oracle (Oracle Warehouse Builder) and of course Microsoft with their SQL Server Integration Services (SSIS) included in certain editions of Microsoft SQL Server 20.

The ETL process has 3 main steps, which are Extract, Transform and Load.

Extract The first step in the ETL process is extracting the data from various sources.

Next, the code parses out the phone number and the extension. The phone system is such that you can't have a 1 as the first number of either an area code or a phone number prefix.

You will then either have a ten-digit phone number or a seven-digit phone number.

Each of the source systems may store its data in completely different format from the rest.

The sources are usually flat files or RDBMS, but almost any data storage can be used as a source for an ETL process.

per se it does let you play around with the script and will definitely let you know if things are working or not.