Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     diffrence between WebFocus Maintan and Data maigrater tool

Read-Only Read-Only Topic
Go
Search
Notify
Tools
diffrence between WebFocus Maintan and Data maigrater tool
 Login/Join
 
<NAG>
posted
Is thr any diffrence between WebFocus Maintan and WebFocus Data maigrater tool.
 
Report This Post
<NAG>
posted
quote:
Originally posted by NAG:
Is thr any diffrence between WebFocus Maintan and WebFocus Data maigrater.
 
Report This Post
Expert
posted Hide Post
They are for completely different uses.

Maintain is used to build applications with onlineGUI screens that update tables. People have done other amazing things with it.

Data Migrator is used to move data from one database to another - ETL - Extract, Transform, Load. These are tasks that are scheduled at a particular interval.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
<NAG>
posted
HI FRANCIS,
I HAVE OTHER QUESTION THAT,IS THESE TWO ARE DIFRENT TOOLS 'OR' ONE TOOL CAN DO THESE TWO TASKS.
MAINTAIN CAN USE AS A ETL TOOL.
 
Report This Post
Expert
posted Hide Post
I don't think you can use Maintain as an ETL tool.

You should read about the products on the Information Builders website.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Platinum Member
posted Hide Post
Could one use just plain WebFocus (with data adaptors, Defines, and Modify) as an ETL tool ?


Regards,
Dave

http://www.daveayers.com

WebFocus/Maintain 7.6.4-8
on Win2000 and 2003 Server
 
Posts: 165 | Location: Detroit Metro | Registered: September 17, 2003Report This Post
Master
posted Hide Post
Actually - Maintain is the perfect ETL tool. This is because Maintain can read any database from any location and save it to any database in any location! Maintain can read an SQL file and save it as a FOCUS file. Or an Oracle file and save it as DB2. It doesn't matter. As long as you can read it, Maintain can save it.

That way you do this is as follows:
MAINTAIN FILE file1 AND file2
For all next File1.flds into stk1
Infer File2.flds into stk2
Compute I/I2=1;
Repeat stk1.foccount
Compute stk2(I).fld1 = stk1(I).fld1;
...
Compute I=I+1;
Endrepeat
For all include File2.fld1 from Stk2
END

The reason that Maintain wasn't used for the default ETL tool is you have to hardcode the field names and the file names. Maintain doesn't allow you to pass the files to the tool dynamically. But, otherwise, it's the perfect ETL tool.

Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Expert
posted Hide Post
Dave,

At our installation, many developers use a WF program in conjunction with Report Caster to build data marts for reporting and scoreboarding, ergo, ETL.

So yes you can and people have been doing that with FOCUS since 1975 probably.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Gold member
posted Hide Post
The difference between WebFOCUS and DataMigrator is like difference between Windows XP and Windows Server.

Kernel is one (not quite, but near), but goals is different.

You can run flows in WebFOCUS and you can run WWW-server on XP.
You can run reports in DataMigrator and you can run MS Office on Windows Server.

Only it's not quite natural.
Each product is optimized for different goals and functionality can be extended with different components.

You can't run SQLServer EE on WindowsXP, you will have limits if you try WebFOCUS as integration solution.

And vice versa.


WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID
 
Posts: 79 | Location: Moscow | Registered: April 27, 2007Report This Post
Virtuoso
posted Hide Post
We use Data Migrator as our ETL tool, but rely HEAVILY on WF RPCs in many of our jobs. In theory, yes you could use WF + some scheduler tool (like Report Caster) as your ETL tool.

In many cases, the SQL that is required is more easily used in DM which relies more on the SQL side than the FOCUS side, (but uses MODIFY in the end for the insert/update/deletes).

MAINTAIN would work, but I would, respectfully, disagree with MaintainWizard (is there a bias there ??) MAINTAIN requires an additional license, knowledge of an entirely different "language" and the reasons Mark lists at the bottom are very key to the ETL process. Plus the fact that there is still a scheduler component that is required. All of the IBI products, not just MAINTAIN read/write any database, any location so that is a plus regardless of the tool you choose. Having used MAINTAIN in a previous life, I definitely would not use it for ETL.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Platinum Member
posted Hide Post
Darin,

Does Data Migrator require additional licensing or is it part of the WebFocus product?

Also, how long has Data Migrator been around?

Thanks
Jim


WF DevStu 5.2.6/WF Srv 5.2.4/Win NT 5.2
 
Posts: 118 | Location: Lincoln Nebraska | Registered: May 04, 2005Report This Post
Expert
posted Hide Post
Data Migrator is an iWay product and has been around since the mid-90's. It was known as Copy Manager in those days and has had a number of name changes since then including ETL Manager. There was a previous product called Data Migrator that sat on top of ETL Manager and was used for ERP tools.

Each and every release is more robust and industry-standard than the previous. Good stuff.

It is a separate license.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Gold member
posted Hide Post
Hmm..

A question comes to my mind: does WebFOCUS Standart support SCDs on load?


WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID
 
Posts: 79 | Location: Moscow | Registered: April 27, 2007Report This Post
Virtuoso
posted Hide Post
Sorry to say that not everybody instantly knows what an SCD is. I'm one of them.
Could you please explain what it is that you are looking for?


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Virtuoso
posted Hide Post
quote:
Originally posted by Ingas:
Hmm..

A question comes to my mind: does WebFOCUS Standart support SCDs on load?


hmm...searched SCD in Google +8 million hits, this is very important, so if IBI can not support this it would be a shame.... Smiler




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Gold member
posted Hide Post
SCDs = Slowly Changing Dimensions
Way for dealing with historical data in datamarts.

When a value in source data for dimension is changed this must reflects on dimension data.

Simplest case - just to update value (e.g. change incorrectly filled value)
More complex - make sequence of actions:
update old dimension record - mark record as inactive, write end date and so on
insert new dimension record - record is marked active, begin date is filled

(I recommend Kimball, Ross "Mastering Data Warehouse")

DataMigrator is supporting SCD-I and SCD-II in master-files.
So it's not needed to write sequences of UPDATE-INSERT - it's done automatically.

The question is: does WebFOCUS Standard/Maintain flows support this.
Maybe only DataMigrator as full-functional ETL do this.

Need to experiment:
simple datamart with fact table and couple of dimension tables
mark some fields in dimension tables as SCDs
create a load flow into this datamart
look what's happened

I do not have time right now
But very interested in results

PS
Hmm..
I've tried to use parallel group in flow (I'm on MAINTAIN right now)
This was first time and I couldn't make it.
But I do not understood - it was bug in DataManagement Console or it impossible in principle


WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID
 
Posts: 79 | Location: Moscow | Registered: April 27, 2007Report This Post
Virtuoso
posted Hide Post
You might get a better response to these questions in the "iWay Products" Forum where ETL and warehousing tools are more commonly discussed.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     diffrence between WebFocus Maintan and Data maigrater tool

Copyright © 1996-2020 Information Builders