English (English)

Configuring ABBYY Timeline Repository

To enable ABBYY Timeline to receive and process data from DBMS:

  1. Open Timeline repository (click the icon in the left bar).
  2. Go to the Details > Data sources tab and select DBMS CLI tool configuration.
  3. Click Add configuration.
  4. In the configuration form, fill in the following fields:
    1. Connection string
      This is a string that passed to a JDBC driver in order to initiate the connection with DBMS.
      1. Hortonworks Data Platform 2.6.5
        Format: jdbc:hive2://<host>:<port>/<dbName>;<sessionConfs>?<hiveConfs>#<hiveVars>
        Example: jdbc:hive2://localhost:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
        Driver can be downloaded here.
      2. Apache Hive
        Format: jdbc:hive2://<host>:<port>/<dbName>;<additionalparameters>
        Example: jdbc:hive2://localhost:10001/Testdb;transportMode=http;httpPath=cliservice
        Driver can be downloaded here.
      3. Microsoft SQL Server
        Format: jdbc:sqlserver://[serverName[\instanceName][:port]][;property=value[;property=value]]Example: jdbc:sqlserver://localhost\SQLEXPRESS:1433;databaseName=Testdb
        Connector includes this driver.
      4. Posgresql
        Format: jdbc:postgresql://server-name:server-port/database-name
        Example: jdbc:postgresql://localhost:5432/Testdb
        Connector includes this driver.
    2. Username
      Enter username for your DBMS account.
    3. Password
      Enter password for your DBMS account.
    4. Query
      Enter a string of query to the DBMS to get data.
    5. Repository table name
      Enter a name for table in the ABBYY Timeline repository.
      Note: You may provide a new table name. During uploading, the data in a table is fully updated. Provide a new table name if you need to keep the data in an existing table.
    6. To-do lists
      You may specify an existing to-do list.
      To-do lists are lists of tasks that need to be performed after the data is filled into the table.
      For detailed instructions on configuring to-do list, see 'How to Create To-do List' below.
  5. Save new configuration and you will be able to see token on the top of that form.

22.02.2024 17:28:05

Usage of Cookies. In order to optimize the website functionality and improve your online experience ABBYY uses cookies. You agree to the usage of cookies when you continue using this site. Further details can be found in our Privacy Notice.