Advertisement
Guest User

Untitled

a guest
May 18th, 2017
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.46 KB | None | 0 0
  1. Creator "Biz.KActivity GML Exporter"
  2. Version 1
  3. graph
  4. [
  5. directed 0
  6. node
  7. [
  8. id "49df51d8-b488-4934-844c-19f8e9c6f868"
  9. name "JdbcSourceConnector"
  10. className "io.confluent.connect.jdbc.JdbcSourceConnector"
  11. type "source"
  12. x "0.0"
  13. y "0.0"
  14. content "{
  15. 'connector.class': 'io.confluent.connect.jdbc.JdbcSourceConnector',
  16. 'timestamp.column.name': '',
  17. 'incrementing.column.name': 'discountID',
  18. 'validate.non.null': 'true',
  19. 'tasks.max': '1',
  20. 'query': 'SELECT TOP 1 * FROM DISCOUNT',
  21. 'batch.max.rows': '100',
  22. 'timestamp.delay.interval.ms': '0',
  23. 'table.types': 'TABLE',
  24. 'table.blacklist': '',
  25. 'table.poll.interval.ms': '6000',
  26. 'table.whitelist': '',
  27. 'mode': 'incrementing',
  28. 'value.converter.schema.registry.url': 'http://localhost:8081',
  29. 'topic.prefix': 'DISCOUNT',
  30. 'schema.pattern': '',
  31. 'poll.interval.ms': '5000',
  32. 'name': 'Forcive-DISCOUNT',
  33. 'connection.url': 'jdbc:sqlserver://192.168.1.200\\MSSQLSERVER2012;user=sa2;password=ZAQ!2wsx;database=LOCATION_ACTIVITY_DB',
  34. 'key.converter.schema.registry.url': 'http://localhost:8081'
  35. }"
  36. ]
  37. node
  38. [
  39. id "452445cc-be82-45a0-ab9e-6800d7882442"
  40. name "JdbcSourceConnector"
  41. className "io.confluent.connect.jdbc.JdbcSourceConnector"
  42. type "source"
  43. x "0.0"
  44. y "0.0"
  45. content "{
  46. 'connector.class': 'io.confluent.connect.jdbc.JdbcSourceConnector',
  47. 'timestamp.column.name': '',
  48. 'incrementing.column.name': 'guestCheckLineItemID',
  49. 'validate.non.null': 'true',
  50. 'tasks.max': '1',
  51. 'query': 'SELECT TOP 1 * FROM GUEST_CHECK_LINE_ITEM_HIST',
  52. 'batch.max.rows': '100',
  53. 'timestamp.delay.interval.ms': '0',
  54. 'table.types': 'TABLE',
  55. 'table.blacklist': '',
  56. 'table.poll.interval.ms': '6000',
  57. 'table.whitelist': '',
  58. 'mode': 'incrementing',
  59. 'value.converter.schema.registry.url': 'http://localhost:8081',
  60. 'topic.prefix': 'GUEST_CHECK_LINE_ITEM_HIST',
  61. 'schema.pattern': '',
  62. 'poll.interval.ms': '5000',
  63. 'name': 'Forcive-GUEST_CHECK_LINE_ITEM_HIST',
  64. 'connection.url': 'jdbc:sqlserver://192.168.1.200\\MSSQLSERVER2012;user=sa2;password=ZAQ!2wsx;database=LOCATION_ACTIVITY_DB',
  65. 'key.converter.schema.registry.url': 'http://localhost:8081'
  66. }"
  67. ]
  68. node
  69. [
  70. id "4c38f566-d26b-413c-997d-84b6a4ea5e45"
  71. name "Forcive.ForciveActivity"
  72. className "Forcive.ForciveActivity"
  73. type "activity"
  74. x "0.0"
  75. y "0.0"
  76. content "{ 'name': 'Forcive.ForciveActivity',
  77. 'query': 'SELECT DISCOUNT.discountID, DISCOUNT.name, GUEST_CHECK_LINE_ITEM_HIST.guestCheckID , GUEST_CHECK_LINE_ITEM_HIST.referenceInfo FROM KSTREAM(DISCOUNT) INNER JOIN KSTREAM(GUEST_CHECK_LINE_ITEM_HIST) ON DISCOUNT.organizationID = GUEST_CHECK_LINE_ITEM_HIST.organizationID',
  78. 'join.window': '60000',
  79. 'topic.result': 'topic_result',
  80. }"
  81. ]
  82. node
  83. [
  84. id "fbc719f0-2f00-4e81-bc6e-573cb6fd92c2"
  85. name "ForciveSinkConnector"
  86. className "Forcive.Kafka.ForciveSinkConnector"
  87. type "source"
  88. x "0.0"
  89. y "0.0"
  90. content "{
  91. 'name': 'ForciveSinkConnector',
  92. 'config': {
  93. 'connector.class': 'Forcive.Kafka.ForciveSinkConnector',
  94. 'topics': 'topic_output2-KEY-SELECT-repartition',
  95. 'tasks.max': '1',
  96. 'forcive.connect.url': '192.168.1.17',
  97. 'forcive.connect.port': '26311',
  98. 'forcive.connect.password': 'ZAQ12wsx',
  99. 'forcive.message.queue.timeout': '100',
  100. 'forcive.connect.user': 'TenancyAdministrator',
  101. 'forcive.profile.name': 'Profile1',
  102. 'key.converter': 'org.apache.kafka.connect.storage.StringConverter',
  103. 'key.converter.schema.registry.url': 'http://192.168.1.163:8081',
  104. 'value.converter': 'io.confluent.connect.avro.AvroConverter',
  105. 'value.converter.schema.registry.url': 'http://192.168.1.163:8081',
  106. 'forcive.batch.size' : '2147483647',
  107. 'forcive.batch.auto.flush' : 'false',
  108. 'forcive.fields.mapping': ' { \'relations\' : [ { \'from\' : \'DISCOUNT_discountID\', \'to\' : \'[sinkTest].[discountID]\' }, { \'from\' : \'DISCOUNT_name\', \'to\' : \'[sinkTest].[discountName]\' }, { \'from\' : \'GUEST_CHECK_LINITEM_HIST_guestCheckID\', \'to\' : \'[sinkTest].[guestCheckID]\' }, { \'from\' : \'GUEST_CHECK_LINE_ITEM_HIST_referenceInfo\', \'to\' : \'[sinkTest].[referenceInfo]\' } ] }'
  109. }
  110. }"
  111. ]
  112. edge
  113. [
  114. source "49df51d8-b488-4934-844c-19f8e9c6f868"
  115. target "4c38f566-d26b-413c-997d-84b6a4ea5e45"
  116. ]
  117. edge
  118. [
  119. source "452445cc-be82-45a0-ab9e-6800d7882442"
  120. target "4c38f566-d26b-413c-997d-84b6a4ea5e45"
  121. ]
  122. edge
  123. [
  124. source "4c38f566-d26b-413c-997d-84b6a4ea5e45"
  125. target "fbc719f0-2f00-4e81-bc6e-573cb6fd92c2"
  126. ]
  127. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement