Your feedback is highly appreciated! Let's make Vertabelo even better.

0
Answered

Service Renewal

Juan Carlos Nunez Umana 3 years ago updated by Łukasz Kubicki 3 years ago 9

Hi Team, 

I need to renew a service with you that has been expired since March 1st.

I have contacted Luke and the office directly but no resonse received yet and this is urgent. 

Can I get someone to assist on this matter please?

Answer
Łukasz Kubicki 3 years ago

Hi Juan,

Sending over the invoice. Will send it also to accounts.payable_US@lionresources.com.

FA_000001_03_2022 Conversant LLC.PDF

Regards,

Luke

0
Answered

A SaaS Subscription Data Model

niklas ullrich4720 3 years ago updated 3 years ago 2

Hey guys,

in the example SaaS Subscription Database Model from Emil Drkušić, 

is there any connection between the user group type in the Users and Groups section and the user group type in the Software and plans section? 

My question is about the min/max members in both entitys.

If there is a company user group type in usergroup section with 1-10 users, must the same number of users be specified in the user group Type: Software? 

0
Fixed

SQL generated for SqlServer doesn't have correct schema name when dealing with extended properties for comments

Nick Rossiter 3 years ago updated 3 years ago 3

Hi, I've notice a bug with Sql generation.


When the target Database is SqlServer, the generated SQL for the table and column comments is not quite right if the schema being used is not dbo.


e.g. this is the generated code for the table 'MyTable' in the schema 'MySchema'.

if exists (select * from ::fn_listextendedproperty('MS_Description', 'schema', 'dbo', 'TABLE', 'MyTable', null,null))
BEGIN
EXEC sp_dropextendedproperty
@name = N'MS_Description',
@level0type = N'SCHEMA',
@level0name = 'MySchema',
@level1type = N'TABLE',
@level1name = 'MyTable';
END;

EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = N'Comment for MyTable',
@level0type = N'SCHEMA',
@level0name = 'MySchema',
@level1type = N'TABLE',
@level1name = 'MyTable';


The calls to sp_dropextendedproperty and sp_addextendedproperty are correct.

The 'if exists (select * from ::fn_listextendedproperty' call to determine whether the extended property exists is incorrect in that it has the schema as 'dbo' instead of 'MySchema'

Therefore the extended property is not dropped and the add fails as it already exists.

(This is the behaviour for when the target is SqlServer 2017/2019, I haven't checked other SqlServer versions.)

Please can you look into it

Thanks

Nick

0
Answered

How to convert database diagram into a conceptual data model

Peter Mbugua 3 years ago updated by Jarosław Błąd (CEO) 3 years ago 1
Answer

Unfortunately there is no such functionality in Vertabelo modeler.

0
Answered

SOX Compliance

Louis Springer 3 years ago updated by Jarosław Błąd (CEO) 3 years ago 2

Is Vertabeo SOX or HiTrust complainant, or do you have similar EU compliance certifications?

Answer

Unfortunately we don’t provide such certificates.

0
Fixed

Iframe link from Confluence stopped working

Mick Flynn 3 years ago updated 3 years ago 5

Hi,

We have been exposing public model views as IFrames in our Confluence documentation for some time but recently this has stopped working with "Connection refused". Using the link in a normal browser window still works fine. Example:

<iframe src="https://my.vertabelo.com/logical/public-model-view/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx?x=6500&y=6500&zoom=0.99" noborder="0" width="1500" height="1000" scrolling="yes" seamless></iframe>

Is there something that has changed in your request handling behaviour?

Thanks!

/Mick

0
Started

Right pane is not visible when editing a model

Aner Perez 6 years ago updated by Justinn Zamora 3 years ago 4

When editing a model on Windows 10 Chrome 72.0.3626.119 (Official Build) (64-bit), the right pane only shows an empty gray area.  Showing/hiding the right pane only hides and shows this gray area with no content.  This makes it impossible to edit table definitions.  Reloading the page did not help.

As a workaround, hiding the left pane causes the right pane to show up correctly.


Image 724

+4
Under review

ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]

정 창훈 4 years ago updated by Jay1111111 3 years ago 2

Image 1108

ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]

0
Completed

Link models

mark leavesley 10 years ago updated by Philip Snyman 3 years ago 4
If I had a very large model and I wanted to separate areas into different models to avoid distraction and aid on screen clarity, it would be good to link tables between them. I'm starting to have problems with lines crossing other lines and having to spend more time re-arranging than actually designing. If I could separate functional areas out without actually disconnecting them, it would be awesome.

Or...tag tables and colour by tag, hide by tag, something like that.
0
Under review

API - Retrieve Drop SQL Script

Rishab Nayak 3 years ago updated by Rafał Strzaliński (Senior Engineer) 3 years ago 1

Is there any way for us to generate the Drop SQL Script using the API?