<vdb name="{vdb-name}" version="1"> <model name="{model-name}" type="PHYSICAL"> <source name="AccountsDB" translator-name="oracle" connection-jndi-name="java:/oracleDS"/> <metadata type="NATIVE,DDL"><![CDATA[ CREATE FOREIGN FUNCTION SCORE (val integer) RETURNS integer; ]]> </metadata> </model> </vdb>
Results in:
CREATE DATABASE "{vdb-name}" VERSION '1'; USE DATABASE "{vdb-name}" VERSION '1'; --############ Translators ############ CREATE FOREIGN DATA WRAPPER oracle; --############ Servers ############ CREATE SERVER AccountsDB FOREIGN DATA WRAPPER oracle OPTIONS ("jndi-name" 'java:/oracleDS'); --############ Schemas ############ CREATE SCHEMA "{model-name}" SERVER AccountsDB; --############ Schema:{model-name} ############ SET SCHEMA "{model-name}"; IMPORT FROM REPOSITORY "NATIVE,DDL" INTO "{model-name}";