To create Open Hub the old way (3.5) using InfoSpoke, we can create directly in Production.
To create Open Hub the new way (7.0) we need Transformation.
and we cannot create Transformation directly in Production.
Does anyone know a solution for this?
or we should not create Open Hub directly in production?
Not all implementations would allow creation of infospokes directly in production, its all dependent on security settings. It must be a miss at security side to prevent creation of infospokes in produciton, especially that being a separate transaction vs. open hub in 7.x requires transformaiton which normally would be locked for changes.
If you are required to create a quick extraction of data in production, you could use APD instead.