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.