Hi 

I do a select * on my view and then pick UPDATE COLUMNS

then i go to the list of columns and delete some and change order

but when i generate the SQL it still shows select * rather than my curated column list.

Regards

George B

Please put me through!  i find it confusing to follow the video screen step by step  "design your database online new " video with "try it now for free" . In the video after introduction click try it now free and next page " create new model" but not like that in the real "try it now for free" in the www.vertabelo.com Pls is there any other round to follow the video just the way it appears on screen.Thanks

This page is totally empty for us!!

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

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

This page is totally empty!!!

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);

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

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. 

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.

It is possible support computed columns for the next version.

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?