General

  1. BI xPress - Applying Auditing Framework with Row Count Logging enabled currently requires auto-layout of Data Flow

    Currently when applying Auditing Framework with Row Count Logging enabled, the data flow must have an auto-layout performed as rows are inserted into the package on every data flow within the package. This can be a nuisance if you have manually formatted the layout on the data flow on your package, your time spent manually formatting is overwritten by the auto layout. It would be great if BI xPress could somehow be improved to either:
    A) Allow the user to apply Framework with Row Count Logging onto targeted data flows. This would limit the auto-layout override to only targeted data…

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. BI xPress SSIS Catalog Import - Implement a scheduling function for import

    Currently SSIS Catalog Import is a very manual process. It would be great if SSIS Catalog Import was fleshed out to leverage some sort of scheduling function so a schedule for the import can be set, along with a user interface update within the Workbench to schedule this. This would allow import during times when the SSIS Catalog is not under regular load, and to help avoid performance issues during production hours.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. DOC xPress - Improved error handling for 'bad reports' from SSRS Sharepoint and Native Web Service

    Often times when upgrading a reporting server, there are many reports that have been imported into the new instance, but the old unimportant ones have not been updated to the new instance (or the data source no longer exists). This becomes a problem for DOC xPress as it will throw various errors upon snapshot.

    The obvious resolution is to fix the reports or filter them out manually, however this is not always a quick or feasible resolution in many organizations that may have a massive amount of old reports.

    Is there a way to improve how DOC xPress handles these…

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Upsert Static Value

    With the Upsert Destination I would like to have the ability to enter a static value on the Column Mappings instead of a Column Name. So if I have a Destination column called 'RecordType' and I don't want to create an upstream column for a value, I just want to have the ability to enter in a value of '2' for the 'RecordType' destination column that should be used when insert, updating or inserting & updating. It would also be nice to have a condition on the static value so that you could insert one specific value on an insert…

    15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. LegiTest - Read data from mainframe, Hadoop, and SAP files for testing

    It would be great if LegiTest could be used to test data in the following formats

    -Mainframe file formats – EBCDIC
    -SAS sas9bdat files, sas9hdat (Hadoop) files
    -SAP​

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Sharepoint Documents Task: Add new Task Modes

    Add the following modes to the current list of download and upload task modes:
    (1) Move a file
    (2) Move all file in a directory

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. GUID Generator

    Just like TF Surrogate Key Transform component but with the option of sequence GUID or random GUID.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. TF Hash Transform editor needs work

    in TF hash transform add capability to reshuffle columns easily. The way it works now if I have 60 columns and a column near the bottom needs to be in position one, I need to press an up arrow with a mouse click ~ 60 times.

    Now consider the amount of work needed to order 60 random columns into a specific order. I should be able to just enter the position number and have everything reshuffle. I should be able to grab the row with the cursor and drag it up. I should be able to sort.

    This works great…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. BI xPress Auditing Framework: Variable Logging

    The option to log all iterations for variables and view the history of each value within the Monitoring Console.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Task Factory: Please add URL locations for PGP Keys.

    When vendors provide the key, we don't often have a choice. Data security is too important to send privacy information without encryption. Please update the PGP task to utilize URLs so that we can use the TF tools for our PGP encryption under this requirement.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. DOC xPress Oracle support for Lineage Analysis

    Currently DOC xPress can not leverage Lineage Analysis for Oracle. We would very much love this addition if possible.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. BI xPress Server: Auditing Framework-Command Line

    To add a switch within the Command Line for "Package Groups" so that a package can be associated to a package group for viewing within the Monitoring Console.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. PW Software Automated Pre-Requisite Utility

    Is there an automated way (e.g. a utility) that will detect whether or not PW Software pre-requisites are met?  Would be a very nice-to-have capability.

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. REST destination component doesnt have logging capability

    REST destination component doesnt have logging capability.
    At the same time REST task does have that capability.
    Sometimes all the rows get redirected to error 400 in Rest destination.
    In the same component , we can see request details by clicking TEST Endpoint URL. If it can log the request details runtime- it will be an awesome thing.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow any character to be read as a delimiter by the TF File Gateway Task

    It would be helpful if the TF File Gateway Task would allow the user to input any character as the file delimiter. This will create a more dynamic component that would be very useful!

    11 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 2-Factor authentication for Sharepoint

    Our sharepoint has 2-factor authentication. Is there any way to implement this in the Sharepoint component so files can be loaded from sharepoint.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Rest API version of SharePoint (Source and Destination)

    Can y'all create the Rest API version of SharePoint (Source and Destination) for file storage? May be able to using Octet-Stream.

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Execute SQL Agent Job and Wait

    There are multiple use cases where an SSIS package needs to execute a SQL Server Agent Job, wait for it to complete, then run something else.

    I propose that you create an Advanced Execute SQL Agent Job Task, which allows me to connect to a server, run a job, then have the task wait until the job is completed and either fail or succeed based on whether the job failed or succeeded.

    Hacks to do this via T-SQL are all over the internet:
    - http://stackoverflow.com/questions/10648475/need-to-start-agent-job-and-wait-until-completes-and-get-success-or-failure
    - https://www.mssqltips.com/sqlservertip/2167/custom-spstartjob-to-delay-next-task-until-sql-agent-job-has-completed/

    However, it requires you to create stored procedures or use really complicated SQL…

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. LegiTest - Increase the default timeout value to higher number (preferably 600 seconds)

    Increase the default timeout value to the longer time (preferably 600 seconds), currently, the default value is 30 seconds which is too short to query a medium-sized table.

    14 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 39 40
  • Don't see your idea?

General

Feedback and Knowledge Base