There should be a command line tool to import PLN files comparable to saexport.

Team, when using a comma as field separator, the (user defined) locale can make life seriously difficult; when a number larger that one thousand is written to the file, a comma gets included into the field, therefore adding a field separator.
In the dtf sink I can define locale for decimal and thousand separator, it would be great if I had the option to ‘not include’ the thousand separator at all. For example: the value 1,750.32 would be included in the file as 1750.32.

Typically I try to use a different field separator of course, but sometimes the application that reads the file won’t allow for that….

kind regards, met vriendelijke groet,

Peter Jansens

There is a great use of Icons and a great UI in Sagent, but everything is only mouse-driven. However, when working, you need to type anyway (name of Transforms and so on). Now, I am not asking about a complete re-visit of all Transforms and dialogs, but if you could make sure the big things, like the main window, like Sagent Plan Editor or how this thing is called can be worked on with the Keyboard. That would be really great.

On behalf of our Partner Alicornio:

When reading in datetime fields using the XML source in Sagent it is only possible to select from the pre-defined formats. At the moment we need to read and define datetime data in the format of YYYY-MM-DD, and this does not seem possible. Would it be possible to put in an enhancement request for the user to be able to define a custom format like in the delimited text file source?

On behalf of our Partner Alicornio:

Make documentation available for tuning Sagent DF for a 64bit environment and also for multi-cpu

sometimes it happens that a connection to the DFS server from the DesignStudio/InformationStudio is lost for network reasons.

 

You can re-connect to the DFS server by going into tools/options/DataFlowService and click ok.

 

But this can only be done when there are no open plans.

 

As long as the connections to the repository database is there, it should be possible to re-connect to the DFS server also when plans are open.

On behalf of our Partner Alicornio:
 
All User-defined settings should be centrally controlled via Sagent Admin.
At the moment we have many registry settings that have to be entered in manually, and aren't available in Admin.

One of our partner requests us to provide an utility that can list up the plan(s) that has the error on expression calculator transform..
Their many of customers had some issues until now after upgrading/applying patch set for the incompatibilities/regression issue.
This makes a impact that they got the incorrect/unexpected result since we can execute the plan that the expression has the error.
So they always have to check all the plans to open the expression calculator transforms on each plan by manual after upgrading or applying the patch set.
This is really time-consuming work for our partners so they were calling for improvement since Sagent V5.0 was released.
Your kind consideration of this matter would be sincerely appreciated.

 If customer has two instances of DFS,then there should be provision of load sharing between two instances of the DFS 
i.e if load,on first instance goes beyond a thresold value load should be diverted to second instance.

Hi,
there are different ways to connect to databases: native connection, ODBC, .NET Framework, etc.
It would be helpful when a connection method could be choosen.
We've seen performance differences when you use a different connection method.

There is a command line tool called SAEXPORT, that exports plans into PLN files. The logical counterpart, an import tool, is missing. To rebuild a repository it is necessary to export all plans without IDs -> the only way to do this is by exporting them into PLN files. Now we have to import all plans manually... and there are about 1.200 plans in more than 50 folders.
Why is the export tool adding the plan ID to the plan/file name?

This is ER from our partner.

One of our partner request to enhance about right click menu on Grid sink.
They asked me to add “copy” facility on the right click menu at least to copy/paste the data on the grid sink to another Windows Application.