GAX Database / Connectivity

[PFCCWA]

hello,

I am deploying gax 8.1 however unsure how the DAP connection is configured (to its own database).
upon using the initial set up I cannot connect to the database.
we use oracle and connect through the TNS entry but unsure what details from here need to be used for the relevant fields.
I was thinking of manually creating the DAP but not sure what details are needed/connection ie jbdc / non jdbc, a dbserver if non jdbc etc.

thanks,

[Kubig]

You can deploy the DAP through the wizard which is available in GAX by default via login using the "root" user (deep details are within dep guide). Other way how to achieve that is through manually adding the DAP to the connection of the GAX. All is JDBC as the GAX is java-based.

[PFCCWA]

[quote author=Kubig link=topic=9393.msg42497#msg42497 date=1456930679]
You can deploy the DAP through the wizard which is available in GAX by default via login using the "root" user (deep details are within dep guide). Other way how to achieve that is through manually adding the DAP to the connection of the GAX. All is JDBC as the GAX is java-based.
[/quote]

I tried to do this through the wizard, however encountered error connecting to DB when trying to pass this step.
when creating a JDBC DAP, do I need to defined a role (if so what value) and jdbc-url in annex tab?
also for jdbc connector , does it matter if the classpath environment variable is odbc6.jar or odbc7.jar?

thanks,
Wasim

[Kubig]

I have encountered the issue with wizard as well. Unfortnately, do not remember the root-cause, but it was a "trifle".

About the JDBC DAP, yes you have to define the role:

Under section "GAX", create option called "role" with value "main" for GAX database itself and for audit dap just change the value for from "main" to "auditing". The jdbc-url is not necessary in this case.

[PFCCWA]

[quote author=Kubig link=topic=9393.msg42499#msg42499 date=1456933192]
I have encountered the issue with wizard as well. Unfortnately, do not remember the root-cause, but it was a "trifle".

About the JDBC DAP, yes you have to define the role:

Under section "GAX", create option called "role" with value "main" for GAX database itself and for audit dap just change the value for from "main" to "auditing". The jdbc-url is not necessary in this case.
[/quote]

Is GAX in caps? not lowercase?

[Timur Karimov]

Yes, GAX in caps.