Working on migrating ETL config from TRN to PRD.
- Script created by SQL Server for all objects in the ETL database
- ETL database deleted
- Script run to recreate the database
- On ETL server, credentials changed to ones exported from PRD ION.
- On ETL server, TRN credentials have been deleted entirely to ensure no mixups in the connection
- On ETL server, the kettle.properties file has been updated to reflect the new credentials
- On ETL server, can create a new transformation. There is a “test connection” option – it returns “Connected to CloudAPI server” Based on this I don’t believe we have any authentication issues.
- Normally the Get Cloud-api fields is used – it reaches out and gets the data dictionary of the table in question
At this point, we get the subject error when we click 'Get cloud-api fields'
Seems that we missed something in our migration checklist?
One other data point, we did update ION Desk yesterday with the latest Object Schemas for DL in PRD as part of our normal cloud migration checklist.