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

0
Отвечен

https://my.vertabelo.com/company-account/documents not working

William Bell 6 лет назад обновлен Mariusz Zakrzewski 6 лет назад 2

This page is totally empty for us!!


https://my.vertabelo.com/company-account/documents


0
Исправлен

Document page is empty

William Bell 6 лет назад обновлен Mariusz Zakrzewski 6 лет назад 3
0
Отклонен

I am not sure why my crosstab is not running but giving me the error message I am getting Line 2 (FROM) systax error, SELECT employee_id, ship_country, freight from orders ORDER BY 1,2 FROM crosstab('select employee_id, ship_country, SUM(freight) from ord

Boat 6 лет назад обновлен Rafał Strzaliński (Senior Engineer) 6 лет назад 1

SELECT employee_id, ship_country, freight from orders ORDER BY 1,2
FROM crosstab('select employee_id, ship_country, SUM(freight) from orders ORDER by 1,2')
    AS final_result(employee_id SMALLINT, Austria VARCHAR, Finland VARCHAR, Italy VARCHAR, France VARCHAR, Germany VARCHAR, Brazil VARCHAR, Belgium VARCHAR, Switzerland VARCHAR);

+1
Отклонен

Are there any plans to support Hive?

Mark Champion 7 лет назад обновлен Ricardo Gaspar 6 лет назад 2

Given the emergence of Hadoop, are there any plans to add Hive as a source?

0
На рассмотрении

Updating existing database with new tables and references

Mathias Bjerglund Poulsen 6 лет назад обновлен Adam Mościcki 6 лет назад 1

I have a simple model designed and exported it and set up a database from that.

Now I want to update my model with new tables and references and export this as well and then update my database.

I tried to do that, but when I imported it to my existing schema, it didn't have all columns and references only some of them.

I use MySQL workbench to manage my MySQL database.


Would I need to make a need schema with the new exported model and then migrate the new one to the old one using something like Flyway? Or how would one do this? 


Sorry if this is a very basic question or it is unclear what i am asking. I am rather new to SQL databases. 

0
Завершен

How to show the fields that have indexes and check constraints in the diagram and exported table

Rikke Hammer 6 лет назад обновлен Mariusz Zakrzewski 6 лет назад 2

It would be nice to be able to show the fields that have indexes and check constraints in the diagram and the exported table, for better overview.

0
Завершен

Is it possible to add computed columns in SQL data model?

Alex Sanchez Sanchez 6 лет назад обновлен Rafał Strzaliński (Senior Engineer) 6 лет назад 1

It is possible support computed columns for the next version.

0
Отклонен

Issue with RSA signing in IBM DataPower

Soujanya Bargavi 6 лет назад обновлен Rafał Strzaliński (Senior Engineer) 6 лет назад 1

I am unable to generate specific sections of SAML assertions in IBM DataPower while trying to digitally sign a request (Product details: Build: 277257, Firmware: IDG.7.5.1.0). I have the uploaded the public crypto certificate on DataPower but I am unable to configure DataPower to generate the following two sections (The below is the format in which the backend expects the DataPower output):

1.

<ds:KeyInfo>
  <ds:KeyValue>
    <ds:RSAKeyValue>
      <ds:Modulus>xxx</ds:Modulus>
      <ds:Exponent>xxx</ds:Exponent>
    </ds:RSAKeyValue>
  </ds:KeyValue>
</ds:KeyInfo>
    2.
<ds:KeyInfo Id="KeyId-xxx">
  <wsse:SecurityTokenReference wsse11:TokenType="http://docs.oasis-open.org/wss/oasis-wss-saml-token-profile-1.1#SAMLV2.0" wsu:Id="xxx" xmlns:wsse11="http://docs.oasis-open.org/wss/oasis-wss-wssecurity-secext-1.1.xsd">
    <wsse:KeyIdentifier ValueType="http://docs.oasis-open.org/wss/oasis-wss-saml-token-profile-1.1#SAMLID">xxx</wsse:KeyIdentifier>
  </wsse:SecurityTokenReference>
</ds:KeyInfo>

Are there any settings on DataPower to generate these header? Or we need to place a custom XSL transform to generate these headers?

0
Отвечен

importing columns

George Bassili 6 лет назад обновлен Adam Mościcki 6 лет назад 1

is there a way to import a table definition from excel? i.e. i have my columns and data types in an excel spreadsheet already and i want to import them in rather than have to key them all?

Ответ
Adam Mościcki 6 лет назад

Hello

Unfortunately, there is no way to copy table definition from excel.


PS: If you have tables with same column names Copy & Paste feature may be helpfulhttps://support.vertabelo.com/communities/1/topics/173-copy-and-paste-columns

Best regards,

Adam Mościcki




+9
На рассмотрении

organize layout

Germán Lares 9 лет назад обновлен Sapan 6 лет назад 3
A function to organize the db layout

Сервис поддержки клиентов работает на платформе UserEcho