ETL jdbc parameter

[CTIgem]

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!

[catanirex]

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.

[alex_sydney]

ETL gets the parameter from your ..\etl_runtime\etl.properties file

[unfaced]

jep alex_sydney is right. if you have to re-initialise the Database, you have to configure the file createdb.properties

[victor]

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

[SorinM]

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!

[victor]

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

[SorinM]

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.

[victor]

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

[SorinM]

2. What do you mean by rebuild ODS? Do you want me to create database again?

Thanks for answer!

[victor]

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

[SorinM]

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.

[victor]

Well, actually this is where Genesys did it right! Datasourcer will remake the table for you - no need to do anything.

[SorinM]

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?

[SorinM]

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.