Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] How to rename the filefeed name in Datamigrator
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to rename the filefeed name in Datamigrator
 Login/Join
 
Member
posted
Can anyone help/guide on how to change the filefeed name

This message has been edited. Last edited by: Tamra,


WebFOCUS 8002, Developer Studio,Excel, PDF, Active Formats and HTML5
 
Posts: 7 | Registered: May 26, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
Could you elaborate on what you mean by "filefeed?"

If it's the source synonym in a flow you can right click on it and select change source.

If it's the DATASET name in a synonym you can edit or paramaterize it there.
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Filefeed i mean the one where my data is .

In my case I have data in an excel file named 'dataset' and with that i create my synonym

When i get new set of data or if i have to point to another dataset named 'dataset2'

how do i do this?


WebFOCUS 8002, Developer Studio,Excel, PDF, Active Formats and HTML5
 
Posts: 7 | Registered: May 26, 2014Reply With QuoteReport This Post
Guru
posted Hide Post
There are two adapters for reading Excel data, Excel (via ODBC) and Excel (via direct retreival). I'm going to guess that you are using the latter.

Open the synoynm in the synonym editor, right click on its name and select properties. There you will see under General an attibute called DATASET that should have the location and name of your workbook.

If this is a one time change you can change the name to another workbook that has the same layout and save the synonym.

If you want to change the workbook dynamically you can right click on DATASET and select Paramertize value. That will replace the value with a global variable name. Save the synonym

Open your data flow and click on the process flow tab. Add a Set variables object between Start and Data Flow and connect it. Now you can set the value for the variable as needed.
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] How to rename the filefeed name in Datamigrator

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.