Comments (2)
SNDML cannot replicate ServiceNow database views. There are a couple of reasons for this. (1) There is no schema information in ServiceNow for database views. (2) There is no way to determine when a row was last updated.
The recommendation is that you replicate the underlying tables, and recreate the view in the target SQL database.
from sndml3.
Thanks @gflewis for the quick update and suggestion!
from sndml3.
Related Issues (20)
- Domain separated data HOT 9
- 'sys_id' is specified more than once in the SET when loading cmdb_ci HOT 2
- sync keeps updating records on wm_order HOT 3
- Partition data by Minute HOT 4
- sndml3 support for SQLite Database/Datasource HOT 9
- MinRows not working HOT 1
- Log4J exploit HOT 4
- expected 'sys_id', found 'priority' in first column of table 'incident' HOT 11
- Config validation fails when there is a number in the source table name HOT 2
- DatabaseInsertWriter Process: Failed/Skipped HOT 2
- DatabaseUpdateStatement bindField time_in_seconds java.lang.NumberFormatException HOT 4
- JsonParseException Unexpected character ('}' (code 125)): was expecting a colon to separate field name and value HOT 4
- Transaction cancelled: maximum execution time exceeded HOT 2
- MSSQL time zone change HOT 1
- Action sync does not respect pagesize HOT 1
- Long load times HOT 1
- Error Unexpected character ('}' (code 125)) HOT 4
- PROCESS: Expected X rows but processed Y rows HOT 2
- Setting Partitions in Data Pump Results in Critical Error HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sndml3.