Migrating resources in Denodo at IU

In Denodo at Indiana University, developers can migrate their own resources from DEV to STG to PRD. See below for details and instructions.

On this page:


About the Denodo environments

Development occurs in the IU Denodo Dev environments at the following URL:

  • DEV: //ebidvt-dev.uits.iu.edu:9999/<your_VDB_name>

After migration, you can access Denodo views in Stage and Production at the following URLs:

  • STG: //ebidvt-stg.uits.iu.edu:9999/<your_VDB_name>
  • PRD: //ebidvt.uits.iu.edu:9999/<your_VDB_name>

Developers can read, write, and create new objects in the DEV environment only. You can view objects in STG and PRD, but you cannot alter them there. The only way to get objects into STG and PRD is through the migration process.

STG access is for testers, and PRD access is for consumers. To request access for additional users or groups to STG and/or PRD, submit the EDSS Support Form.

Migrating resources

  1. Preparing to migrate: Before migrating your resources, prepare all of your data sources and views in the virtual database (VDB) without the _dev suffix (this is the VDB that will migrate). All the objects in this VDB will be migrated, except the data sources. To migrate data sources, email denodo-request@iu.edu with proof of data manager approval for all data sources that contain any enterprise data.
  2. If you have a significant amount of work in progress, you should keep that in your other VDB. If you have work in progress that only you need to access, you may request a personal VDB.

  3. Accessing the Scheduler: To access the stage Denodo Scheduler:
    1. On the Denodo Authentication Page, for both "Login" and "Password", enter guest, and then click Accept.
    2. On the "Servers list" page, find the SCHEDULE SERVER entry, and then, in the "Actions" column, click Connect.
    3. On the next "Authentication Page", for "Login" and "Password", enter your IU username and passphrase, respectively; make sure the Local Authentication box is unchecked, and then click Accept.
  4. Migrating to STG: Once you have accessed the stage scheduler, you can migrate your resources to STG:
    1. In jobs list, find your export <your_vdb> Dev to Stage job, and then, in the "Actions" column, click the corresponding Play icon:
    2. Click the 'Play' icon corresponding to the 'export &lt;your_vdb> Dev to Stage' job

    3. When the export completes, click the Play icon corresponding with the import <your_vdb> Dev to Stage job. You should see your changes in the STG VDB within minutes.
  5. Migrating to PRD: Make sure to test everything thoroughly on STG before migrating your VDB to PRD. When you're ready, access the stage scheduler (using the instructions from step 2, above), and then:
    1. Click Project, and then select the project name that matches your VDB.
    2. Click Jobs.
    3. In the list of jobs, find your export <your_vdb> Stage to Prod job, and then, in the "Actions" column, click the corresponding Play icon.
    4. When the export completes, click the Play icon corresponding with the import <your_vdb> Stage to Prod job. Your data sources will export and import automatically.
Important:
Consumer access privileges do not migrate between environments. If consumers need to access to views in STG and/or PRD, contact EDSS.

Handling environment-specific settings

In some cases, you may need to have different data source connections in different environments (e.g., you may want the STG Denodo VDB to point to DSS1STG and PRD point to DSS1PRD).

If environment-specific settings are part of your requirements, and you need to migrate data sources, email denodo-request@iu.edu with proof of data manager approval for all data sources that contain any enterprise data. Subsequently, when you need to modify data sources in STG and PRD, contact EDSS.

Note:
Currently, Excel data sources and custom data sources cannot be managed with environment-specific configurations.

Migrating web services

If you migrate web services to production, contact EDSS. EDSS will add targeted monitoring to increase the availability of your web services.

Getting help

If you need help or have questions about the migration the process, submit the EDSS Support Form.

This is document altb in the Knowledge Base.
Last modified on 2017-08-25 12:06:32.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.