-
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 Refresh Source - Check/Force Assemble Status
For Collect Refresh Source - It would be nice if it ran a check to see if any Assemble packages registered to that source are currently in a "processing" state and give the option to do a Force reset of the Assemble package, then proceed to kick o...0 Needs review
-
Collect - Stop Refresh
It would be great to be able to stop a current refresh in Collect. -
Collect - Activate the setting "Delete Target Table On Build" by default
I wanted to add some new target fields in a dg target table in Collect. A simple rebuild didn't add them. After investigation, we figured out the table has to be manually dropped in SSMS. After you can rebuild the table in Collect and the new fiel...0 Future consideration
-
When building tables in collect utilizing the SAP data dictionary we should leverage the DD04L.LOWERCASE Indicator to set case sensitive collation where appropriate.
When building tables in collect utilizing the SAP data dictionary we should leverage the DD04L.LOWERCASE Indicator to set case sensitive collation where appropriate. Everyone working with SAP (migration, governance, data quality, etc.) will benefi...2 Future consideration
-
View Source Record Count Button In Collect & Assemble
Often when dealing with presumed large tables I want to check the size before I collect them. I may even want to try several different where clauses. Right now my only option is to modify the select statement in assemble to count(*) and then hit t... -
Collect - Add update RAW and VARBINARY data conversions for most common source databases
As part of every install of DSP or new data source type added, we have to change the RAW and VARBINARY data types to convert properly to character fields. Here are two examples that should come out of the box configured: ODBCHANA New Data Type For...1 Likely to Implement
-
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
-
Collect should disable Source Schema Owner for SAPAPPSERVER Sources
In Collect, the [SCHEMA OWNER] setting must be "dbo" in order for Data Services using RFC packages to build without error in an "SAPAPPSERVER" Source. It doesn't make sense that a user is allowed to change it, since "dbo" is the default. Simply di...0 Planned
-
Copy DBMoto Replication Status Meta Data into dgTargetSourceTable
Currently when a table is setup to be refreshed in DBMoto, we have to log into the DBMoto application to view the status. It would be great if the Errors could be copied from DBMoto into the RefreshMessage column in dgTargetSourceTable similar to ...