Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
Hello,
This community has been very helpful in the past so I figure I'll give this another go. Long story short, we have two StruxureWare DCO servers that we use at two different locations. I initially set-up the ETL integration roughly 6-8 months ago on one of the servers, and I don’t recall the exact steps I took, but I somehow already had jobs and transformations in the following locations: "/data/pentaho/export/", and "/data/pentaho/import" (Please see screen capture below). I’m not sure if it was something I did because it was a long process of trying to figure out how to get everything working, or if they were already there.
Import:
Export:
I’m now at the point where I’m attempting to set-up our other server with ETL integration, but I don’t see any of the jobs and transformations in the above directories like in the screen capture above in our other server. I attempted to manually add a few of them from the directory: “/data/pentaho_backup/export/” because the same list is in there as it is in the other working server, but they don’t seem to work. I’ve created multiple internal import and export databases, but that didn’t seem to matter. Obviously I can’t integrate with DCO operations without a valid job to click on. I’m able to connect to the import and export databases from our database management system just fine, but the export databases table are all empty obviously because I can’t integrate and sync with DCO
So question, are the jobs and transformations supposed to natively be in those locations? Or am I supposed to add them? Would I just download them all from the “pentaho_backup” folder and upload them to the “/data/pentaho/import” and "/data/pentaho/export/" folders? I just don’t know why everything was good to go on one server, but not the other server when they’re supposed to have the same configuration. I can provide additional screen capture if needed if you'd like to see our configuration settings.
Link copied. Please paste this link to share this article on your social media post.
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.