The Aspider Web Crawler Database Server Connector can be configured using the Aspire Admin UI. It requires the following entities to be created:
Easy Heading Free | ||||||
---|---|---|---|---|---|---|
|
Use query for table metadata extraction: A specific query to extract additional data. ex.
Code Block |
---|
select data from admin_table where table_id={{table}} and database_id={{database}} |
Info |
---|
Please keep in mind that you necessarily need to select Index DBs and tables or Enable row extraction for the connector to work properly. Please remember that both options are exclusive, so you will not be able to use the two of them at the same time. |
For the creation of the Connector object using the Admin UI, check this page.
Scope: Exclude/include File: can be used to filter the crawled databases and tables. Add the path to the .json file where the excluded/included items are placed.
Code Block |
---|
{
"database" : [
{
"name" : "dbtest1",
"pattern" : false
},{
"name" : ".*2",
"pattern" : true
}
],
"table" : [
{
"name" : "test1",
"database" : "dbtest1",
"pattern" : false
}, {
"name" : ".*3",
"pattern" : true
}, {
"name" : ".*4",
"database" : "dbtest2",
"pattern" : true
}
],
"schema" : [
{
"name" : "*schema_1*",
"database" : "dbtest_1",
"pattern" : false
}
]
} |