Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Terraform Remote State and OCI Object Storage

user10211083Jan 17 2018 — edited Feb 28 2018

We are planning to utilize terraform for our new project in OCI and looking for ways to store remote data state securely with versioning. AWS S3 with dynamo DB offers excellent solution, however we would like to keep everything in Oracle Cloud.

Any idea what will be the good Oracle Cloud service for storing terraform remote state? To summarize, remote state store should have the following:

1. Shared storage - Ability for multiple team members to share the same terraform state.

2. Locking State Files - For obvious reasons, the solution should have the ability to lock the state file. This is very important otherwise we end up with corrupted state, conflicts and data loss.

3. Isolation - Would like to maintain different terraform state for different environments. For example separate one for Dev, Stage and PROD environment.

Any word from OCI dev if they are planning to enable OCI Object Storage for OCI provider? Or what is there recommendation for immediate needs? As stated above we would like to stay away from AWS S3 and if possible terraform enterprise aka atlas....

This post has been answered by 3581875 on Jan 29 2018
Jump to Answer

Comments

Pete_Scott

You say Variable C is refreshed - have you tried setting it instead?  On the Set Variable option of the package you could enter the two variables to combine - you need qualify the variables with the project name

Also are both A and B of the same data type?

3551278

It doesn't seem to work by setting variable C either.

I still get the error  "Variable has no value: PROJECT.VARIABLE_A"

Both variables are text.

The whole process works when I am setting the variable A and launching my package manually.

It doesn't work when i'm passing the variable A value with the startscen command.

Pavan8u

While generating Scenario, have you selected VAR A as startup parameter?

Regards,

Pavan

3551278

I think so, VAR A is INTERFACES.PAIE_XINT_MOIS in the screenshot below.

pastedImage_0.png

Pierre-Yves

Pavan8u

I tried it in my pc and it is working fine.

In Var_c I wrote query like

SELECT '#PAVAN.var_a'||'#PAVAN.var_b' from dual.

Please check whether you are using # before variable name or not. Please check Project name as well.

Regards,

Pavan

3551278

Sorry i was no specific enough.

I am encapsulating a scenario in another scenario.

In scenario 1 I declare VAR A (INTERFACES.PAIE_XINT_MOIS) and set VAR B (INTERFACES.PAIE_XINT_SOC_LIB)

Then I call scen 2 and refresh VAR C (INTERFACES.PAIE_XINT_CHEMIN) using the following query :

pastedImage_0.png

If I try refreshing VAR C in the first scenario, it works fine.

It is not working when doing it in scenario 2

Pierre-Yves

Pavan8u

If I am not wrong, you have one main scenario SCN1 and from SCN1 you are calling SCN2. You have var1 and var2 in SCN1 and var3 in SCN2.

In order to refresh VAR3 in SCN2 you need to pass var1 and var2 as additional parameters to SCN2.

Refer this blog for some insight-

http://odiexperts.com/passing-values-to-odi-variables-in-packagesscenarios/

Regards,

Pavan

3551278

You are right.

VAR A and B are declared in SCN2 before refreshing VAR C.

pastedImage_0.png

Therefore they are passed as startup parameters.

The whole thing works when VAR A is set manually in SCN1

But it doesn't work anymore when VAR A is passed with starscn command.

I think the solution might be to write the value of VAR A in a temporary table and use this table for queries.

Pierre-Yves

Pavan8u
Answer

In Package1, click on SCN2 and click on ADDITIONAL PARAMETERS, there you need to add VAR-A and VAR-B as additional parameters. Refer blog which mentioned in above thread.

Regards,

Pavan

Marked as Answer by 3551278 · Sep 27 2020
3551278

Thanks a lot Pavan, it did the trick, indeed.

Have a nice day.

Pierre-Yves

1 - 10

Post Details