ETIo Accelerator for SQL/Teradata.The ETIoAccelerator for SQL/Teradata the newest addition to the ETI (Embed The Internet) An earlier consortium that was devoted to putting Web servers into microcontrollers used in embedded systems. Using a Web server enables access to the device via any Web browser. See Web server and microcontroller. Solution for Teradata accelerates the transformation and exchange of data between data warehousing See data warehouse. data warehousing - data warehouse applications hosted on Teradata Relational Database Management Systems See DBMS for a shorter list of “typical”, representative database management systems. Open-source software
RDBMS - relational database ). In most data integration projects, for data to be shared, it must first be extracted from the source application and transformed into a format compatible with the target application. The ETIoAccelerator for SQL/Teradata extracts, transforms and loads data within the Teradata parallel architecture, leveraging the Teradata engine for processing of the data. As part of the ETI Solution for Teradata, the ETIoAccelerator for SQL/Teradata automates the generation of SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. scripts that extract, transform and load data between applications on Teradata, while capturing a full metadata audit trail. Automated code generation saves manual coding of data transformations, an error-prone process that also fails to capture an audit trail. The metadata audit trail retains a description of transformations made to the data. If data values or definitions change within Teradata or its hosted applications, SQL statements can be regenerated. ETIoAccelerator for SQL Teradata includes a GUI-driven, point-and-click interface to ensure accurate SQL statements. By allowing business rules to be specified in plain English Plain English (sometimes known, more broadly, as plain language) is a communication style that focuses on considering the audience's needs when writing. It recommends avoiding unnecessary words and avoiding jargon, technical terms, and long and ambiguous sentences. , the product enables non-technical users to generate complex SQL statements for data transformation. Experienced SQL programmers can then be better utilised on more crucial aspects of the project. www.eti.co.uk |
|
||||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion