English (English)

Configuring ABBYY Timeline Repository

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

  1. Open Timeline repository (click View > Repository).
  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: Select Keep old data if you need to add a new data and keep the old one 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.09.2023 8:59:47

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.