{"id":2719,"date":"2025-08-18T10:18:24","date_gmt":"2025-08-18T10:18:24","guid":{"rendered":"https:\/\/blog.daiconext.com\/?p=2719"},"modified":"2025-08-18T20:54:18","modified_gmt":"2025-08-18T20:54:18","slug":"erwin-data-modeler-teradata","status":"publish","type":"post","link":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/","title":{"rendered":"Crear un Modelo: Erwin Data Modeler &#8211; Teradata"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Creando un modelo en Erwin Data Modeler con base de datos Teradata<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en <strong>Erwin Data Modeler<\/strong> utilizando como motor de base de datos <strong>Teradata<\/strong>. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Cliente<\/strong><\/li>\n\n\n\n<li><strong>Factura<\/strong><\/li>\n\n\n\n<li><strong>Producto<\/strong><\/li>\n\n\n\n<li><strong>Categor\u00eda<\/strong><\/li>\n\n\n\n<li><strong>Usuario<\/strong><\/li>\n\n\n\n<li><strong>RolUsuario<\/strong><\/li>\n\n\n\n<li><strong>Factura_Producto<\/strong> (en el modelo f\u00edsico, para manejar la relaci\u00f3n de muchos a muchos entre Factura y Producto).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">1. Preparando el entorno<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de empezar:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verifica que tienes instalado <strong>Erwin Data Modeler<\/strong> con el driver de <strong>Teradata<\/strong> configurado.<\/li>\n\n\n\n<li>Crea un nuevo <strong>modelo l\u00f3gico\/f\u00edsico (LDM\/PDM)<\/strong> seleccionando <em>Teradata<\/em> como base de datos objetivo.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">2. Dise\u00f1o del modelo l\u00f3gico<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">En el nivel l\u00f3gico, identificamos las entidades principales y sus atributos:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Cliente<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdCliente (PK)<\/li>\n\n\n\n<li>Nombre<\/li>\n\n\n\n<li>Apellido<\/li>\n\n\n\n<li>Direccion<\/li>\n\n\n\n<li>Tel\u00e9fono<\/li>\n\n\n\n<li>DNI<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Factura<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdFactura (PK)<\/li>\n\n\n\n<li>Cif<\/li>\n\n\n\n<li>Fecha<\/li>\n\n\n\n<li>RazonSocial<\/li>\n\n\n\n<li>Direccion<\/li>\n\n\n\n<li>MontoTotal<\/li>\n\n\n\n<li>IdCliente (FK)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Producto<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdProducto (PK)<\/li>\n\n\n\n<li>Producto<\/li>\n\n\n\n<li>PrecioCompra<\/li>\n\n\n\n<li>PrecioVenta<\/li>\n\n\n\n<li>Stock<\/li>\n\n\n\n<li>IdCategoria (FK)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Categor\u00eda<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdCategoria (PK)<\/li>\n\n\n\n<li>Categoria<\/li>\n\n\n\n<li>Descripcion<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Usuario<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdUsuario (PK)<\/li>\n\n\n\n<li>Usuario<\/li>\n\n\n\n<li>Password<\/li>\n\n\n\n<li>Estado<\/li>\n\n\n\n<li>IdRol (FK)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>RolUsuario<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdRol (PK)<\/li>\n\n\n\n<li>Rol<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Nota:<\/strong> Relaci\u00f3n <strong>Factura \u2013 Producto<\/strong> contiene una relacion muchos a muchos (una factura puede contener varios productos y un producto puede estar en varias facturas).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Normalizando las relaciones<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Para manejar las relaciones de muchos a muchos, se crean tablas intermedias en el <strong>modelo f\u00edsico<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Factura_Producto<\/strong>\n<ul class=\"wp-block-list\">\n<li>IdFactura (FK)<\/li>\n\n\n\n<li>IdProducto (FK)<\/li>\n\n\n\n<li>Cantidad<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">4. Generaci\u00f3n del modelo f\u00edsico en Teradata<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">En el modelo f\u00edsico, definimos los <strong>tipos de datos<\/strong> seg\u00fan Teradata. Por ejemplo:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>INTEGER<\/code> para claves primarias.<\/li>\n\n\n\n<li><code>VARCHAR(100)<\/code> para nombres y correos.<\/li>\n\n\n\n<li><code>DECIMAL(10,2)<\/code> para montos y precios.<\/li>\n\n\n\n<li><code>DATE<\/code> para fechas.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Video Tutorial:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"4. Erwin Data Modeler - Crear Un Modelo\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/S6b2Q75gKA4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">5. Validaciones finales<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de exportar el modelo a Teradata:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verifica consistencia de nombres.<\/li>\n\n\n\n<li>Revisa que todas las relaciones tengan sus llaves correctamente asignadas.<\/li>\n\n\n\n<li>Comprueba que los tipos de datos sean compatibles con Teradata.<\/li>\n\n\n\n<li>Documenta cada entidad y columna para facilitar el mantenimiento.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">6. Exportando a Teradata<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Una vez terminado el modelo f\u00edsico, Erwin permite generar el <strong>DDL de Teradata<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ve a <strong>Forward Engineer > Generate Database Script<\/strong>.<\/li>\n\n\n\n<li>Selecciona Teradata como destino.<\/li>\n\n\n\n<li>Elige las tablas y relaciones que quieras generar.<\/li>\n\n\n\n<li>Exporta el script y ejec\u00fatalo en tu base de datos Teradata.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Ejemplo de definici\u00f3n en el <strong>DDL para Teradata<\/strong>:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE MiBaseDatos.Cliente (\n    IdCliente INTEGER NOT NULL,\n    Nombre VARCHAR(100),\n    Apellido VARCHAR(100),\n    Direccion VARCHAR(100),\n    Telefono VARCHAR(20),\n    Dni VARCHAR(20),\n    PRIMARY KEY (IdCliente)\n);\n\nCREATE TABLE MiBaseDatos.Factura (\n    IdFactura INTEGER NOT NULL,\n    Cif VARCHAR(20),\n    Fecha DATE,\n    MontoTotal DECIMAL(10,2),\n    RazonSocial VARCHAR(20),\n    IdCliente INTEGER,\n    PRIMARY KEY (IdFactura),\n    FOREIGN KEY (IdCliente) REFERENCES Cliente(IdCliente)\n);\n\nCREATE TABLE MiBaseDatos.Producto (\n    IdProducto INTEGER NOT NULL,\n    Producto VARCHAR(100),\n    PrecioCompra DECIMAL(10,2),\n    PrecioVenta DECIMAL(10,2),\n    Stock VARCHAR(100),\n    IdCategoria INTEGER,\n    PRIMARY KEY (IdProducto),\n    FOREIGN KEY (IdCategoria) REFERENCES Categoria(IdCategoria)\n);\n\nCREATE TABLE MiBaseDatos.Categoria (\n    IdCategoria INTEGER NOT NULL,\n    Categoria VARCHAR(100),\n    Descripcion VARCHAR(100),\n    PRIMARY KEY (IdCategoria)\n);\n\n-- Nota: Esta tabla tambien se puede llamar Detalle_Pedido\nCREATE TABLE MiBaseDatos.Factura_Producto (\n    IdFactura INTEGER,\n    IdProducto INTEGER,\n    Cantidad INTEGER,\n    PRIMARY KEY (IdFactura, IdProducto),\n    FOREIGN KEY (IdFactura) REFERENCES Factura(IdFactura),\n    FOREIGN KEY (IdProducto) REFERENCES Producto(IdProducto)\n);\n\nCREATE TABLE MiBaseDatos.Usuario (\n    IdUsuario INTEGER NOT NULL,\n    NombreUsuario VARCHAR(50),\n    Contrasena VARCHAR(100),\n    Email VARCHAR(100),\n    PRIMARY KEY (IdUsuario)\n);\n\nCREATE TABLE MiBaseDatos.RolUsuario (\n    IdRol INTEGER NOT NULL,\n    Rol VARCHAR(50),\n    PRIMARY KEY (IdRol)\n);<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Cliente<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Nombre<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Apellido<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Direccion<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Telefono<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Dni<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Factura<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Cif<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Fecha<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">DATE<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">MontoTotal<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">DECIMAL<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">RazonSocial<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Cliente<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Producto<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Producto<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PrecioCompra<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">DECIMAL<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PrecioVenta<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">DECIMAL<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Stock<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Categoria<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Categoria<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Categoria<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Descripcion<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">--<\/span><span style=\"color: #D8DEE9FF\"> Nota<\/span><span style=\"color: #ECEFF4\">:<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Esta<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">tabla<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">tambien<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">se<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">puede<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">llamar<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Detalle_Pedido<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Factura_Producto<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Cantidad<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Factura<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Producto<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Usuario<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdUsuario<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">NombreUsuario<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">50<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Contrasena<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Email<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdUsuario<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">RolUsuario<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdRol<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Rol<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">50<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdRol<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Crear un modelo de datos en <strong>Erwin Data Modeler<\/strong> para Teradata no solo ayuda a organizar la informaci\u00f3n, sino que tambi\u00e9n asegura consistencia, escalabilidad y documentaci\u00f3n clara. Con este modelo, puedes gestionar clientes, facturas, productos, categor\u00edas y usuarios de manera eficiente, y tener un dise\u00f1o listo para producci\u00f3n en Teradata.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Nota:<\/strong> en este caso se utilizo como base de datos Teradata, pero usando la misma metodolo\u00eda se puede hacer lo mismo para llevarlo a SqlServer, Oracle o el motor de bases de datos de su preferencia.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: 1. Preparando el entorno Antes [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2727,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[61],"tags":[],"class_list":["post-2719","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teradata"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\u00eda Usuario\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"admin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"es_ES\" \/>\n\t\t<meta property=\"og:site_name\" content=\"blog.daiconext -\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Crear un Modelo: Erwin Data Modeler \u2013 Teradata - blog.daiconext\" \/>\n\t\t<meta property=\"og:description\" content=\"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\u00eda Usuario\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2026\/08\/cropped-DAiCoNext_logo_170x88.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2026\/08\/cropped-DAiCoNext_logo_170x88.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2025-08-18T10:18:24+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-08-18T20:54:18+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Crear un Modelo: Erwin Data Modeler \u2013 Teradata - blog.daiconext\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\u00eda Usuario\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2026\/08\/cropped-DAiCoNext_logo_170x88.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#blogposting\",\"name\":\"Crear un Modelo: Erwin Data Modeler \\u2013 Teradata - blog.daiconext\",\"headline\":\"Crear un Modelo: Erwin Data Modeler &#8211; Teradata\",\"author\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/author\\\/cano19781wp\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/blog.daiconext.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/edm-crear-modelo.jpg\",\"width\":839,\"height\":842},\"datePublished\":\"2025-08-18T10:18:24+00:00\",\"dateModified\":\"2025-08-18T20:54:18+00:00\",\"inLanguage\":\"es-ES\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#webpage\"},\"articleSection\":\"Teradata\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.daiconext.com#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.daiconext.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/category\\\/teradata\\\/#listItem\",\"name\":\"Teradata\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/category\\\/teradata\\\/#listItem\",\"position\":2,\"name\":\"Teradata\",\"item\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/category\\\/teradata\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#listItem\",\"name\":\"Crear un Modelo: Erwin Data Modeler &#8211; Teradata\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.daiconext.com#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#listItem\",\"position\":3,\"name\":\"Crear un Modelo: Erwin Data Modeler &#8211; Teradata\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/category\\\/teradata\\\/#listItem\",\"name\":\"Teradata\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/#organization\",\"name\":\"blog.daiconext\",\"url\":\"https:\\\/\\\/blog.daiconext.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/blog.daiconext.com\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/cropped-DAiCoNext_logo_170x88.png\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#organizationLogo\",\"width\":170,\"height\":88},\"image\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/author\\\/cano19781wp\\\/#author\",\"url\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/author\\\/cano19781wp\\\/\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6f98bef2100a8df6af9544238f8ca7e3616d56b473b3bed1367a8e6456e07b78?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"admin\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#webpage\",\"url\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/\",\"name\":\"Crear un Modelo: Erwin Data Modeler \\u2013 Teradata - blog.daiconext\",\"description\":\"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\\u00edculo vamos a recorrer paso a paso c\\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\\u00eda Usuario\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/author\\\/cano19781wp\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/author\\\/cano19781wp\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/blog.daiconext.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/edm-crear-modelo.jpg\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#mainImage\",\"width\":839,\"height\":842},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/index.php\\\/2025\\\/08\\\/18\\\/erwin-data-modeler-teradata\\\/#mainImage\"},\"datePublished\":\"2025-08-18T10:18:24+00:00\",\"dateModified\":\"2025-08-18T20:54:18+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/#website\",\"url\":\"https:\\\/\\\/blog.daiconext.com\\\/\",\"name\":\"blog.daiconext\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.daiconext.com\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Crear un Modelo: Erwin Data Modeler \u2013 Teradata - blog.daiconext","description":"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\u00eda Usuario","canonical_url":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#blogposting","name":"Crear un Modelo: Erwin Data Modeler \u2013 Teradata - blog.daiconext","headline":"Crear un Modelo: Erwin Data Modeler &#8211; Teradata","author":{"@id":"https:\/\/blog.daiconext.com\/index.php\/author\/cano19781wp\/#author"},"publisher":{"@id":"https:\/\/blog.daiconext.com\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2025\/08\/edm-crear-modelo.jpg","width":839,"height":842},"datePublished":"2025-08-18T10:18:24+00:00","dateModified":"2025-08-18T20:54:18+00:00","inLanguage":"es-ES","mainEntityOfPage":{"@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#webpage"},"isPartOf":{"@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#webpage"},"articleSection":"Teradata"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/blog.daiconext.com#listItem","position":1,"name":"Home","item":"https:\/\/blog.daiconext.com","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.daiconext.com\/index.php\/category\/teradata\/#listItem","name":"Teradata"}},{"@type":"ListItem","@id":"https:\/\/blog.daiconext.com\/index.php\/category\/teradata\/#listItem","position":2,"name":"Teradata","item":"https:\/\/blog.daiconext.com\/index.php\/category\/teradata\/","nextItem":{"@type":"ListItem","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#listItem","name":"Crear un Modelo: Erwin Data Modeler &#8211; Teradata"},"previousItem":{"@type":"ListItem","@id":"https:\/\/blog.daiconext.com#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#listItem","position":3,"name":"Crear un Modelo: Erwin Data Modeler &#8211; Teradata","previousItem":{"@type":"ListItem","@id":"https:\/\/blog.daiconext.com\/index.php\/category\/teradata\/#listItem","name":"Teradata"}}]},{"@type":"Organization","@id":"https:\/\/blog.daiconext.com\/#organization","name":"blog.daiconext","url":"https:\/\/blog.daiconext.com\/","logo":{"@type":"ImageObject","url":"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2026\/08\/cropped-DAiCoNext_logo_170x88.png","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#organizationLogo","width":170,"height":88},"image":{"@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/blog.daiconext.com\/index.php\/author\/cano19781wp\/#author","url":"https:\/\/blog.daiconext.com\/index.php\/author\/cano19781wp\/","name":"admin","image":{"@type":"ImageObject","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/6f98bef2100a8df6af9544238f8ca7e3616d56b473b3bed1367a8e6456e07b78?s=96&d=mm&r=g","width":96,"height":96,"caption":"admin"}},{"@type":"WebPage","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#webpage","url":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/","name":"Crear un Modelo: Erwin Data Modeler \u2013 Teradata - blog.daiconext","description":"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\u00eda Usuario","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/blog.daiconext.com\/#website"},"breadcrumb":{"@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#breadcrumblist"},"author":{"@id":"https:\/\/blog.daiconext.com\/index.php\/author\/cano19781wp\/#author"},"creator":{"@id":"https:\/\/blog.daiconext.com\/index.php\/author\/cano19781wp\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2025\/08\/edm-crear-modelo.jpg","@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#mainImage","width":839,"height":842},"primaryImageOfPage":{"@id":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/#mainImage"},"datePublished":"2025-08-18T10:18:24+00:00","dateModified":"2025-08-18T20:54:18+00:00"},{"@type":"WebSite","@id":"https:\/\/blog.daiconext.com\/#website","url":"https:\/\/blog.daiconext.com\/","name":"blog.daiconext","inLanguage":"es-ES","publisher":{"@id":"https:\/\/blog.daiconext.com\/#organization"}}]},"og:locale":"es_ES","og:site_name":"blog.daiconext -","og:type":"article","og:title":"Crear un Modelo: Erwin Data Modeler \u2013 Teradata - blog.daiconext","og:description":"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\u00eda Usuario","og:url":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/","og:image":"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2026\/08\/cropped-DAiCoNext_logo_170x88.png","og:image:secure_url":"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2026\/08\/cropped-DAiCoNext_logo_170x88.png","article:published_time":"2025-08-18T10:18:24+00:00","article:modified_time":"2025-08-18T20:54:18+00:00","twitter:card":"summary_large_image","twitter:title":"Crear un Modelo: Erwin Data Modeler \u2013 Teradata - blog.daiconext","twitter:description":"Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: Cliente Factura Producto Categor\u00eda Usuario","twitter:image":"https:\/\/blog.daiconext.com\/wp-content\/uploads\/2026\/08\/cropped-DAiCoNext_logo_170x88.png"},"aioseo_meta_data":{"post_id":"2719","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2025-08-18 10:18:25","updated":"2025-08-18 20:57:58","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/blog.daiconext.com\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/blog.daiconext.com\/index.php\/category\/teradata\/\" title=\"Teradata\">Teradata<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tCrear un Modelo: Erwin Data Modeler \u2013 Teradata\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/blog.daiconext.com"},{"label":"Teradata","link":"https:\/\/blog.daiconext.com\/index.php\/category\/teradata\/"},{"label":"Crear un Modelo: Erwin Data Modeler &#8211; Teradata","link":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/"}],"_links":{"self":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts\/2719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/comments?post=2719"}],"version-history":[{"count":7,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts\/2719\/revisions"}],"predecessor-version":[{"id":2736,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts\/2719\/revisions\/2736"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/media\/2727"}],"wp:attachment":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/media?parent=2719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/categories?post=2719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/tags?post=2719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}