-
Add "Numeric" rule to SQLSERVER connection type in Collect.
In the absence of a Numeric data type rule, Collect defaults to the ANY type as defined as nvarchar with the same length as the source field. When the source data contains a value that is at the character maximum for numeric and is a negative valu...1 Planned
-
API: Start Refresh for a Group of Tables in Collect from the stored procedure
BOAUnited This will make possible to call Collect refreshes from manual rules registered in Transform. In the complex objects the load flow often looks like this: 1.Process ttTarget1 2.Load export into target system 3.Refresh Collect for...0 Future consideration
-
Excel or Flatfile sources should be permitted in Collect
BOAUnited This ORT Support request has the details - Proper method to Import Excel using Collect I would like to set up a directory to import files and treat it like a system or other connection in collect. We have files coming from various ...0 Likely to Implement
-
Collect Manual SQL
BOAUnited One of the drives about DSP I really like is the push to reuse work from one release cycle/wave to another. We have already successfully used the copy mappings functions, and we do our best to write rules that can be Automated. However f...0 Future consideration
-
From UAT: It would be nice if Collect didn't require Username and Password for Local Resources
BOAUnited It would be nice if Collect didn't require Username and Password for Local Resources See Issue Documentation - 1070 - Collect should not require UN/PW for local datasources0 Future consideration
-
Collect - Enhance collect such that Variant Tables (CU60) can be downloaded
BOAUnited Add features to Collect per this document such that these additional tables can be properly downloaded from SAP. There may be additional solutions/changes required in order to download these tables and the associated data using Data Ser... -
Filter on Tables Imported using RFC Package
It would be good to have the ability to add filters in the WHERE clause for tables being imported into Collect via an RFC package. Some tables are really large (for eg. Long Text) and adding in a filter would help to reduce the download time and o...0 Already exists
-
Collect background process improvement that reduces collect from hours to minutes
Within collect we are using Load Balencer. There is a setting for max jobs per LB queue but due to the way Collect service pages allocates the jobs, we are not seeing multiplue jobs in a LB queue. We are using manual SDS jobs, but i suspect the sa...3 Unlikely to Implement
-
In Collect, Ignored Columns Should be logged on build
Currently I spend a lot of time tracking down missing data in collected tables, often this is attributable to the datatype conversion being set as ignore. There is not notification that a column is ignored. On a single table build I would recommen...0 Planned
-
Handle Data Services Warnings not as Errors in Collect, but instead as non-error messages.
Can you alter how Data Services Warning log messages are handled, so that they are not considered errors in Collect? We have some situations in pulling data from SalesForce.com where we sometimes get warnings, and it retriggers a long running tabl...0 Future consideration