Solved

Application Database with Vignette

Posted on 2002-07-25
5
849 Views
Last Modified: 2009-01-06
Hello, I´m a new developer using Vignette v6. I am spanish and my english is not pretty good. I am doing my first web application with Vignette. I have a database for this application but I don´t know if this database is the Content database or not. I know the Content database is an internal Vignette database but I don´t know if my application database has to be the same.

I need help. Thanks a lot.
0
Comment
Question by:oarnaiz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 1

Expert Comment

by:hooker042299
ID: 7176837
Basically, you need a place where Vignette can create all it's own tables that store all the internal information it needs and a place where your application will store its data.

This can be the same schema/database.
But it is good practice to store the internal Vignette tables and the content (the tables that you will insert/select from) in different schemas.

There are two ways to configure this. Firstly, you can use the configuration script to use <schema a> for the Vignette system tables and <schema b> for the content tables.
Or, you can configure the installation to use the <schema a> for both. Then in your application you can overwrite the variables ::USERNAME and ::PASSWORD to connect to a different schema. Why this way? If you were going to have multiple different applications, then you might want them to store their data in different logical places - different schemas. So each application could connect to their own schema.

What database are you using? And is there a database person assisting you in this?

Yo no conozco las palabras tecnicas para responder en espanol a su pregunta (ni las teclas para escribirlo)...
Espero que entiendas lo que digo..
0
 

Author Comment

by:oarnaiz
ID: 7176889
First of all, thanks for your answer. The problem is that I still having the same question I tried to explain before. Do I need to transfer my application´s Oracle 8.1.7. schema/database to the CMS database or not? I´ve one schema (Vignette´s default) in CMS database.
0
 
LVL 1

Expert Comment

by:hooker042299
ID: 7176947
Ok - I don't fully understand your question / situation.
I need more information
Can we try and walk through it?

What is the situation with your Vignette installation?
Vignette is installed and configured?
Configured is use <schema a> for both system and content?
Configured to use <schema a> for system tables and <schema b> for content?
It sounds like you're going to create a new application in Vignette. Is that right? Or are you transfering an existing application to Vignette?
When you say that you "have a database for this application", do you mean that someone has created a schema in a different database for use in this new application? There is a table structure? There is data?
Is this currently a different schema or a different database (e.g. is the Vignette schema connect string something like <user1>/<password>@<DB1> but the application database is <user2>/<passsword>@<DB2> OR is the it <user1>/<password>@<DB1> and <user2>/<password>@<DB1>)?


Whatever your answers, there is probably more than one option. Within a template, you can override the internally set connect string to connect to a different schema or a different database.
I would have thought that your ideal aim should be to have one database with two schemas - one with the system tables, one with the tables & data used in your application.


0
 
LVL 1

Accepted Solution

by:
hooker042299 earned 50 total points
ID: 7176972
Addition: Just to explain further, Vignette uses ODBC so you should be able to configure the templates to connect and query any database that you would normally be able to connect to. So although I mention what I think is the "ideal" situation - that's just my opinion. But if you already have schema a in database 1 for Vignette system and schema b in database 2 for the application then there's no problem - it's just a case of overriding the ::USERNAME, ::PASSWORD and ::SERVER variables to get the template to connect to where you want it to connect to (I know I'm repeating myself).
0
 

Author Comment

by:oarnaiz
ID: 7177024
Thanks a lot.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack 7.0.0.23 or Above. The following steps a…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question