You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
Step 1. Launch Aspire and open the Content Source Management Page
Launch Aspire (if it's not already running). See:
Step 2. Add a new Database Server Content Source
To specify exactly what shared folder to crawl, we will need to create a new "Content Source".
To create a new content source:
- From the Content Source , click on "Add Source" button.
- Click on "Database Server Connector".
In the "General" tab in the Content Source Configuration window, specify basic information for the content source:
- Enter a content source name in the "Name" field.
- This is any useful name which you decide is a good name for the source. It will be displayed in the content source page, in error messages, etc.
- Click on the Scheduled pulldown list and select one of the following: Manually, Periodically, Daily, Weekly or Advanced.
- Aspire can automatically schedule content sources to be crawled on a set schedule, such as once a day, several times a week, or periodically (every N minutes or hours).For the purposes of this tutorial, you may want to select Manually and then set up a regular crawling schedule later.
- Click on the Action pulldown list to select one of the following: Start, Stop, Pause, or Resume.
- This is the action that will be performed for that specific schedule.
- Click on the Crawl pulldown list and select one of the following: Full, Real Time, or Cache Groups.
- This will be the type of crawl to execute for that specific schedule.
After selecting a Scheduled, specify the details, if applicable:
- Manually: No additional options.
- Periodically: Specify the "Run every:" options by entering the number of "hours" and "minutes."
- Daily: Specify the "Start time:" by clicking on the hours and minutes drop-down lists and selecting options.
- Weekly: Specify the "Start time:" by clicking on the hours and minutes drop-down lists and selecting options, then clicking on the day checkboxes to specify days of the week to run the crawl.
- Advanced: Enter a custom CRON Expression (e.g. 0 0 0 ? * *)
In the "Connector" tab, specify the connection information to crawl the Database Server.
- JDBC Url: The default JDBC url for your RDBMS server and database. For example, "jdbc:mysql://server:3306/mydb" (MySQL). This will vary depending on the type of RDBMS.
- User: The default name of a database user with the access to all of the databases and tables containing data to be indexed.
- Password: The password for the database user.
- JDBC Driver Jar: Path to the default JDBC driver jar file for your RDBMS. Typically this is placed in the "lib" directory inside your Aspire Home, for example "lib/myjdbcdriver.jar".
- Specify JDBC Driver Class: Check this box if you need to manually specify the JDBC driver class.
- JDBC Driver Class:
- Specify Classpath: Check this box if you need to add external jar files that the specify the JDBC driver depends on
- JDBC Classpath: The class path for external jar files.
- Index Containers: Select if databases and tables are to be indexed. Clear to index rows only.
- Enable rows extraction: Select if the tables should be scanned.
- Extract table row count: Select if the row count of the tables should be extracted.
- Specify Table Metadata Extraction Query: Check this to specify a query to extract the tables object metadata
- Table Metadata Query: The query to run for extracting the tables metadata. The placeholders {{database}}, {{schema}} and {{table}} can used.
- Include File: Use this field to specify the path of the include file. The file will be used to filter databases and tables from the crawl.
- Exclude File: Use this field to specify the path of the exclude file. The file will be used to exclude databases and tables from the crawl.
In the "Workflow" tab, specify the workflow steps for the jobs that come out of the crawl. Drag and drop rules to determine which steps should an item follow after being crawled. This rules could be where to publish the document or transformations needed on the data before sending it to a search engine. See Workflow for more information.
- For the purpose of this tutorial, drag and drop the Publish To File rule found under the Publishers tab to the onPublish Workflow tree.
- Specify a Name and Description for the Publisher.
- Click Add.
After completing this steps click on the Save then Done and you'll be sent back to the Home Page.
During the crawl, you can do the following:
If there are errors, you will get a clickable "Error" flag that will take you to a detailed error message page.