Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: CTIgem on November 26, 2007, 03:40:53 PM
-
Where does ETL(7.1) get jdbc parameter "jdbcurl=jdbc:oracle:thin:@server Name:1521:sid"?
I thought it is from DM.source, DB_URL!
-
From the DAP (jdbc enabled). It build the connection string using the information on the DAP.
If you have the configurations wizards installed on the Configuration Manager computer, try this:
Right click on the DAP, and choose Wizard/Configure. Select the jdbc info tab.
-
ETL gets the parameter from your ..\etl_runtime\etl.properties file
-
jep alex_sydney is right. if you have to re-initialise the Database, you have to configure the file createdb.properties
-
Oh boy, there are quite a few places where it can get it:
1. your CME
2. etl.properties file (just look in the same directory as your etl runtime)
3. trans_only.properties and anything else friend Genesys engineer has modified.
the best way to see is just open CME and look under ETL_Runtime command line. Usually, you would have a .bat file (or .sh file depending on your OS) Open that file and see if it specifies etl.properties or not.
Best regards,
Vic
-
Hello,
I have a little question about ETL.
First when it was installed ETL, the run-creadb.bat was ran under user system of Datamart database(in createdb.properties was configured this user).
Now, i don't want to use this user for reports in Hyperion. I created another user in DMA database, I think i have to run again run-creadb.bat with the new user in createdb.properties in order that the new schema to be created.
Besides this, where else i have to configure the new user for the data to be transferred through ETL in this new user's schema? Or is enough to create a new oce file with the new user?
Thanks!
-
Ok,
I am answering this without checking, but:
1. if you run createdb with new user, you will essentially create a new Datamart - data from old datamart (the data that your Hyperion actually accesses) will not be transferred there, and you will end up with an empy database. While it IS possible to migrate DB from old datamart to new and then continue with receiving data updates from ODS even after that, the process is rather painful and I would not go that way.
2. why not just create a read-only user that would have access to the existing datamart tables? This way you would not have to worry about anything :)
In a future, it is always a good idea to create a datamart user, because ... well, I think you don't need me to lecture you on that one.
Vic
-
I'm not interested in data from previous database because we are still in test, not production. My question is if i have a new database schema with the new user where i have to config in order that the data to be transferred in the new schema. Maybe in ETL Assistant...
If i log in ETL Assistant with the new user i don't see data. My opinion is that ETL still transfers data from ODS to the old user's schema.
-
Ok,
this gets a bit simpler then:
1. stop your ETL
2. rebuild ODS (to save you any grief from un-related data)
3. ETL Assitant: define the new database (again :) )
4. modify .properties file or whatever you use where you define your user and password
5. run createdb
in other words, you would just rebuild your CCA :)
Would be the fastest and surest way to do things.
Vic
-
2. What do you mean by rebuild ODS? Do you want me to create database again?
Thanks for answer!
-
Yes, because you have several index tables there, plus probably some unprocessed data as well. Just drop ODS user and recreate it...shoudl be pretty simple :) 1 minute of work will save you probably days of anguish later ;)
-
Ok, I will drop ODS user from ODS database. Then i will create it again and i will have a user with an empty schema. What should i do to initialize ODS database, ODS schema?
I'm sorry if my questions are stupid but i'm really a begginer with Genesys.
-
Well, actually this is where Genesys did it right! Datasourcer will remake the table for you - no need to do anything. :)
-
I stopped ETL Runtime, i deleted and then created a new ODS database user.
When i try to add in ETL Assistant the new DB Source putting the new user i get the error:
"ODS tables are missing in your database".
Did I missed some steps?
-
I managed to do it partially.
I reinstalled DataSourcer and then i recreated in DMA the source.
Now i see data in DMA.
Now i have to see why in Brio the reports for today are empty even if i placed some test calls. Do you have any ideea? The time within the data shoul be agregated and transferred has passed.
-
Ok, ok, first of all:
ODS database should have been automatically created by Datasourcer once you start, but I see you went the hard way about it. :)
Usually, when there is absolutely no data coming into Datamart, the cause for it is either you forgot to activate the report inside DMA, ETL Assistant or you have some more serious issues. You said you already have data inside ODS, so your ETL has trouble transferring the data to DM. Before we go the difficult route, once again, let's do a quick check:
1. you used ETL Assistant to configure connection to datamart, right?
2. open DMA and see if your reports are activated
3. inside the reports, click on data and see if you have data inside
4. you ran create_db once, and then you ran run_trans_once and then run_trans_agg or did you do create_db, and run_trans_agg?
5. what does your ETL log say?
Based on your last post, I see that you did (2) and (3) for sure, but just in case....
My hunch would be:
1. you forgot ETL assistant
2. you do not have the right user inside etl.properties
Vic
-
Yes, i did 2 and 3. I see data in report in DMA.
I didn't ran run_trans_once manually, i let ETL to do it.
Now It seems OK, i see data in Brio charts and reports.
I reinstalled Datasourcer because i modified also the ODS database user. I didn't know the easiest solution and that's why i reinstalled it.
Thank you very much for help.