by Moha » Fri, 17 Jan 2003 07:59:07
Hi,
I have a MS 2k DB on Win Nt. I need to extract and load
the data from this operational DB to a warehouse which is
on sun solaris/oracle 8i DB. Are there any tools
available ? I know of MS SQL server's DTS option. Anything
else ?
TIA
MOhan
ISoft Announces AMADEA Version 3.0, The First Decision-Based ETL in Real
Time Built on The Concept of DATA MORPHING.
AMADEA is a data Extraction, Transformation, and Real Time Reporting
software. It revolutionizes the traditional data transformation approach
(ETL) by bringing the necessary flexibility and adaptability to enable the
Information System to deliver the key information at the right time, and to
the right people.
AMADEA introduces the DATA MORPHING concept to transform in Real Time huge
volume of heterogeneous data into information, create and load Data
Warehouses, elaborate dynamic and parametric analysis-oriented Data Marts,
generate sophisticated indicators and reports by taking into account the
users' experience and knowledge. AMADEA brings about an answer to the users
' needs and support them throughout the decision process.
AMADEA enriches its third version with new functionalities:
NATIVE CONNECTIVITY
AMADEA offers as a standard the native access to most of the RDBMS (Oracle,
DB2, SQL Server,.).
OPENNESS TO OUTSIDE ELEMENTS
The plug-in technology developed for AMADEA enables a superior connectivity
to every application or external software.
GRAPHICS MANAGEMENT
The decision-based reporting and piloting module, AMADEA WEB, offers an
improved report preparation function thanks to a new graphical display of
data.
AMADEA WEB MINING
AMADEA WEB MINING, Web log analysis module, examines Web users behaviour and
join the acquired data with the ones generated through other communication
channels.
AMADEA, Real Time decision-based ETL, integrates the users' functional
knowledge and expertise, and generates an answer to the flexibility needs
identified within the following application fields:
? Marketing : In-demand production of specific Data Marts, definition and
creation of dashboard and reports, restoration of customer's trajectory.
? Finance : Production of documented treatment strings to generate statutory
reports.
? Health : Analysis of patient data to build medico-economic indicators,
study of medical practices, pharmaco-vigilance study.
? Banking & Insurance : Customer scoring, fraud-analysis.
About ISoft
For more than 12 years, ISoft has been offering tools and solutions to
manage information, to analyse and data in order to valorise customers'
value. ISoft proposes a complete range of tools and services dedicated to
analytical CRM, behaviour analysis, data modelization and analysis, Data
Mining and DATA MORPHING.
AMADEA, data Extraction, Transformation, and Real Time Reporting solution.
ALICE D'ISoft, Complete and interactive Data Mining solution using decision
tree.
AC2, C++ Data Mining library. RECALL, advanced Case-Based Reasoning system
for problem-solving tasks.
CONTACT
Fran?ois HALFEN
+ 33 1 69 35 37 37
4. Porting from T-SQL forMS SQL 2k to P-SQL For Oracle 8i
5. Under Oracle 9, is there a guarantee of at least 1 temp TS ?
6. Looking for Performance tools for Oracle 8i on Unix
7. Connect up to 1,7000 Suppliers. ; More than 5,7000 Active buyers.
8. MS SQL 2K Client Tools in VB6 Package And Deployment
9. 13750-WA-SEATTLE-MS SQL Server-ORACLE-ORACLE Tools-FOXPRO-DB2-SYBASE-MS Access-Developer
10. installing sql 7 tools and sql 2k tools in same box