Thanks for the link to the new Idera forum, I've been waiting for the transfer to happen. I had an email about it months ago, before the data modelling groups had been created. It'd be a good idea to broadcast the URL to everyone on the old groups, so we all know where it is, and also post messages on all the old groups.
Have all the old discussions been transferred?

Read More...

Two questions:

1. How can I access this information if I don't have a repository (or want to run a macro against a model in the client)?
2. Where are all these properties documented?

Please see my question (in "Answers") re. tracing a path from a column to the Views that reference it
http://community.embarcadero.com/answers/create-question/can-t-access-view-fields-linked-to-a-column

Read More...

Idera have confirmed that this is indeed a bug. A bug report has been created for solving this issue on a future release - ERS-25769 (Title: Value of attachments for transformations are not updated with ValueOverride property of BoundAttachment object)

Read More...

Thanks, Nic. I seem to have missed a line out, the full code is below. Idera have confirmed that this doesn't work, and there's no way around it. We're still waiting to hear about if and when they propose to fix it.
Here's a macro you can use to try it yourself.
' tests update of attachments for Transformations - all hard-coded' seems to demonstrate that we cannot update attachment value overrides for transformations - look for this line:'theBoundAttachment.ValueOverride = attValueOverride ' DOES NOT WORK !!!!!!!!!!!!!!!!!!!
'Requires the following:' Data Flow called "Names", With a Transformation called "Customer ID"' - make sure this has no attachments' In the Data Dictionary' Attachment Type "Data Lineage Features", for Transformations' - Attachments called "Transformation Status" and "Transformation Status Commentary", both allowing text input
Dim diag As DiagramDim tran As TransformationDim dflow As DataFlow
Dim theDictionary As DictionaryDim theAttachment As AttachmentDim theAttachmentType As AttachmentTypeDim theBoundAttachment As BoundAttachment
Dim dflowNameStr As StringDim tranNameStr As StringDim attValueOverride As String
Dim tranStatus As StringDim tranStatusCommentary As String
Option Explicit
Sub Main
Debug.Clear
Set diag = DiagramManager.ActiveDiagram
Debug.Print "Testing update of attachments for transformations"Debug.Print "Diagram Name: " & diag.ProjectNameDebug.Print "File Name: " & diag.FileName & vbCrLf & "=============================================="
dflowNameStr = "Names"tranNameStr = "Customer ID"tranStatus = "Transformation Issue"tranStatusCommentary = "some words about it"
Set theDictionary = DiagramManager.ActiveDataDictionary
Set dflow = diag.DataFlows.Item(dflowNameStr)
If dflow Is Nothing Then'data flow doesn't existDebug.Print "Data Flow " & dflowNameStr & " does not exist - aborted"Exit SubEnd If
Set tran = dflow.Transformations.Item(tranNameStr)
If (tran Is Nothing) Then'the transformation does not existDebug.Print "Tramsformation " & tranNameStr & " does not exist - aborted"Exit SubEnd If
Set theAttachmentType = theDictionary.AttachmentTypes("Data Lineage Features")
' Transformation StatusSet theAttachment = theAttachmentType.Attachments("Transformation Status")Set theBoundAttachment = tran.BoundAttachments.Add(theAttachment.ID)theBoundAttachment.ValueOverride = tranStatus ' DOES NOT WORK !!!!!!!!!!!!!!!!!!!
' Transformation Status CommentarySet theAttachment = theAttachmentType.Attachments("Transformation Status Commentary")Set theBoundAttachment = tran.BoundAttachments.Add(theAttachment.ID)theBoundAttachment.ValueOverride = tranStatusCommentary ' DOES NOT WORK !!!!!!!!!!!!!!!!!!!
Dim boxMessage As StringboxMessage = "Test update complete"
MsgBox(boxMessage,vbOkOnly,"Transformation attachment test macro")
Exit Sub
'Error_handle:' MsgBox("Please enter a valid path.",,"Error!")' GoTo start_dialog
End Sub

Read More...

The people at ERwin pay a lot more attention than some other vendors do to promoting their product, including asking their users to vote for them in...The people at ERwin pay a lot more attention than some other vendors do to promoting their product, including asking their users to vote for them in various polls or awards. Currently they’re asking their users to vote for ERwin in the “Readers’ Choice Awards” for Database Trends and Applications.

The following data modelling tools are listed in the poll –
PremiumSoft Navicat Data Modeler, Dell T Show more

I want to be able to Import Visual Data Lineage via a macro, and it works OK, except for one thing. It won't apply an override value to an attachment bound to a Transformation. I can do it for attributes, but not Transformations. Is this a bug, or do I need a different command?
Here's the outline of what I'm doing

Set theAttachmentType = theDictionary.AttachmentTypes(attachmentType)

Set theAttachment = theAttachmentType.Attachments(attachmentName)

Set theBoundAttachment = currTran.BoundAttachments(theAttachment.ID)

theBoundAttachment.ValueOverride = importValue

I've had a look at the Idera Community site (community.idera.com/forums/) - I can't see a forum there for ER/Studio

Forums | community.idera.com/forums/

That's one of the checks we'd like to add :)

Read More...

Thanks, Mohammad.
Is it possible to see the wording of the enhancement request, please? Has it been allocated to a future release or approximate timing?

Read More...

I'd like to extend model valiation, to include checks that are in our modelling standards but not currently supported by model validation. I know I can do this by writing macros, but we'd rather have all our checks run from the same dialogue.
Is it possible to customise model validation? If not, I'd like to suggest that as an enhancement.

Read More...

Could this cause ER/Studio to attempt to display a dialogue on a secondary monitor that isn't connected?

Read More...

Out of curiosity, Bill, do you remember which method worked?

Read More...