- Does Xtract need Java to run?
Yes. Xtract-ETL and Xtract IA need a Java Runtime Environment to run.
Billions of Products are running on Java, even the mobile phone OS Android is run by Java. There is a good chance that you all ready have a JRE installed on your system.
See
Install page for more information.
- Is Xtract-ETL an XML/XSLT editor?
No. But it can edit XML and XLST (stylesheets) as part of it's ETL (Extract Transform Load) capabilities.
Xtract is an extract, edit, verify and packaging tool for creating SIP (Submission Information Package) packages for e-archive consumtion.
With Xtract ETL you get a WYSIWYG
(What You See Is What You Get) perspective to your ETL processess.
- How do I install MYSQL JDBC driver in Xtract-ETL?
1) In Xtract-ETL File menu add your JDBC jar file in File->Settings->Classpath dialog
2) In Xtract-ETL File menu add your Driver class in File->Settings->JDBC Drivers dialog
Alt. Edit [Xtract home]/classpath.txt and [Xtract home]/lib/jdbc.properties.
Loaded drivers will be displayed in Xtract Console at startup.
- Can I make my own Java Plugin for Xtract-ETL?
Yes. By extending the
java.crazedout.etl.plugin.AbstractPluginNodeListener
you can make your own Java Plugin that can interact with Xtract-ETL in runtime.
Xtract ETL has an integrated IDE for buildning Java Plugins.
See [Xtract home]/javadoc.
- How does Xtract handle rights/privileges on my system?
Xtract-ETL and Xtract IA always run under the priviligies of the starters (user) process. No special or individual rights are set or used.
When connecting to external source such as SQL-Databases or file areas it is always the privileges of the Users process that will be used.
Username / Password is the usual logon on scenario for databases.
- How does Xtract handle security/integraty of my data?
Users project files (.etl) is stored on the users system by the user and is the users responsibility to handle securely.
During work in Xtract-ETL temporary files will be created in the [Xtract home]/.temp directory. Xtract-ETL will try to delete all data and artifacts from this area on shutdown/close but mail fail
for any number of reasons. Therefore it is of
HIGH IMPORTANCE the the User deletes all created content of this area on exit or on a daily basis.
Xtract will warn the Users if this content is more that 100 files.
C8Soft does
NOT take responsibility for any data, documents or artifacts that is handled by the system.
Make sure to backup your data, files and artifacts before using Xtract-ETL if this can become be an issue.
- Is Xtract XIA an e-archive?
Yes and No. Xtract XIA is an Intermediate e-achive and it's primary pourpose is to be a functional storage area for SIP packages during the building process
and later for SIP packages waiting to be exported to their final e-archive destination. XIA can of course be used as a long term e-archive if the needs are limited.