Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
VBA Palo Connect
I have multiple Palo DBs (all the same structure - each for a different client). I have an update program where I need to open the Palo DB (or make sure it is open) do my updates and then close the Palo DB.
One of the DBs that I need to open is the common data used to translate the data to be updated.
Does anyone have the VBA code to do this?
I have found it in the PHP kit but no reference to the VBA code.
Thanks,
David
this is a classic job for ETL-Server!
- no dependence on a Microsoft tool to run it
- fine grained rights
- can run on different machines across your network
- versionable source code
...
hi axi,
what do you mean with "versionable source code". In thread
http://www.jedox.com/community/palo-foru…p?threadid=2645 you wrote something similar:
" the ETL-server is a nice tool
for dimension modelling you can put the source files under version control"
Could you please give us a hint in which way you do the "version control"?
hi axi,
thanks a lot. Our programmers use "CVS".
Is it enough to do version control only for the file "repository.xml" of "PALO-WEB-ETL-Manager"?
you decide what needs to be versioned...
CVS is a bad choice for binary data e.g. Excel-files
the guys who created CVS crafted Subversion
