Skip to main content

Posts

Showing posts from 2017

Using startSQLRepository from scratch

While you can very easily import/export data through /dyn/admin, if working on a production environment you will have to deal with very high amounts of data that your browser will just not withstand to display/ingest, in that case you can use startSQLRepository utility program from ATG installation. Information for configuring it is out there on Oracle docs, however, there are some tricks you might be missing, I'm going to detail steps for getting it up. First of all, make sure you read through Oracle's documentation: http://docs.oracle.com/cd/E52191_03/Platform.11-1/ATGRepositoryGuide/html/s1207startsqlrepository01.html Configure your datasources for database access In order to get started with the utility you need to configure the FakeXADataSource component in order to allow the utility to connect to your database, you can see documentation from Oracle in here . But let's get into detail: Create a new server on your ATG installation along with the necessary fol